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页