MySQL 8.0 Database Administrator — Question 109

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

Answer options

• A. table data
• B. primary indexes
• C. user privileges
• D. InnoDB Data Dictionary
• E. change buffer
• F. doublewrite buffer

Correct answer: A, E

Explanation

The InnoDB system tablespace (ibdata1) by default contains table data and the change buffer. While primary indexes, user privileges, the InnoDB Data Dictionary, and the doublewrite buffer are important, they are not stored within the system tablespace by default.