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

​single-ro

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 
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 
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 
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 
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 
A)  ​correlated 
B)  ​single-row 
C)  ​multiple-row 
D)  ​uncorrelated

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.

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Views

Filters

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

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Views

Filters

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.