Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Contents of the CUSTOMERS table​
 
-​Based upon the contents of the CUSTOMERS table,which of the following would be the most appropriate use of a subquery?

Accepted Answer

A)  ​When searching for all customers who live in the same state as customer# 1007.> 
B)  ​When searching for all customers who were referred by customer# 1003.> 
C)  ​When searching for all customers with the last name of Thompson.ml> > 
D)  ​When searching for all customers assigned customer# 1010.html> ml> >

Question 3

​Which comparison operator allows you to search for NULL values in a subquery?

Accepted Answer

A)  ​IS NULL 
B)  ​NVL 
C)  ​=NULL 
D)  ​NVLS

Question 4

The only type of subquery that can be used in a SELECT clause is a(n)____________________ subquery.​

Accepted Answer

The answer of The only type of subquery that can...

Question 5

The following SQL statement contains which type of subquery?
SELECT title,retail,category,cataverage FROM books NATURAL JOIN
(SELECT category,AVG(retail)cataverage FROM books GROUP BY

Accepted Answer

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

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

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

Accepted Answer

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

Question 8

In Oracle12c,a(n)____ allows a series of DML actions to occur.​​

Accepted Answer

A)  ​Inline view 
B)  ​MERGE statement 
C)  ​DML subquery 
D)  ​None of the above

Question 9

If the value of the EXISTS operator is ____________________,then the rows meeting the condition are displayed.​

Accepted Answer

The answer of If the value of the EXISTS operator...

Question 10

A complete query nested inside another query is called a(n)____​

Accepted Answer

A)  inner view 
B)  subquery 
C)  ​child view 
D)  ​all of the above

Question 11

A(n)____ subquery is one that can return several rows of results.​

Accepted Answer

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

Exam 12: Subqueries and Merge Statements

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

Contents of the CUSTOMERS table -Based upon the contents of the CUSTOMERS table,which of the following would be the most appropriate use of a subquery?

Which comparison operator allows you to search for NULL values in a subquery?

The only type of subquery that can be used in a SELECT clause is a(n)____________________ subquery.

The following SQL statement contains which type of subquery? SELECT title,retail,category,cataverage FROM books NATURAL JOIN (SELECT category,AVG(retail) cataverage FROM books GROUP BY

The EXISTS operator must be listed ____

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

In Oracle12c,a(n) ____ allows a series of DML actions to occur.

If the value of the EXISTS operator is ____________________,then the rows meeting the condition are displayed.

A complete query nested inside another query is called a(n) ____

A(n) ____ subquery is one that can return several rows of results.

Exam 12: Subqueries and Merge Statements

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

Contents of the CUSTOMERS table​ -​Based upon the contents of the CUSTOMERS table,which of the following would be the most appropriate use of a subquery?

​Which comparison operator allows you to search for NULL values in a subquery?

The only type of subquery that can be used in a SELECT clause is a(n)____________________ subquery.​

The following SQL statement contains which type of subquery? SELECT title,retail,category,cataverage FROM books NATURAL JOIN (SELECT category,AVG(retail) cataverage FROM books GROUP BY

The EXISTS operator must be listed ____​

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

In Oracle12c,a(n) ____ allows a series of DML actions to occur.​​

If the value of the EXISTS operator is ____________________,then the rows meeting the condition are displayed.​

A complete query nested inside another query is called a(n) ____​

A(n) ____ subquery is one that can return several rows of results.​

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

Contents of the CUSTOMERS table -Based upon the contents of the CUSTOMERS table,which of the following would be the most appropriate use of a subquery?

Which comparison operator allows you to search for NULL values in a subquery?

The only type of subquery that can be used in a SELECT clause is a(n)____________________ subquery.

The EXISTS operator must be listed ____

In Oracle12c,a(n) ____ allows a series of DML actions to occur.

If the value of the EXISTS operator is ____________________,then the rows meeting the condition are displayed.

A complete query nested inside another query is called a(n) ____

A(n) ____ subquery is one that can return several rows of results.