Oracle Exam 1Z0-071 Topic 14 Question 85 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 85
Topic #: 14

In the PROMOTIONS table, the PROMO_ BEGIN_DATE column is of data type and the default date format is DD-MON-RR

Which two statements are true about expressions using PROMO_ BEGIN_DATE in a query?

ATONUMBER (PROMO BEGIN_DATE) - 5 will return a number

BPROMO_ BEGIN_DATE - 5 will return a date

CPROMO_ BEGIN_DATE - SYSDATE will return a number

DPROMO_ BEGIN_DATE - SYSDATE will return an error

ETODATE(PROMO BEGIN_DATE *5) will return a date

Show Suggested Answer

Suggested Answer: B, C

by Winfred at Jan 24, 2024, 03:50 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!