Exit 1Z0-082 Oracle DBA Administration I
Question 2 of 5
0% complete
Q2 Multiple choice

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.)

Select all that apply.

  • A

    TO_NUMBER(PROMO_BEGIN_DATE) - 5 will return a number.

  • B

    PROMO_BEGIN_DATE - SYSDATE will return a number.

  • C

    PROMO_BEGIN_DATE - SYSDATE will return an error.

  • D

    PROMO_BEGIN_DATE - 5 will return a date.

  • E

    TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.

Previous Next