A.There is no impact on performance
B.The overhead depends on the settings of the Performance Schema
C.There is an overhead for querying the Performance Schema but not for having it enabled
D.There is a constant overhead regardless of settings and workload
第1题
havebeendeleted.Theonlybackupofthisfilesystemisamonth-oldtararchive.Thisarchivewillneedtoberestoredasroot.Whichtwostatementscorrectlydescribetheeffectsoftherestoreoperation?()
A.FilesfoundinthefilesystemthatarealsoontapewillNOTbeoverwritten.
B.Themissingfiles,presentonthebackuptape,arerestoredtothefilesystemwiththedataasitwaswhenthebackupwastaken.
C.Theaccesstimesarepreservedbytarandwillreflectthetimewhenauserlastaccessedthedata.
D.Themodificationtimeonthefilesrestoredbytarwillbepreservedandwillreflectthetimethefilewaslastmodifiedbeforethebackup,NOTthetimeoftherestoreoperation.
第2题
gethevalueoftheLOG_BUFFERinitializationparameter:ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH;Whatwouldbetheoutcomeofthiscommand()
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds,butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea(SGA).
第3题
A.whenrecoveringalostread-onlytablespacefromaread-onlytablespacebackup
B.whenrecoveringalostread-onlytablespacefromaread-writetablespacebackupwhenthedatabaseisrunninginARCHIVELOGmode
C.whenrecoveringalostread-onlytablespacefromaread-writetablespacebackupwhenthedatabaseisrunninginNOARCHIVELOGmodeandthechangesintheonlineredologfileshavebeenoverwritten
D.whenrecoveringalostread-onlytablespacefromaread-onlytablespacebackupusingthebackupofthecontrolfile,thecontrolfilewascreatedusingtheALTERDATABASEBACKUPCONTROLFILETOTRACEstatement,andthisstatementwasissuedwhenthetablespacewasread-only
第4题
A.GlassFish
B.iAS
C.WebLogicServer11g
D.JBoss
第5题
A. Result Type is optional.
B. Result Type is mandatory.
C. Result Type can be changed after it is assigned to the function activity.
D. Result Type should belong to the same item type as the function activity
第6题
A.Recoverdatabasedatafilesfromphysicaldiskbackupsets.
B.Recoverrequiredincrementalbackupsfromphysicaldiskbackupsets.
C.Recoverrequiredarchivedredologsfromphysicaldiskbackupsets.
D.Applyincrementalbackupstorecoverthedatabase.
E.Applyarchivedredologstorecoverthedatabase.
第7题
YourdatabaseisrunninginNOARCHIVELOGmodewithtwoonlineredologfiles.TheSALEStablecontainssalesinformationfortheorganization.TheSALEStablebelongstotheSALESTBtablespace.OnMonday,youinsert10rowsintotheSALEStable.Thecurrentlogsequencenumberis14.YouchangethetablespacestatusfromREADWRITEtoREADONLYfortheSALESTBtablespace.YoushutdownthedatabaseandtakeabackupoftheSALESTBtablespace.
OnTuesday,youstartthedatabase.YouchangethestatusfortheSALESTBtablespacefromREADONLYtoREADWRITE.Youinsert10morerowsintotheSALEStableandshutdownthedatabase.Thecurrentlogsequencenumberis15.
WhenyoutrytoopenthedatabaseonWednesdaymorning,youdiscoverthattheSALESTBtablespacewaslostbecauseofamediafailure.WhichofthefollowingoptionsistrueaboutrecoveringtheSALEStable?()
第8题
A./etc/backup
B./etc/ufsdump
C./etc/dumpdates
D./etc/fsdumpdates
第9题
A. Updating
B. Viewing
C. Deleting
D. Inserting
E. Truncating
第10题
A.It requires the RELOAD, FILE, and DROP privileges
B.It closes and reopens all log files
C.It closes and sends binary log files to slave servers
D.It flushes dirty pages in the buffer pool to the REDO logs
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!