Oracle Exam 1Z0-071 Topic 6 Question 107 Discussion

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

Question #: 107
Topic #: 6

[All 1Z0-071 Questions]

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 Jacki at Oct 20, 2024, 05:07 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Brande

24 days ago

Honestly, I'm just impressed they managed to cram 'PROMO_BEGIN_DATE' into one column name. That's some serious database real estate right there.

upvoted 0 times

...

Dylan

26 days ago

Whoa there, buddy. Option A is the real winner here. TONUMBER(PROMO BEGIN_DATE) will turn that date into a sweet, sweet number. Who needs dates when you've got numbers?

upvoted 0 times

Julene

4 days ago

User 3: But what about Option B? PROMO_BEGIN_DATE - 5 should return a date, right?

upvoted 0 times

...

Cordell

7 days ago

User 2: Yeah, I agree. Dates are overrated. Numbers all the way.

upvoted 0 times

...

India

12 days ago

User 1: I think Option A is correct. TONUMBER(PROMO BEGIN_DATE) will give us a number.

upvoted 0 times

...

Kendra

1 months ago

Hold up, option E is the one that makes the most sense to me. TODATE(PROMO BEGIN_DATE *5) will convert the date to a new date that's 5 times the original.

upvoted 0 times

...