What is the outcome on execution?

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

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

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

B.
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.

C.
Rows are displayed in the order that they are stored in the table only for the first three rows.

D.
Rows are displayed sorted in ascending order of the values in the third column in the table.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


evilsoldier

evilsoldier

D is correct if there are at least 3 columns in the BOOKS_TRANSACTIONS table.