Question 1

​A MERGE statement containing an UPDATE and an INSERT clause is also called a(n)____________________ statement.

Accepted Answer

The answer of ​A MERGE statement containing an UPDATE and...

Question 2

Single-row operators can be used with multiple-row subqueries that return only one column of results.​

Accepted Answer

A) True 
 B)False

Question 3

The EXISTS operator can be used with multiple-row subqueries.​

Accepted Answer

A) True 
 B)False

Question 4

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks.​

Accepted Answer

A) True 
 B)False

Question 5

You can include multiple subqueries in a SELECT statement._________________________​

Accepted Answer

A) True 
 B)False

Question 6

Valid single-row operators include =,>,=,<=.​

Accepted Answer

A) True 
 B)False

Question 7

The NVL function can be used in a subquery.​

Accepted Answer

A) True 
 B)False

Question 8

A group function cannot be included in the SELECT clause of a single-row subquery.​

Accepted Answer

A) True 
 B)False

Question 9

​The results of a subquery are passed back as input to the ____ query.

Accepted Answer

A)  ​inner 
B)  ​outer 
C)  ​correlated 
D)  ​uncorrelated 
A)  ​inner 
B)  ​outer 
C)  ​correlated 
D)  ​uncorrelated

Question 10

The operators =,,=,and  are referred to as ____ operators.​

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of The ____________________ operator is used to determine...

Question 12

A subquery must be enclosed in a set of ____________________.

Accepted Answer

The answer of A subquery must be enclosed in a...

Question 13

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?​

Accepted Answer

A)  ​IN and ANY 
B)  ​IN and ALL 
C)  ​ALL and ANY 
D)  ​EXISTS and IN 
A)  ​IN and ANY 
B)  ​IN and ALL 
C)  ​ALL and ANY 
D)  ​EXISTS and IN

Question 14

​The results of a subquery are passed back to the ____________________ query.

Accepted Answer

The answer of ​The results of a subquery are passed...

Question 15

With a MERGE statement,a series of ____ actions can occur with a single SQL statement.​

Accepted Answer

A)  ​SGML 
B)  ​DML 
C)  ​XML 
D)  ​PML 
A)  ​SGML 
B)  ​DML 
C)  ​XML 
D)  ​PML

Question 16

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

Accepted Answer

255
two hu

Question 17

​Contents of the BOOKS table
  
-​Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

Accepted Answer

A)  ​SELECT title FROM books WHERE pubid >ANY
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'); 
B)  ​SELECT title FROM books WHERE pubid =ANY
SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'; 
C)  ​SELECT title FROM books WHERE pubid IN
(SELECT pubid,title FROM books WHERE title = 'SHORTEST POEMS'); 
D)  ​none of the above 
A)  ​SELECT title FROM books WHERE pubid >ANY
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'); 
B)  ​SELECT title FROM books WHERE pubid =ANY
SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'; 
C)  ​SELECT title FROM books WHERE pubid IN
(SELECT pubid,title FROM books WHERE title = 'SHORTEST POEMS'); 
D)  ​none of the above

Question 18

Which of the following subqueries returns more than one row of results to the outer query?​

Accepted Answer

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

Question 19

The following SQL statement contains which type of subquery?
SELECT title,retail, (SELECT AVG(retail)FROM books)
FROM books;​

Accepted Answer

A)  ​single-row 
B)  ​multiple-row 
C)  ​multiple-column 
D)  ​inline view 
A)  ​single-row 
B)  ​multiple-row 
C)  ​multiple-column 
D)  ​inline view

Question 20

The <ANY operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results._________________________​

Accepted Answer

A) True 
 B)False

A MERGE statement containing an UPDATE and an INSERT clause is also called a(n)____________________ statement.

Single-row operators can be used with multiple-row subqueries that return only one column of results.

The EXISTS operator can be used with multiple-row subqueries.

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks.

You can include multiple subqueries in a SELECT statement._________________________

Valid single-row operators include =,>,<,>=,<=.

The NVL function can be used in a subquery.

A group function cannot be included in the SELECT clause of a single-row subquery.

The results of a subquery are passed back as input to the ____ query.

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.

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

A subquery must be enclosed in a set of ____________________.

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?

The results of a subquery are passed back to the ____________________ query.

With a MERGE statement,a series of ____ actions can occur with a single SQL statement.

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

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

Which of the following subqueries returns more than one row of results to the outer query?

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail)FROM books) FROM books;

The <ANY operator indicates that a value must be less than the lowest value returned by the subquery to be included in the 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

​A MERGE statement containing an UPDATE and an INSERT clause is also called a(n)____________________ statement.

Single-row operators can be used with multiple-row subqueries that return only one column of results.​

The EXISTS operator can be used with multiple-row subqueries.​

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks.​

You can include multiple subqueries in a SELECT statement._________________________​

Valid single-row operators include =,>,<,>=,<=.​

The NVL function can be used in a subquery.​

A group function cannot be included in the SELECT clause of a single-row subquery.​

​The results of a subquery are passed back as input to the ____ query.

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.​

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

A subquery must be enclosed in a set of ____________________.

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?​

​The results of a subquery are passed back to the ____________________ query.

With a MERGE statement,a series of ____ actions can occur with a single SQL statement.​

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

​Contents of the BOOKS table -​Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

Which of the following subqueries returns more than one row of results to the outer query?​

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail)FROM books) FROM books;​

The <ANY operator indicates that a value must be less than the lowest value returned by the subquery to be included in the 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

A MERGE statement containing an UPDATE and an INSERT clause is also called a(n)____________________ statement.

Single-row operators can be used with multiple-row subqueries that return only one column of results.

The EXISTS operator can be used with multiple-row subqueries.

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks.

You can include multiple subqueries in a SELECT statement._________________________

Valid single-row operators include =,>,<,>=,<=.

The NVL function can be used in a subquery.

A group function cannot be included in the SELECT clause of a single-row subquery.

The results of a subquery are passed back as input to the ____ query.

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.

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

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?

The results of a subquery are passed back to the ____________________ query.

With a MERGE statement,a series of ____ actions can occur with a single SQL statement.

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

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

Which of the following subqueries returns more than one row of results to the outer query?

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail)FROM books) FROM books;

The <ANY operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results._________________________