itgle.com

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 fre

题目
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.对于一个正常的移动台主叫流程,下面的信令流程先后次序正确的是()A.OriginationMessage->CMServiceRequest->Allocation->Establish->AssignmentComplete->TchPreambleB.OriginationMessage->CMServiceRequest->TchPreamble->Establish->AssignmentCompleteAllocationC.OriginationMessage->CMServiceRequest->Establish->Allocation->TchPreamble->AssignmentCompleteD.OriginationMessage->CMServiceRequest->Establish->AssignmentComplete->Allocation->TchPreamble

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

3.The "main storage" normally means that part of internal storage into which instructions and other data must be loaded for subsequent execution or processing. In large computing systems, the term "main storage" is(71) to "memory". "Buffer" mainly indicates a special-purpose storage or storage area allowing, through(72) storage, the data transfer between two functional units having different transfer characteristics. A buffer storage is used between non-synchronized devices or where one is(73) and the other is parallel or between those having different trans far rates. "(74) (memory)" is also a special-purpose buffer storage, smaller and faster than main storage, used to hold a copy of instructions and data obtained from main storage and likely to be needed next by the processor. "Register" is commonly composed of a part of internal storage having a specified storage(75) and usually intended for a specific purpose.A．suitableB．optionalC．choiceD．preferred

4.MySQL为哪些内容分配内存()A、线程句柄B、MEMORY存储引擎创建的表C、客户端缓冲区D、全局缓冲区与高速缓存

更多“Which three statements are true about memory buffer allocation by a MySQL Server?() ”相关问题

  • 第1题：

    YouhaveanExchangeorganization.TheExchangeserversintheorganizationareconfiguredasshowninthefollowingtable.YoudeployanewExchangeServer2010ClientAccessservernamedServer4andsuccessfullyupdatetherequiredDNSrecordsforServer4.YouneedtoensurethatallusersonServer3cansuccessfullyaccesstheirmailboxesbyusingExchangeActiveSync.Whatshouldyoudo（）？

    A.OnServer1，settheauthenticationtypefortheMicrosoft-Server-ActiveSyncvirtualdirectorytonTLm.

    B.OnServer1，settheauthenticationtypefortheMicrosoft-Server-ActiveSyncvirtualdirectorytoanonymous.

    C.FromtheExchangeManagementShellonServer4，runNew-ActiveSyncDeviceAccessRulequeryString*-CharacteristicDeviceModelAccessLevelAllow.

    D.FromtheExchangeManagementShellonServer3，runSet-ActiveSyncVirtualDirectory-Identity"server3\Microsoft-Server-ActiveSync（defaultwebsite）"-Basicauthentication：$true.


    参考答案：A

  • 第2题：

    下列（ ）是MySQL的布尔数据类型的值。

    A.good

    B.false

    C.bad

    D.true


    正确答案：BD

  • 第3题：

    Act6-1： 向客户端输出 1 到 10000，Buffer 属性分别设置为 True 或 False，比较一下 1 到 10000 输出到页面所用时间的差别。 （网站名称：ResponseBufferAct）


    14

  • 第4题：

    你公司有一个AD域。域中的所有服务器运行windowsserver2008.TS网关角色服务安装在名为server1的服务器上。终端服务服务角色服务安装在服务器server2和server3上。Server2和server3配置在名为TSLoad负载均衡终端服务场中。你在新服务器server4中安装TS会话Broker角色服务。你把TSLoad场加入到server4中的TS会话Broker配置中。你需要确保TS会话Broker能接受server2和server3的连接。你应该怎么做？（）

    A.把server2和server3加入到server4上的会话Broker计算机本地组中

    B.把server2和server3加入到ActiveDirectory域中windows认证访问域本地安装组中

    C.配置一个组策略对象（GPO），设置终端服务安全部分的“需要安全RPC通信”选项为True。应用这个组策略到server2和server3上

    D.配置一个组策略对象（GPO），设置终端服务部分的“只允许从初始客户重新连接”为True。应用这个组策略到所有客户端计算机上


    参考答案：A

  • 第5题：

    MEMORY是MySQL5.7.22默认的存储引擎。


    InnoDB

  • 第6题：

    MySQL以下存储引擎中支持事务的是

    A．InnoDB

    B．TokuDB

    C．MyISAM

    D．Memory


    InnoDB;TokuDB

相关内容