ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

73 / 120

Question 73:

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? 

Answer options:

A. The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
B. All table rows are displayed sorted in ascending order of the values in the third column.
C. The first three rows in the table are displayed in the order that they are stored.
D. Only the three rows with the lowest values in the key column are displayed in the order that they are stored.