Oracle Exam 1Z0-149 Topic 5 Question 21 Discussion

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

Question #: 21
Topic #: 5

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 Simona at Mar 10, 2024, 03:15 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

7 months ago

I agree with Carey, the table alteration might cause an error. So, I also think C) is the correct answer.

upvoted 0 times

...

7 months ago

I'm not sure, but I think both answers make sense. We should check the code again.

upvoted 0 times

...

7 months ago

I disagree, I believe the correct answer is D) It will run successfully producing a result of 5.

upvoted 0 times

...

7 months ago

I think the correct answer is C) It will result in an error because table depts has been altered.

upvoted 0 times

...