Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?（）A. When two-way disk

题目

Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?（）

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

相似考题

1.能使数据库记录只显示当前记录且能暂停的命令是()。A、GOTOB、DISPC、USED、CREATE

2.数据库记录的显示命令是指()、DISP。A、GOTOB、LISTC、USED、CREATE

3.能使数据库记录满屏显示而不暂停的命令是()。A、GOTOB、LISTC、USED、CREATE

4.数据库记录的显示命令有LIST和()。A、GOTOB、DISPC、USED、CREATE

更多“Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP ”相关问题

  • 第1题：

    Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQL>BEGINDBMS_SCHEDULER.CREATE_JOB_CLASS（JOB_CLASS_NAME=>’LOW_PRIORITY_CLASS’，RESOURCE_CONSUMER_GROUP=>’LOW_GROUP’，LOGGING_LEVEL=>DBMS_SCHEDULER.LOGGING_FULL，LOG_HISTORY=>1200，COMMENTS=>’LOWJOBPRIORITYCLASS’）；END；SQL>/Whatwillbetheresultoftheabovecommand？（）

    A.Thecommandwillbeexecutedsuccessfully.

    B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.


    参考答案：E

  • 第2题：

    YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）

    A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；

    B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；

    C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；

    D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；


    参考答案：B

  • 第3题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）

    A．CREATE，DROP，UPDATE

    B．CREATE，DROP，ALTER

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

  • 第4题：

    Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEPARTMENTS’，

    CPU_P1=0）；

    END；

    Then，youissuethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEVELOPERS’，

    CPU_P2=100）；

    END；

    Whatwillbetheimpactofexecutingtheabovecode？（）


    参考答案：B

  • 第5题：

    Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt－inscanyouuse?()

    A.CREATE_GROUP

    B.ADD_GROUP_NOW

    C.POPULATE_GROUP

    D.ADD_GROUP_COLUMN

    E.CREATE_GROUP_FROM_QUERY


    参考答案：A, B, D

  • 第6题：

    下列哪组SQL命令全部属于数据定义语句的命令？（）

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，SELECT

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，UPDATE


    CREATE，DROP，ALTER

相关内容