Oracle Database MySQL 5.6 Developer — Question 35

What are two ways in which normalizing your tables helps improve performance In MySQL?

Answer options

• A. Smaller table sizes and row lengths improve sorting operations.
• B. Separate tables allow indexing more columns.
• C. Fewer nullable column improve index usage.
• D. Normalizing Improves the performance of innodb_file_per _table.

Correct answer: D

Explanation

The correct answer, D, is accurate because normalization can optimize the management and performance of tables when using the innodb_file_per_table setting. Other options, while they mention valid concepts, do not directly relate to the specific performance improvements associated with normalization in this context.