Which is not true about the USING keyword?
A) you use it to simplify the syntax for joining tables
B) you code a USING clause in addition to the ON clause
C) it can be used with inner or outer joins
D) the join must be an equijoin, meaning the equals operator is used to compare the two columns
Points Earned: 0.0/2.0
Correct Answer(s): B

Correct 2.
When you code a SELECT statement, you must code the four main clauses in the following order
A) SELECT, FROM, ORDER BY, WHERE
B) SELECT, ORDER BY, FROM, WHERE
C) SELECT, WHERE, ORDER BY, FROM
D) SELECT, FROM, WHERE, ORDER BY
Points Earned: 2.0/2.0
Correct Answer(s): D

Correct 3.
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?
A) payment_date IS NULL AND invoice_total > 500
B) payment_date IS NOT NULL OR invoice_total >= 500
C) NOT (payment_date IS NULL AND invoice_total = 500
Points Earned: 2.0/2.0
Correct Answer(s): D

Correct 4.
The order of precedence for the logical operators in a WHERE clause is
A) Not, And, Or
B) And, Or, Not
C) Or, And, Not
D) Not, Or, And
Points Earned: 2.0/2.0
Correct Answer(s): A

Correct 5.
Which of the following types of SQL statements is not a DML statement?
A) INSERT
B) UPDATE
C) SELECT
D) CREATE TABLE
Points Earned: 2.0/2.0
Correct Answer(s): D

Incorrect 6.
Which of the following is not a common error when entering and executing SQL statements?
A) Misspelling a keyword
B) Misspelling the name of a table
C) Selecting the wrong database
D) Forgetting to connect to a database
Points Earned: 0.0/2.0
Correct Answer(s): D

Incorrect 7.
When you run a SQL statement that contains a coding error, MySQL Workbench displays an error message that does not include
A) an error code
B) brief description