Chapter 3
Which clause of the SELECT statement specifies the table that contains the data to be retrieved?
FROM
Which of the following would return a maximum of 7 rows, starting with the 5th row?
LIMIT 4, 7
The order of precedence for the logical operators in a WHERE clause is
Not, And, Or
How would you code a SELECT clause so it returns all columns from the base table?
SELECT *
When you code a SELECT statement, you must code the four main clauses in the following order
SELECT, FROM, WHERE, ORDER BY
What is the result of the expression that follows if the value of last_name is "Smith" and the value of first_name is "Steve"?CONCAT(last_name, first_name)
SmithSteve
When you code a calculated value in a SELECT clause, the expression for the calculated value can include
arithmetic operators and functions only
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 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 is not a valid column alias?
total sales