WINDOWS NT QUIZ

A way to establish a loop in SQL.

A way to establish a data definition in SQL.

All of these

A way to establish an IF-THEN-ELSE in SQL.

All of these

Involves the use of an inner and outer query.

Cannot return the same result as a query that is not a subquery.

Does not start with the word SELECT.

False

True

False

True

True

False

Outer join

Cartesian join

Equi-join

Natural join

Combines the output from multiple queries and does not include the same number of columns.

Combines the output from no more than two queries and does not include the same number of columns.

Combines the output from no more than two queries and must include the same number of columns.

Combines the output from multiple queries and must include the same number of columns.

Outer join

Equi-join

Natural join

All of these

False

True

You do not create them with SQL.

They have an event, condition, and action.

They cannot cascade (cause another trigger to fire).

They execute against only some applications that access a database.