Oracle
1Z0-888 · Question #58
1Z0-888 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
Installation and Configuration
Question
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256K
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns. Which three best describe this scenario? (Choose three.)
Options
- AGlobal variables are not persistent across server restarts.
- BSession variables are not persistent across server restarts.
- CThe query benefited from sort_buffer_size increase.
- Dsort_buffer_size should match tmp_table_size to be optimal.
- EThe query benefited from tmp_table_size increase.
- FThe query benefited from sort_buffer_size and tmp_table_size increases.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Variable Persistence#Query Buffer Tuning#Configuration Management#Performance Debugging