Oracle Database SQL — Question 129

Which three queries execute successfully? (Choose three.)

Answer options

• A. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;
• B. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;
• C. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;
• D. SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;
• E. SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;
• F. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

Correct answer: B, D, E

Explanation

The correct answers B, D, and E work because they properly handle the date arithmetic without resulting in invalid operations. Option A fails due to the subtracting of SYSDATE and DATE '2019-01-01' from a number, C fails because dividing a date by another date is not valid, and F fails because it attempts to divide a number by SYSDATE, which is also invalid.