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
