What are these people complaining about?
A.The noise in the room.
B.The heat inside.
C.The long working hours.
D.The crowded room.
第1题
A.Thedatabaseinstanceaborts.
B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.
C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.
D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
第2题
A.ThedatafileshaveanONLINEstatus.
B.ThedatafileshaveanOFFLINEstatus.
C.ThedatafileshaveanONLINEstatusandareinhotbackupmodepreparedforanonlinebackup.
D.ThedatafileshaveanOFFLINEstatusandareinhotbackupmodeforanonlinebackup.
E.ThedatafilesareinSTANDBYmode.
第3题
A.Theminimummemorysizeforthedatabasebuffercacheissetto100mb.
B.ThemaximummemorysizethatcanbeobtainedbythedatabasebuffercacheduringASMMissetto100mb
C.Theminimummemorysizeallocatedforaserverprocessinthedatabasebuffercacheindedicatedmodeissetto100mb.
D.ThemaximummemorysizefromthedatabasebuffercachethatcanbereleasedfordynamicdistributionduringASMMissetto100mb
第4题
A.Theinstanceaborts.
B.Thedatabasecannotberecovered.
C.Thedatabasecanberecoveredbyrestoringthecontrolfilesfromthebackup.
D.ThedatabaseremainsopenedandyouhavetoshutitdownwiththeABORToption.
E.Thedatabasecanberestoredtillthepointofthelastclosedwholedatabasebackup.
第5题
A.Thetablespacecannotbeduplicatedorrestoredtoanypointintimeaftertheduplication.
B.Thetablespacecannotbeduplicatedorrestoredtothepointintimebeforetheduplication.
C.TheentiredatabasecannotberestoredafteraTSPITR,soabackupisrequired.
D.Youcannotbringthetablespaceonlineuntilitsbeenbackedup.
E.Thereisnorequirementtodoso,asRMANwillbackupthetablespaceaftertheTSPITR.
第6题
A.Thestatementsremainsuspendedforatleast60seconds.
B.Thestatementsaresuspendedfor60secondsandthentheyareexecuted.
C.Thesuspendedstatementserroroutiftheproblemisnotrectifiedwithin60seconds.
D.Thestatementsareautomaticallysuspended60secondsafteranerrorisreceived,andthenattempttoexecutenormallyagain.
第7题
A. The amount of undo retained is user controlled.
B. SecureFile LOBs can be used only for nonpartitioned tables.
C. Fragmentation is minimized by using variable-sized chunks dynamically.
D. SecureFile encryption allows for random reads and writes of the encrypted data.
E. It automatically detects duplicate LOB data and conserves space by storing only one copy.
第8题
A.Thebackupissimilartoimagecopy.
B.Thebackupcontainsalluseddatablocks.
C.Thebackupcontainsonlyunuseddatablocks.
D.Thebackupcontainsalldatablockschangedsincethelastincrementallevel1backup.
第9题
A.Toindicatethelocationoftheauxiliary-instanceonlineredologs.
B.Toindicatethelocationofthetargetdatabasedatafiles.
C.Toindicatethelocationoftheauxiliary-instancecontrolfileandonlineredologs.
D.Toindicatethelocationoftheauxiliary-instancedatabasedatafiles.
E.Thisisnotavalidparameterwhenduplicatingadatabase.
第10题
A. The two statements produce identical results.
B. The second statement returns a syntax error.
C. There is no need to specify DESC because the results are sorted in descending order by default.
D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!