oracle architectural components_练习

《oracle architectural components_练习》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、OracleApplicationServer应用服务器.net(IIS)Java(tomcat,oracleApplicationServer,glassfish(sun),IBMwebsphere,beaweblogical)html(apache)OracleApplicationsCRMERPHR查看SGA的配置参数：Showsga;(推荐)Showparametersga_max_size;一个instance只能对应一个数据库（orcl）但是在集群的环境下一个数据库可能有多个instance为之服务。1Whichoneofth

2、efollowingstatementsistrue?aAnOracleserverisacollectionofdataconsistingofthreefiletypes.bAuserestablishesaconnectionwiththedatabasebystartinganOracleinstance.cAconnectionisacommunicationpathwaybetweentheOracleServerandtheOracleInstance.dAsessionstartswhenauserisvalidatedb

3、ytheOracleserver.2WhichoneofthefollowingmemoryareasisnotpartoftheSGA?aDatabasebuffercachebPGAcRedologbuffercachedSharedPool3WhichtwoofthefollowingstatementsaretrueabouttheSharedPool?aThesharedPoolconsistsoftheLibraryCache,DataDictionaryCache,SharedSQLarea,JavaPool,andLarg

4、ePool.bTheSharedPoolisusedtostorethemostrecentlyexecutedSQLstatementsandthemostrecentlyuseddata.cTheSharedPoolisusedforobjectthatcanbesharedglobally.dTheLibraryCacheconsistoftheSharedSQLandSharedPL/SQLareas.4Whichoneofthefollowingmemoryareasisusedtocachethedatadictionaryi

5、nformation?aDatabaseBufferCachebPGAcRedologbuffercachedSharedPool5TheprimarypurposeoftheRedoLogBufferCacheistorecordallchangestothedatabasedatablocks.aTruebFalseAnswer:True6ThePGAisamemoryregionthatcontainsdataandcontrolinformationformultipleserverprocessesormultiplebackg

6、roundprocesses.aTruebFalse7WhichoneofthefollowingprocessesisavailablewhenanOracleinstanceisstarted.aUserprocessbBackgroundprocesscServerprocessdSystemprocess8Identifythesixmandatorybackgroundprocesses._DBWn_________________________________________CKPT_____________________

7、____________________LGWR________________________________________SMON_________________________________________PMON__________________________________________DIAG__________________________________9Whichoneofthefollowingmemoryareasisusedtocachethedatadictionaryinformation?aDa

8、tabaseBufferCachebPGAcRedologbuffercachedSharedPool10Matchtheprocesswithitstask.aDatabaseWriter_