The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-061 — Oracle Database 12c: SQL Fundamentals

Question 2:

Evaluate the SQL statements below:

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY act_seats;

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY SEATS ASC;

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY 3 ASC;

Which of the following statements is true?

A. The three statements produce identical results.
B. The three statements can be made to produce identical results by adding ASC to the the ORDER BY clause of the first statement.
C. The first statement returns an error.
D. The second statement returns an error.
E. The third statement returns an error.