Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

© examsnet.com

Question : 5

Total: 57

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 a query? (Choose two.)

PROMO_BEGIN_DATE – 5 will return a date.
PROMO_BEGIN_DATE – SYSDATE will return a number.
TO_NUMBER(PROMO_BEGIN_DATE) – 5 will return a number.
TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
PROMO_BEGIN_DATE – SYSDATE will return an error.

Go to Question:

Prev Question

Next Question