Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Week #13 Quiz - CIST1220-Structured Query Language-SQL

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

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

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

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

Front

B) False

Back

A(n) ____ subquery is one that can return several rows of results. A) correlated B) single-row C) multiple-row D) uncorrelated

Front

C) multiple-row

Back

Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery? A) When searching for all customers who live in the same state as customer# 1007. B) When searching for all customers who were referred by customer# 1003. C) When searching for all customers with the last name of Thompson. D) When searching for all customers assigned customer# 1010.

Front

A) When searching for all customers who live in the same state as customer# 1007.

Back

You can include multiple subqueries in a SELECT statement. A) True B) False

Front

A) True

Back

A multiple-column subquery cannot be nested in a WHERE clause. A) True B) False

Front

B) False

Back

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

Front

A) True

Back

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

Front

B) False

Back

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

Front

B) False

Back

A complete query nested inside another query is called a(n) ____. A) inner view B) subquery C) child view D) all of the above

Front

B) subquery

Back

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. A) True B) False

Front

B) False

Back