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