Oracle
1Z0-071 · Question #38
The BOOKS_TRANSACTIONS table exists in your database. Examine the SQL statement: SQL>SELECT * FROM books_transactions ORDER BY 3; What is the outcome on execution?
The correct answer is D. Rows are displayed sorted in ascending order of the values in the third column in the table. See the full explanation below for the reasoning.
Question
The BOOKS_TRANSACTIONS table exists in your database. Examine the SQL statement:
SQL>SELECT * FROM books_transactions ORDER BY 3; What is the outcome on execution?
Options
- AThe execution tails unless the numeral 3 in the order by clause is replaced by a column name,
- BRows are displayed in the order that they are stored in the table only for the three rows with the
- CRows are displayed in the order that they are stored in the table only for the first three rows.
- DRows are displayed sorted in ascending order of the values in the third column in the table.
How the community answered
(51 responses)- A14% (7)
- B8% (4)
- C4% (2)
- D75% (38)
Community Discussion
No community discussion yet for this question.