多项选择题Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)

A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题What privileges must be granted to allow an account to create the recovery catalog?()

A. RECOVERY_CATALOG_OWNER
B. DBA
C. RESOURCE
D. SELECT ANY DICTIONARY
E. CONNECT

2.单项选择题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?()

A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channel
D. intrafile parallel backup

3.单项选择题Which statement is true regarding virtual private catalogs?()

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B. The virtual private catalog owner cannot create and modify the stored scripts.
C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

4.多项选择题What is the purpose of the RMAN recovery catalog?() 

A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.
B. It provides a convenient, optional, repository of backup- and recovery-related metadata.
C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
D. It provides a means of storing all RMAN backup sets physically in an Oracle database server. 
E. It provides the ability to store backup records for more than a year.

5.多项选择题In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)

A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations

6.单项选择题

You issue the following command:  
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;  
What is the result of this command on your backups?()

A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E. RMAN will automatically compress backups.

8.单项选择题Which command is used to configure RMAN to perform a compressed backup for every backup executed?()

A. BACKUP AS COMPRESSED BACKUPSET DATABASE
B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS 
E. BACKUP DATABASE COMPRESS


9.单项选择题Which statement about Automatic Memory Management with Oracle 11g is true?()

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size

10.多项选择题For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)

A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources

最新试题

Which three functions are performed by the SQL Tuning Advisor?() 

题型:多项选择题

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?()

题型:多项选择题

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()

题型:多项选择题

Examine the following ALTER command:  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;  What is the purpose of the command?()  

题型:单项选择题

Which option is best practice for creating a recovery catalog owner in the catalog database?()  

题型:单项选择题

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?()

题型:单项选择题

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?()

题型:单项选择题

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?() 

题型:多项选择题

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()  

题型:单项选择题