The BOOKS_TRANSACTIONS table exists in your database.SQL>SELECT * FROM books_transactions ORDER BY 3;What is the outcome on execution?
Question:
What is the outcome on execution?
Options:
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.
Correct Answer
The Correct Answer for this Question is
Rows are displayed sorted in ascending order of the values in the third column in the table.
