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 operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for

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

相似考题

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

2.YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQL>SELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

3.TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently，alotofinsertactivityistakingplaceinthedatabase，andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces，youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged？（）A.LOG_BUFFERB.DB_CACHE_SIZEC.JAVA_POOL_SIZED.LARGE_POOL_SIZEE.SHARED_POOL_SIZEF.STREAMS_POOL_SIZE

4.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"DB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD？（）A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST

更多“Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?() ”相关问题

  • 第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题：

    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

  • 第3题：

    YouaremaintainingtheSALESdatabaseonOracle10g.Youhaveaddedanewdisktoadiskgroup.AutomaticStorageManagementperformstherebalancingactivity.Youwanttospeeduptherebalancingactivity.Whichparameterwillyouspecifytocontrolthespeedoftherebalancingactivity？（）

    A.ASM_POWER_LIMIT

    B.ASM_DISKSTRING

    C.ASM_DISKGROUPS

    D.LARGE_POOL_SIZE


    参考答案：A

  • 第4题：

    WhenmanuallyconfiguringtheSGA,whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect?()"FirstTest,FirstPass"－www.lead2pass.com97Oracle1Z0－053Exam

    A.DB_CACHE_SIZE

    B.SHARED_POOL_SIZE

    C.LARGE_POOL_SIZE

    D.JAVA_POOL_SIZE

    E.SGA_MAX_SIZE

    F.SORT_AREA_SIZE


    参考答案：E

  • 第5题：

    YouincludedthefollowingAutomaticStorageManagement（ASM）initializationparametersettingsintheASMinitializationparameterfile：INSTANCE_TYPE=ASMASM_POWER_LIMIT=11LARGE_POOL_SIZE=4MASM_DISKGROUPS=DG1，DG2DB_UNIQUE_NAME=+ASMYouareunabletostarttheASMinstance.Whichinitializationparameterfilesetting（s）isnotallowingtheASMinstancetostart？（）

    A.onlytheINSTANCE_TYPEinitializationparameterissettoaninvalidvalue

    B.onlytheASM_POWER_LIMITinitializationparameterissettoaninvalidvalue

    C.onlytheLARGE_POOL_SIZEinitializationparameterissettoaninvalidvalue

    D.boththeLARGE_POOL_SIZEandINSTANCE_TYPEinitializationparametersaresettoinvalidvalues


    参考答案：D

  • 第6题：

    ORACLE初始化参数文件的默认路径是:()

    A.对于UNIX，在$ORACLE_HOME/dbs

    B.对于UNIX，在$ORACLE_HOME/dbs/admin

    C.对于Linux，在%ORACLE_HOME%\database

    D.对于Windows，在%ORACLE_HOME%\dbs

    E.对于Windows，在%ORACLE_HOME%\database\admin


    参考答案：A

相关内容