网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Yourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）.
参考答案
更多 “ Yourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）. ” 相关考题
考题
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host
考题
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()
A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
考题
Tomakeauditinformationmoreproductive，theDBAexecutesthefollowingcommandbeforestartinganauditoperation：SQLALTERSYSTEMSETAUDIT_TRAIL=DB，EXTENDEDSCOPE=SPFILE；WhichstatementistrueregardingtheauditrecordgeneratedwhenauditingstartsafterrestartingThedatabase（）A.ItcontainsonlytheplanfortheSQLstatementexecutedbytheuser.B.ItcontainstheSQLtextexecutedbytheuserandthebindvariablesusedwithit.C.ItcontainstheplanandstatisticsassociatedwiththeSQLstatementexecutedbytheuser.D.ItcontainstheplanfortheSQLstatementexecutedbytheuserandthebindvariablesusedwithit
考题
WhichtwostatementsaboutAutomaticStorageManagement(ASM)aretrue?()
A.ASMprovidesmirroringonfilebyfilebasis.B.ASMprovidesautomaticloadbalancingacrossallASMdisks.C.ASMsupportstheOracledatabaseandoperatingsystemfiles.D.ASMcanbeusedtostoretracefiles，alertlogfiles，andtheserverparameterfile（SPFILE）.
考题
ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）A.init.oraB.spfile.oraC.initorcl.oraD.spfile+ASM.ora
考题
YouaremaintainingyourdatabaseinOracle10g.YouareperformingthebackupbyusingtheBACKUPASBACKUPSETcommandattheRMANprompt.WhichfilecannotbebackedupbyusingtheBACKUPASBACKUPSETcommand?()
A.DatafilesB.CurrentcontrolfileC.Serverparameterfile（spfile）D.Passwordfile
考题
WhataretheprerequisitesforenablingFlashbackDatabase?()
A.ThedatabasemustbestartedintheMOUNTEXCLUSIVEstate.B.Thedatabasemusthavemultiplexedcontrolfiles.C.Thedatabasemustbeopenedbyusingatext-basedparameterfileinsteadofaserverparameterfile（SPFILE）.D.ThedatabasemustbeinARCHIVELOGmode.E.ThedatabasemustbeintheNOMOUNTstate.F.ThedatabasemustbeopenedinRESTRICTEDmode.
考题
数据库参数文件的执行优先级由高到低是:()
A. SpfileSID.ora ->initSID.ora ->spfile.ora - init.oraB. InitSID.ora ->spifleSID.ora ->init.ora ->spfile.oraC. SpfileSID.ora->spfile.ora->initSID.ora ->init.ora
热门标签
最新试卷