MySQL 8.0 Database Administrator — Question 123

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

Answer options

• A. performance metrics
• B. table definitions
• C. access control lists
• D. view definitions
• E. server runtime configuration
• F. server configuration rollback
• G. stored procedure definitions
• H. InnoDB buffer pool LRU management data

Correct answer: B, C, D, G

Explanation

The correct answers B, C, D, and G represent the specific types of information that the MySQL data dictionary maintains, including definitions for tables, views, access control, and stored procedures. Options A, E, F, and H do not pertain to the data dictionary, as they relate to performance, server settings, or memory management, which are not stored in the data dictionary.