View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

Which is true about the & and && prefixes with substitution variables?

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b'
FROM departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a'
FROM departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output? (Choose two.)

Examine the structure of the SALES table.

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

Examine this statement:

What is returned upon execution?