A.It results in an error because the ORDER BY clause should be the last clause.

B.It displays 5 percent of the products with the highest amount sold.

C.It displays 5 percent of the products with the lowest amount sold.

D.It displays the first 5 percent of the rows from the SALES table.

A.A role can be granted to itself.

B.A role can be granted to PUBLIC.

C.A user can be granted only one role at any point of time.

D.The REVOKE command can be used to remove privileges but not roles from other users.

E.Roles are named groups of related privileges that can be granted to users or other roles.

A.annual_comp
FROM employees;
SELECT last_name, (monthly_salary * 12) + (monthly_commission_pct * 12) AS

B.monthly_commission_pct) AS annual_comp
FROM employees;
SELECT last_name, (monthly_salary + monthly_commission_pct) * 12 AS

C.annual_comp
FROM employees;
SELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 * NVL

D.(monthly_commission_pct, 0)) AS annual_comp
FROM employees;

A.Option D

B.Option C

C.Option B

D.Option A

A.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.

B.Performance would improve in query 2.

C.There would be no change in performance.

D.Performance would degrade in query 2.