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.
您可能感兴趣的试卷
你可能感兴趣的试题
A. RECOVERY_CATALOG_OWNER
B. DBA
C. RESOURCE
D. SELECT ANY DICTIONARY
E. CONNECT
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
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
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.
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
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.
A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor
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
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
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?()