网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 ” 相关考题
考题
若不同范围的变量使用了同名,则按以下哪个顺序查引用的变量()
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
热门标签
最新试卷
