ADVANCED SQL QUIZ

A UNION query is which of the following?

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

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 must include the same number of columns.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

A CASE SQL statement is which of the following?

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

A way to establish a data definition in SQL.

A way to establish a loop in SQL.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A function returns one value and has only output parameters.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

There should be one condition within the WHERE clause for each pair of tables being joined.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Subqueries can be nested multiple times.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

How many tables may be included with a join?

One

Two

All of these

Three

TRUE ANSWER : ?
YOUR ANSWER : ?

Embedded SQL is which of the following?

The process of making an application capable of generating specific SQL code on the fly.

Hard-coded SQL statements in a program language such as Java.

Hard-coded SQL statements in a procedure.

Hard-coded SQL statements in a trigger.

TRUE ANSWER : ?
YOUR ANSWER : ?

Triggers are stored blocks of code that have to be called in order to operate.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑