Oracle Exam 1Z0-071 Topic 16 Question 73 Discussion

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

Question #: 73
Topic #: 16

[All 1Z0-071 Questions]

Which three are true?

ALAST_DAY returns the date of the last day of the current ,month onlyu.

BCEIL requires an argument which is a numeric data type.

CADD_MONTHS adds a number of calendar months to a date.

DADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

ELAST_DAY return the date of the last day the previous month only.

FCEIL returns the largest integer less than or equal to a specified number.

GLAST_DAY returns the date of the last day of the month for the date argument passed to the function.

Show Suggested Answer

Suggested Answer: D, E, G

by Ty at Mar 31, 2023, 10:05 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Freeman

1 months ago

Wait, is CEIL a math function or a database function? I always get those mixed up. Better double-check that one.

upvoted 0 times

...

Ethan

1 months ago

E is a trick question, right? LAST_DAY is for the current month, not the previous one. That's just common sense.

upvoted 0 times

Elza

13 days ago

C) ADD_MONTHS adds a number of calendar months to a date.

upvoted 0 times

...

Leila

21 days ago

A) LAST_DAY returns the date of the last day of the current month only.

upvoted 0 times

...

Margurite

1 months ago

Haha, 'onlyu'? Looks like someone needs to proofread their answers a bit more carefully. But C and G are good choices.

upvoted 0 times

...

Milly

1 months ago

B and F are definitely true, but I'm not sure about D. Isn't ADD_MONTHS supposed to work with a date, not a character string?

upvoted 0 times

Samira

8 days ago

F) CEIL returns the largest integer less than or equal to a specified number.

upvoted 0 times

...

Arthur

20 days ago

B) CEIL requires an argument which is a numeric data type.

upvoted 0 times

...

Anna

2 months ago

A, C, and G sound right to me. I'm pretty sure LAST_DAY works for the current month, not just the previous one.

upvoted 0 times

Rene

I agree, LAST_DAY returns the date of the last day of the month for the date passed to the function.

upvoted 0 times

...

Hillary

11 days ago

A, C, and G are correct. LAST_DAY does work for the current month.

upvoted 0 times

...

Markus

12 days ago

So, A, B, C, and G are all true statements about the functions.

upvoted 0 times

...

Shizue

21 days ago

CEIL requires a numeric data type as an argument, so B is true as well.

upvoted 0 times

...

Essie

1 months ago

I agree, LAST_DAY returns the date of the last day of the month for the date passed to the function.

upvoted 0 times

...

Onita

2 months ago

A, C, and G are correct. LAST_DAY does work for the current month.

upvoted 0 times

...

Rene

2 months ago

I'm not sure about D and E. Can someone explain why they are not true?

upvoted 0 times

...

Louis

2 months ago

I agree with Mona. A, C, and G make sense to me.

upvoted 0 times

...

Mona

3 months ago

I think A, C, and G are true.

upvoted 0 times

...