niusouti.com

多选题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 lo

题目
多选题
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

相似考题

1.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.

2.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

3.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

4.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 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 lo”相关问题

  • 第1题：

    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 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


    参考答案：A

  • 第2题：

    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 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

    正确答案:A,B,C

  • 第3题：

    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.

    正确答案:C

  • 第4题：

    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.

    正确答案:A,B

  • 第5题：

    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.

    正确答案:A,C

  • 第6题：

    Which two options describe how MySQL Server allocates memory?（）

    • 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

    正确答案:B,C

  • 第7题：

    单选题
    Which of the following is an advantage of SMP?（）
    A

    Smaller initial investment

    B

    Doubles memory requirements

    C

    Higher simultaneous thread processing

    D

    Decreases overhead


    正确答案： D
    解析： 暂无解析

  • 第8题：

    多选题
    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 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


    正确答案： C,A
    解析： 暂无解析

  • 第9题：

    多选题
    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 machine

    B

    Clustered Servers can be on a same or different machine with same operating system only

    C

    Clustered Servers can only be on a same machine or different operating system

    D

    Clustered Servers can be on a same or different machine with same or different operating system


    正确答案： A,D
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： B,D
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： C
    解析： Java语言将内存分配和释放的工组交给了自己，程序员不必做这些工作，它提供一个系统级的线程跟踪每个内存的分配，在JVM的空闲处理中，垃圾收集线程将检查和释放不再使用的内存（即可以被释放的内存）。垃圾收集的过程在java程序的生存期中是自动的，不需要分配和释放内存，也避免了内存泄漏。可以调用System.gc()方法建议（suggest）JVM执行垃圾收集以使得可被释放的内存能立即被使用，当此方法返回的时候，JVM已经做了最大的努力从被丢弃的对象上回收内存空间。程序员不能指定收集哪些内存，一般而言也不用关心这个问题，除非是程序的内存消耗很大，特别是有很多临时对象时可以“建议“进行垃圾收集以提高可用内存。需要指出的是调用System.gc()方法不能保证JVM立即进行垃圾收集，而只能是建议,因为垃圾收集线程的优先级很低（通常是最低的）。

  • 第12题：

    单选题
    An Intermediate System experiencing memory problems indicates that it may have incomplete data by setting which bit in its LSP?（）
    A

    more bit

    B

    partition bit

    C

    attached bit

    D

    overload bit


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which of the following is an advantage of SMP?()

    A. Smaller initial investment

    B. Doubles memory requirements

    C. Higher simultaneous thread processing

    D. Decreases overhead


    参考答案：C

  • 第14题：

    Which of the following is an advantage of SMP？（）

    • A、 Smaller initial investment
    • B、 Doubles memory requirements
    • C、 Higher simultaneous thread processing
    • D、 Decreases overhead

    正确答案:C

  • 第15题：

    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.

    正确答案:B

  • 第16题：

    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

    正确答案:B,C

  • 第17题：

    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 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

    正确答案:A,B,C

  • 第18题：

    多选题
    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.


    正确答案： D,A
    解析： 暂无解析

  • 第19题：

    单选题
    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 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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    多选题
    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.


    正确答案： A,D
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements are true about standard database auditing（）
    A

    DDL statements can be audited.

    B

    Statements that refer to stand-alone procedure can be audited.

    C

    Operations by the users logged on as SYSDBA cannot be audited.

    D

    Only one audit record is ever created for a session per audited statement even though it is executedmore than once.


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

    单选题
    Which of the following is an advantage of SMP？（）
    A

     Smaller initial investment

    B

     Doubles memory requirements

    C

     Higher simultaneous thread processing

    D

     Decreases overhead


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    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.


    正确答案： E,B
    解析： 暂无解析

  • 第24题：

    多选题
    Which two options describe how MySQL Server allocates memory?（）
    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


    正确答案： D,C
    解析： 暂无解析

相关内容