nerdexam
HP

HP2-N36 · Question #31

What is the difference between dropping a partition and deleting records?

The correct answer is D. Dropping a partition recovers space immediately; deleting records does not recover space. See the full explanation below for the reasoning.

Question

What is the difference between dropping a partition and deleting records?

Options

  • ADropping a partition creates delete vectors; deleting records does not create delete vectors.
  • BDropping a partition can be rolled back; deleting records cannot be rolled back.
  • CDropping a partition creates new files; deleting records does not create new files.
  • DDropping a partition recovers space immediately; deleting records does not recover space

How the community answered

(17 responses)
  • A
    18% (3)
  • B
    6% (1)
  • C
    6% (1)
  • D
    71% (12)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice