CMS专题

多选题Which three statements are true about memory buffer allocation by a MySQL Server?（）AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedBThread buffers are allocated when a client connects, and are fr

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

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

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

第3题：

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

第4题：

Which statement describes queue and buffer managment in the E-series router?（）

  • A、Buffer memory is managed dynamically in the I/O module.
  • B、Buffer memory is managed dynamically in the switch fabric.
  • C、Buffer memory is managed dynamically on egress line modules.
  • D、Buffer memory is managed dynamically on ingress line modules

正确答案:C

第5题：

Which three statements about Label-Switched Paths （LSPs） are true？ （）

  • A、 LSPs are bidirectional.
  • B、 LSPs are unidirectional.
  • C、 LSPs can be signaled by CAC.
  • D、 LSPs can be configured explicitly.
  • E、 LSPs can be configured dynamically.

正确答案:B,D,E

第6题：

Which three statements are true about Automatic Workload Repository (AWR)?()

A. All AWR tables belong to the SYSTEM schema.

B. The AWR data is stored in memory and in the database.

C. The snapshots collected by AWR are used by the self-tuning components in the database

D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.


参考答案：B, C, E

第7题：

Which three statements about bidirectional PIM are true？（）

  • A、Traffic for a bidirectional group flows along the one shared tree and simultaneously utilizes multiple paths in a redundant network topology
  • B、It does not require any traffic signaling in the protocol
  • C、Membership to a bidirectional group is signaled using explicit Join messages
  • D、It maintains source-specific forwarding state
  • E、It reduces memory， bandwidth， and CPU requirements

正确答案:B,C,E

第8题：

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

第9题：

Which three statements are true about terms in a policy?（）

  • A、The order of the terms in a policy is irrelevant
  • B、The action is specified in a then statement
  • C、Ters are optional in a policy
  • D、The match condition can be identified with a from statement
  • E、Every policy must contain at least one term

正确答案:B,D,E

第10题：

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

更多相关问题
相关内容