Oracle Database SQL — Question 64

Examine this incomplete query:

SELECT DATE '2019-01-01' +
FROM DUAL;

Which three clauses can replaceto add 12 hours to the date? (Choose three.)

Answer options

• A. INTERVAL '0.5' DAY
• B. INTERVAL '720' MINUTE
• C. INTERVAL '11:60' HOUR TO MINUTE
• D. INTERVAL '12:00' HOUR TO SECOND
• E. INTERVAL '0 12' DAY TO HOUR
• F. INTERVAL '12' HOUR

Correct answer: B, E, F

Explanation

The correct answers B, E, and F all effectively add 12 hours to the date. Option B uses minutes to achieve this (720 minutes), option E specifies a time interval of 12 hours, and option F directly adds 12 hours. Options A, C, and D do not correctly represent an addition of exactly 12 hours in the context of this SQL query.