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 storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
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、Local->Global->Shared-->InstanceB、Global->Local-->Shared-->InstanceC、Shared->Global->Instance->LocalD、Local->Shared->Global->Instance
YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT=$ORACLE_SID_%s_%t.%tDB_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
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQLSELECTname，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.
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
UsingOracleEnterpriseManagertosetSGApoolvaluesmanually,forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately?() A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE
WhenmanuallyconfiguringtheSGA,whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect?()FirstTest,FirstPass－www.lead2pass.com97Oracle1Z0－053Exam A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE
TomanuallyconfiguretheSGAcomponentsusingOracleEnterpriseManagerMemoryAdvisor,youcansetvaluesforwhichofthefollowinginitializationparameters?() A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE
YouincludedthefollowingAutomaticStorageManagement（ASM）initializationparametersettingsintheASMinitializationparameterfile：INSTANCE_TYPE=ASMASM_POWER_LIMIT=11LARGE_POOL_SIZE=4MASM_DISKGROUPS=DG1，DG2DB_UNIQUE_NAME=+ASMYouareunabletostarttheASMinstance.Whichinitializationparameterfilesetting（s）isnotallowingtheASMinstancetostart？（）A.onlytheINSTANCE_TYPEinitializationparameterissettoaninvalidvalueB.onlytheASM_POWER_LIMITinitializationparameterissettoaninvalidvalueC.onlytheLARGE_POOL_SIZEinitializationparameterissettoaninvalidvalueD.boththeLARGE_POOL_SIZEandINSTANCE_TYPEinitializationparametersaresettoinvalidvalues
YouaremaintainingtheSALESdatabaseonOracle10g.Youhaveaddedanewdisktoadiskgroup.AutomaticStorageManagementperformstherebalancingactivity.Youwanttospeeduptherebalancingactivity.Whichparameterwillyouspecifytocontrolthespeedoftherebalancingactivity？（）A.ASM_POWER_LIMITB.ASM_DISKSTRINGC.ASM_DISKGROUPSD.LARGE_POOL_SIZE
ORACLE初始化参数文件的默认路径是:() A.对于UNIX，在$ORACLE_HOME/dbsB.对于UNIX，在$ORACLE_HOME/dbs/adminC.对于Linux，在%ORACLE_HOME%\databaseD.对于Windows，在%ORACLE_HOME%\dbsE.对于Windows，在%ORACLE_HOME%\database\admin