itgle.com

InyourAutomaticStorageManagement（ASM）instance，oneofthenonemptydiskgroups，DGROUP1，isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective：DROPDISKGROUPdgroup1EXCLUDINGCONTENTS；Whatwouldbetheresultofthiscomma

题目

InyourAutomaticStorageManagement（ASM）instance，oneofthenonemptydiskgroups，DGROUP1，isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective：DROPDISKGROUPdgroup1EXCLUDINGCONTENTS；Whatwouldbetheresultofthiscommand？（）

A.Thiscommandwouldresultinanerrorbecausethediskgroupisnotempty.

B.Thecommandwoulddropthediskgroup，ignoringtheEXCLUDINGCONTENTSoption.

C.ThecommandwouldresultinthediskgroupbeingmarkedasINVALIDbecauseitcannotbedropped.

D.Thecommandwouldresultinthecontentsbeingmovedtotheparentdiskgroupanddroppingofthediskgroup.

E.Thecommandwoulddistributethecontentsofthespecifieddiskgroupamongallotherdiskgroupsandthendropthespecifieddiskgroup.

相似考题

1.A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?()A. The transactions that use the disk group will halt.B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

2.The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation?（）A. The databases configured to use the ASM instance are mountedB. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

3.Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

4.You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）A. ASM_POWER_LIMITB. ASM_DISKSTRINGC. ASM_DISKGROUPSD. INSTANCE_TYPE

更多“InyourAutomaticStorageManagement(ASM)instance,oneofthenonemptydiskgroups,DGROUP1,isnolonge ”相关问题

  • 第1题：

    ImmediatelyafteraddinganewdisktoorremovinganexistingdiskfromanAutomaticStorageManagement（ASM）instance，youfindthattheperformanceofthedatabasedecreasesinitially，untiltheadditionorremovalprocessiscompleted.Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks？（）

    A.increasethenumberofcheckpointprocesses

    B.definethePOWERoptionwhileaddingorremovingthedisks

    C.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSES

    D.increasethenumberofslavedatabasewriterprocessesbysettingupahighervaluefor DBWR_IO_SLAVES

    E.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremovalprocess


    参考答案：B, E

  • 第2题：

    WhichofthefollowingoptionsistrueaboutshuttingdownanAutomaticStorageManagement(ASM)instance?()

    A.IftheSHUTDOWNIMMEDIATEcommandisissuedtotheASMinstance，theASMinstanceimmediatelyshutsdown.

    B.IftheSHUTDOWNABORTcommandisissuedtotheASMinstance，theASMinstancewillshutdownallthedatabaseinstancesandthenshutdownimmediately.

    C.IftheSHUTDOWNNORMALcommandisissuedtotheASMinstance，beforeshuttingdown，theASMinstancewaitsforthedependentdatabaseinstancestoshutdown.

    D.IftheSHUTDOWNTRANSACTIONALcommandisissuedtotheASMinstance，theASMinstancepassesthesameSHUTDOWNcommandtothedependentdatabaseinstances，butdoesnotwaitforanyactivetransactionstocompletebeforeitshutsdown.


    参考答案：C

  • 第3题：

    YouexecutethefollowingcommandtostartanAutomaticStorageManagement(ASM)instance:SQL>STARTUP;InwhichofthefollowingmodeswilltheASMinstancestart?()

    A.OPEN

    B.MOUNT

    C.NORMAL

    D.NOMOUNT


    参考答案：B

  • 第4题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)

    A. As ASM instance mounts an ASM control file

    B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

    C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

    D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


    参考答案：C, D

  • 第5题：

    YouhaveasingleAutomaticStorageManagement（ASM）instancerunningonthenodeonwhichyourOracleDatabase10gresides.WhichASMinstanceinitializationparametersmustbeincludedintheASMinstanceinitializationparameterfile？（）

    A.INSTANCE_TYPE

    B.DB_UNIQUE_NAME

    C.ASM_DISKSTRING

    D.ASM_POWER_LIMIT


    参考答案：A

相关内容