网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?() A. ASMBB. PMONC. RBALD.SMON

考题 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

考题 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

考题 Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON

考题 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 fileB、to enable the ASM instance to identify the server parameter fileC、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

考题 n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、 Oracle Migration AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

考题 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

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

考题 Which statement is true about the Manageability Monitor (MMON) background proces()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 databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

考题 In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?() A、 ALTER SYSTEM KILL SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION

考题 You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

考题 You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT

考题 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

考题 Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON

考题 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

考题 单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A  Oracle Migration AssistantB  Recovery Manager (RMAN)C  Oracle Data Pump Export and ImportD  conventional Oracle Export and ImportE  operating system utilities to copy the files to the ASM instance

考题 单选题You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A  OPENB  MOUNTC  NORMALD  NOMOUNT

考题 单选题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

考题 单选题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

考题 单选题Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A  ASMBB  PMONC  RBALD  SMON

考题 单选题In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()A Oracle Migration AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

考题 单选题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 fileB to enable the ASM instance to identify the server parameter fileC 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

考题 单选题Which statement is true about the Manageability Monitor (MMON) background proces()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 databaseinstance.D It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

考题 多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance?()AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

考题 单选题You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A  INSTANCE_TYPEB  DB_UNIQUE_NAMEC  ASM_DISKSTRINGD  ASM_POWER_LIMIT

考题 单选题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

考题 单选题Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()A  ALTER SYSTEM KILL SESSIONB  ALTER SYSTEM DISCONNECT SESSIONC  ALTER SYSTEM QUIESCE RESTRICTEDD  ALTER SYSTEM ENABLE RESTRICTED SESSION