CSC301 chpt 3 - quiz ?
To search for null values, use the ____ clause.
IS NULL
To return all of the columns from the base table, you can code the ___ operator in the SELECT clause.
*
To concatenate character strings, you use the ___ function in a string expression.
CONCAT
To prevent duplicate rows from being returned by a SELECT statement, you can code the ___ keyword in the SELECT clause.
DISTINCT
The ___ 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 ___ 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
The order of precedence for the logical operators in a WHERE clause is
Not, And, Or
Which of the following WHERE clauses will return vendor names from A to C?
WHERE vendor_name < 'D'
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 Answer DESC
When you code a SELECT statement, you must code the four main clauses in the following order
SELECT, FROM, WHERE, ORDER BY
If you want to filter the rows that are returned by a SELECT statement, you must include a/an ___ clause.
WHERE
Unless you assign a/an ___, the column name in the result set is the same as the column name in the base table.
alias
When you code an ORDER BY clause, you can specify a
column name, alias, expression, or column number
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 - 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 IN (0, 1000)
To override the order of precedence in an arithmetic expression, you can use
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 AND invoice_total >= 500
Which of the following isn't a valid column alias?
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 REGEXP 'NA$'