Oracle Exam 1Z0-149 Topic 4 Question 50 Discussion

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

Question #: 50
Topic #: 4

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: C, D

by Salena at May 02, 2025, 08:59 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

23 hours ago

I agree with you, Willard. Option A looks correct to me too.

upvoted 0 times

...

3 days ago

I'm going with Option B. It's the only one that uses the COALESCE function, which is perfect for handling null values.

upvoted 0 times

...

25 days ago

Option A and Option B seem to be the way to go. They're the only ones that mention the PDT_ID, which is the key to the question.

upvoted 0 times

23 hours ago

User 2: Yeah, they both mention the PDT_ID which is important for this question.

upvoted 0 times

...

4 days ago

User 1: I think Option A and Option B are the correct ones.

upvoted 0 times

...

25 days ago

I think the answer is Option A.

upvoted 0 times

...