Oracle
1Z0-883 · Question #46
1Z0-883 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Question
Which three statements are true about memory buffer allocation by a MySQL Server?
Options
- AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
- BThread buffers are allocated when a client connects, and are freed when the client disconnects.
- CBuffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
- DUser buffers are allocated at server startup and freed when the user is dropped.
- EAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally,
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 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.