OracleDBA数据库结构题选1.docx
- 文档编号:26083210
- 上传时间:2023-06-17
- 格式:DOCX
- 页数:9
- 大小:15.78KB
OracleDBA数据库结构题选1.docx
《OracleDBA数据库结构题选1.docx》由会员分享,可在线阅读,更多相关《OracleDBA数据库结构题选1.docx(9页珍藏版)》请在冰豆网上搜索。
OracleDBA数据库结构题选1
OracleDBA数据库结构题选1
OracleDBA数据库结构题选1OracleDBA数据库结构题选1q.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:
theareathatstorestheblocksrecentlyusedbysqlstatementsiscalled
1.sharedpool
2.buffercache
3.pga
4.uga
2
q.6:
whichofthefollowingisnotabackgroundserverprocessinanoracleserver
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.oncetheserverprocessmakesachangeinthememory,dbwrwritesthemodifiedblocksbacktodisk.
q.9:
theprocessthatrecordsinformationaboutthechangesmadebyalltransactionsthatcommitis
1.dbwr
2.smon
3.ckpt
4.noneoftheabove
4:
lgwrprocessrecordstheinformationaboutchangestodatabase
q.10:
oracledoesnotconsideratransactioncommitteduntil
1.thedataiswrittenbacktothediskbydbwr
2.thelgwrsuccessfullywritesthechangestoredo
3.pmonprocesscommitstheprocesschanges
4.smonprocesswritesthedata
2
q.11:
theprocessthatperformsinternaloperationsliketablespacecoalescingis
1.pmon
2.smon
3.dbwr
4.arch
2
q.12:
theprocessthatmanagestheconnectivityofusersessionsis
1.pmon
2.smon
3.serv
4.net8
1
q.13:
thearchprocessisenabledwhenthedatabaserunsina
1.parallelmode
2.archivelogmode
3.noarchivelogmode
4.noneoftheabove
2
q.14:
whatperformsthecheckpointintheabsenceofackptprocess
1.dbwr
2.lgwr
3.pmon
4.smon
2:
atacheckpointdbwrwritesalldatatodatafilesfrommemory.atthistimethedatafileheadershavetobeupdatedbylgwrintheabsenceofackptprocess
q.15:
ifanapplicationrequestsdatathatisalreadyinthememory,itisreferredtoasa
1.cacheread
2.cachehit
3.cachemiss
4.cachelatch
2
q.16:
ifthedatarequestedisinthememorybuthadtobereloadedduetoaging,itisreferredtoas
1.cachehit
2.cacherefresh
3.cachereload
4.noneoftheabove
3
q.17:
ifthedatarequestedisnotintheserversmemory,itisreferredtoas
1.cachedisk
2.cachemiss
3.cacheread
4.noneoftheabove
2
q.18:
youcandynamicallyresizethefollowingparametersinthesga
1.buffercache
2.librarycache
3.dictionarycache
4.noneoftheabove
4
q.19:
thememoryareathatstorestheparsedrepresentationofmostrecentlyexecutedstatementsis
1.buffercache
2.librarycache
3.dictionarycache
4.noneoftheabove
2
q.20:
themostrecentlyuseddatadictionaryinformationisstoredin
1.datadictionarycache
2.sharedcache
3.buffercache
4.noneoftheabove
1
q.21:
theservermemorythatholdssession-specificinformationisreferredtoas
1.programorprivateglobalarea
2.sessionglobalarea
3.tempspace
4.noneoftheabove
1
q.22:
theareaofmemoryusedbytheserverastemporaryareaforsortingiscalled
1.tempspace
2.sortarea
3.redobuffer
4.sortbuffer
2
q.23:
thefundamentalunitofstorageinadatafileis
1.byte
2.bit
3.block
4.noneoftheabove
3
q.24:
theprocessthatresolvesthein-doubttransactionsinadistributedenvironmentis
1.arch
2.proc
3.reco
4.noneoftheabove
3
q.25:
thesizeofeachbufferinthedatabaseissetusingthisparameter
1.db_block_buffers
2.db_block_size
3.db_byte_size
4.noneoftheabove
2
q.26:
thenumberofblockbuffersinthedatabaseissetintheinit.orausing
1.db_block_size
2.db_block_buffers
3.db_buffer_cache
4.noneoftheabove
2
q.27:
theparameterthatsetsthesizeofthesharedsqlareais
1.shared_sql_area
2.shared_pool_size
3.shared_cache_size
4.noneoftheabove
2
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:
theareathatstorestheblocksrecentlyusedbysqlstatementsiscalled
1.sharedpool
2.buffercache
3.pga
4.uga
2
q.6:
whichofthefollowingisnotabackgroundserverprocessinanoracleserver
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.smonOracleDBA数据库结构题选1相关内容:
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OracleDBA 数据库 结构
![提示](https://static.bdocx.com/images/bang_tan.gif)