课
程
程
资
讯
讯
综
合
合
q.1:physicaldiskresourcesinanoracledatabaseare
1.controlfiles
2.redologfiles
3.datafiles
4.alloftheabove
4
q.2:whatisaschema
1.aphysicalorganizationofobjectsinthedatabase
2.alogicalorganizationofobjectsinthedatabase
3.aschemeofindexing
4.noneoftheabove
2
q.3:anoracleinstanceis
1.oraclememorystructures
2.oraclei/ostructures
3.oraclebackgroundprocesses
4.alloftheabove
4
q.4:thesgaconsistsofthefollowingitems
1.buffercache
2.sharedpool
3.redologbuffer
4.alloftheabove
4
q.5:theareathatstorestheblocksrecentlyusedbysqlstatementsis
1.sharedpool
2.buffercache
3.pga
4.uga
2
q.6:whichofthefollowingisnotabackgroundserverprocessinanoracle
1.dbwriter
2.dbreader
3.logwriter
4.smon
2
q.7:whichofthefollowingisavalidbackgroundserverprocessesinoracle
1.archiver
2.lgwr(logwriter)
3.dbwr(dbwriter)
4.alloftheabove
4
q.8:theprocessthatwritesthemodifiedblockstothedatafilesis
1.dbwr
2.lgwr
3.pmon
4.smon
1:oracledoesnotmodifythedataindatafile.oncetheserverprocess
makesachangeinthememory，dbwrwritesthemodifiedblocksbacktodisk.
q.9:theprocessthatrecordsinformationaboutthechangesmadebyall
1.dbwr
2.smon
3.ckpt
4.noneoftheabove
4:lgwrprocessrecordstheinformationaboutchangestodatabase
q.10:oracledoesnotconsideratransactioncommitteduntil
1.thedataiswrittenbacktothediskbydbwr 2.thelgwrsuccessfullywritesthechangestoredo
3.pmonprocesscommitstheprocesschanges
4.smonprocesswritesthedata
q.11:theprocessthatperformsinternaloperationsliketablespace
| 广告合作：400-664-0084 全国热线：400-664-0084 Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号 珠峰网 版权所有 All Rights Reserved 
|
