Oracle
1Z0-064 · Question #78
Which two situations can lead to sparsely populated index blocks? (Choose two.)
The correct answer is B. Indexed columns in a table are frequently updated. D. Bulk delete operations are performed on a table with indexes. See the full explanation below for the reasoning.
Question
Which two situations can lead to sparsely populated index blocks? (Choose two.)
Options
- AData is frequently inserted using direct path load into a table with an index.
- BIndexed columns in a table are frequently updated.
- CValues in an indexed column are inserted using monotonically incrementing sequences.
- DBulk delete operations are performed on a table with indexes.
- EOnline table move operations are performed frequently on a table with indexes.
How the community answered
(32 responses)- A9% (3)
- B84% (27)
- C3% (1)
- E3% (1)
Community Discussion
No community discussion yet for this question.