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.
您可能感兴趣的试卷
你可能感兴趣的试题
View the Exhibit and examine the output.
You execute the following RMAN command to perform the backup operation:
What is the multiplexing level in the preceding backup process()
A. 4
B. 8
C. 7
D. 0
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
A. ALTER DISKGROUP misc MOUNT;
B. ALTER DISKGROUP misc DROP DISK misc2;
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
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. 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. 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 co pleted
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
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:
Which option illustrates the correct sequence that you must use?()
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
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
A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
最新试题
View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()
Which three functions are performed by the SQL Tuning Advisor? ()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
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 command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()
The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
Which three statements are true about persistent configuration?()
Examine the following RMAN script:Which statement describes the purpose of the script?()
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?()