Oracle Exam 1Z0-052 Topic 3 Question 2 Discussion

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

Question #: 2
Topic #: 3

Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

AAn update in a leaf row takes place.

BThe index becomes invalid after the update.

CThe leaf block containing the row to be updated is marked as invalid.

DA row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

Show Suggested Answer

Suggested Answer: D

by Rozella at Dec 24, 2022, 09:15 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!