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
You opened the encryption wallet and then issued the following command：
SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M
ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；
Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome？（）
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
A. The incident metadata is purged when the problem is resolved and the DBA closes the SR
B. The incident files and dumps are not retained in the ADR for the manually created incidents
C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?（）
A./u01/app/oracle/product/11.1.0/db_1
B./u01/app/oracle
C.$ORACLE_HOME/bdump
D.$ORACLE_HOME/log
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:
ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database, the database will not be opened.
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command：
SQL> ALTER TABLESPACE hi_data BEGIN BACKUP；
Which two statements are true in this scenario？（）
A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
最新试题
Which three tasks can be performed using a duplicate database？（）
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）
Examine the following RMAN script： RMAN> run { debug on； allocate channel c1 type disk； backup datafile 5； } Which statement describes the purpose of the script？（）
To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）
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？（）
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
Which command creates an image copy？（）
Tape streaming is not happening while performing RMAN tape backup. On investigation， you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup？（）
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？（）
Which two statements are true about a job chain？（）