1Z0-071 Using Subqueries

Question 1

What is a subquery in Oracle SQL?

Accepted Answer

A SELECT statement nested inside another SQL statement

Answer

A stored procedure that returns a table

Answer

A synonym for a VIEW

Answer

A query that uses GROUP BY

Question 2

Where can a single-row subquery be used in a SELECT statement?

Accepted Answer

In the WHERE, HAVING, and SELECT clauses

Answer

Only in the WHERE clause

Answer

Only in the FROM clause

Answer

Only in the ORDER BY clause

Question 3

Which comparison operator is INVALID when used with a multi-row subquery?

Accepted Answer

=

Answer

IN

Answer

ANY

Answer

ALL

Question 4

What does the EXISTS operator check in a subquery?

Accepted Answer

Whether the subquery returns at least one row

Answer

Whether all rows in the subquery are non-NULL

Answer

Whether the subquery returns exactly one row

Answer

Whether the subquery has no GROUP BY clause

Question 5

A subquery that returns more than one column is called a:

Accepted Answer

Multiple-column subquery

Answer

Multi-row subquery

Answer

Scalar subquery

Answer

Correlated subquery

Question 6

Which keyword pair allows a multi-row subquery to check if a value matches any value in the returned list?

Accepted Answer

Both = ANY and IN

Answer

= ALL

Answer

= ANY

Answer

IN