Question 1

A(n)____________________ subquery returns more than one column to the outer query.​

Accepted Answer

multiple-c

Question 2

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

Accepted Answer

A)  multiple-row 
B)  ​multiple-column 
C)  ​single-row 
D)  ​none of the above 
A)  multiple-row 
B)  ​multiple-column 
C)  ​single-row 
D)  ​none of the above

Question 3

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

Accepted Answer

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

Question 4

​The following SQL statement contains which type of subquery?
SELECT title FROM books WHERE EXISTS
(SELECT isbn FROM orderitems WHERE books.isbn = orderitems.isbn);

Accepted Answer

A)  ​multiple-column 
B)  ​inline view 
C)  ​correlated 
D)  ​uncorrelated 
A)  ​multiple-column 
B)  ​inline view 
C)  ​correlated 
D)  ​uncorrelated

Question 5

​If it is possible for a subquery to return a NULL value to the outer query for comparison,the ____ function should be used to substitute an actual value for the NULL.

Accepted Answer

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

Question 6

Which of the following must be used to separate a subquery from the outer query?​

Accepted Answer

A)  ​/ / 
B)  ​" " 
C)  ​| | 
D)  ​( ) 
A)  ​/ / 
B)  ​" " 
C)  ​| | 
D)  ​( )

Question 7

​Any type of subquery can be used in the FROM,WHERE,or ____________________ clause of a SELECT statement.

Accepted Answer

The answer of ​Any type of subquery can be used...

Question 8

​With a(n)____________________ statement,a series of DML actions can occur with a single SQL statement.

Accepted Answer

The answer of ​With a(n)____________________ statement,a series of DML actions...

Question 9

A group function can be used in a(n)inline view._________________________​

Accepted Answer

A) True 
 B)False

Question 10

A multiple-row subquery can be nested in a HAVING clause.​

Accepted Answer

A) True 
 B)False

Question 11

A subquery can only be nested in the WHERE or HAVING clause of the outer query.​

Accepted Answer

A) True 
 B)False

Question 12

Valid multiple-row operators include =,>,=,<=._________________________​

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A multiple-row subquery can re

Question 14

The EXISTED operator is used to determine whether a condition is present in a subquery._________________________​

Accepted Answer

A) True 
 B)False

Question 15

A multiple-column subquery nested in the SELECT clause of the outer query is known as an inline view._________________________​

Accepted Answer

A) True 
 B)False

Question 16

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.​

Accepted Answer

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

Question 17

The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail)FROM books
GROUP BY category);

Accepted Answer

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

Question 18

​If a subquery's result must be compared with a group function,you must nest the inner query in the ____________________ clause of the outer query.

Accepted Answer

The answer of ​If a subquery's result must be compared...

Question 19

A(n)single-row subquery can be nested in a(n)SELECT clause._________________________

Accepted Answer

A) True 
 B)False

Question 20

In Oracle12c,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

A(n)____________________ subquery returns more than one column to the outer query.

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

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

The following SQL statement contains which type of subquery? SELECT title FROM books WHERE EXISTS (SELECT isbn FROM orderitems WHERE books.isbn = orderitems.isbn);

If it is possible for a subquery to return a NULL value to the outer query for comparison,the ____ function should be used to substitute an actual value for the NULL.

Which of the following must be used to separate a subquery from the outer query?

Any type of subquery can be used in the FROM,WHERE,or ____________________ clause of a SELECT statement.

With a(n)____________________ statement,a series of DML actions can occur with a single SQL statement.

A group function can be used in a(n)inline view._________________________

A multiple-row subquery can be nested in a HAVING clause.

A subquery can only be nested in the WHERE or HAVING clause of the outer query.

Valid multiple-row operators include =,>,<,>=,<=._________________________

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

The EXISTED operator is used to determine whether a condition is present in a subquery._________________________

A multiple-column subquery nested in the SELECT clause of the outer query is known as an inline view._________________________

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

The following SQL statement contains which type of subquery? SELECT title,retail,category FROM books WHERE retail IN (SELECT MAX(retail)FROM books GROUP BY category);

If a subquery's result must be compared with a group function,you must nest the inner query in the ____________________ clause of the outer query.

A(n)single-row subquery can be nested in a(n)SELECT clause._________________________

In Oracle12c,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.

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 returns more than one column to the outer query.​

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

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

​The following SQL statement contains which type of subquery? SELECT title FROM books WHERE EXISTS (SELECT isbn FROM orderitems WHERE books.isbn = orderitems.isbn);

​If it is possible for a subquery to return a NULL value to the outer query for comparison,the ____ function should be used to substitute an actual value for the NULL.

Which of the following must be used to separate a subquery from the outer query?​

​Any type of subquery can be used in the FROM,WHERE,or ____________________ clause of a SELECT statement.

​With a(n)____________________ statement,a series of DML actions can occur with a single SQL statement.

A group function can be used in a(n)inline view._________________________​

A multiple-row subquery can be nested in a HAVING clause.​

A subquery can only be nested in the WHERE or HAVING clause of the outer query.​

Valid multiple-row operators include =,>,<,>=,<=._________________________​

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

The EXISTED operator is used to determine whether a condition is present in a subquery._________________________​

A multiple-column subquery nested in the SELECT clause of the outer query is known as an inline view._________________________​

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.​

The following SQL statement contains which type of subquery? SELECT title,retail,category FROM books WHERE retail IN (SELECT MAX(retail)FROM books GROUP BY category);

​If a subquery's result must be compared with a group function,you must nest the inner query in the ____________________ clause of the outer query.

A(n)single-row subquery can be nested in a(n)SELECT clause._________________________

In Oracle12c,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.​

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 returns more than one column to the outer query.

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

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

The following SQL statement contains which type of subquery? SELECT title FROM books WHERE EXISTS (SELECT isbn FROM orderitems WHERE books.isbn = orderitems.isbn);

If it is possible for a subquery to return a NULL value to the outer query for comparison,the ____ function should be used to substitute an actual value for the NULL.

Which of the following must be used to separate a subquery from the outer query?

Any type of subquery can be used in the FROM,WHERE,or ____________________ clause of a SELECT statement.

With a(n)____________________ statement,a series of DML actions can occur with a single SQL statement.

A group function can be used in a(n)inline view._________________________

A multiple-row subquery can be nested in a HAVING clause.

A subquery can only be nested in the WHERE or HAVING clause of the outer query.

Valid multiple-row operators include =,>,<,>=,<=._________________________

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

The EXISTED operator is used to determine whether a condition is present in a subquery._________________________

A multiple-column subquery nested in the SELECT clause of the outer query is known as an inline view._________________________

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

If a subquery's result must be compared with a group function,you must nest the inner query in the ____________________ clause of the outer query.

In Oracle12c,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.