Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 3 Topic 1 Discussion

Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 3 Topic 1 Discussion

1z0-149 Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

Examine the structure of the ora1.depts table:

1z0-149 Question 3

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:

1z0-149 Question 3

Which is true?


A.

DEP_VU must be manually recompiled to successfully run this code.


B.

It will run successfully producing a result of 4.


C.

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


D.

It will run successfully producing a result of 5.


Get Premium 1z0-149 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.