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

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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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

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

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

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

考题 You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have been specified: DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()A、When a new log group is added, it would have one member in each disk group.B、When a new log group is added, it would have two members in each disk group.C、When a new tablespace is added, it would have one data file in each disk group.D、When a new log file is added, it would have one member spread across the disk groups.

考题 You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective?()  A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

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

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

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

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

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

考题 You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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 database files to an ASM disk group.B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C、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).D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location, defined using OMF

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

考题 单选题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 have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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 database files to an ASM disk group.B RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C 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).D RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location, defined using OMF

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

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

考题 单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2with one device each. In the parameter file of the production database, the following parameters have been specified:  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()A  When a new log group is added, it would have one member in each disk group.B  When a new log group is added, it would have two members in each disk group.C  When a new tablespace is added, it would have one data file in each disk group.D  When a new log file is added, it would have one member spread across the disk groups.

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

考题 单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each.  In the parameter file of the production database, the following parameters have been specified:  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting?()A When a new log group is added, it would have one member in each disk group.B When a new log group is added, it would have two members in each disk group.C When a new tablespace is added, it would have one data file in each disk group.D When a new log file is added, it would have one member spread across the disk groups.

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

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

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

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

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