Poor software characteristics comes under product risk

Failure to follow up on information found in testing and reviews comes under product risk

Problems in defining the right requirements comes under project risk

The quality of the design, code and tests comes under project risk

True

False

True

False

Finding defects

Fixing defects

Gaining confidence about the level of quality

Preventing defects

We are joining two tables only

we are using left and right join together

we are joining table to itself

we are joining more than 2 tables

Access. Constant. Information. Data.

Atomicity. Consistency. Isolation. Durability.

Access. Constraint. Index. Data.

Access. Consistency. Isolation. Data.

There is no default value.

DESC

Random

ASC

TRUNCATE Sales TABLE

TRUNCATE * FROM TABLE Sales

TRUNCATE TABLE Sales

TRUNCATE * FROM COLUMN Sales

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

returns all the matching rows from 2 tables.

returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

returns all rows from 2 tables.

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

Indexes are only used in special cases

Indexes are used to make table storage more efficient

Indexes rarely make a difference in SQL performance

Indexes exist solely to improve query speed

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database table attribute, which speeds-up data search within a table.

An index is a database row attribute, which speeds-up data search within a table.

UPDATE, DELETE, INSERT and SELECT statements.

UPDATE statements only.

DELETE statements only.

INSERT statements only.

Removal of data redundancy

The introduction of data redundancy

The introduction of non-first normal form relations

The introduction of SQL*Plus

The number of CPUs on the server

The degree of parallelism on the tables

The quality of the SQL optimization

The use of bitmap indexes

Black box testing

System testing

Independent testing

Acceptance Testing

True

False

Reviews

Testing

Both

None of the above

Stubs

Manual simulation

Coverage metrics

All of the above

True

False