Tag: testing

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.