网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 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
考题
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A、It would result in an error because the template cannot be used along with the disk group.B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
考题
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
考题
You are maintaining the SALES database on Oracle 10g. 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 will you specify to control the speed of the rebalancing activity？ （） A、 ASM_POWER_LIMITB、 ASM_DISKSTRINGC、 ASM_DISKGROUPSD、 LARGE_POOL_SIZE
考题
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.
考题
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement 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
考题
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 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 an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do？（） A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
考题
You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（） A、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database 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 nonASM files to an operating system location， defined using OMF
考题
单选题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 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
考题
单选题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 are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）A
ASMBB
ARBnC
RBAL in the ASM instanceD
RBAL in the database instance
考题
多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.
热门标签
最新试卷
