Oracle Database SQL — Question 145

Which two queries execute successfully? (Choose two.)

Answer options

• A. SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL
• B. SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;
• C. SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;
• D. SELECT INTERVAL '1' DAY + INTERVAL '1' MONTH FROM DUAL;
• E. SELECT SYSDATE * INTERVAL '1' DAY FROM DUAL;

Correct answer: A, B

Explanation

Options A and B are correct because they use valid interval arithmetic that can be executed in SQL. Option C is incorrect as it tries to subtract SYSDATE from an INTERVAL, which is not valid. Options D and E are also invalid since they involve operations that are not allowed with INTERVAL and SYSDATE.