Question 1

Contents of the CUSTOMERS table
 
-Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?

Accepted Answer

A)  SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ'); 
B)  SELECT customer# FROM customers WHERE state =
(SELECT state FROM customers WHERE customer#=1013); 
C)  SELECT customer# FROM customers WHERE customer# IN
(SELECT state FROM customers WHERE state = 'NJ'); 
D)  SELECT customer# FROM customers WHERE state EXISTS
(SELECT state FROM customers WHERE customer#=1013);

Question 2

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.

Accepted Answer

The answer of The ____________________ operator indicates that a value...

Question 3

A(n) ____________________ is a nested query - one complete query inside another query.

Accepted Answer

The answer of A(n) ____________________ is a nested query -...

Question 4

Explain the difference between multiple-row and multiple-column subqueries.

Accepted Answer

The answer of Explain the difference between multiple-row and multiple-column...

Question 5

In Oracle11g, a MERGE statement compares data between two tables and can perform a series of DML actions to assist in synchronizing the data of the two tables.

Accepted Answer

A) True 
 B)False

Question 6

The EXISTS operator must be listed ____.

Accepted Answer

A)  on the left side of the comparison operator 
B)  on the right side of the comparison operator 
C)  in the SELECT clause 
D)  none of the above

Question 7

In Oracle11g, subqueries can be nested to a depth of 255 in a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ____________________ query can return several rows of results, but only one column.

Accepted Answer

The answer of A(n) ____________________ query can return several rows...

Question 9

A(n) $\underline {\text { correlated }}$ subquery is when the outer query is executed first, and then the inner query is executed. _________________________

Accepted Answer

A) True 
 B)False

Question 10

When used with a multiple-row subquery, the IN operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

Accepted Answer

A) True 
 B)False

Question 11

A subquery must be enclosed in a set of ____________________.

Accepted Answer

The answer of A subquery must be enclosed in a...

Question 12

The = operator is referred to as a(n) ____ operator.

Accepted Answer

A)  single-row 
B)  multiple-row 
C)  correlated 
D)  uncorrelated

Question 13

A(n) single-row subquery can be nested in a(n) $\underline {\text { SELECT } }$ clause. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The results of the outer query are passed to the inner query.

Accepted Answer

A) True 
 B)False

Question 15

The operators =, , =, and  are referred to as ____ operators.

Accepted Answer

A)  multiple-row 
B)  single-row 
C)  correlated 
D)  multiple column

Question 16

Which of the following can be used in a WHERE clause?

Accepted Answer

A)  single-row subquery 
B)  multiple-column subquery 
C)  multiple-row subquery 
D)  all of the above

Question 17

With a MERGE statement, a series of ____ actions can occur with a single SQL statement.

Accepted Answer

A)  SGML 
B)  DML 
C)  XML 
D)  PML

Question 18

You $\underline {\text { can } }$ include multiple subqueries in a SELECT statement. _________________________

Accepted Answer

A) True 
 B)False

Question 19

With a(n) ____________________ subquery, the inner query is executed first and the results are passed back to the outer query.

Accepted Answer

The answer of With a(n) ____________________ subquery, the inner query...

Question 20

A subquery, except one in the FROM clause, cannot contain a(n) ____________________ clause.

Accepted Answer

The answer of A subquery, except one in the FROM...

Exam 12: Subqueries and Merge Statements

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.

A(n) ____________________ is a nested query - one complete query inside another query.

Explain the difference between multiple-row and multiple-column subqueries.

In Oracle11g, a MERGE statement compares data between two tables and can perform a series of DML actions to assist in synchronizing the data of the two tables.

The EXISTS operator must be listed ____.

In Oracle11g, subqueries can be nested to a depth of 255 in a WHERE clause.

A(n) ____________________ query can return several rows of results, but only one column.

A(n) $\underline {\text { correlated }}$ subquery is when the outer query is executed first, and then the inner query is executed. _________________________

When used with a multiple-row subquery, the IN operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

A subquery must be enclosed in a set of ____________________.

The = operator is referred to as a(n) ____ operator.

A(n) single-row subquery can be nested in a(n) $\underline {\text { SELECT } }$ clause. _________________________

The results of the outer query are passed to the inner query.

The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

Which of the following can be used in a WHERE clause?

With a MERGE statement, a series of ____ actions can occur with a single SQL statement.

You $\underline {\text { can } }$ include multiple subqueries in a SELECT statement. _________________________

With a(n) ____________________ subquery, the inner query is executed first and the results are passed back to the outer query.

A subquery, except one in the FROM clause, cannot contain a(n) ____________________ clause.

Exam 12: Subqueries and Merge Statements

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.

A(n) ____________________ is a nested query - one complete query inside another query.

Explain the difference between multiple-row and multiple-column subqueries.

In Oracle11g, a MERGE statement compares data between two tables and can perform a series of DML actions to assist in synchronizing the data of the two tables.

The EXISTS operator must be listed ____.

In Oracle11g, subqueries can be nested to a depth of 255 in a WHERE clause.

A(n) ____________________ query can return several rows of results, but only one column.

A(n) correlated ‾\underline {\text { correlated }} correlated ​ subquery is when the outer query is executed first, and then the inner query is executed. _________________________

When used with a multiple-row subquery, the IN operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

A subquery must be enclosed in a set of ____________________.

The = operator is referred to as a(n) ____ operator.

A(n) single-row subquery can be nested in a(n) SELECT ‾\underline {\text { SELECT } } SELECT ​ clause. _________________________

The results of the outer query are passed to the inner query.

The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

Which of the following can be used in a WHERE clause?

With a MERGE statement, a series of ____ actions can occur with a single SQL statement.

You can ‾\underline {\text { can } } can ​ include multiple subqueries in a SELECT statement. _________________________

With a(n) ____________________ subquery, the inner query is executed first and the results are passed back to the outer query.

A subquery, except one in the FROM clause, cannot contain a(n) ____________________ clause.

A(n) $\underline {\text { correlated }}$ subquery is when the outer query is executed first, and then the inner query is executed. _________________________

A(n) single-row subquery can be nested in a(n) $\underline {\text { SELECT } }$ clause. _________________________

You $\underline {\text { can } }$ include multiple subqueries in a SELECT statement. _________________________