What is the result?

The BOOKS_TRANSACT IONS table exists in your schema in this database.You execute this SQL statement when connected to your schema in your database instance.SQL> SELECT* FROM booksjransactions ORDER BY 3;What is the result?

Question:

What is the result?

Options:

The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name,

All table rows are displayed sorted in ascending order of the values in the third column.

The first three rows in the table are displayed in the order that they are stored.

Only the three rows with the lowest values in the key column are displayed in the order that they are stored

Correct Answer

The Correct Answer for this Question is

All table rows are displayed sorted in ascending order of the values in the third column.