Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide Answer
Suggested Answer: B, C, D

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

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Mel
20 days ago
Wait, did someone say 'TO_number'? I thought we were dealing with dates, not phone numbers!
upvoted 0 times
Anthony
1 days ago
A) to_number(promo_begin_date) - 5 will return a number.
upvoted 0 times
...
...
Eliz
22 days ago
E) TO_date(PROMO_BEGIN_DATE * 5) will return a date? That's a creative way to manipulate dates, but I'm not sure it's the best approach.
upvoted 0 times
Edwin
24 hours ago
A) to_number(promo_begin_date) - 5 will return a number.
upvoted 0 times
...
...
Carmela
1 months ago
D) PROMO_BEGIN_DATE - 5 will return a date? Hmm, I wonder if that's subtracting 5 days or 5 years.
upvoted 0 times
Myra
24 hours ago
D) PROMO_BEGIN_DATE - 5 will return a date.
upvoted 0 times
...
Marlon
16 days ago
B) PROMO_BEGIN_DATE - sysdate will return a number.
upvoted 0 times
...
Lenna
22 days ago
A) to_number(promo_begin_date) will return a number.
upvoted 0 times
...
...
Terrilyn
1 months ago
B) PROMO_BEGIN_DATE - sysdate will return a number? That's interesting, but I'm not sure what the number would represent.
upvoted 0 times
...
Doretha
2 months ago
A) to_number(promo_begin_date) will return a number? Seriously? That's just asking for trouble with a date column!
upvoted 0 times
Lenna
1 months ago
User 1
upvoted 0 times
...
Cherri
1 months ago
User 2
upvoted 0 times
...
Tegan
1 months ago
User 1
upvoted 0 times
...
...
Kati
2 months ago
I agree with Ashton, statement C is correct. Subtracting a date from another date will indeed return an error.
upvoted 0 times
...
Ashton
2 months ago
I disagree, I believe statement C is true because subtracting a date from another date will result in an error.
upvoted 0 times
...
Tony
2 months ago
I think statement A is true because to_number function will convert the date to a number.
upvoted 0 times
...

Save Cancel