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

题目
多选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


参考答案:A, D

第2题:

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

正确答案:A

第3题:

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 offline

B. when one or more ASM files are dropped

C. when some disks in a disk group are offline

D. when some disks in a failure group for a disk group are rebalancing


参考答案:C

第4题:

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.

正确答案:D

第5题:

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.

正确答案:D

第6题:

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 array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays


参考答案:A, E, G

第7题:

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 group
  • B、all disks that are currently in OFFLINE mode
  • C、all disks that are not currently in OFFLINE mode
  • D、all disks in the disk group only if all of them are ONLINE

正确答案:C

第8题:

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 group

B. all disks that are currently in OFFLINE mode

C. all disks that are not currently in OFFLINE mode

D. all disks in the disk group only if all of them are ONLINE


参考答案:C

第9题:

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

正确答案:A

第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

更多相关问题