电脑桌面
添加小米粒文库到电脑桌面
安装后可以在桌面快捷访问

2024Oracle DBA数据库结构试题及答案VIP免费

2024Oracle DBA数据库结构试题及答案_第1页
1/22
2024Oracle DBA数据库结构试题及答案_第2页
2/22
2024Oracle DBA数据库结构试题及答案_第3页
3/22
2022OracleDBA数据库结构试题及答案OracleDBA数据库结构精选试题及答案Q.1:PhysicalDiskResourcesinanOracleDatabaseare1.ControlFiles2.RedoLogFiles3.DataFiles4.Alloftheabove4第1页共22页Q.2:WhatisaSchema1.APhysicalOrganizationofObjectsintheDatabase2.ALogicalOrganizationofObjectsintheDatabase3.ASchemeOfIndexing4.Noneoftheabove2Q.3:AnOracleInstanceis1.OracleMemoryStructures2.OracleI/OStructures第2页共22页3.OracleBackgroundProcesses4.AlloftheAbove4Q.4:TheSGAConsistsoftheFollowingItems1.BufferCache2.SharedPool3.RedoLogBuffer4.AlloftheAbove4第3页共22页Q.5:TheareathatstorestheblocksrecentlyusedbySQLstatementsiscalled1.SharedPool2.BufferCache3.PGA4.UGA2Q.6:WhichofthefollowingisnotaBackgroundServerProcessinanOracleServer第4页共22页1.DBWriter2.DBReader3.LogWriter4.SMON2Q.7:WhichofthefollowingisavalidbackgroundserverprocessesinOracle1.ARCHiver2.LGWR(LogWriter)第5页共22页3.DBWR(Dbwriter)4.Alloftheabove4Q.8:Theprocessthatwritesthemodifiedblockstothedatafilesis1.DBWR2.LGWR3.PMON4.SMON第6页共22页1:Oracledoesnotmodifythedataindatafile.OncetheserverprocessmakesachangeintheMemory,DBWRwritesthemodifiedblocksbacktodisk.Q.9:Theprocessthatrecordsinformationaboutthechangesmadebyalltransactionsthatcommitis1.DBWR2.SMON3.CKPT4.Noneoftheabove第7页共22页4:LGWRprocessrecordstheinformationaboutchangestodatabaseQ.10:Oracledoesnotconsideratransactioncommitteduntil1.TheDataiswrittenbacktothediskbyDBWR2.TheLGWRsuccessfullywritesthechangestoredo3.PMONProcesscommitstheprocesschanges4.SMONProcessWritesthedata2第8页共22页Q.11:TheprocessthatperformsinternaloperationslikeTablespaceCoalescingis1.PMON2.SMON3.DBWR4.ARCH2Q.12:Theprocessthatmanagestheconnectivityofusersessionsis第9页共22页1.PMON2.SMON3.SERV4.NET81Q.13:TheARCHprocessisenabledwhenthedatabaserunsina1.PARALLELMode2.ARCHIVELOGMode第10页共22页3.NOARCHIVELOGMode4.Noneoftheabove2Q.14:WhatperformstheCheckPointintheabsenceofaCKPTProcess1.DBWR2.LGWR3.PMON4.SMON第11页共22页2:Atacheckpointdbwrwritesalldatatodatafilesfrommemory.AtthistimethedatafileheadershavetobeupdatedbyLGWRintheabsenceofaCKPTprocessQ.15:Ifanapplicationrequestsdatathatisalreadyinthememory,itisreferredtoasa1.CacheRead2.CacheHit3.CacheMiss4.CacheLatch第12页共22页2Q.16:Ifthedatarequestedisinthememorybuthadtobereloadedduetoaging,itisreferredtoas1.CACHEHIT2.CACHEREFRESH3.CACHERELOAD4.Noneoftheabove3Q.17:Ifthedatarequestedisnotintheservers第13页共22页memory,itisreferredtoas1.CACHEDISK2.CACHEMISS3.CACHEREAD4.Noneoftheabove2Q.18:YoucanDynamicallyresizethefollowingParametersintheSGA1.BufferCache第14页共22页2.LibraryCache3.DictionaryCache4.Noneoftheabove4Q.19:ThememoryareathatstorestheparsedrepresentationofmostrecentlyexecutedStatementsis1.BUFFERCACHE2.LIBRARYCACHE3.DICTIONARYCACHE第15页共22页4.NONEOFTHEABOVE2Q.20:TheMostrecentlyuseddatadictionaryinformationisstoredin1.DATADICTIONARYCACHE2.SHAREDCACHE3.BUFFERCACHE4.NONEOFTHEABOVE1第16页共22页Q.21:Theservermemorythatholdssession-specificinformationisreferredtoas1.ProgramorPrivateGlobalArea2.SessionGlobalArea3.TempSpace4.Noneoftheabove1Q.22:Theareaofmemoryusedbytheserverastemporaryareaforsortingiscalled第17页共22页1.TEMPSPACE2.SORTAREA3.REDOBUFFER4.SORTBUFFER2Q.23:Thefundamentalunitofstorageinadatafileis1.BYTE2.BIT第18页共22页3.BLOCK4.Noneoftheabove3Q.24:Theprocessthatresolvesthein-doubttransactionsinadistributedenvironmentis1.ARCH2.PROC3.RECO4.NONEOFTHEABOVE第19页共22页3Q.25:Thesizeofeachbufferinthedatabaseissetusingthisparameter1.DB_BLOCK_BUFFERS2.DB_BLOCK_SIZE3.DB_BYTE_SIZE4.NONEOFTHEABOVE2Q.26:ThenumberofBlockBuffersinthedatabaseis第20页共22页setintheinit.orausing1.DB_BLOCK_SIZE2.DB_BLOCK_BUFFERS3.DB_BUFFER_CACHE4.NONEOFTHEABOVE2Q.27:TheParameterthatsetsthesizeofthesharedSQLAreais1.SHARED_SQL_AREA第21页共22页2.SHARED_POOL_SIZE3.SHARED_CACHE_SIZE4.NONEOFTHEABOVE2本文来源:网络收集与整理,如有侵权,请联系作者删除,谢谢!第22页共22页

1、当您付费下载文档后,您只拥有了使用权限,并不意味着购买了版权,文档只能用于自身使用,不得用于其他商业用途(如 [转卖]进行直接盈利或[编辑后售卖]进行间接盈利)。
2、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。
3、如文档内容存在违规,或者侵犯商业秘密、侵犯著作权等,请点击“违规举报”。

碎片内容

2024Oracle DBA数据库结构试题及答案

确认删除?
VIP
微信客服
  • 扫码咨询
会员Q群
  • 会员专属群点击这里加入QQ群
客服邮箱
回到顶部