Oracle Exam 1Z0-060 Topic 11 Question 8 Discussion

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

Question #: 8
Topic #: 11

DBA_IND_partitions,orphaned_entries contains yes for several index partitions. This is due to the use of deferred Index maintenance. Which three methods will remove the orphaned keys?

Ausing alter index rebuild partition once for each affected global index partition

Busing DBMS PART.CLEANUP GIDX once to clean up any orphaned keys in all global indexes on partitioned tables

Cusing alter index coalesce partition cleanup once for each affected global index partition

Dusing alter index coalesce partition cleanup once for each affected local index partition

Eusing alter index rebuild partition once for each affected local index partition

Fusing DBMS PART.CLEANUP GIDX once to clean up orphaned keys In all local indexes

Show Suggested Answer

Suggested Answer: A, D

by Donette at May 07, 2022, 08:23 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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