Chapter 3: Retrieve From Single Table

To return all of the columns from the base table, which wildcard character do you include in the SELECT clause?

*

To concatenate character strings in a string expression, which operator do you use?

+

Which keyword lets you control the number of rows that are returned by a query?

All of the above: All Distinct Top

A string expression can consist of

All of the above: One or more character columns One or more literal values A combination of character columns and literal values

A combination of column names and operations that evaluate to a single value is called

An expression

The search condition of a WHERE clause consists of one or more

Boolean expressions

Unless you assign a _______, the column name in the result set is the same as the column name in the base table

Column alias

When you code an ORDER BY clause, you can specify a

Column name, alias, expression or column number

To prevent deuplicate rows from being returned by a SELECT statement, you can code which keyword in the SELECT clause?

DISTINCT

To sort the records that are retrieved by a SELECT statement in descending sequence what keyword do you code at the end of the ORDER BY clause?

DISTINCT

Which clause specifies the number of rows that should be retrieved after skipping the specified number rows?

FETCH

Which clause of the SELECT statement names the table that contains the data to be retrieved ?

From

Which of the following expressions will not compute 10% of the balance due if is the invoice total minus the credit total minus the payment total?

InvoiceTotal - CreditTotal - PaymentTotal / 10

When coded in a WHERE clause, which of the following search conditions will not return set that includes all invoices with an InvoiceTotal value of $1000 or less?

InvoiceTotal IN (0,1000)

Which keyword can you use to retrieve rows in which an expression matches a string pattern called mask?

Like

The order of precedece for the logical operations in a WHERE clause is

Not, And, Or

The order of precedence for the logical operators in a WHERE clause is

Not, And, Or

Which clause specifies the number of rows that should be skipped before rows are returned from the result set?

OFFSET

Which ORDER BY clause causes 10 rows to be retrieved from the result set, starting with the 20th row?

ORDER BY InvoiceTotal DESC OFFSET 20 ROWS FETCH NEXT 10 ROWS

To override the order of precedence in an arithmetic expression, you can use

Parentheses

To override the order of precedence in an aritihmetic expression, you can use

Parentheses

When coded in a WHERE clause, which search condition will return invoices when PaymentDate is not null and InvoiceTotal is greater than or equal to $500?

PaymentDate IS NOT NULL AND InvoiceTotal >= 500

When you code a SELECT statement, you must code the four main clauses in the following order

SELECT, FROM, WHERE, ORDER BY

When coded within a SELECT clause, which TOP clause will return set consisting of the ten largest InvoiceNumbers?

Top 10 InvoiceNumber

Which of the following is not a valid column alias name?

Total Sales

If you want to filter the result set that's returned by a SELECT statement, you must include which clause?

WHERE