When you set up per-table tablespace files for InnoDB...

The correct answer is C. Shared tablespace files are still needed. InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo The .ibd files are not sufficient for InnoDB to operate.

InnoDB Storage Engine

Question

Options

AShared tablespace files are not needed.
BOccasionally shared tablespace files are still needed.
CShared tablespace files are still needed.
DPer-table tablespace files cannot be used with InnoDB.

How the community answered

(44 responses)

A
5% (2)
B
18% (8)
C
70% (31)
D
7% (3)

Explanation

InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo The .ibd files are not sufficient for InnoDB to operate.

Topics

#InnoDB#per-table tablespace#shared tablespace#innodb_file_per_table

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice