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 questionsTo 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.
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.
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
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
