Oracle SQL Oracle SQL SELECT Statements 3

Question 1

Which Oracle SQL clause must appear in every SELECT statement?

Accepted Answer

FROM

Answer

Every SELECT statement in Oracle must include a FROM clause (or use DUAL), as Oracle requires a table source.

Question 2

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

Accepted Answer

ASC

Answer

By default, ORDER BY sorts in ascending order (ASC), placing the smallest or earliest values first.

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

In Oracle SQL, column aliases defined in the SELECT list can be referenced in the ORDER BY clause.

Question 4

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

Accepted Answer

LIKE

Answer

The LIKE operator enables wildcard pattern matching using % (any sequence of characters) and _ (any single character).

Question 5

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

Accepted Answer

Rows where manager_id has no value stored

Answer

IS NULL checks for the absence of a value; rows where manager_id has never been set (top-level managers) are returned.

Oracle SQL Practice Test