3 Quiz

To search for null values, use the BLANK clause.

IS NULL

To prevent duplicate rows from being returned by a SELECT statement, you can code the BLANK keyword in the SELECT clause.

DISTINCT

The BLANK clause of the SELECT statement specifies the table that contains the data.

FROM

To retrieve rows in which an expression matches a string pattern called a mask, you can use the BLANK keyword followed by the mask.

LIKE

Which of the following would return a maximum of 7 rows, starting with the 4th row? LIMIT 4, 7 LIMIT 7, 4 LIMIT 4 LIMIT 4, 6

LIMIT 7, 4

The order of precedence for the logical operators in a WHERE clause is Not, And, Or Or, And, Not Not, Or, And And, Or, Not

Not, And, Or

When you code a SELECT statement, you must code the four main clauses in the following order SELECT, WHERE, ORDER BY, FROM SELECT, ORDER BY, FROM, WHERE SELECT, FROM, WHERE, ORDER BY SELECT, FROM, ORDER BY, WHERE

SELECT FROM WHERE ORDER BY

If you want to filter the rows that are returned by a SELECT statement, you must include a/an BLANK clause.

WHERE

Which of the following WHERE clauses will return vendor names from A to C? WHERE vendor_name < 'D' WHERE vendor_name < 'C' WHERE vendor_name = D WHERE vendor_name = 'D'

WHERE vendor_name < 'D'

Unless you assign a/an BLANK, the column name in the result set is the same as the column name in the base table.

alias

To return all of the columns from the base table, you can code the BLANK operator in the SELECT clause.

asterisk

When you code an ORDER BY clause, you can specify a column name, alias, or expression only column name or alias only column name, alias, expression, or column number column name or expression only

column name, alias, expression, or column number

To sort the rows that are retrieved by a SELECT statement in descending sequence by invoice_total, you code this ORDER BY clause: ORDER BY invoice_total BLANK

desc

??Which of the following expressions does not compute 10% of the balance due if balance due is the invoice total minus the credit total minus the payment total? ((invoice_total - payment_total) - credit_total) / 10 (invoice_total - (payment_total + credit_total)) * 0.10 (invoice_total - payment_total - credit_total) / 10 invoice_total - credit_total - payment_total / 10

invoice_total - credit_total - payment_total / 10

When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an invoice_total value of $1000 or less? invoice_total <= 1000 invoice_total IN (0, 1000) NOT (invoice_total > 1000) invoice_total BETWEEN 0 AND 1000

invoice_total IN (0, 1000) TRYING

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

parentheses

When coded in a WHERE clause, which search condition will return invoices when payment_date isn't null and invoice_total is greater than or equal to $500? payment_date IS NOT NULL OR invoice_total >= 500 payment_date IS NOT NULL AND invoice_total >= 500 NOT (payment_date IS NULL AND invoice_total <= 500) payment_date IS NULL AND invoice_total > 500

payment_date IS NOT NULL AND invoice_total >= 500

Which of the following isn't a valid column alias? total total_sales "Total Sales" total sales

total sales

When coded in a WHERE clause, which of the following would not return rows for vendors in the cities of San Diego and Santa Ana? vendor_city LIKE 'SAN%' vendor_city REGEXP '^SA' vendor_city REGEXP 'NA$'

vendor_city REGEXP 'NA$'