Oracle Exam 1Z0-149 Topic 13 Question 35 Discussion

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

Question #: 35
Topic #: 13

[All 1Z0-149 Questions]

Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:

Create or replace view dep_vu as select * from depts;

Alter table depts add dep_email varchar2(20);

Finally, examine this block of code executed by user ora1:

Which is true?

ADEP_VU must be manually recompiled to successfully run this code.

BIt will run successfully producing a result of 4.

CIt will result in an error because table depts has been altered.

DIt will run successfully producing a result of 5.

Show Suggested Answer

Suggested Answer: B

by Theodora at Sep 10, 2024, 07:12 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Stephane

3 months ago

Haha, I bet the answer is C. That's the classic 'gotcha' where you think it should work, but the table structure changed and the view is now out of sync.

upvoted 0 times

...

3 months ago

The view dep_vu was created, so the code should run successfully. It's just a matter of whether it produces a result of 4 or 5.

upvoted 0 times

Elfriede

2 months ago

B) It will run successfully producing a result of 4.

upvoted 0 times

...

Galen

3 months ago

A) DEP_VU must be manually recompiled to successfully run this code.

upvoted 0 times

...

Rasheeda

3 months ago

I agree with Viola, the table has been altered.

upvoted 0 times

...

Viola

3 months ago

I think the answer is C.

upvoted 0 times

...