MySQL 8.0 Database Administrator — Question 46

Which three are types of InnoDB tablespaces? (Choose three.)

Answer options

• A. redo tablespaces
• B. encryption tablespaces
• C. schema tablespaces
• D. data tablespaces
• E. undo tablespaces
• F. temporary table tablespaces

Correct answer: B, D, E

Explanation

The correct answers B, D, and E represent encryption tablespaces, data tablespaces, and undo tablespaces, which are all recognized types of InnoDB tablespaces. Options A and C do not pertain to recognized tablespace types within InnoDB, while option F refers to temporary table spaces which are not included among the primary types.