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?（）
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
您可能感兴趣的试卷
你可能感兴趣的试题
A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQLs for tuning
You issued the following command：
CREATE GLOBAL TEMPORARY TABLE admin_work_area
（startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command？（）
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table.
Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
A. Restore the backup control file and open the database with RESETLOGS option.
B. Perform point-in-time recovery because flashback cannot be performed again on this table
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.
Which two statements are true about this backup operation? （）(Choose two.)
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.
The following steps must be performed in the correct sequence to do this:
Choose the correct sequence.（）
A.4，1，3，2，5
B.4，3，1，2，5
C.2，4，3，5，1
D.4，2，5，3，1
The following command is executed to create the baseline template：
SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），
END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，
TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）；
Which statement is true about the effect of the above command？（）
A. It creates a baseline template that never expires.
B. It produces an error because no snapshot information is provided to create the baseline.
C. It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
D. It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
最新试题
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？（）
In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）
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？（）
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）
Which two client requests are captured during database replay Capture？（）
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？（）
Which three tasks can be performed using a duplicate database？（）
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？（）