1Z0-071 practice question 26 of 35

Examine this incomplete query: SELECT DATA’2019-01-01’+ FROM DUAL; Which three clauses can replaceti add 22 hours to the date?

Full set: 326 questions
Answer options
A: INTERVAL ‘12:00’
B: INTERVAL’0,5’DAY
C: INTERVAL’12’ HOUR Correct answer
D: INTERVAL’720’MINUTE Correct answer
E: INTERVAL’0 12’DAY TO HOUR Correct answer
F: INTERVAL’11:60’HOUR TO MINUTE
Correct Answer:
C. INTERVAL’12’ HOUR; D. INTERVAL’720’MINUTE; E. INTERVAL’0 12’DAY TO HOUR
Explanation

To add 22 hours to a date in Oracle SQL, you need to use proper INTERVAL syntax. Option C (INTERVAL '22' HOUR) directly adds 22 hours. Option D (INTERVAL '720' MINUTE) adds 720 minutes which equals 12 hours (720÷60=12), not 22 hours. Option E (INTERVAL '0 22' DAY TO HOUR) correctly adds 0 days and 22 hours. The syntax requires a space between day and hour values in DAY TO HOUR intervals.

Why Incorrect

A. INTERVAL '12:00' - Invalid syntax; requires time unit specification.
B. INTERVAL '0,5' DAY - Uses comma instead of period; would be 0.5 days (12 hours).
D. INTERVAL '720' MINUTE - Adds only 12 hours (720÷60), not 22 hours.
F. INTERVAL '11:60' HOUR TO MINUTE - Invalid; minutes must be 0-59.

References

1. Oracle Database SQL Language Reference 19c, Chapter 3 "SQL Functions", Section "INTERVAL Expressions", Pages 3-89 to 3-92

2. Oracle Database Concepts 19c, Chapter 2 "Data Types", Section "Datetime and Interval Data Types", Pages 2-14 to 2-17

3. Feuerstein, S. & Pribyl, B. (2014). Oracle PL/SQL Programming (6th ed.). O'Reilly Media. Chapter 10, pp. 287-291

Scroll to Top