网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
A
Increase the value of the ASM_POWER_LIMIT parameter.
B
Set the DISK_REPAIR_TIME disk attribute to a lower value.
C
Specify the statement that adds the disk back to the disk group.
D
Increase the number of ASMB processes.
E
Increase the number of DBWR_IO_SLAVES in the ASM instance.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.” 相关考题
考题
Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group? ()
A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks in a failure group for a disk group are rebalancing
考题
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time‘ = ‘5h‘;To which disks in the disk group will the new value be applicable?（）A. all disks in the disk groupB. all disks that are currently in OFFLINE modeC. all disks that are not currently in OFFLINE modeD. all disks in the disk group only if all of them are ONLINE
考题
You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）A. Increase the value of the ASM_POWER_LIMIT parameter.B. Set the DISK_REPAIR_TIME disk attribute to a lower value.C. Specify the statement that adds the disk back to the disk group.D. Increase the number of ASMB processes.E. Increase the number of DBWR_IO_SLAVES in the ASM instance.
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC?（）A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD. Database files stored in ZFS and accessed using conventional NFS mounts.E. Database files stored in ZFS and accessed using the Oracle Direct NFS featureF. Database files stored in any file system and accessed using the Oracle Direct NFS featureG. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
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
考题
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）A、all disks in the disk groupB、all disks that are currently in OFFLINE modeC、all disks that are not currently in OFFLINE modeD、all disks in the disk group only if all of them are ONLINE
考题
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
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 managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours： ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H； Which statement is true in this scenario？（）A、 It starts the ASM fast mirror resync.B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.C、 It drops all disk paths from the dga disk group.D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
考题
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.
考题
Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（） A、 when ASM disk goes offlineB、 when one or more ASM files are droppedC、 when some disks in a disk group are offlineD、 when some disks in a failure group for a disk group are rebalancing
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD、Database files stored in ZFS and accessed using conventional NFS mounts.E、Database files stored in ZFS and accessed using the Oracle Direct NFS featureF、Database files stored in any file system and accessed using the Oracle Direct NFS featureG、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
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
考题
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A、 Because the FRA disk group will not support dynamic rebalancingB、 Because the FRA disk group is not configured to support mirroringC、 Because disks in the FRA disk group are not formatted at this stageD、 Because the FRA disk group will support only a single size of allocation unit
考题
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.
考题
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario？（）A、 The disk is immediately dropped from the disk group.B、 The ASM tracks the extents that are modified during the outaC、 The ASM migrates the extents from the unavailable disk to the remaining disks.D、 The disk automatically goes offline.
考题
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
考题
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
考题
单选题You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A
Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B
Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C
Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D
Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E
Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
考题
单选题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.
考题
单选题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）A
You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B
You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C
You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D
You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
考题
多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost
考题
单选题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 plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
单选题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 ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario？（）AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.
热门标签
最新试卷
