Which two situations can lead to sparsely populated ind…

Which two situations can lead to sparsely populated index blocks?(Choose two.)

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=yVTwF

K
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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


vasya

vasya

I think B and D
Not sure about B.