Oracle Exam 1Z0-149 Topic 14 Question 19 Discussion

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

Question #: 19
Topic #: 14

[All 1Z0-149 Questions]

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.

Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

AError in inner block

BError in inner block Error in outer block

CError in inner block Error in calling block

DError in inner block Error in outer block Error in calling block

Show Suggested Answer

Suggested Answer: B, D

by Trinidad at Jan 26, 2024, 12:19 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Pamella

1 months ago

Error in inner block? More like error in my brain trying to understand this question. Time to call the IT department for some tech support!

upvoted 0 times

...

Audry

1 months ago

I got this one! The answer is B, for sure. The inner block has an error, and the outer block also has an error. Simple as that.

upvoted 0 times

Mila

17 hours ago

But don't forget, the outer block also has an error according to the code.

upvoted 0 times

...

Melodie

20 days ago

I think you're right, the inner block definitely has an error.

upvoted 0 times

...

William

1 months ago

Hmm, this is a tough one. I'm leaning towards D, but I could be wrong. Guess I'll have to study a bit more on exception handling in PL/SQL.

upvoted 0 times

...

Ricki

1 months ago

I'm not sure about this one. The code seems a bit tricky, but I think B is the right answer. What do you guys think?

upvoted 0 times

...

Teresita

1 months ago

The correct answer is B. The outer block and inner block both have an error, but the calling block (not shown) is fine.

upvoted 0 times

Silva

4 days ago

Yes, the calling block is fine according to the explanation.

upvoted 0 times

...

Iraida

6 days ago

I agree, both the outer block and inner block have errors.

upvoted 0 times

...

Annmarie

17 days ago

I think the correct answer is B.

upvoted 0 times

...

Joseph

2 months ago

I'm not sure, but I think it might be C because it only mentions errors in the inner block and calling block.

upvoted 0 times

...

An

2 months ago

I agree with Luther, the code seems to have errors in all the blocks.

upvoted 0 times

...

Luther

2 months ago

I think the answer is D because it shows errors in all three blocks.

upvoted 0 times

...

Willodean

2 months ago

I'm not sure, but I think the correct answer might be B) Error in inner block Error in outer block.

upvoted 0 times

...

Arlette

3 months ago

I agree with Daniel, the code seems to have an error in the inner block only.

upvoted 0 times

...

Daniel

3 months ago

I think the answer is A) Error in inner block.

upvoted 0 times

...