单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this comman

题目
单选题
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
A

All the instances, including the ASM instance, are shut down in the ABORT mode

B

The ASM instance is shut down, but the other instances are still running 

C

The ASM instance is still functional, but the other instances are shut down 

D

All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 

E

HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode 

F

HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

相似考题

1.You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:ASMCMD> lsdsk -I -d DATAWhich statement is true regarding the outcome of this command?（）A. The command succeeds but it retrieves only the disk names.B. The command produces an error because the ASM instance is down.C. The command succeeds but it shows only the status of the ASM instance.D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

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

3.Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

4.You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）A、All the instances, including the ASM instance, are shut down in the ABORT modeB、The ASM instance is shut down, but the other instances are still running C、The ASM instance is still functional, but the other instances are shut down D、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. E、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode F、HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command”相关问题

  • 第1题：

    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）

    • A、The ASM instance is shut down, but the other instances are still running.
    • B、It results in an error because other database instances are connected to it.
    • C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
    • D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

    正确答案:B

  • 第2题：

    When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）

    • A、 TRANSACTIONAL
    • B、 IMMEDIATE
    • C、 ABORT
    • D、 NORMAL

    正确答案:C

  • 第3题：

    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? （）(Choose two.)

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第4题：

    What happens if you shutdown abort ASM instance?（）

    • A、The RDBMSs connected will shutdown abort too
    • B、CLUSTER SERVICE will shutdown
    • C、ASM wil do instance recovery after startup

    正确答案:A

  • 第5题：

    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 mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第6题：

    多选题
    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? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第7题：

    单选题
    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command：   ASMCMD> lsdsk -I -d DATA   Which statement is true regarding the outcome of this command？（）
    A

     The command succeeds but it retrieves only the disk names.

    B

     The command produces an error because the ASM instance is down.

    C

     The command succeeds but it shows only the status of the ASM instance.

    D

     The command succeeds and retrieves information by scanning the disk headers based on an  ASM_DISKSTRING  value.


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

  • 第8题：

    多选题
    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 mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第9题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）
    A

    to enable the ASM instance to identify the alert log file

    B

    to enable the ASM instance to identify the server parameter file

    C

    to enable the ASM instance to define the locations for Oracle Managed Files （OMF）

    D

    to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）
    A

     OPEN

    B

     MOUNT

    C

     NORMAL

    D

     NOMOUNT


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

  • 第12题：

    单选题
    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）
    A

    The ASM instance is shut down, but the other instances are still running.

    B

    It results in an error because other database instances are connected to it.

    C

    All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

    D

    HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.


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

  • 第13题：

    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）  

    • A、 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
    • B、 The drop disk operation is complete and you can run the undrop disks command if needed.
    • C、 The drop disk operation is complete and you cannot run the undrop disk command.
    • D、 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 
    • E、 None of the above is true.

    正确答案:C

  • 第14题：

    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

    • A、to enable the ASM instance to identify the alert log file
    • B、to enable the ASM instance to identify the server parameter file
    • C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
    • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

    正确答案:D

  • 第15题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第16题：

    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）

    • A、The command succeeds but it retrieves only the disk names.
    • B、The command produces an error because the ASM instance is down.
    • C、The command succeeds but it shows only the status of the ASM instance.
    • D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

    正确答案:D

  • 第17题：

    单选题
    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
    A

    All the instances, including the ASM instance, are shut down in the ABORT mode

    B

    The ASM instance is shut down, but the other instances are still running 

    C

    The ASM instance is still functional, but the other instances are shut down 

    D

    All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 

    E

    HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode 

    F

    HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode


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

  • 第18题：

    单选题
    Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）
    A

     If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.

    B

     If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.

    C

     If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.

    D

     If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.


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

  • 第19题：

    多选题
    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 mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the  ASM_DISKGROUPS initialization parameters


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）
    A

     The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

    B

     The drop disk operation is complete and you can run the undrop disks command if needed.

    C

     The drop disk operation is complete and you cannot run the undrop disk command.

    D

     The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 

    E

     None of the above is true.


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

  • 第22题：

    多选题
    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? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第23题：

    单选题
    When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）
    A

     TRANSACTIONAL

    B

     IMMEDIATE

    C

     ABORT

    D

     NORMAL


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

  • 第24题：

    单选题
    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）
    A

    The command succeeds but it retrieves only the disk names.

    B

    The command produces an error because the ASM instance is down.

    C

    The command succeeds but it shows only the status of the ASM instance.

    D

    The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.


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

相关内容