itgle.com

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from

题目

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time‘ = ‘5h‘;To which disks in the disk group will the new value be applicable?（）

A. all disks in the disk group

B. all disks that are currently in OFFLINE mode

C. all disks that are not currently in OFFLINE mode

D. all disks in the disk group only if all of them are ONLINE

相似考题

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

2.InyourAutomaticStorageManagement（ASM）instance，oneofthenonemptydiskgroups，DGROUP1，isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective：DROPDISKGROUPdgroup1EXCLUDINGCONTENTS；Whatwouldbetheresultofthiscommand？（）A.Thiscommandwouldresultinanerrorbecausethediskgroupisnotempty.B.Thecommandwoulddropthediskgroup，ignoringtheEXCLUDINGCONTENTSoption.C.ThecommandwouldresultinthediskgroupbeingmarkedasINVALIDbecauseitcannotbedropped.D.Thecommandwouldresultinthecontentsbeingmovedtotheparentdiskgroupanddroppingofthediskgroup.E.Thecommandwoulddistributethecontentsofthespecifieddiskgroupamongallotherdiskgroupsandthendropthespecifieddiskgroup.

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

更多“You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three d ”相关问题

  • 第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

  • 第6题：

    Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）

    CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG

    MAXLOGFILES20

    MAXLOGMEMBERS3

    MAXDATAFILES30

    MAXINSTANCES10

    MAXLOGHISTORY1200

    LOGFILE

    GROUP1（

    ’/disk1/prod/orders/db/log1a.dbf’，

    ’/disk2/prod/orders/db/log1b.dbf’

    ）SIZE100K

    GROUP2（

    ’/disk1/prod/orders/db/log2a.dbf’，

    ’/disk2/prod/orders/db/log2b.dbf’

    ）SIZE100K，

    DATAFILE

    ’/disk1/prod/orders/db/database1.dbf’，

    ’/disk2/prod/orders/db/file1.dbf’；


    参考答案：B

相关内容