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=PA35
0&dq=situations+can+lead+to+sparsely+populated+index+blocks&source=bl&ots=yVTwFK
a7wH&sig=Cie0Hgl4AuoL2NZpwqPp_X4GlpY&hl=en&sa=X&ved=0CBsQ6AEwAGoV
ChMI
6dTNj8iSyQIVxrqUCh1TKA1f#v=onepage&q=situations%20can%20lead%20to%20sparse
l y%20populated%20index%20blocks&f=false
I think B and D
Not sure about B.
Maybe B,D
imo DE
BD