网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which two statements are true about setting the per-thread buffers higher than required?（）
- A、More memory per thread is beneficial in all scenarios
- B、It causes increased overhead due to initial memory allocation
- C、It can affect system stability during peak load times, due to swapping
- D、It requires increasing the thread_cache_size variable
参考答案
更多 “Which two statements are true about setting the per-thread buffers higher than required?（）A、More memory per thread is beneficial in all scenariosB、It causes increased overhead due to initial memory allocationC、It can affect system stability during peak load times, due to swappingD、It requires increasing the thread_cache_size variable” 相关考题
考题
Which statements are true regarding table compression? ()(Choose all that apply.)
A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overhead during DML but not direct loading operations.E. It requires uncompress operation during I/O.
考题
Which three statements are true about memory buffer allocation by a MySQL Server?()
A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedB.Thread buffers are allocated when a client connects, and are freed when the client disconnectsC.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it endsD.User buffers are allocated at server startup and freed when the user is droppedE.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
Which two options describe how MySQL Server allocates memory?()
A.Thread memory is pre-allocated up to thread_cache_size for performanceB.Each connection may have its own per-thread memory allocationsC.Global memory resources are allocated at server startupD.Each thread allocates memory from a global pool
考题
Which two statements are true about setting the per－thread buffers higher than required?()
A.More memory per thread is beneficial in all scenariosB.It causes increased overhead due to initial memory allocationC.It can affect system stability during peak load times, due to swappingD.It requires increasing the thread_cache_size variable
考题
Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.)
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
Which of the following is an advantage of SMP?()
A. Smaller initial investmentB. Doubles memory requirementsC. Higher simultaneous thread processingD. Decreases overhead
考题
Which statements about the MEMORY_TARGET initialization parameter are true？（） A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
Which of the following is an advantage of SMP？（）A、 Smaller initial investmentB、 Doubles memory requirementsC、 Higher simultaneous thread processingD、 Decreases overhead
考题
An administrator is adding additional memory into a server that registers 1GB of memory in the OS and notices that the system has 2GB of memory physically installed； however， the server only shows 1GB of memory during POST. Which of the following is the MOST likely reason for this？（）A、 The OS does not support more than 1GB of memory.B、 The system memory has different manufacture dates.C、 Two of the memory sticks are defective.D、 The server is using memory interleaving.
考题
An x445 can sustain up to two memory chip failures per memory bank， and in an 8-way with four memory banks， up to eight memory chip failures can be sustained. Which combination of EXA features provides this functionality？（）A、ECC with ChipkillB、ECC with Memory MirroringC、Chipkill with Memory ProteXionD、Memory ProteXion with Hot Spare Memory
考题
Which statements about the garbage collection are true？（） A、 The program developer must create a thread to be responsible for free the memory.B、 The garbage collection will check for and free memory no longer needed.C、 The garbage collection allow the program developer to explicity and immediately free the memory.D、 The garbage collection can free the memory used java object at expect time.
考题
Which two statements are true regarding the SGA_TARGET initialization parameter（）A、It can be increased up to the value of the SGA_MAX_SIZE parameter.B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
考题
Which statements are true regarding table compression？（）A、 It saves disk space and reduces memory usage.B、 It saves disk space but has no effect on memory usage.C、 It incurs extra CPU overhead during DML as well as direct loading operations.D、 It incurs extra CPU overhead during DML but not direct loading operations.E、 It requires uncompress operation during I/O.
考题
Which three statements are true about memory buffer allocation by a MySQL Server?（）A、Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedB、Thread buffers are allocated when a client connects, and are freed when the client disconnectsC、Buffers that are needed for certain operation are allocated when the operation starts, and freed when it endsD、User buffers are allocated at server startup and freed when the user is droppedE、All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
Which two statements are true about the WebLogic Cluster ？（）A、 Clustered Servers capacity can be increased by adding new server instance to the cluster on an existing machineB、 Clustered Servers can be on a same or different machine with same operating system onlyC、 Clustered Servers can only be on a same machine or different operating systemD、 Clustered Servers can be on a same or different machine with same or different operating system
考题
Which two options describe how MySQL Server allocates memory?（）A、Thread memory is pre-allocated up to thread_cache_size for performanceB、Each connection may have its own per-thread memory allocationsC、Global memory resources are allocated at server startupD、Each thread allocates memory from a global pool
考题
多选题Which statements are true regarding table compression? （）(Choose all that apply.)AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
考题
单选题Which of the following is an advantage of SMP?（）A
Smaller initial investmentB
Doubles memory requirementsC
Higher simultaneous thread processingD
Decreases overhead
考题
单选题Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)A
MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB
MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC
MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D
MEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
多选题Which statements about the MEMORY_TARGET initialization parameter are true？（）AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
多选题Which two statements are true about setting the per-thread buffers higher than required?（）AMore memory per thread is beneficial in all scenariosBIt causes increased overhead due to initial memory allocationCIt can affect system stability during peak load times, due to swappingDIt requires increasing the thread_cache_size variable
考题
单选题Which of the following is an advantage of SMP？（）A
Smaller initial investmentB
Doubles memory requirementsC
Higher simultaneous thread processingD
Decreases overhead
考题
单选题Which statements about the garbage collection are true？（）A
The program developer must create a thread to be responsible for free the memory.B
The garbage collection will check for and free memory no longer needed.C
The garbage collection allow the program developer to explicity and immediately free the memory.D
The garbage collection can free the memory used java object at expect time.
考题
多选题Which statements are true regarding table compression？（）AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
考题
单选题An administrator is adding additional memory into a server that registers 1GB of memory in the OS and notices that the system has 2GB of memory physically installed； however， the server only shows 1GB of memory during POST. Which of the following is the MOST likely reason for this？（）A
The OS does not support more than 1GB of memory.B
The system memory has different manufacture dates.C
Two of the memory sticks are defective.D
The server is using memory interleaving.
考题
单选题An administrator is adding additional memory into a server that registers 1GB of memory in the OS and notices that the system has 2GB of memory physically installed; however, the server only shows 1GB of memory during POST. Which of the following is the MOST likely reason for this?（）A
The OS does not support more than 1GB of memory.B
The system memory has different manufacture dates.C
Two of the memory sticks are defective.D
The server is using memory interleaving.
考题
多选题Which two options describe how MySQL Server allocates memory?（）AThread memory is pre-allocated up to thread_cache_size for performanceBEach connection may have its own per-thread memory allocationsCGlobal memory resources are allocated at server startupDEach thread allocates memory from a global pool
热门标签
最新试卷