Which two options describe how MySQL Server allocates memory

题目
多选题
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
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which are the two options to which a menu can be assigned?() (Choose two.)

A.menu

B.functions

C.data group

D.responsibility

E.functional group


参考答案:A, D

第2题:

Which are the two main uses of a VIO server?()

A.Virtualize network and memory to LPARs.

B.Virtualize network and storage to LPARs.

C.Virtualize memory and processors to LPARs.

D.Virtualize storage and processors to LPARs.


参考答案:B

第3题:

Which of the following statements describe(s) the properties of a purely segmented memory system?

Ⅰ.It divides memory into units of equal size

Ⅱ.It permits implementation of virtual memory

Ⅲ.It suffers from internal fragmentation

A.Ⅰ only

B.Ⅱ only

C.Ⅲ only

D.Ⅰand Ⅲ


正确答案:B

第4题:

Which two statements describe the behavior of the server's SQL mode?()

  • A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
  • B、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
  • C、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
  • D、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

正确答案:A,C

第5题:

Memory was recently taken out of a fully functional production server before it wasdecommissioned and added to another server.  Upon booting up the server with the additional memory the server emits a series of beeps and fails to POST.  Which of the following is MOST likely the problem?()

  • A、Incompatible memory
  • B、Memory failure
  • C、The memory is not configured
  • D、The server BIOS was not configured to accept the additional memory

正确答案:A

第6题:

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()

A. Allocates memory for RMAN backup and restore operations

B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors

D. Contains stack space

E. Contains a hash area performing hash joins of tables


参考答案:A, B, C

第7题:

The following terms describe various design options for Enterprise connectivity to the Internet.Which of the follow ing imply that the Enterprise connects to two or more ISPs?()

A. Single Homed

B. Dual Homed

C. Single Multihomed

D. Dual Multihomed


参考答案:C, D

第8题:

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

第9题:

Which of the following statements could be true about a server overheating?()

  • A、The processor is hitting 100% utilization.
  • B、The server is having memory errors.
  • C、The server fans have failed.
  • D、The processors are of two different stepping levels.
  • E、There is no thermal protection between the processor and the heat sink.

正确答案:C,E

第10题:

Which are the two options to which a menu can be assigned?() (Choose two.)

  • A、menu
  • B、functions
  • C、data group
  • D、responsibility
  • E、functional group

正确答案:A,D

更多相关问题