Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 11 of 50

Marks: +1, -0

The BOOKS_TRANSACTIONS table exists in your database.
SQL>SELECT * FROM books_transactions ORDER BY 3;
What is the outcome on execution?

The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.
Rows are displayed in the order that they are stored in the table only for the first three rows.
Rows are displayed sorted in ascending order of the values in the third column in the table.

Go to Question:

Prev Question

Next Question