单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP

题目
单选题
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; 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.

相似考题

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.You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、 mount the new disk group in the ASM instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

3. You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.

4.Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)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

更多“单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP c”相关问题

  • 第1题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

    • 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

  • 第2题：

    A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; 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.

    正确答案:C

  • 第3题：

    As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP；  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED  

    • A、 The DGROUP1 disk group was unmounted by another DBA.
    • B、 A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
    • C、 One of the redundant disks （DGROUP1） has been lost in a disk group.
    • D、 This query has no meaning in an ASM instance.
    • E、 A disk associated with a disk group was discovered after the ASM instance initially opened.

    正确答案:A,E

  • 第4题：

    You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）

    • A、 When a file is created in DGROUP1 with the template， it would have three-way mirroring.
    • B、 When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
    • C、 When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
    • D、 When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
    • E、 When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.

    正确答案:C

  • 第5题：

    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

  • 第6题：

    单选题
    Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK '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


    正确答案： B
    解析： 暂无解析

  • 第7题：

    多选题
    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）
    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


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    单选题
    Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; 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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）
    A

    The rebalancing of the disk group would be stopped.

    B

    The rebalancing of the disk group would be completed as fast as possible.

    C

    The command would result in an error because the value of POWER cannot be 0.

    D

    The rebalancing of the disk group would be completed without affecting the disk group DG3.

    E

    The command would result in an error because the disk groups cannot be manually rebalanced.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）
    A

     This command would result in an error because the disk group is not empty.

    B

     The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

    C

     The command would result in the contents being moved to the parent disk group and dropping of the disk group.

    D

     The command would result in the disk group being marked as INVALID because it cannot be dropped.

    E

     The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第14题：

    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

    • A、 This command would result in an error because the disk group is not empty.
    • B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
    • C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
    • D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
    • E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

    正确答案:A

  • 第15题：

    A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）

    • A、Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
    • B、Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
    • C、The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
    • D、ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
    • E、Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

    正确答案:B

  • 第16题：

    Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’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

    正确答案:C

  • 第17题：

    Which statement is true about the Manageability Monitor （MMON） background process（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

    正确答案:A

  • 第18题：

    单选题
    You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

     mount the new disk group in the ASM instance

    B

     restart the ASM instance and the production database instance

    C

     register the new disk groups in the production database instance

    D

     restart the ASM instance without restarting the production database instance

    E

     include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）
    A

    When a file is created in DGROUP1 with the template， it would have three­way mirroring. 

    B

    When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

    C

    When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping.

    D

    When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping.

    E

    When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background process（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）
    A

    Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

    B

    Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

    C

    The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

    D

    ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

    E

    Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）
    A

     RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.

    B

     RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF

    C

     RMAN would relocate all the database files to an ASM disk group.

    D

     RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups，DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）
    A

    This command would result in an error because the disk group is not empty.

    B

    The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

    C

    The command would result in the disk group being marked as INVALID because it cannot be dropped.

    D

    The command would result in the contents being moved to the parent disk group and dropping of the disk group.

    E

    The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）
    A

     When a file is created in DGROUP1 with the template， it would have three-way mirroring.

    B

     When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

    C

     When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.

    D

     When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.

    E

     When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.


    正确答案： E
    解析： 暂无解析

相关内容