ADVANCED SQL QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ROLLBACK WORK asks SQL to empty the log file.

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

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

Cartesian join

Equi-join

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

Cartesian join

Natural join

TRUE ANSWER : ?
YOUR ANSWER : ?

Subqueries can be nested multiple times.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Embedded SQL is which of the following?

Hard-coded SQL statements in a procedure.

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 trigger.

TRUE ANSWER : ?
YOUR ANSWER : ?

A function returns one value and has only output parameters.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Subqueries

All of these

Union Join

Natural join

TRUE ANSWER : ?
YOUR ANSWER : ?

↑