A.正断层
B.逆断层
C.顺断层
D.反断层
第1题
ALGWRInput/output(I/O)fellsduetopermanentmediafailurethathasresultedInthelossofredologfileandtheLWGRterminatescausingtheinstancetocrash.Thestepstorecoverfromthelossofacurrentredologgroupmemberintherandomorderareasfollow.
1)Restorethecorruptedredologgroup.
2)Restorefromawholedatabasebackup.
3)Performincompleterecovery.
4)Relocatebyrenamingthememberofthedamagedonlineredologgrouptoanewlocation.
5)OpenthedatabasewiththeRESETLOGSoption.
6)Restartthedatabaseinstance.
7)Issueacheckpointandclearthelog.
Identifytheoptionwiththecorrectsequentialstepstoaccomplishthetaskefficiently().
第2题
A. Only a single partitioning key column can be specified.
B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition.
D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.
第3题
A.ThetableusesthedefaultFlashbackDataArchive.
B.TheFlashbackDataArchiveIscreatedIntheSYSAUXtablespace.
C.TheFlashbackDataArchiveiscreatedinthesametablespacewherethetablesarestored.
D.ThecommandgeneratesanerrorbecausenoflashbackDataArchivenameisspecifiedandthereis nodefaultFlashbackDataAchieve.
第4题
A.increasethesizeoftheredologbuffer
B.increasethenumberofredologgroups
C.increasethenumberoflogwriterprocesses
D.increasethenumberofARCnprocesses
E.changetheappropriateLOG_ARCHIVE_DEST_nparametertoplacethearchivedlogfilesinaseparatelocation
第5题
A.Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.
B.Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.
C.Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.
D.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.
第6题
A. It enables all system triggers.
B. It allows only SYSDBA connections.
C. It ensures that all job queues remain active during the upgrade process.
D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
第7题
A.ANALYZEoperations
B.dbv
C.SQLqueriesthataccessthepotentiallycorruptblock
D.RMAN
E.Alloftheabove
第8题
A.increasethesizeofredologfiles
B.increasethesizeoftheundotablespace
C.increasethesizeoftheDatabaseBufferCache
D.increasethesizeofthedefaulttemporarytablespace
E.enabletheretentionguaranteefortheundotablespace
第9题
A.ReducedMTTR.
B.Datafilesremainofflinewhilecorruptblocksarerepaired.
C.Datafilesremainonlinewhilecorruptblocksarerepaired.
D.AandC
第10题
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLAccessAdvisor
D.AutomaticWorkloadRepository(AWR)
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!