nerdexam
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)
  • A
    9% (3)
  • B
    84% (27)
  • C
    3% (1)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-064 Practice