In the promotions table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query? (Choose two.)
In the promotions table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query? (Choose two.)
PROMO_BEGIN_DATE is of data type DATE, and in Oracle SQL, date arithmetic is possible. PROMO_BEGIN_DATE - SYSDATE will return a number representing the difference in days, making it a valid and true statement. PROMO_BEGIN_DATE - 5 will subtract 5 days from the given date and return a date, which is also valid and true.
https://www.examtopics.com/discussions/oracle/view/10240-exam-1z0-071-topic-1-question-269-discussion/
C and D are corrects.
Todas dan errores de sintaxis.
CD are correct answers
C D are correct