Question 1

IN is a valid multiple-row subquery operator._________________________​

Accepted Answer

A) True 
 B)False

Question 2

Which operator will instruct Oracle12c to list all records with a value that is less than the highest value returned by the subquery?​

Accepted Answer

A) >ANY B) >ALL C) ANY B) >ALL C)

Question 3

​Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table,which line of the following SQL statement contains an error?
1 SELECT title,pubid,cost,retail
2 FROM books
3 WHERE (pubid,cost)
4 (SELECT pubid,cost)
5 FROM books
6 WHERE pubid = 3);

Accepted Answer

A)  Line 1 
B)  ​Line 4 
C)  ​Line 5 
D)  ​Line 6 
A)  Line 1 
B)  ​Line 4 
C)  ​Line 5 
D)  ​Line 6

Question 4

If a subquery references a column from the outer query,then it is a(n)____________________ subquery.​

Accepted Answer

The answer of If a subquery references a column from...

Question 5

​Contents of the BOOKS table
  
-​Based on the contents of the BOOKS table,which of the following SQL statements will return an error message?

Accepted Answer

A)  ​SELECT title FROM books WHERE retail =
(SELECT MAX(retail)FROM books); 
B)  ​SELECT title FROM books WHERE retail IN
(SELECT MAX(retail)FROM books); 
C)  ​SELECT title FROM books WHERE retail >
(SELECT MAX(retail)FROM books); 
D)  ​none of the above 
A)  ​SELECT title FROM books WHERE retail =
(SELECT MAX(retail)FROM books); 
B)  ​SELECT title FROM books WHERE retail IN
(SELECT MAX(retail)FROM books); 
C)  ​SELECT title FROM books WHERE retail >
(SELECT MAX(retail)FROM books); 
D)  ​none of the above

Question 6

​Valid multiple-row operators include ANY,ALL,and ____________________.

Accepted Answer

The answer of ​Valid multiple-row operators include ANY,ALL,and ____________________....

Question 7

​Contents of the BOOKS table
  
-​Based on the contents of the BOOKS table,which line in the following SQL statement contains an error?
1 SELECT title
2 FROM books
3 WHERE pubid EXISTS IN
4 (SELECT pubid
5 FROM books
6 WHERE retail > 41.95);

Accepted Answer

A)  ​Line 1 
B)  ​Line 3 
C)  ​Line 4 
D)  ​Line 6 
A)  ​Line 1 
B)  ​Line 3 
C)  ​Line 4 
D)  ​Line 6

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The =ANY operator yields the same results as using the IN multiple-row operator._________________________​

Accepted Answer

A) True 
 B)False

Question 10

​Which clause is used when the group results of a subquery need to be restricted,based on some condition?

Accepted Answer

A)  ​GROUP BY 
B)  ​HAVING 
C)  ​WHERE 
D)  ​ORDER BY 
A)  ​GROUP BY 
B)  ​HAVING 
C)  ​WHERE 
D)  ​ORDER BY

Question 11

A(n)correlated subquery references one or more columns from the outer query._________________________​

Accepted Answer

A) True 
 B)False

Question 12

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

Accepted Answer

A)  ​more than the highest 
B)  ​less than the highest 
C)  ​more than the lowest 
D)  ​less than the lowest 
A)  ​more than the highest 
B)  ​less than the highest 
C)  ​more than the lowest 
D)  ​less than the lowest

Question 13

IN is not a valid operator for a multiple-column subquery.​

Accepted Answer

A) True 
 B)False

Question 14

A subquery is a complete query nested inside another query.

Accepted Answer

A) True 
 B)False

Question 15

​If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query,the ____________________ operator must be used.

Accepted Answer

The answer of ​If a multiple-column subquery is contained in...

Question 16

A subquery nested in a SELECT clause cannot contain an ORDER BY clause.​

Accepted Answer

A) True 
 B)False

Question 17

Which of the following operators is the equivalent of the IN comparison operator?

Accepted Answer

A) ANY C) =ANY D) =ALL A) ANY C) =ANY D) =ALL

Question 18

The outer query receives its input from the ____.​

Accepted Answer

A)  ​inner view 
B)  ​outer view 
C)  ​nested function 
D)  ​subquery 
A)  ​inner view 
B)  ​outer view 
C)  ​nested function 
D)  ​subquery

Question 19

A subquery must be enclosed in a set of quotation marks._________________________​

Accepted Answer

A) True 
 B)False

Question 20

​What is the difference between the IN operator and the =ANY operator?

Accepted Answer

​While both operators can be u

IN is a valid multiple-row subquery operator._________________________

Which operator will instruct Oracle12c to list all records with a value that is less than the highest value returned by the subquery?

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which line of the following SQL statement contains an error? 1 SELECT title,pubid,cost,retail 2 FROM books 3 WHERE (pubid,cost) 4 (SELECT pubid,cost) 5 FROM books 6 WHERE pubid = 3);

If a subquery references a column from the outer query,then it is a(n)____________________ subquery.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following SQL statements will return an error message?

Valid multiple-row operators include ANY,ALL,and ____________________.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which line in the following SQL statement contains an error? 1 SELECT title 2 FROM books 3 WHERE pubid EXISTS IN 4 (SELECT pubid 5 FROM books 6 WHERE retail > 41.95);

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

The =ANY operator yields the same results as using the IN multiple-row operator._________________________

Which clause is used when the group results of a subquery need to be restricted,based on some condition?

A(n)correlated subquery references one or more columns from the outer query._________________________

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

IN is not a valid operator for a multiple-column subquery.

A subquery is a complete query nested inside another query.

If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query,the ____________________ operator must be used.

A subquery nested in a SELECT clause cannot contain an ORDER BY clause.

Which of the following operators is the equivalent of the IN comparison operator?

The outer query receives its input from the ____.

A subquery must be enclosed in a set of quotation marks._________________________

What is the difference between the IN operator and the =ANY operator?

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 is a valid multiple-row subquery operator._________________________​

Which operator will instruct Oracle12c to list all records with a value that is less than the highest value returned by the subquery?​

​Contents of the BOOKS table -Based upon the contents of the BOOKS table,which line of the following SQL statement contains an error? 1 SELECT title,pubid,cost,retail 2 FROM books 3 WHERE (pubid,cost) 4 (SELECT pubid,cost) 5 FROM books 6 WHERE pubid = 3);

If a subquery references a column from the outer query,then it is a(n)____________________ subquery.​

​Contents of the BOOKS table -​Based on the contents of the BOOKS table,which of the following SQL statements will return an error message?

​Valid multiple-row operators include ANY,ALL,and ____________________.

​Contents of the BOOKS table -​Based on the contents of the BOOKS table,which line in the following SQL statement contains an error? 1 SELECT title 2 FROM books 3 WHERE pubid EXISTS IN 4 (SELECT pubid 5 FROM books 6 WHERE retail > 41.95);

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

The =ANY operator yields the same results as using the IN multiple-row operator._________________________​

​Which clause is used when the group results of a subquery need to be restricted,based on some condition?

A(n)correlated subquery references one or more columns from the outer query._________________________​

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

IN is not a valid operator for a multiple-column subquery.​

A subquery is a complete query nested inside another query.

​If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query,the ____________________ operator must be used.

A subquery nested in a SELECT clause cannot contain an ORDER BY clause.​

Which of the following operators is the equivalent of the IN comparison operator?

The outer query receives its input from the ____.​

A subquery must be enclosed in a set of quotation marks._________________________​

​What is the difference between the IN operator and the =ANY operator?

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 is a valid multiple-row subquery operator._________________________

Which operator will instruct Oracle12c to list all records with a value that is less than the highest value returned by the subquery?

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which line of the following SQL statement contains an error? 1 SELECT title,pubid,cost,retail 2 FROM books 3 WHERE (pubid,cost) 4 (SELECT pubid,cost) 5 FROM books 6 WHERE pubid = 3);

If a subquery references a column from the outer query,then it is a(n)____________________ subquery.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following SQL statements will return an error message?

Valid multiple-row operators include ANY,ALL,and ____________________.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which line in the following SQL statement contains an error? 1 SELECT title 2 FROM books 3 WHERE pubid EXISTS IN 4 (SELECT pubid 5 FROM books 6 WHERE retail > 41.95);

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

The =ANY operator yields the same results as using the IN multiple-row operator._________________________

Which clause is used when the group results of a subquery need to be restricted,based on some condition?

A(n)correlated subquery references one or more columns from the outer query._________________________

IN is not a valid operator for a multiple-column subquery.

If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query,the ____________________ operator must be used.

A subquery nested in a SELECT clause cannot contain an ORDER BY clause.

The outer query receives its input from the ____.

A subquery must be enclosed in a set of quotation marks._________________________

What is the difference between the IN operator and the =ANY operator?