A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period
您可能感兴趣的试卷
你可能感兴趣的试题
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.
You issue the following RMAN command to set a retention policy on a database：
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；
What will be the outcome of issuing this command？（）
A. After two days，a backup will be marked obsolete
B. After two days，a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?（）
A. It cancels all pending disk drops within the disk group
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been completed
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
A. stored scripts in the recovery catalog
B. backups that can be deleted from disk
C. backup sets and image copies are obsolete
D. backups that do not have the AVAILABLE status in the RMAN repository
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
最新试题
You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file.2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）
Examine the CREATE DISKGROUP command used to create a disk group： SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2； In which situation would you use this method of disk group creation？（）
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）
Examine the following RMAN command： RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）
Which option is best practice for creating a recovery catalog owner in the catalog database？（）
To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）
Which two client requests are captured during database replay Capture？（）