Oracle SQL Oracle SQL SELECT Statements 2

Question 1

What does the DUAL table represent in Oracle SQL?

Accepted Answer

A special one-row, one-column table used for evaluating expressions

Answer

A temporary table for joins

Answer

A backup of the main table

Answer

A table containing dual primary keys

Question 2

Which Oracle SQL clause is used to eliminate groups that don't meet a condition after GROUP BY?

Accepted Answer

HAVING

Answer

WHERE

Answer

EXCLUDING

Answer

FILTER BY

Question 3

What is the result of dividing a number by zero in Oracle SQL?

Accepted Answer

Raises an ORA-01476 error

Answer

Returns NULL

Answer

Returns 0

Answer

Returns Infinity

Question 4

In a SELECT statement, which order do clauses execute logically in Oracle SQL?

Accepted Answer

FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY

Answer

SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY

Answer

WHERE → FROM → SELECT → GROUP BY → ORDER BY → HAVING

Answer

FROM → SELECT → WHERE → HAVING → GROUP BY → ORDER BY

Question 5

Which Oracle SQL function returns the current date and time including seconds?

Accepted Answer

SYSDATE

Answer

CURRENT_DATE

Answer

NOW()

Answer

GETDATE()

Question 6

What does the BETWEEN operator do in Oracle SQL?

Accepted Answer

Checks if a value falls within an inclusive range

Answer

Checks if a value is NULL

Answer

Compares two strings for equality

Answer

Returns rows between two tables