PostgreSQL Exam PGCES-02 Topic 10 Question 46 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 46
Topic #: 10

The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17 12:00:00'. Select the correct expression to fill in the blank below. SELECT CURRENT_TIMESTAMP::timestamp + ________________ ;

A'10 day'::timestamp

B'10 day'::interval

C10::day

D8640000::time

Eage(8640000)

Show Suggested Answer

Suggested Answer: A

by Myra at Jul 25, 2023, 02:51 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Mary

2 months ago

Wait, are we sure it's not option E? I mean, age(8640000) sounds like it might work, right? *scratches head* Oh well, B it is!

upvoted 0 times

Tommy

28 days ago

User 3: I'm not so sure, but I'll trust you guys. B it is!

upvoted 0 times

...

Bobbie

1 months ago

User 2: Yeah, I agree. Let's go with '10 day'::interval.

upvoted 0 times

...

Merlyn

1 months ago

User 1: I think option B is the correct one.

upvoted 0 times

...

Leigha

2 months ago

B is the way to go! '10 day'::interval is the only option that makes sense for adding a 10-day period to the current timestamp.

upvoted 0 times

...

Lonna

2 months ago

I'm going to have to go with option D - 8640000::time. I mean, who doesn't love a good time-based solution, right? *chuckles*

upvoted 0 times

Martha

18 days ago

I agree with you, option D - 8640000::time seems like the best solution.

upvoted 0 times

...

Ciara

30 days ago

I believe option C - 10::day is the right choice here.

upvoted 0 times

...

Hector

1 months ago

I would go with option B - '10 day'::interval for this one.

upvoted 0 times

...

Darell

1 months ago

I think option A - '10 day'::timestamp is the correct one.

upvoted 0 times

...

Holley

2 months ago

Option B is the correct answer, for sure. It's the only one that actually uses an interval to add 10 days to the current timestamp.

upvoted 0 times

Justa

29 days ago

Great, thanks for confirming. Option B it is.

upvoted 0 times

...

Alex

1 months ago

Yes, I agree. It's the one that uses an interval to add 10 days.

upvoted 0 times

...

Maryanne

2 months ago

I think option B is the correct answer.

upvoted 0 times

...

Marge

3 months ago

Hmm, this looks like a tricky one. I'm going to go with option B - '10 day'::interval. That seems like the most logical way to add a 10-day interval to the current timestamp.

upvoted 0 times