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.
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.
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.
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.
Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
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
第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?()
第3题:
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
第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?()
第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?()
第6题:
You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do?()
第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?()
第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
第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?()
第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?()