You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to

题目

You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are true in this scenario for the features enabled for ASM? （）

A. The ASM-preferred mirror read feature is enabled.

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

相似考题

1.What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)－compliant? ()A. ORACLE_BASE should be set explicitly.B. An Oracle base should have only one Oracle home created in it.C. Flash recovery area and data file location should be on separate disks.D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

2.ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）A.init.oraB.spfile.oraC.initorcl.oraD.spfile+ASM.ora

3.YouareaDatabaseAdministratorwithWonderWeb.You&enYouareaDatabaseAdministratorwithWonderWeb.YouuseapasswordfiletoestablishconnectionstotheSalesdatabaselocatedontheserver.Youcreatedthepasswordfileusingthefollowingcommand：ORAPWDfile=d：\oracle\ora9i\orapwU01password=adminentries=4Youerroneouslydeletedthepasswordfilewhilethedatabasewasrunning.Youre-createthepasswordfileusingthefollowingcommand：ORAPWDfile=d：\oracle\ora9i\orapwU01password=change_on_installentries=4However，whenyoutrytoconnectastheSYSuser，youreceivethefollowingerror：ORA-01031：insufficientprivilegesWhatshouldyoudotoresolvethiserror？（）

4.YoucreatedtheDEPTtablebyusingthefollowingcommand：CREATETABLEscott.dept（deptnoNUMBER（3），dnameVARCHAR2（15），locVARCHAR2（15））STORAGE（INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4）；YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation，youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable？（）

参考答案和解析
参考答案：A, B
更多“You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initial ”相关问题

  • 第1题：

    Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQL>startupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）

    A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.

    B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.

    C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.

    D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.

    E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.


    参考答案：C

  • 第2题：

    ORACLE初始化参数文件的默认路径是:()

    A.对于UNIX，在$ORACLE_HOME/dbs

    B.对于UNIX，在$ORACLE_HOME/dbs/admin

    C.对于Linux，在%ORACLE_HOME%\database

    D.对于Windows，在%ORACLE_HOME%\dbs

    E.对于Windows，在%ORACLE_HOME%\database\admin


    参考答案：A

  • 第3题：

    Deploying the cisco unified computing system platform into the data center provides which two benefits?()

    A.it leverages low-speed interfaces

    B.only one configuration is used for all blades

    C.storage, computing and networking services are combined onto one blade

    D.it is A pra-as-you-go incremental deployment

    E.server replacement is as easy as replacing the physical blade


    参考答案：D, E

  • 第4题：

    Whichofthefollowingisnotaconfigurableattributeforanindividualdiskgroup?()

    A.AU_SIZE

    B.COMPATIBLE·RDBMS

    C.COMPATIBLE·ASM

    D.DISK_REPAIR_TIME

    E.DG_DROP_TIME


    参考答案：E

  • 第5题：

    当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。

    A.DB_FILES

    B.DB_DATAFILES

    C.DATABASE_FILES

    D.LOG_FILES


    参考答案：A

  • 第6题：

    下面哪一个语句创建了值为storage的宏变量location？ （）

    A．&let location = storage;

    B．let &location = storage;

    C．%let location = "storage";

    D．%let location = storage;


    B

相关内容