Oracle SQL Oracle SQL SELECT Statements 1

Question 1

Which clause is used to filter rows AFTER grouping in Oracle SQL?

Accepted Answer

HAVING

Answer

WHERE

Answer

FILTER

Answer

GROUP FILTER

Question 2

What does SELECT DISTINCT do in Oracle SQL?

Accepted Answer

Removes duplicate rows from the result set

Answer

Returns only the first row of each group

Answer

Sorts the result set

Answer

Selects a random row

Question 3

Which Oracle SQL keyword limits the number of rows returned using a row-limiting clause (Oracle 12c+)?

Accepted Answer

FETCH FIRST

Answer

TOP

Answer

LIMIT

Answer

ROWNUM

Question 4

What is the purpose of the ORDER BY clause in a SELECT statement?

Accepted Answer

Sorts the result set by one or more columns

Answer

Filters rows based on a condition

Answer

Groups rows with the same value

Answer

Joins two tables together

Question 5

In Oracle SQL, which pseudo-column assigns a sequential number to each row in a result set before ORDER BY is applied?

Accepted Answer

ROWNUM

Answer

ROW_NUMBER()

Answer

ROWID

Answer

SEQUENCE

Question 6

Which Oracle SQL operator is used to compare a value against a list of values in a WHERE clause?

Accepted Answer

IN

Answer

BETWEEN

Answer

LIKE

Answer

EXISTS