View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result? (Choose two.)

Examine this SQL statement:

Which two are true?

Examine the description of the EMPLOYEES table:

You write this falling statement:
SELECT dept-no AS department_id MAX (salary) AS max-sal
FROM employees
WHERE salary > 10000
GROUP BY department_id
ORDER BY max-sal:
Which clause causes the error?

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)