Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 121

Which two queries execute successfully? (Choose two.)

SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL

SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;

SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

SELECT INTERVAL '1' DAY + INTERVAL '1' MONTH FROM DUAL;

SELECT SYSDATE * INTERVAL '1' DAY FROM DUAL;

Correct Answer: B, D

The query using SYSTIMESTAMP + INTERVAL '1' DAY is valid because it adds a day interval to the current timestamp, which is an allowed operation. Also, INTERVAL '1' DAY + INTERVAL '1' MONTH is valid because it involves adding two interval values together, which is a permissible operation in SQL. Other queries involve invalid operations such as subtracting dates from intervals or multiplying dates by intervals, which are not supported.

Discussion

lucemqyOptions: AB

AB is correct

musafirOptions: AB

Checked in Oracle