Oracle
1Z0-071 · Question #91
The BOOKS_TRANSACTIONS 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 books_transactions…
The correct answer is B. All table rows are displayed sorted in ascending order of the values in the third column. See the full explanation below for the reasoning.
Question
The BOOKS_TRANSACTIONS 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 books_transactions ORDER BY 3; What is the result?
Options
- AThe execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
- BAll table rows are displayed sorted in ascending order of the values in the third column.
- CThe first three rows in the table are displayed in the order that they are stored.
- DOnly the three rows with the lowest values in the key column are displayed in the order that they
How the community answered
(44 responses)- A5% (2)
- B70% (31)
- C16% (7)
- D9% (4)
Community Discussion
No community discussion yet for this question.