You are administering a database stored in Automatic Storage

题目
多选题
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?()
A

Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

B

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

C

Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

D

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

E

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

F

Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

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

第1题:

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

第2题:

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_LIMIT
  • B、ASM_DISKSTRING
  • C、ASM_DISKGROUPS
  • D、INSTANCE_TYPE

正确答案:A

第3题:

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables


参考答案:D

第4题:

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

第5题:

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 Assistant
  • B、Recovery Manager (RMAN)
  • C、Oracle Data Pump Export and Import
  • D、conventional Oracle Export and Import
  • E、operating system utilities to copy the files to the ASM instance

正确答案:B

第6题:

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do?()

  • A、Create a single storage group. Create one database for all users
  • B、Create two storage groups. In each storage group, create one database. Place mailboxes for remote users in one storage group database, and place all other mailboxes in the other storage group database
  • C、Create two storage groups. In each storage group, create one database. Place executive mailboxes in one storage group database, and place all other mailboxes in the other storage group database
  • D、Create two storage groups. In one storage group, create a database, and place all mailboxes for remote users and executives in the database. In the other storage group, create a database for all other mailboxes

正确答案:C

第7题:

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

第8题:

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_LIMIT

B. ASM_DISKSTRING

C. ASM_DISKGROUPS

D. INSTANCE_TYPE


参考答案:A

第9题:

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()

  • A、 Enable Flashback Data Archive for the tables.
  • B、 Specify undo retention guarantee for the database.
  • C、 Enable supplemental logging for the database.
  • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
  • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

正确答案:A

第10题:

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 SESSION
  • B、 ALTER SYSTEM DISCONNECT SESSION
  • C、 ALTER SYSTEM QUIESCE RESTRICTED
  • D、 ALTER SYSTEM ENABLE RESTRICTED SESSION

正确答案:D

更多相关问题