ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-149 All Questions

View all questions & answers for the 1z0-149 exam
Go to Exam

Exam 1z0-149 topic 1 question 44 discussion

Actual exam question from Oracle's 1z0-149
Question #: 44
Topic #: 1
[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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Raju_thangavel at March 13, 2023, 6:27 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jfc1
Highly Voted 1 year, 12 months ago
Selected Answer: B
tested
upvoted 6 times
...
2708b98
Most Recent 7 months, 3 weeks ago
Selected Answer: B
Sorry it is B, for table the all_tab_columns gets updated but for the view it does not.
upvoted 1 times
...
2708b98
7 months, 3 weeks ago
Selected Answer: D
tested
upvoted 1 times
...
2oracleexam
1 year, 7 months ago
Selected Answer: B
B, tested
upvoted 1 times
...
thranduyl
1 year, 7 months ago
Selected Answer: B
tested B
upvoted 2 times
...
jm9999
1 year, 12 months ago
what is colcount? Does not run on my SQLDeveloper version 23 unless I remove that word?
upvoted 3 times
...
serkan110
2 years, 4 months ago
No B, it will create the view with the column names that existed before
upvoted 2 times
thranduyl
1 year, 7 months ago
if you create the view and add colum, and if you execute this query return four records
upvoted 1 times
...
...
Raju_thangavel
2 years, 4 months ago
Answer is A?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel