QuestionText QuestionType Choice1

A PRIMARY
KEY
constraint
does not
automatically
have a
UNIQUE
Please read the question carefully and choose the most appropriate constraint
option. Which of the given options are TRUE regarding 'Constraints'? MCQ defined on it.

Please read the question carefully and choose the most appropriate None of the
option. The main reason that constraints are added to a table is: MCQ listed options

Please read the question carefully and choose the most appropriate None of the
option. Which of the given options are TRUE regarding 'Constraints'? MCQ listed options

Please read the question carefully and choose the most appropriate
option. Statement 1: If you want to select rows that satisfy at least one
of the given conditions, you can use the logical operator, AND.

Statement 2: <> Checks if the value of two operands are equal or not, if
values are not equal then condition becomes true.
Only
Which of the above statements are TRUE? MCQ statement 2

Please read the question carefully and choose the most appropriate
option. A column defined as NOT NULL can have a DEFAULT value of
NULL. True or False? MCQ true

Please read the question carefully and choose the most appropriate
option. You can have many UNIQUE constraints per table, but only one
PRIMARY KEY constraint per table.
State whether the above statement is TRUE or FALSE. MCQ true
 The primary
key is a
column or
combination
of columns
whose values
uniquely
identify each
Please read the question carefully and choose the most appropriate row in the
option. What is a primary key? MCQ table.

Please read the question carefully and choose the most appropriate
option. A table must have at least one not null constraint and one
unique constraint. True or False? MCQ true

Please read the question carefully and choose the most appropriate
option. Statement 1: Operators are used to specify conditions in an
SQL statement and to serve as conjunctions for multiple conditions in a
statement.
Both
Statement 2: Arithmetic operators manipulate numeric operands. statement 1
and statement
Which of the above statements are TRUE? MCQ 2

Please read the question carefully and choose the most appropriate
option. Statement 1: 'UNION' returns all distinct rows selected by either
query.

Statement 2: 'INTERSECT 'returns all distinct rows selected by both

queries.
Only
Which of the above statements is TRUE? MCQ statement 2

Please read the question carefully and choose the most appropriate
option. To automatically delete rows in a child table when a parent ON DELETE
record is deleted use: MCQ CASCADE

Please read the question carefully and choose the most appropriate
option. Statement 1:Each table can have only ONE primary key per
table
Both
Statement 2: A primary key column can contain NULL values statement 1
and statement
Which of the above statements are TRUE? MCQ 2
Please read the question carefully and choose the most appropriate
option. Statement 1: A FOREIGN KEY in one table points to a
PRIMARY KEY in another table.

Statement 2: If you define a CHECK constraint on a single column it Both

allows only certain values for this column. statement 1
and statement
Which of the given options are TRUE? MCQ 2

Please read the question carefully and choose the most appropriate
option. Which operator returns all distinct rows selected by the first
query but not the second? MCQ MINUS

Please read the question carefully and choose the most appropriate
option. A table can have more than one UNIQUE key constraint. True
or False? MCQ false

Please read the question carefully and choose the most appropriate
option. Primary Key does allow the Null Values. where as in
Unique key doesn't accept the Null values.
State whether the statement is true or false MCQ true

Please read the question carefully and choose the most appropriate
option. Statement 1: 'AND' Returns TRUE if both component conditions
are TRUE. Returns FALSE if either is FALSE; otherwise returns
UNKNOWN.

Statement 2: 'EXISTS' returns FALSE if a sub-query returns at least

one row.
None of the
Which of the above statements are TRUE? MCQ listed options

Please read the question carefully and choose the most appropriate
option. Which clause should you use to exclude group results? MCQ WHERE

Please read the question carefully and choose the most appropriate
option. ON UPDATE CASCADE ensures which of the following? MCQ None
create a new
Please read the question carefully and choose the most appropriate table in the
option. The SQL DROP TABLE clause is used to... MCQ database

Please read the question carefully and choose the most appropriate
option. Which one will delete the table data as well as table structure? MCQ DISTINCT
Please read the question carefully and choose the most appropriate
option. To remove duplicate rows from the result set of a SELECT use NO
the following keyword: MCQ DUPLICATE

Please read the question carefully and choose the most appropriate All listed
option. Which of the given options are TRUE about 'varchar' datatype? MCQ options

SELECT
CustomerNam
e,
COUNT(Cust
omerName)
FROM Orders
ORDER BY
Please read the question carefully and choose the most appropriate CustomerNam
option. Which of the following SQL statements is correct? MCQ e

Please read the question carefully and choose the most appropriate
option. Which of the following is not a valid aggregate function? MCQ COUNT

Please read the question carefully and choose the most appropriate
option. Can you use combination of GROUP BY clause,HAVING
clause and WHERE clause SQL clauses in one SQL statement? MCQ true

UPDATE
employees
SET
Please read the question carefully and choose the most appropriate first_name =
option. Examine the structure of the EMPLOYEES table: 'John' AND
EMPLOYEE_ID NUMBER Primary Key last_name
FIRST_NAME VARCHAR2(25) ='Smith'
LAST_NAME VARCHAR2(25) WHERE
HIRE_DATE DATE employee_id
Which UPDATE statement is valid? MCQ = 180;
Please read the question carefully and choose the most appropriate
option. The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(50)
STATE_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50)
COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CUSTOMER_PHONE VARCHAR2(20)
A sale is being advertised to the customers in France. Which WHERE
clause
identifies customers that are located in France? MCQ None

Please read the question carefully and choose the most appropriate
option. What SQL clause is used to restrict the rows returned by a
query? MCQ HAVING

Please read the question carefully and choose the most appropriate
option. Which SQL statement is used to insert a new data in a
database? MCQ INSERT NEW

The SQL
ALTER
TABLE
deletes data
Please read the question carefully and choose the most appropriate from database
option. What does the ALTER TABLE clause do? MCQ table.

Please read the question carefully and choose the most appropriate
option. What is the standard way to separate each SQL statement in
database systems that allow more than one SQL statement to be
executed in the same call to the server. MCQ Comma
Please read the question carefully and choose the most appropriate All listed
option. Which of the given options are TRUE about TCL? MCQ options

Please read the question carefully and choose the most appropriate
option. The result of a SELECT statement can contain duplicate rows. MCQ true

Please read the question carefully and choose the most appropriate
option. Statement1: Data types specify what the type of data can be for
that particular column

Statement 2: Varchar is a datatype in SQL

Only
Which of the above statements is TRUE? MCQ statement 1

The AS
clause is used
Please read the question carefully and choose the most appropriate with the JOIN
option. What is the purpose of the SQL AS clause? MCQ clause only.

Please read the question carefully and choose the most appropriate
option.
The SQL WHERE clause: MCQ NONE

Please read the question carefully and choose the most appropriate
option.
In a LIKE clause, you could ask for any value ending in "qpt" by writing MCQ LIKE %qpt

Please read the question carefully and choose the most appropriate Defines
option. DDL part of SQL does which of the following? MCQ indexes (keys)
 You can use
aggregate
functions only
in the column
list of the
SELECT
clause and in
theWHERE
Please read the question carefully and choose the most appropriate clause of a
option. SELECT
Which two are true about aggregate functions?(Choose two) MCA statement.

SELECT is
invalid without
Please read the question carefully and choose the most appropriate a WHERE
option. A SELECT command without a WHERE clause returns? MCQ clause

Please read the question carefully and choose the most appropriate
option. Statement 1: GRANT, DENY and REVOKE are DCL commands
Statement 2: CREATE, ALTER, DROP, TRUNCATE are DDL None of the
commands MCQ listed options

LIKE ......
Please read the question carefully and choose the most appropriate (that's six
option. In a LIKE clause, you can ask for any 6 letter value by writing? MCQ dots)

Please read the question carefully and choose the most appropriate
option. Which of the following commands should be used to create a DATABSE
database named “student”? MCQ student

Please read the question carefully and choose the most appropriate
option. Which of the following can add a row to a table? MCQ Add

Please read the question carefully and choose the most appropriate
option. Which statement is used to query the database and retrieve
selected data that match the criteria that you specify? MCQ UPDATE
Please read the question carefully and choose the most appropriate
option. Statement 1: The DELETE statement is used to delete columns
in a table.

Statement 2: The UPDATE statement is used to update existing

records in a table.
Only
Which of the above statements are TRUE? MCQ statement 2

Please read the question carefully and choose the most appropriate
option. ANSI is the official U.S. representative to the International
Organization for Standardization (ISO). State whether the above
statement is true or false MCQ false

Please read the question carefully and choose the most appropriate
option. Statement 1: DCL contains the commands which protect data
from unauthorized access.

Statement 2: DCL consists of 2 commands: COMMIT and ROLLBACK

Only
Which of the above statements are TRUE? MCQ statement 1

Please read the question carefully and choose the most appropriate The sort is in
option. ascending
Which two statements are true regarding the ORDER BY clause? order by
(Choose two) MCA default.
All the listed
operation can
Please read the question carefully and choose the most appropriate be done by
option. SQL can be used to: MCQ SQL.

Please read the question carefully and choose the most appropriate
option. Which of the given options return rows when there is at least
one match in both tables? MCQ GROUP BY

Please read the question carefully and choose the most appropriate
option. Which type of join combines the results of both left and right
outer joins? MCQ Cross Join

Please read the question carefully and choose the most appropriate
option. Which syntax would be used to retrieve all rows in both the
EMPLOYEES and DEPARTMENTS tables, even when there is no
match? MCQ Self join
 returns only
the rows from
the first table,
which have
non-matching
values with
the second
table in the
field on which
Please read the question carefully and choose the most appropriate the 2 tables
option. The INNER JOIN clause… MCQ are joined.

You can join n

tables (all
having single
column
primary keys)
in a SQL
statement by
specifying a
minimum of n-
Please read the question carefully and choose the most appropriate 1 join
option. What is true about joining tables through an equijoin? MCQ conditions.

Please read the question carefully and choose the most appropriate
option. Statement 1: In case of Natural Joins, common columns are
columns that have the same number of rows in both tables.

Statement 2: JOIN ON syntax is much more readable and maintainable

than the natural join syntax.
Only
Which of the above statements are TRUE? MCQ statement 1

Please read the question carefully and choose the most appropriate
option. In the relational model, relationships between relations or tables
are created by using: MCQ foreign keys.

Please read the question carefully and choose the most appropriate
option. Statement 1: CROSS JOIN returns the Cartesian product of the
sets of rows from the joined tables.

Statement 2: You can have multiple conditions for the ON clause just
like you can in a WHERE clause.
Only
Which of the above statements is TRUE? MCQ statement 2
Please read the question carefully and choose the most appropriate
option. Statement 1: The FULL OUTER JOIN will return all rows, as
long as there's matching data in one of the tables.

Statement 2: FULL OUTER JOIN includes all the rows from both the
participating tables and does not select either the LEFT or RIGHT table
from the JOIN key word.
Only
Which of the above statements are TRUE? MCQ statement 1

Please read the question carefully and choose the most appropriate
option. If table A have 10 rows and table B have 5 rows, how many
rows will be returned if you perform a cartesian join on those two
tables? MCQ 5

Please read the question carefully and choose the most appropriate
option. A table may be joined to itself. MCQ false

Please read the question carefully and choose the most appropriate
option. Which of the given options return all rows from the left table,
even if there are no matches in the right table? MCQ RIGHT JOIN

Please read the question carefully and choose the most appropriate
option. A Self Join is a type of sql join which is used to join a table to
itself, particularly when the table has a FOREIGN KEY that references
its own PRIMARY KEY.

State whether the above statement is TRUE or FALSE. MCQ false

Please read the question carefully and choose the most appropriate
option. The ___________ join is the ANSI-standard syntax used to
generate a Cartesian product. MCQ ALL

Please read the question carefully and choose the most appropriate
option. Which type of join does not require each record in the two
joined tables to have a matching record? MCQ Outer Join
we are using
Please read the question carefully and choose the most appropriate left and right
option. We refer to a join as a self-join when? MCQ join together
Please read the question carefully and choose the most appropriate
option. SQL joins are used to query data from two or more tables, None of the
based on ___________________. MCQ listed options

Please read the question carefully and choose the most appropriate
option. GROUP BY clause is used in collaboration with the SELECT
statement to arrange identical data into groups.

State whether the above statement is TRUE or FALSE. MCQ true

Please read the question carefully and choose the most appropriate
option. Statement 1: SQL aggregate functions return a single value,
calculated from values in a column.

Statement 2: AVG() returns the average value

None of the
Which of the above statements is TRUE? MCQ listed options

The percent
sign
represents
zero, one, or
multiple
characters,
Please read the question carefully and choose the most appropriate when used
option. with LIKE
Which of the given options is TRUE about LIKE clause? MCQ clause.

Please read the question carefully and choose the most appropriate
option. LIKE clause is used to compare a value to similar values using
logical operators. State whether the above statement is TRUE or
FALSE. MCQ false

Please read the question carefully and choose the most appropriate
option. The GROUP BY clause follows the WHERE clause in a
SELECT statement and precedes the ORDER BY clause.

State whether the above statement is TRUE or FALSE. MCQ true

Please read the question carefully and choose the most appropriate
option. The ROUND() function is used to round a numeric field to the
nearest hundred.
State whether the above statement is TRUE or FALSE. MCQ false

Please read the question carefully and choose the most appropriate
option. The HAVING clause places conditions on the selected columns,
whereas the WHERE clause places conditions on groups created by
the GROUP BY clause.

State whether the above statement is TRUE or FALSE. MCQ false

SUM function
allows
selecting the
total for a
Please read the question carefully and choose the most appropriate numeric
option. Which of the given options is TRUE? MCQ column.

Please read the question carefully and choose the most appropriate
option. Statement 1: Numeric functions accept numeric input and return
string values.

Statement 2: Single-row functions return a single result row for every

row of a queried table or view.
Only
Which of the above statements are TRUE? MCQ statement 1

Please read the question carefully and choose the most appropriate
option. The percent sign and the underscore cannot be used in
combinations, when using LIKE clause.

State whether the above statement is TRUE or FALSE. MCQ false

Please read the question carefully and choose the most appropriate
option. You cannot add a subquery to a SELECT clause as a column
expression in the SELECT list.

State whether the above statement is TRUE or FALSE. MCQ true

Please read the question carefully and choose the most appropriate CREATE
option. Which of the following is valid SQL for an Index? MCQ INDEX ID;

Please read the question carefully and choose the most appropriate
option. Statement 1: A subquery is also called an inner query or inner
select, while the statement containing a subquery is also called an
outer query or outer select.

Statement 2: A subquery can be nested inside the WHERE or HAVING

clause of an outer SELECT, INSERT, UPDATE, or DELETE statement, Both
or inside another subquery. statement 1
and statement
Which of the above statements are TRUE? MCQ 2

Please read the question carefully and choose the most appropriate DELETE
option. View can be removed using which command? MCQ VIEW

Please read the question carefully and choose the most appropriate
option. Statement 1: A view can be accessed with the use of SQL
SELECT statement like a table.

Statement 2: A view can be made up by selecting data from more than

one tables.
Only
Which of the above statements are TRUE? MCQ statement 2

Please read the question carefully and choose the most appropriate
option. An index helps speed up SELECT queries and WHERE
clauses, but it slows down data input, with UPDATE and INSERT
statements.

State whether the above statement is TRUE or FALSE. MCQ true

Please read the question carefully and choose the most appropriate
option. Statement 1: Clustered index physically rearranges the data
that users inserts in your tables.
Both
Statement 2: There can be 2000 non-clustered index per table. statement 1
and statement
Which of the above statement are TRUE? MCQ 2
 An inline view
exists only
inside of the
FROM clause
Please read the question carefully and choose the most appropriate as a run-time
option. Which of the given options are TRUE? MCQ result set.

Please read the question carefully and choose the most appropriate
option. Statement 1: If a subquery is not dependent on the outer query
it is called a non-correlated subquery.

Statement 2: Subqueries cannot be used with the comparison

operators.
None of the
Which of the above statements are TRUE? MCQ listed options

Please read the question carefully and choose the most appropriate
option. A query is called correlated subquery when both the inner query
and the outer query are interdependent.

State whether the above statement is TRUE or FALSE. MCQ false

Please read the question carefully and choose the most appropriate
option. Statement 1: The SQL subquery is a SELECT query that is
embedded in the main SELECT statement.
Both
Statement 2: A subquery cannot return more than one rows statement 1
and statement
Which of the above statements is TRUE? MCQ 2

Carefully read the question and answer accordingly. The following s/w
process model can be represented schematically as a series of major All of the
technical activities and there associated sate MCQ listed options

Both are
Carefully read the question and answer accordingly. If Quality Control literally the
and Quality Assurance are compared MCQ same

Carefully read the question and answer accordingly. To produce a

good quality product, process should be MCQ None
Carefully read the question and answer accordingly. Software
processes can be constructed out of pre-existing software patterns to
best meet the needs of a software project. State True or False MCQ false

Carefully read the question and answer accordingly. Who is essentially Development
responsible for the quality of a product MCQ Manager

Carefully read the question and answer accordingly. Data structure procedural
suitable for the application is discussed in ? MCQ design

Carefully read the question and answer accordingly. Using software To decrease
process improvement model will help a company MCQ the defect rate

Carefully read the question and answer accordingly. The object All of the
relationship pair of data model is represented graphically by using MCQ listed options

Carefully read the question and answer accordingly. Which one is the Efficiency
most important feature of spiral model MCQ management

do not waste
development
time on
Carefully read the question and answer accordingly. Process models planning
are described as agile because they MCQ activities

Carefully read the question and answer accordingly. People who

perform software quality assurance must look at the software from the
customer's perspective. MCQ false

Carefully read the question and answer accordingly. In software quality

assurance work there is no difference between software verification
and software validation. State True/False MCQ false

Carefully read the question and answer accordingly.

Software is a product and can be manufactured using the same
technologies used for other engineering artifacts. State True or False MCQ true

have
measurable
specifications
Carefully read the question and answer accordingly. A key concept of for process
quality control is that all work products MCQ outputs

Carefully read the question and answer accordingly. What are the
qualities of a good s/w MCQ Portability
 may result
Carefully read the question and answer accordingly. Software safety is from user
a quality assurance activity that focuses on hazards that MCQ input errors

Carefully read the question and answer accordingly. The goal of quality
assurance is to provide management with the data needed to
determine which software engineers are producing the most defects. MCQ false

Carefully read the question and answer accordingly. Variation control in process
the context of software engineering involves controlling variation in the MCQ applied

Carefully read the question and answer accordingly. What is used to Process
measure the characteristics of the documentation and code MCQ metrics

Carefully read the question and answer accordingly. The purpose of

software reviews is to uncover errors in work products so they can be
removed before moving on to the next phase of development. MCQ false
attributes,
Carefully read the question and answer accordingly. In object oriented name and
design of software , objects have MCQ operations

Carefully read the question and answer accordingly. Which of these

criteria are useful in assessing the effectiveness of a particular
design notation MCQ modularity
The primary
output of the
Carefully read the question and answer accordingly. Which of the system design
following is the correct definition for DFD MCQ phase

Classes are
defined based
Carefully read the question and answer accordingly. Which of the on the
following comments about object oriented design of software, is not attributes of
true MCQ objects

Hardware
Carefully read the question and answer accordingly. In system design, design after
we do following MCQ software

Carefully read the question and answer accordingly. Which of these is

a graphical notation for depicting procedural detail MCQ flowchart
Carefully read the question and answer accordingly. The term module
in the design phase refers to MCQ Sub programs

Carefully read the question and answer accordingly. Informational structured

cohesion is a realization of MCQ programming
size of the
Carefully read the question and answer accordingly. The work products product being
produced during requirement elicitation will vary MCQ built

Carefully read the question and answer accordingly. Object-oriented

analysis techniques can be used to identify and refine user task
objects and actions without any need to refer to the user voice. State
True/False MCQ true

Carefully read the question and answer accordingly. Change cannot be

easily accommodated in most software systems, unless the system
was designed with change in mind. State True/False MCQ false

Carefully read the question and answer accordingly. Software

Engineering is the systematic approach to the development, operation,
maintenance and retirement of software. This definition is given
by_________ MCQ Bauer

Carefully read the question and answer accordingly. Which of the items
listed below is not one of the software engineering layers MCQ Tools

Carefully read the question and answer accordingly. Software

engineering umbrella activities are only applied during the initial phases
of software development projects. State True or False MCQ true

Carefully read the question and answer accordingly. Which phase is

not available in s/w life cycle MCQ Coding

Mini model of
existing
Carefully read the question and answer accordingly. The Prototype is a MCQ system

Neither
Carefully read the question and answer accordingly. Which of the intrinsically
following is not Risk characteristic MCQ good not bad

Carefully read the question and answer accordingly. Management of

software development is dependent upon MCQ People
 send them to
the design
team and see
Carefully read the question and answer accordingly. The best way to if they have
conduct a requirements validation review is to MCQ any concerns

Carefully read the question and answer accordingly. Software Reliable

engineering aims at developing MCQ Software

The potential
loss or impact
Carefully read the question and answer accordingly. Major component associated
of Risk Analysis are MCQ with the event
Know the
Carefully read the question and answer accordingly. Milestones are status of the
used to MCQ project

Carefully read the question and answer accordingly. The review is one
of the methods of V&V. The other methods are MCQ Walkthrough
Better
Carefully read the question and answer accordingly. Software performance
Engineering approach is used to achieve MCQ of h/w

Carefully read the question and answer accordingly. Which is not the Prepare
responsibility of customer/ user of the software MCQ resource plan

Carefully read the question and answer accordingly. A stakeholder is

anyone who will purchase the completed software system under
development. State True/False MCQ false

Carefully read the question and answer accordingly. Project risk factor
is considered in MCQ Water fall

The best
approach to
use for
projects with
large
Carefully read the question and answer accordingly. The prototyping development
model of software development is MCQ teams
Carefully read the question and answer accordingly. required for all
Control flow diagrams are MCQ systems.

Carefully read the question and answer accordingly. A data model All of the
consists of the following information MCQ listed options

Carefully read the question and answer accordingly. Which of following

is not a UML diagram used creating a system analysis Activity
model MCQ diagram

Carefully read the question and answer accordingly. If requirements

are frequently changing, which model is best suited MCQ RAD

Carefully read the question and answer accordingly. The data flow
diagram must be augmented by descriptive text in order to
describe the functional requirements for a software product. State
True/False MCQ true

The best
approach to
use for
projects with
large
Carefully read the question and answer accordingly. The incremental development
model of software development is MCQ teams.

Carefully read the question and answer accordingly. Which is not a

software life cycle model MCQ Spiral

Carefully read the question and answer accordingly. If requirements

are understandable, easy, defined, which model is best suited MCQ Prototype

depicts
functions that
Carefully read the question and answer accordingly. The entity transform the
relationship diagram MCQ data flow

A quantitative
measure of
the current
Carefully read the question and answer accordingly. What exactly level of
Baseline means MCQ performance
Carefully read the question and answer accordingly. Which of these are
valid software configuration items? MCQ test data

make sure
that change
information is
communicate
d to all
Carefully read the question and answer accordingly. The primary affected
purpose of configuration status reporting is to MCQ parties

Carefully read the question and answer accordingly. When software

configuration management is a formal activity, the software senior
configuration audit is conducted by the MCQ managers

Carefully read the question and answer accordingly. A new

__________ is defined when major changes have been made to one or
more configuration objects. MCQ item

management
of the
configurable
Carefully read the question and answer accordingly. components
What is configuration management in software engineering MCQ in a system

Carefully read the question and answer accordingly.

In requirements validation the requirements model is reviewed to
ensure its technical feasibility. State True/False MCQ false

Carefully read the question and answer accordingly. A basic

configuration object is a __________ created by a software engineer All of the
during some phase of the software development process. MCQ listed options

Carefully read the question and answer accordingly. The ability to track
relationships and changes to configuration objects is one of the most
important features of the SCM repository. MCQ true

Carefully read the question and answer accordingly. Which of the change
following tasks is not part of software configuration management? MCQ control
Please read the question carefully and choose the most appropriate
option. An input field takes the birth year of the user ranging from 1960
to 1995. The boundary values for testing this field are? MCQ 0,1960,1995

Please read the question carefully and choose the most appropriate
option. Business
Test scenarios have to be written with the consideration of ? MCA rules

Please read the question carefully and choose the most appropriate
option. State whether True or False.
Testers should be involved in reviewing documents as soon as drafts
are available in the development cycle. MCQ true

Please read the question carefully and choose the most appropriate
option. Alternate flows can be tested by themselves (State Frue or
false) MCQ true

Please read the question carefully and choose the most appropriate All the listed
option. We derive _________ by using the test design techniques MCQ options

Please read the question carefully and choose the most appropriate
option. State whether True or False.
A use case can result into more than one scenario. MCQ true
Test condition
Please read the question carefully and choose the most appropriate defining
option. Test data preparation data is done during _________ ? MCQ process

Please read the question carefully and choose the most appropriate
option. For a given set of boundaries, how many boundary values are
possible? MCQ 2
Please read the question carefully and choose the most appropriate
option.
Test Scenarios have case specific data assigned to them (State True
or False) MCQ true

Test scenario
Please read the question carefully and choose the most appropriate involves the
option. expected
Which of the following statements is/are true? MCA results.

Please read the question carefully and choose the most appropriate
option. Test conditions can be valid or invalid (State True or False) MCQ false
Please read the question carefully and choose the most appropriate
option.
Which of the below is not an activity involved in Test execution Test data
process? MCQ setup

Please read the question carefully and choose the most appropriate
option. The conditions that need to be verified by the tester after the
activity is performed are called _________? MCQ Exceptions

Please read the question carefully and choose the most appropriate
option. State whether True or False. Triage meeting is done before
fixing the defect. MCQ false

A. Build the
compiled code
into software
B. Add the
release notes
C. Perform
Please read the question carefully and choose the most appropriate Smoke/ Sanity
option. Which is the correct order to be followed for a Build Verification Test D. Test
Process? MCQ Execution

Please read the question carefully and choose the most appropriate
option. A defect is found after retest. What are all the possible stages Reopen,
this defect may undergo? MCQ Fixed, Closed

Verifying that
the test
environment
Please read the question carefully and choose the most appropriate has been set
option. Which is not a major task of test implementation and execution? MCQ up correctly

Please read the question carefully and choose the most appropriate
option. State whether True or False. Release notes are prepared by
developer/ development team. MCQ true
 Develop and
prioritizing test
cases,
creating test
data, writing
test
procedures
and optionally,
preparing test
harness and
writing
Please read the question carefully and choose the most appropriate automated
option. Which is not a major task of test implementation and execution? MCQ test scripts

Please read the question carefully and choose the most appropriate
option.
What are the subsequent states that a new defect can undergo? MCA Closed

Please read the question carefully and choose the most appropriate
option. State whether True or False. Developer has to ensure that the
pre requisite of each test case are met. MCQ True
Please read the question carefully and choose the most appropriate
option.
What are the action items if an application does not behave as Update status
expected? MCA of the defect

Please read the question carefully and choose the most appropriate Use of proper
option. Software testing ensures which of the below? MCQ test approach

Please read the question carefully and choose the most appropriate
option. Match the following.
A) Self review B) Formal review C) Informal review
1. Conducted by one or more peers in the team
2. Conducted by one or more reviewers or SME A - 3, B - 1, C
3. Conducted by the author himself MCQ -2

Please read the question carefully and choose the most appropriate
option. Review of Test case Artifact is done with the help of? MCQ Reviewer
Please read the question carefully and choose the most appropriate
option.
In causal analysis which attributes among below assist in analyzing the
effect? MCA Failures
Please read the question carefully and choose the most appropriate
option. State whether true or false. Selenium tools helps to develop
Automated test scripts MCQ true

Helps to
Please read the question carefully and choose the most appropriate provide a
option. reliable
Which of the statements is applicable to software testing? MCA system

Please read the question carefully and choose the most appropriate Test
option. Test environment check up is part of _________ . MCQ Execution

Developers
tend to
Please read the question carefully and choose the most appropriate neglect test
option. approach to
What are the possible causes for ending up into 0.1 % defective the developed
application? MCA product.

Requirement
Analysis -
Test Planning
Design and
Code - Test
Please read the question carefully and choose the most appropriate Design
option. Which of the following map the corresponding phases from Testing - Unit
SDLC with STLC. MCQ Testing

Please read the question carefully and choose the most appropriate
option. State whether true or false. QC is used for logging the outcome
of the test execution. MCQ false
Choice2 Choice3 Choice4 Choice5 Grade1 Grade2

The UNIQUE
constraint
uniquely
identifies each
record in a
database None of the All listed
table. listed options options 0 1
Constraints
gives Constraints Constraints
programmers ensure data add a level of
job security integrity complexity 0 0

The NOT
NULL Constraints
constraint are used to
enforces a limit the type
column to of data that
NOT accept All listed can go into a
NULL values. options table 0 0

Both
statement 1
and statement None of the Only
2 listed options statement 1 1 0

false 0 1

false 1 0
The primary
key column is
a column or
combination The primary
of columns key is a
whose values column that
can be non- can have
unique. NULL values. 1 0

false 0 1

None of the Only Only

listed options statement 1 statement 2 1 0

Both
statement 1
and statement None of the Only
2 listed options statement 1 0 1

ON DELETE ON DELETE None of the

SET NULL ORPHAN listed options 1 0

Only Only None of the

statement 1 statement 2 listed options 0 1
None of the Only Only
listed options statement 1 statement 2 1 0

UNION INTERSECT UNION ALL 1 0

true 0 1

false 0 1

Both
statement 1
Only and statement Only
statement 1 2 statement 2 0 1

RESTRICT GROUP BY HAVING 0 0

Materialized
View Normalization data Integrity 0 0
modify an delete a table
existing table from the
in a database database 0 0

TRUNCATE REMOVE DROP 0 0

 None of the
DISTINCT listed options UNIQUE 0 1

Holds a
variable
length string
(can contain
letters, Its maximum
numbers, and size is
special None of the specified in
characters). listed options parenthesis. 1 0

SELECT
CustomerNam
e,
COUNT(Cust SELECT
omerName) CustomerNam
FROM Orders e,
GROUP BY COUNT(Cust
CustomerNam omerName)
e FROM Orders 0 1

COMPUTE MAX MIN 0 1

false 1 0

UPDATE UPDATE UPDATE

employees employees employees
SET SET SET
first_name = first_name = first_name =
'John' SET 'John', SET 'John',
last_name last_name last_name
='Smith' ='Smith' ='Smith'
WHERE WHERE WHERE
employee_id employee_id employee_id
= 180; = 180; = 180; 0 0
WHERE WHERE WHERE
lower(country lower(country lower(country
_address) = _address) IS _address) =
"france" 'france' 'france' 0 0

AND FROM WHERE 0 0

ADD UPDATE INSERT INTO 0 0

The SQL
ALTER
TABLE clause
modifies a
The SQL table definition The SQL
ALTER by altering, ALTER
TABLE clause adding, or TABLE clause
is used to deleting table is used to
insert data columns delete a
into database and/or database
table. constraints. table 0 0

All listed
Colon options Semicolon 0 0
 TCL contains
the
TCL consists commands
of 2 which are
commands: required for
COMMIT and None of the Transaction
ROLLBACK listed options Management. 1 0

false 1 0

Both
statement 1
Only and statement None of the
statement 2 2 listed options 0 0

The AS SQL
clause is used
to change the
name of a
column in the
result set or to
assign a The AS
name to a clause defines
derived a search
column. condition 0 1
limits the
limits the rows column data limits the row
& columns that are data that are
returned returned. returned. 0 0

LIKE *qpt LIKE ^.*qpt$ LIKE qpt$ 1 0

Specifies links
between
tables, and allows
imposes database
constraints tables to be
between All listed created or
tables options deleted 0 0
 You can mix
single row
columns with
You can pass aggregate
column functions in
names, the column list
expressions, of a You can use
constants, or SELECTstate aggregate
functions as ment by functions in
parameters to grouping on any clause of
anaggregate the single row a SELECT
function. columns. statement. 0 0.5

All the records

All the records from a table
from a table, that match the
or information previous
about all the WHERE
Nothing records clause 0 0

Both
statement 1
Only and statement Only
statement 1 2 statement 2 0 0
LIKE ______
LIKE .{6} (that's six
Answer 5: underscore
LIKE ?????? LIKE ^.{6}$ characters) 0 0

CREATE
CREATE ?I DATABASE DATABASE
student /student student 0 0

Insert Update Alter 0 1

RETRIEVE SELECT INSERT 0 0

Both
statement 1
and statement None of the Only
2 listed options statement 1 1 0

true 0 1

Both
statement 1
None of the and statement Only
listed options 2 statement 2 1 0

The ORDER
BY clause The ORDER The sort is in
comes last in BY clause is descending
the SELECT executed on order by
statement. the client side default 0.5 0.5
create
query database
database data structures Modify the
only. only. database 1 0

WHERE JOIN ORDER BY 0 0

Full Outer All listed

Join Inner join options 0 1

Natural join Outer join Inner join 0 0

 returns all
rows that
have
matching
value in the
returns all field on which
rows from 2 the 2 tables
tables are joined. 0 0

You can join a You can join a

maximum of maximum of
two columns two tables
through an All listed through an
equijoin. options equijoin. 1 0

Both
statement 1
and statement Only None of the
2 statement 2 listed options 0 0

composite candidate
keys. determinants. keys 1 0

Both
statement 1
Only None of the and statement
statement 1 listed options 2 0 0
Both
statement 1
and statement None of the Only
2 listed options statement 2 0 1

15 10 50 0 0

true 0 1

JOIN CROSS JOIN LEFT JOIN 0 0

true 0 1

FULL CROSS NATURAL 0 0

Equi Join Inner join Self join 1 0

we are joining
more than 2 we are joining
tables table to itself 0 0
a relationship
between a relationship
certain between
columns in certain rows in All listed
tables tables. options 0 1

false 1 0

Both
statement 1
and statement Only Only
2 statement 2 statement 1 0 1

The
underscore
Both the represents a
statements single number
given or character. 0 1

true 1 0

false 1 0
true 1 0

true 1 0

COUNT
function is
used to count
the number of
columns in a
None of the database All listed
listed options table. options 1 0

None of the Only All the listed

listed options statement 2 options 0 0

true 1 0

false 0 1
REMOVE CHANGE ADD INDEX
INDEX ID; INDEX ID; ID; 1 0

Only None of the Only

statement 2 listed options statement 1 1 0

REMOVE All listed

VIEW options DROP VIEW 0 0

Both
statement 1
and statement None of the Only
2 listed options statement 1 0 1

false 1 0

None of the Only Only

listed options statement 2 statement 1 0 0
 An inline view
exists only
A subquery inside of the
exists only WHERE
inside of the clause as a
All listed FROM clause run-time result
options as a run-time set. 1 0

Both
statement 1
Only Only and statement
statement 1 statement 2 2 0 1

true 0 1

None of the Only Only

listed options statement 2 statement 1 0 0

Concurrent
Incremental development Component
model model assembly 0 0

QA is done by
the client and QC is a higher QA is a higher
QC is done by activity in the activity in the
the software management management
vendor Hierarchy Hierarchy 0 0

Rigorous Complex Efficient 0 0

true 0 1

Customer QA Manager 1 0

architectural interface
design design data design 0 0
To decrease
All of the To increase development
listed options profitability time To meet schedule 0 1

Entity
Data flow relationship
Flow chart diagram diagram 0 0

Performance Risk Quality

Management Management management 0 0

eliminate the
emphasize need for make
maneuverabili cumbersome extensive use
ty and documentatio of prototype
adaptability n creation 0 1

true 0 1

true 1 0

false 0 1

are thoroughly have

tested before are delivered complete
delivery to the on time and documentatio
customer under budget n 1 0

All of the Inter

Reusability listed options Operability 0 0
prevent
profitable affect the
marketing of may cause an reliability of a
the final entire system software
product to fail component 0 0

true 1 0

product
All of the resources quality
listed options expended attributes 0 1

Software
Quality Product None of the
metrics metrics listed options 0 0

true 0 1
operations
None of the and names attributes and
listed options only names only 1 0

size maintainability simplicity maintainability, simplicity and m 0 0

Mainly used at
The modern systems
version of specification All of the
flowchart stages listed options 1 0

an object can classes are Objects inherit

belong to two always the properties
classes different of class 0 1
Parallel
Software hardware and No hardware
design after software design
hardware design needed 0 0

process
ER diagram decision table diagram 1 0
 All of the
Procedures listed options Functions 0 0

data
Modularity Concurrency abstraction 0 0
software
size of the stakeholders process being
budget needs used 1 0

false 0 1

true 0 1

Charles
Boehm Babbage IEEE 0 0

Manufacturing Methods Process 0 1

false 0 1

Installation &
Specifications Design Maintenance 0 0
Working
model of Mini model of
existing processed None of the
system system listed options 0 1
Something to
fear but not
something to Probability of Inherent in
manage loss every project 0 1

All of the
Process listed options Product 0 0
 use a
checklist of have the
examine the questions to customer look
system model examine each over the
for errors requirement requirements 0 0
Reliable and
None of the Cost Effective cost effective
listed options Software Software 0 0
The
probability
that the
negative
event will The
occur and The probability
potential loss that the
or impact The potential negative
associated loss is very event will
with the event high occur 0 1

Know the cost Know the user None of the

of the project expectations listed options 1 0

All of the
Inspection Testing listed options 0 0
Quality
Reusable software
software Error free s/w product 0 0

Plan
resources for
Plan how and providing
by whom each information on
acceptance which to base Prepare the
activity will be acceptance acceptance
performed decisions plan 1 0

true 1 0

All of the
Spiral listed options Prototype 0 1

A useful
approach A reasonable
A risky model when a approach
that rarely customer when
produces a cannot define requirements
meaningful requirements are well
product clearly defined 0 0
 needed to
used in place useful for model event
of data flow modeling real- driven
diagrams. time systems. systems. useful for modeling real-time s 0 0
Relationship
The attributes that connect
that describe data object to
data object one another Data Object 1 0

Dataflow
Class diagram State diagram diagram 1 0

Prototype Water fall  Spiral 0 1

false 1 0

A good
approach A reasonable A
when a approach revolutionary
working core when model that is
product is requirements not used for
required are well commercial
quickly defined products 0 1
Capability
Maturity
Model  Water fall Prototype 0 1

None Water fall  Spiral 0 0

indicates
depicts indicates how system
relationships data are reactions to
between data transformed external
objects by the system events 0 1

A single
software A test or
product that analysis
may or may conducted
not fully after an
support a application is
business moved into None of the
function production listed options 1 0
 executable All of the
software tools programs listed options documentation 0 0

evaluate the allow revision

performance of project
of software schedules and
developers cost estimates
and None of the by project
organizations listed options managers 1 0

quality
development assurance testing
team group specialists 0 0

version entity variant 0 1

in object- the
oriented identification
programming, of the
the configuration
management of a system at
of objects that discrete points
control the in time to
configuration control overall
of some other changes to management
function(s) in the of the design
the system configuration of the system 0 0

true 1 0

program data unit of a software

structure information component 0 0

false 1 0

version statistical
control quality control reporting 0 0
1959, 1960, 0, 1959, 1960,
1961, 1994, 1960, 1995, 1961, 1994,
1995, 1996 1996 1995, 1996 1959, 1960, 1994, 1995 0 1

Functional None of the Non functional

standards listed options standards 0.333 0.333

false 1 0

false 0 1

None of the
Test Scenario Test case listed options Test condition 0 0

false 1 0
Test Test Test Scenario
Development Execution identification
process process process 0 1

None of the
listed options 4 8 6 0 0

false 0 1

Test scenario
Test case define the Test cases
includes the setup to are developed
steps to perform the from Test
execute. tests conditions. Test case includes the method 0 0.5

true 0 1
 Build
Retesting of verification Test case
defects process execution Defect Tracking 1 0

Post condition Pre condition Triggers 0 1

true 0 1

A. Review the
code B. Build
the compiled
code into
software C.
Perform
Smoke/ Sanity
Test D. Test
Execution 0 0
Defferred,
Open, Fixed, Open, Fixed,
Reopen, Reopen, Reopen,
Closed Fixed Closed 1 0

Develop and
prioritizing test
cases, Verifying that
creating test the test
data, writing environment
test has been set
procedures up correctly
and optionally, and Checking Checking test
preparing test test logs logs against
harness and against the the exit
writing exit criteria criteria
automated specified in specified in
test scripts test planning test planning Logging the outcome of test exec 0 0

false 0 1
Logging the Verifying that
outcome of the test
test execution environment
and recording has been set
the identities up correctly
and versions and Checking
of the Verifying that test logs
software the test against the
under test, environment exit criteria
test tools and has been set specified in
testware up correctly test planning Checking test logs against the ex 0 0

Rejected Deferred Fixed Open 0 0.333

false 0 1
Execute next
test step of
same test
case Log defect Retest 0.5 0

Requirement
satisfaction
Usage of and usage of
design Proper causal best design
architecture analysis architecture None of the listed options 0 0

A - 2, B - 1, C A - 2, B - 3, C A - 3, B - 2, C
-3 -1 -1 A - 1, B - 2, C - 3 0 0

Self review Author Peer review Checklist 0 0

Requirement
Cause gathering Reason Test Approach 0 0.5
false 1 0

Helps to
identify
completeness
Helps prevent None of the of the
the defects listed options software Helps in identifying defects 0.25 0.25

None of the Test

listed options Test Scenario Development Test Design 1 0

Less
knowledge on Lack of
Defective development domain
code language knowledge Misunderstood requirements 0.25 0.25

Requirement Requirement
Analysis - Analysis -
Test Planning Test Planning
Design and Design and
Code - Unit Code - Test
Testing Design
Testing - Testing -
Component Component
Integration Integration
testing and testing and
None of the System System
listed options testing testing Requirement Analysis - Test De 0 0

true 0 1
Grade3 Grade4 Grade5 AnswerDescriptQuestionMedia AnswerMedia Author

0 0 TEXT TEXT

1 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

TEXT TEXT
0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT
0 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 1 TEXT TEXT

0 1 TEXT TEXT

1 TEXT TEXT

0 1 TEXT TEXT
0 0 TEXT TEXT

0 0 TEXT TEXT

0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT
0 1 TEXT TEXT

0 1 TEXT TEXT

0 1 TEXT TEXT

1 0 TEXT TEXT

0 1 TEXT TEXT
0 0 TEXT TEXT

TEXT TEXT

1 0 TEXT TEXT

0 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
0.5 0 TEXT TEXT

1 0 TEXT TEXT

1 0 TEXT TEXT

0 1 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
0 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
1 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

0 1 TEXT TEXT
0 0 TEXT TEXT

0 1 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT

TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

1 TEXT TEXT
0 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 TEXT TEXT

TEXT TEXT

TEXT TEXT
 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

TEXT TEXT

TEXT TEXT
11111 0 TEXT TEXT

0 0 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT
0 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT

1 0 TEXT TEXT

1 0 TEXT TEXT

0 1 TEXT TEXT
 TEXT TEXT

0 TEXT TEXT

0 1 TEXT TEXT

0 0 0 TEXT TEXT

0 1 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
1 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 0 1 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT
1 0 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
1 0 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

0 1 TEXT TEXT

0 1 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT
1 0 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

0 0 TEXT TEXT
0 1 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

0 0 TEXT TEXT

1 0 TEXT TEXT

TEXT TEXT

0 1 TEXT TEXT

TEXT TEXT

1 0 TEXT TEXT
0 0 0 TEXT TEXT

0 0.333 TEXT TEXT

TEXT TEXT

TEXT TEXT

1 0 0 TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 0 1 TEXT TEXT

TEXT TEXT

0 0 0.5 TEXT TEXT

TEXT TEXT
0 0 0 TEXT TEXT

0 0 TEXT TEXT

TEXT TEXT

TEXT TEXT

0 0 TEXT TEXT

0 1 0 TEXT TEXT

TEXT TEXT
 0 0 1 TEXT TEXT

0.333 0 0.333 TEXT TEXT

TEXT TEXT

0.5 0 TEXT TEXT

0 1 0 TEXT TEXT

0 1 0 TEXT TEXT

0 0 1 TEXT TEXT

0 0.5 0 TEXT TEXT

 TEXT TEXT

0 0.25 0.25 TEXT TEXT

0 0 0 TEXT TEXT

0 0.25 0.25 TEXT TEXT

0 1 0 TEXT TEXT

TEXT TEXT
Reviewer Is Numeric