Question 1

A(n)____________________ subquery can return only one row of results to the outer query.
​

Accepted Answer

​single-row
single row

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

​>ALL

Question 4

A multiple-column subquery cannot be nested in a WHERE clause.​

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

A(n)uncorrelated subquery is when the outer query is executed first,then the inner query is executed._________________________​

Accepted Answer

A) True 
 B)False

Question 7

A single-row subquery can be nested in the SELECT clause of the outer function.​

Accepted Answer

A) True 
 B)False

Question 8

The greater than operator,>,is a valid operator for multiple-row subqueries._________________________​

Accepted Answer

A) True 
 B)False

Question 9

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 clause,cannot...

Question 10

​A single-row subquery can return several columns,but only one row,of results to the outer query.

Accepted Answer

A) True 
 B)False

Question 11

The IN operator can be used with single-row,multiple-row,or multiple-column subqueries._________________________​

Accepted Answer

A) True 
 B)False

Question 12

​Contents of the BOOKS table
  
-​Based on the contents of the BOOKS table,which line of the following SQL statement contains an error?
1 SELECT isbn,title
2 FROM books
3 WHERE pubid =
4 (SELECT pubid
5 FROM books
6 WHERE title = 'SHORTEST POEMS')
7 AND retail-cost >
8 (SELECT AVG(retail-cost)
9 FROM books);

Accepted Answer

A)  ​Line 3 
B)  ​Line 5 
C)  ​Line 7 
D)  ​none of the above 
A)  ​Line 3 
B)  ​Line 5 
C)  ​Line 7 
D)  ​none of the above

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) ALL D) >ANY A) ALL D) >ANY

Question 15

A correlated subquery is one in which the inner query is executed first,and then the outer query is executed.​

Accepted Answer

A) True 
 B)False

Question 16

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 17

The equal sign,=,is a valid single-row operator.​

Accepted Answer

A) True 
 B)False

Question 18

A(n)correlated subquery is when the outer query is executed first,and then the inner query is executed._________________________​

Accepted Answer

A) True 
 B)False

Question 19

A(n)outer query is also referred to as a parent query._________________________​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

A(n)____________________ subquery can return only one row of results to the outer query.

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

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

A multiple-column subquery cannot be nested in a WHERE clause.

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

A(n)uncorrelated subquery is when the outer query is executed first,then the inner query is executed._________________________

A single-row subquery can be nested in the SELECT clause of the outer function.

The greater than operator,>,is a valid operator for multiple-row subqueries._________________________

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

A single-row subquery can return several columns,but only one row,of results to the outer query.

The IN operator can be used with single-row,multiple-row,or multiple-column subqueries._________________________

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

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

A correlated subquery is one in which the inner query is executed first,and then the outer 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.

The equal sign,=,is a valid single-row operator.

A(n)correlated subquery is when the outer query is executed first,and then the inner query is executed._________________________

A(n)outer query is also referred to as a parent query._________________________

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

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

A(n)____________________ subquery can return only one row of results to the outer query. ​

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

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

A multiple-column subquery cannot be nested in a WHERE clause.​

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

A(n)uncorrelated subquery is when the outer query is executed first,then the inner query is executed._________________________​

A single-row subquery can be nested in the SELECT clause of the outer function.​

The greater than operator,>,is a valid operator for multiple-row subqueries._________________________​

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

​A single-row subquery can return several columns,but only one row,of results to the outer query.

The IN operator can be used with single-row,multiple-row,or multiple-column subqueries._________________________​

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

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

A correlated subquery is one in which the inner query is executed first,and then the outer 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.​

The equal sign,=,is a valid single-row operator.​

A(n)correlated subquery is when the outer query is executed first,and then the inner query is executed._________________________​

A(n)outer query is also referred to as a parent query._________________________​

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

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

A(n)____________________ subquery can return only one row of results to the outer query.

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

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

A multiple-column subquery cannot be nested in a WHERE clause.

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

A(n)uncorrelated subquery is when the outer query is executed first,then the inner query is executed._________________________

A single-row subquery can be nested in the SELECT clause of the outer function.

The greater than operator,>,is a valid operator for multiple-row subqueries._________________________

A single-row subquery can return several columns,but only one row,of results to the outer query.

The IN operator can be used with single-row,multiple-row,or multiple-column subqueries._________________________

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

A correlated subquery is one in which the inner query is executed first,and then the outer 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.

The equal sign,=,is a valid single-row operator.

A(n)correlated subquery is when the outer query is executed first,and then the inner query is executed._________________________

A(n)outer query is also referred to as a parent query._________________________

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