nerdexam
Oracle

1Z0-883 · Question #18

Which of the following is true for how the InnoDB storage engine uses diskspace?

The correct answer is A. It stores its data, index and undo information all in its own tablespace. See the full explanation below for the reasoning.

Question

Which of the following is true for how the InnoDB storage engine uses diskspace?

Options

  • AIt stores its data, index and undo information all in its own tablespace.
  • BIt stores its data in .MYD files, in the respective database directory, and its index and undo
  • CIt stores its data and index in .MYD and .MYI files, in the respective database directory, and undo
  • DIt stores its data, index and undo information in .MYD and .MYI files, in the respective database

How the community answered

(24 responses)
  • A
    75% (18)
  • B
    4% (1)
  • C
    8% (2)
  • D
    13% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice