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.
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN).
To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true about the execution of the above command? ()(Choose two.)
A. The backup piece size will be limited to 300 MB
B. The RMAN uses multiplexing to perform backup
C. The operation is accomplished using the default channel available
D. The RMAN parallelizes the backup although the parallelism is not set for a channel
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. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
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. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
You issue the following RMAN command to set a retention policy on a database:
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
What will be the outcome of issuing this command?()
A. After two days,a backup will be marked obsolete
B. After two days,a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file,then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
最新试题
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?()
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?()
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
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 statements are true about a job chain?()
Which three tasks can be performed using a duplicate database?()
Which three functions are performed by the SQL Tuning Advisor?()
Which three statements are true about persistent configuration?()
Which option is best practice for creating a recovery catalog owner in the catalog database?()