ourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）A.ThecommandsucceedsonlyifAutomaticMemoryM

题目

ourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）

A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.

B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.

C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.

D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）

相似考题

1.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

2.Tomakeauditinformationmoreproductive，theDBAexecutesthefollowingcommandbeforestartinganauditoperation：SQL>ALTERSYSTEMSETAUDIT_TRAIL=DB，EXTENDEDSCOPE=SPFILE；WhichstatementistrueregardingtheauditrecordgeneratedwhenauditingstartsafterrestartingThedatabase（）A.ItcontainsonlytheplanfortheSQLstatementexecutedbytheuser.B.ItcontainstheSQLtextexecutedbytheuserandthebindvariablesusedwithit.C.ItcontainstheplanandstatisticsassociatedwiththeSQLstatementexecutedbytheuser.D.ItcontainstheplanfortheSQLstatementexecutedbytheuserandthebindvariablesusedwithit

3.WhichtwostatementsaboutAutomaticStorageManagement(ASM)aretrue?()A.ASMprovidesmirroringonfilebyfilebasis.B.ASMprovidesautomaticloadbalancingacrossallASMdisks.C.ASMsupportstheOracledatabaseandoperatingsystemfiles.D.ASMcanbeusedtostoretracefiles，alertlogfiles，andtheserverparameterfile（SPFILE）.

4.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

更多“ourdatabaseinstanceisstartedusingtheserverparameterfile(SPFILE).Youexecutedacommandtochang ”相关问题

  • 第1题：

    ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）

    A.init.ora

    B.spfile.ora

    C.initorcl.ora

    D.spfile+ASM.ora


    参考答案：B

  • 第2题：

    WhataretheprerequisitesforenablingFlashbackDatabase?()

    A.ThedatabasemustbestartedintheMOUNTEXCLUSIVEstate.

    B.Thedatabasemusthavemultiplexedcontrolfiles.

    C.Thedatabasemustbeopenedbyusingatext-basedparameterfileinsteadofaserverparameterfile（SPFILE）.

    D.ThedatabasemustbeinARCHIVELOGmode.

    E.ThedatabasemustbeintheNOMOUNTstate.

    F.ThedatabasemustbeopenedinRESTRICTEDmode.


    参考答案：A, D

  • 第3题：

    数据库参数文件的执行优先级由高到低是:()

    A. SpfileSID.ora ->initSID.ora ->spfile.ora - init.ora

    B. InitSID.ora ->spifleSID.ora ->init.ora ->spfile.ora

    C. SpfileSID.ora->spfile.ora->initSID.ora ->init.ora


    参考答案C

  • 第4题：

    YouaremaintainingyourdatabaseinOracle10g.YouareperformingthebackupbyusingtheBACKUPASBACKUPSETcommandattheRMANprompt.WhichfilecannotbebackedupbyusingtheBACKUPASBACKUPSETcommand?()

    A.Datafiles

    B.Currentcontrolfile

    C.Serverparameterfile（spfile）

    D.Passwordfile


    参考答案：D

  • 第5题：

    如何转换init.ora到spfile？解答：使用create spfile from pfile 命令。


    正确答案：
             

相关内容