More memory per thread is beneficial in all scenarios
It causes increased overhead due to initial memory allocation
It can affect system stability during peak load times, due to swapping
It requires increasing the thread_cache_size variable
第1题:
A.Thread memory is pre-allocated up to thread_cache_size for performance
B.Each connection may have its own per-thread memory allocations
C.Global memory resources are allocated at server startup
D.Each thread allocates memory from a global pool
第2题:
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 zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. 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
第3题:
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.
第4题:
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?()
第5题:
Which statements about the MEMORY_TARGET initialization parameter are true?()
第6题:
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
第7题:
A. Smaller initial investment
B. Doubles memory requirements
C. Higher simultaneous thread processing
D. Decreases overhead
第8题:
A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
B.Thread buffers are allocated when a client connects, and are freed when the client disconnects
C.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
D.User buffers are allocated at server startup and freed when the user is dropped
E.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
第9题:
Which of the following is an advantage of SMP?()
第10题:
Which statements about the garbage collection are true?()