Oracle SQL Oracle SQL SELECT Statements 3

Question 1

Which Oracle SQL clause must appear in every SELECT statement?

Accepted Answer

FROM

Answer

WHERE

Answer

ORDER BY

Answer

GROUP BY

Question 2

What is the default sort order when ORDER BY is used in Oracle SQL?

Accepted Answer

ASC

Answer

DESC

Answer

RANDOM

Answer

Alphabetical only

Question 3

Which Oracle SQL syntax correctly uses a column alias in ORDER BY?

Accepted Answer

SELECT salary * 12 annual_sal FROM emp ORDER BY annual_sal

Answer

ORDER BY alias WHERE alias = col

Answer

ORDER BY col AS alias

Answer

SELECT salary FROM emp ALIAS sal ORDER BY sal

Question 4

Which Oracle SQL operator is used for pattern matching in a WHERE clause?

Accepted Answer

LIKE

Answer

=

Answer

MATCH

Answer

CONTAINS

Question 5

What does SELECT * FROM employees WHERE manager_id IS NULL return?

Accepted Answer

Rows where manager_id has no value stored

Answer

An error because IS NULL is invalid

Answer

Rows where manager_id equals 0

Answer

All rows from employees

Question 6

Which Oracle SQL feature allows you to give a table a shorter name within a query?

Accepted Answer

Table alias

Answer

Table synonym

Answer

Table abbreviation

Answer

RENAME clause