Which two statements will return the names of the three employees with the lowest salaries?

A: This statement is correct. It orders the employees by salary and fetches the first 3 rows.

B: This statement has a typo with "FETCE" and "RONS" which should be "FETCH" and "ROWS". Hence,

it will not execute successfully.

C: This statement will not execute successfully due to syntactical errors and incorrect use of the

ORDER BY clause.

D: This statement is correct. It uses a subquery to order employees by salary and then limits the

results to the first 3 using the ROWNUM pseudo-column.

E: This statement will not execute successfully because ROWNUM is evaluated before the ORDER BY

clause, so it would return the first 3 rows based on the table's natural order, not the lowest salaries.

The behavior of ROWNUM and the FETCH FIRST syntax are explained in the Oracle Database SQL

Language Reference 12c.