ADVANCED SQL QUIZ

With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A CASE SQL statement is which of the following?

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

All of these

A way to establish a loop in SQL.

A way to establish a data definition in SQL.

TRUE ANSWER : ?
YOUR ANSWER : ?

How many tables may be included with a join?

All of these

One

Two

Three

TRUE ANSWER : ?
YOUR ANSWER : ?

When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

Natural join

Outer join

Equi-join

Cartesian join

TRUE ANSWER : ?
YOUR ANSWER : ?

Embedded SQL is which of the following?

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.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is where the outer query depends on data from the inner query.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following statements is true concerning subqueries?

All of these

Does not start with the word SELECT.

Involves the use of an inner and outer query.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Natural join

All of these

Subqueries

Union Join

TRUE ANSWER : ?
YOUR ANSWER : ?

What type of join is needed when you wish to return rows that do have matching values?

All of these

Equi-join

Outer join

Natural join

TRUE ANSWER : ?
YOUR ANSWER : ?