Oracle Exam 1Z0-082 Topic 3 Question 99 Discussion

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

Question #: 99
Topic #: 3

[All 1Z0-082 Questions]

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.

h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

Ato_numberipromo_begin_date) - s will return a number.

BPROMO_ BEGIN_DATE - sysdate will return a number.

CPROMO_ BEGIN_DATE - sysdate will return an error.

DPROMO_ BEGIN_DATE - 5 will return a date.

DTO_date(PROMO_ BEGIN_DATE * 5| will return a date.

Show Suggested Answer

Suggested Answer: B, C, D

by Venita at Aug 04, 2024, 12:21 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

29 days ago

I think statement A is true because to_number function will convert the date to a number.

upvoted 0 times

...