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

Question

Options

• Aperformance metrics
• Btable definitions
• Caccess control lists
• Dview definitions
• Eserver runtime configuration
• Fserver configuration rollback
• Gstored procedure definitions
• HInnoDB buffer pool LRU management data

• A
  5% (1)
• B
  95% (21)

Explanation

B, D, and G are straightforward: MySQL's data dictionary (formally structured as internal InnoDB tables in MySQL 8.0+) is a centralized metadata store that holds definitions of database objects - tables (B), views (D), and stored routines like procedures (G), along with triggers, events, and indexes. F (server configuration rollback) is the trickiest choice here; it refers to MySQL 8.0's atomic DDL support, where the data dictionary participates in transactional schema changes that can be rolled back on failure - this rollback state is tracked within the data dictionary itself.

Why the distractors are wrong:

• A (performance metrics) → lives in the Performance Schema, a separate instrumentation layer
• C (access control lists) → user/privilege data lives in the mysql system schema grant tables, distinct from the data dictionary
• E (server runtime configuration) → controlled by system variables and my.cnf, not stored in the data dictionary
• H (InnoDB buffer pool LRU data) → this is in-memory InnoDB internals, never persisted to the data dictionary

Memory tip: Think "TVSP - Things You'd find in a Schema Printout" - Tables, Views, Stored programs, Plus rollback (the atomic DDL bonus). If it sounds like runtime behavior or monitoring, it belongs elsewhere (Performance Schema, system variables, or InnoDB engine internals).

Note: F is the most debatable choice on this question. If you see variance in other practice materials, it's because "server configuration rollback" is an indirect way of describing atomic DDL support rather than a standard term in MySQL documentation.

No community discussion yet for this question.