Which two situations can lead to sparsely populated index blocks? (Choose two.)
A.
Data is frequently inserted using direct path load into a table with an index.
B.
Indexed columns in a table are frequently updated.
C.
Values in an indexed column are inserted using monotonically incrementing sequences.
D.
Bulk delete operations are performed on a table with indexes.
E.
Online table move operations are performed frequently on a table with indexes.
Explanation:
https://books.google.com.pk/books?id=b3DIkYO2gBQC&pg=PA350&lpg=PA350&dq=situations
+can+lead+to+sparsely+populated+index
+blocks&source=bl&ots=yVTwFKa7wH&sig=Cie0Hgl4AuoL2NZpwqPp_X4GlpY&hl=en&sa=X&ved=0CBsQ6AE
wAGoVChMI6dTNj8iSyQIVxrqUCh1TKA1f#v=onepage&q=situations%20can%20lead%20to%20sparsely%
20populated%20index%20blocks&f=false