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
第1题
A.committingatransaction
B.rollingbackatransaction
C.recoveringfromfailedtransactions
D.recordingatransactiontoredologfiles
E.rollingforwardduringinstancerecovery
第2题
A. take the Java sources (.java) files and include them in your $APPL_TOP
B. take the Java sources (.java) files and include them in your CLASSPATH
C. take the Java classes (.class) files and include them in your $APPL_TOP
D. take the Java classes (.class) files and include them in your CLASSPATH
第3题
A.Abackupsetthatismissingoneormorebackupsetpieces
B.Abackupthathasexceededtheretentioncriteriaandisnolongerneeded
C.Abackupsetthatdoesnotincludearchivedredologs
D.Abackupsetthatcannotberecoveredduetocorruption
E.Abackupsetsupercededbyadatafilecopy
第4题
YouareworkingasaDatabaseAdministrator.Despitehavingapasswordinthedatadictionaryaschange_on_install,youalwayslogontothedatabaseMYNEWDBusingoperatingsystemauthentication.Yourorganizationisplanningtorecruittwojunior-levelDBAs.YoudecidetoenableremoteauthenticationinyourdatabasesothatthenewDBAscanlogontothedatabasefromtheirworkstationstocarryoutadministrativetasks.
ToallowthenewDBAstoperformtheadministrativetasks,youcreateapasswordfileonthedatabaseserverusingthefollowingcommand:
ORAPWDfile=d:\oracle\ora9i\orapwU01password=adminentries=4
Aftercreatingthepasswordfile,youremovetheoperatingsystemauthenticationandchangethevalueoftheREMOTE_LOGIN_PASSWORDFILEparametertoEXCLUSIVE.YoualsocreateanetservicenameasMYNEWDBthatallowsthenewDBAstoconnecttothedatabaseserverfromtheirworkstationsusingthisnetservicename.Whichcommandmustyouusetoconnecttothedatabasetostartit?()
第5题
A.PerMachine
B.PerDomain
C.PerManagedServer
D.PerAdminServer
第6题
A.Always stop the server prior to the backup
B.Stop the server or lock the tables prior to the backup
C.Stop the server or lock the databases prior to the backup
D.Make a copy of the .frm, .myd, and the .myi files
E.Make a copy of the binary log and tablespace files
第7题
lurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario?()
A.Theinstanceaborts.
B.Thedatabasecannotberecovered.
C.Thedatabasecanberecoveredbyrestoringthecontrolfilesfromthebackup.
D.ThedatabaseremainsopenedandyouhavetoshutitdownwiththeABORToption.
E.Thedatabasecanberestoredtillthepointofthelastclosedwholedatabasebackup.
第8题
nistratorbeforeyoucancompletethefileselectionprocessandstarttherestore.Afteransweringtheadministrator’squestion,yourealizethatyouhaveforgottenwhichfilesyouhadalreadyselectedfortherestore.Howcanyoudeterminewhichfilesarealreadymarkedforextractionandrestore?()
A.Youcanusethelssubcommandofufsrestore.
B.Youcanusetheaddsubcommandofufsrestore.
C.Youcanusetheselectsubcommandofufsrestore.
D.Youcanviewtheselectedfilesastheyaremarkedwithaplussign(+)inthelistthatispermanentlydisplayedintheupperhalfoftheinteractiveufsrestorescreenview.
第9题
A.ToreviewRMANcontrolfileandrecoverycatalogmetadataandensurethatitscorrect
B.TodeleteRMANbackup-relatedmetadatafromtherecoverycatalog
C.Tocreatemetadatainthecontrolfileandtherecoverycatalogrelatedtobackupsetpieces
D.Tocreateareportthatlistsdatabasebackups
E.Torebuildtherecoverycatalog
第10题
A.LOG_BUFFER
B.SORT_AREA_SIZE
C.JAVA_POOL_SIZE
D.STREAMS_POOL_SIZE
E.DB_16K_CACHE_SIZE
F.DB_KEEP_CACHE_SIZE
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!