Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
The InnoDB system tablespace (ibdata1) by default contains table data and the change buffer. The table data includes actual data stored in InnoDB tables, and the change buffer is used to buffer changes to secondary index pages. These components are critical to the operation of InnoDB and are stored in the system tablespace by default.
A and E. See documentation: https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
InnoDB system tablespace contains the doublewrite buffer and the change buffer. • Each database (including the mysql system database) has a single directory under the data directory that contains storage-engine specific data files for the database. – For example: tablename.ibd for InnoDB, which contains the table data and metadata
In previous MySQL versions, the system tablespace contained the InnoDB data dictionary, but in MySQL 8.0, InnoDB stores metadata in the MySQL data dictionary. The doublewrite buffer storage area also resided in the system tablespace in previous MySQL releases, but this storage area resides in separate doublewrite files as of MySQL 8.0.201.
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
A and B. data directory contains other things. double write now has its own files.
E is stored in tablespace. Not sure why B isn't correct.