Oracle Exam 1Z0-909 Topic 11 Question 54 Discussion

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

Question #: 54
Topic #: 11

[All 1Z0-909 Questions]

Examine these commands and output:

Which is true about the execution of the insert statement?

AIt returns an error.

BIt inserts a row in the view and base table.

CIt inserts a new row in the base table only.

DIt inserts a new row in the view only.

Show Suggested Answer

Suggested Answer: A, B

by Yvonne at Dec 09, 2024, 01:20 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

This is a tricky one. The view seems to be defined on the base table, so I'm going to go with C) - it inserts a new row in the base table only.

upvoted 0 times

...

17 days ago

But the insert statement inserts a row in both the view and base table, so it should be B.

upvoted 0 times

...

19 days ago

I disagree, I believe the answer is C.

upvoted 0 times

...

25 days ago

I think the answer is B.

upvoted 0 times

...