You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime

题目
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements

相似考题

1.若不同范围的变量使用了同名,则按以下哪个顺序查引用的变量()A、Local->Global->SharedInstanceB、Global->LocalSharedInstanceC、Shared->Global->Instance->LocalD、Local->Shared->Global->Instance

2.在ASP中,操作文件系统需要创建哪个对象?()A.Server.CreateObject（“AdodB.Connection”）B.Server.CreateObject（“AdodB.RecordSet”）C.Server.CreateObject（“Scripting.FileSystemObject”）D.Server.CreateObject（“WScript.Shell”）

3.下面是该网站中数据库连接程序conn.inc的代码，请在空白处填入相应的程序代码。＜%Setcorm=server.(1)("adodb.connection")conn.provider="sqloledb"provstr="server=127.0.0.1；database=(2)；uid=(3)；pwd=(4)"conn.open(5)%＞

4.在连接对象的创建方法，正确的是( )。A conn=createobject("ADOBD.Connection")B conn=server.createobject("ADODB.Connection")C set conn=server.createobject(ADOBD.Connection)D set conn=server.createobject("ADODB.Connection")

参考答案和解析
参考答案：A, C
更多“You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?() ”相关问题

  • 第1题：

    UsingOracleEnterpriseManagertosetSGApoolvaluesmanually,forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately?()

    A.DB_CACHE_SIZE

    B.SHARED_POOL_SIZE

    C.LARGE_POOL_SIZE

    D.JAVA_POOL_SIZE

    E.SGA_MAX_SIZE

    F.SORT_AREA_SIZE


    参考答案：A, B

  • 第2题：

    以下连接对象的创建方法，正确的是()。

    A.conn=CreateObject(”ADODB.connection”)

    B.conn=Server.CreateObject(”ADODB.connection”)

    C.Setconn=Server.CreateObject(ADODB.connection)

    D.Setconn=Server.CreateObject(”ADODB.connection”)


    正确答案：D

  • 第3题：

    以下映射网络文件夹的命令正确的是()

    A.NET USE Z: \\Server\Share

    B.NET USE C:\ //Server/Share

    C.NET SHARE Z: \\Server\Share

    D.NET Send Server Share


    答案A

  • 第4题：

    TomanuallyconfiguretheSGAcomponentsusingOracleEnterpriseManagerMemoryAdvisor,youcansetvaluesforwhichofthefollowinginitializationparameters?()

    A.DB_CACHE_SIZE

    B.SHARED_POOL_SIZE

    C.LARGE_POOL_SIZE

    D.JAVA_POOL_SIZE

    E.SGA_MAX_SIZE

    F.SORT_AREA_SIZE


    参考答案：A, B, C, D

  • 第5题：

    编写一个通用的错误信息提示模块或者数据操作模块（连接数据库和关闭数

    据库），并注明其调用方法及相关参数说明。

    [数据库操作模块相关提示：server.createobject("ADODB.Connection")

    server.createobject("ADODB.Recordset")

    Driver={SQL Server}; server=(local) database=fjw uid=sa pwd=sa

    以上仅以MSSQL为例提示]


    正确答案：
     

  • 第6题：

    WhicharerequiredinitializationparametersinanOracleSharedServerenvironment?()

    A.DISPATCHERSandSHARED_SERVERS

    B.DISPATCHERSandMAX_DISPATCHERS

    C.MAX_DISPATCHERSandMAX_SHARED_SERVERS

    D.SHARED_SERVER_SESSIONSandDISPATCHERS


    参考答案：A

相关内容