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

第页2023OracleDBA数据库结构试题及答案OracleDBA数据库结构精选试题及答案

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.OracleMemoryStructuresQ.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