ADVANCED SQL QUIZ

Which of the following is a correlated subquery?

Uses the result of an outer query to determine the processing of an outer query.

Uses the result of an inner query to determine the processing of an inner query.

Uses the result of an outer query to determine the processing of an inner query.

Uses the result of an inner query to determine the processing of an outer query.

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.

False

True

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 : ?

How many tables may be included with a join?

Two

One

Three

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is one of the basic approaches for joining tables?

All of these

Natural join

Subqueries

Union Join

TRUE ANSWER : ?
YOUR ANSWER : ?

Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Outer join

Equi-join

Natural join

Cartesian join

TRUE ANSWER : ?
YOUR ANSWER : ?

The UNION clause is used to combine the output from multiple queries together into a single result table.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A UNION query is which of the following?

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

Embedded SQL is which of the following?

Hard-coded SQL statements in a procedure.

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

Hard-coded SQL statements in a trigger.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

↑