Oracle
1Z0-060 · Question #205
1Z0-060 Question #205: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Question
DBS_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? (Choose three.)
Options
- Ausing ALTER INDEX REBUILD PARTITION once for each affected local index partition
- Busing DBMS_PART.CLEANUP_GIDX once to clean up orphaned keys in all local indexes.
- Cusing ALTER INDEX COALESCE PARTITION CLEANUP once for each affected global index
- Dusing DBMS_PART.CLEANUP_CIDX once to clean up any orphaned keys in all global indexes on
- Eusing ALTER INDEX COALESCE PARTITION CLEANUP once for each affected local index
- Fusing ALTER INDEX REBUILD PARTITION once for each affected global index partition
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.