Chapter 7 Study Questions

Question 1

A ________ is a SELECT statement that is coded within another SQL statement.

Answer 1

subquery

Question 2

A subquery coded within another subquery is also known as a ______ subquery.

Answer 2

nested

Question 3

An ____________ subquery is executed once for the entire query.

Answer 3

uncorrelated

Question 4

A __________ subquery refers to a value that is provided by a column in the main query and is executed once for each row that is processed by the main query.

Answer 4

correlated

Question 5

The ______ operator tests whether the subquery returns a result set (i.e. one or more rows are returned by the subquery).

Answer 5

EXISTS

Question 6

Use the ___ ______ operator to test whether no rows are returned by the subquery.

Answer 6

NOT EXISTS

Question 7

A result set referred to as an ______ ____ is one coded in the FROM clause of a SELECT statement.

Answer 7

inline view

Question 8

_____ may be used to describe the different parts of a complex query without changing how the query operates.

Answer 8

Alias

Question 9

To code a single-line comment start a line with two ______.

Answer 9

dashes

Question 10

__________ is code that represents the intent of a query but does not necessarily use SQL code.

Answer 10

Pseudocode