A. redo log files
B. password file
C. control file
D. change tracking file
您可能感兴趣的试卷
你可能感兴趣的试题
A. LIST command
B. CROSSCHECK command
C. REPORT command
D. SHOW command
A. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
B. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
C. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
A.Datafiles
B. Current control file
C. Server parameter file (spfile)
D. Password file
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.
RMAN> COPY DATAFILE 2 TO ’D:\ORACLE\ORA90\MYNEWDB\DA2.DBF’;
Which two statements are true regarding the backup created using this command?()
A. The copy of the datafile created is stored in the RMAN repository.
B. The copy of the datafile created can be viewed using the LIST BACKUP command.
C. The copy of the datafile created using this COPY command can be placed only on the disk.
D. The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
E. The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
A. the system change number
B. the locations of the redo log files
C. the locations of the datafiles
D. the physical location of all the database changes
In which scenario, will you issue the following command?()
RMAN> REPORT NEED BACKUP DAYS 7;
A. to configure RMAN to maintain backup information in the RMAN repository for seven days
B. to configure RMAN to maintain backup information in the control file for at least seven days
C. to display the list of files that have not been backed up for the last seven days
D. to display the list of files that must be backed up within seven days
A. The block change tracking feature is enabled, and the information about the system change number is written in the change tracking file.
B. The block change tracking feature is enabled, and the information about the log sequence number is written in the change tracking file.
C. The block change tracking feature is enabled, and the information about the blocks that are changed since the last backup is written in the change tracking file.
D. The block change tracking feature is enabled, and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace:
RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M;
Which statement is true about executing this command?()
A. The command generates an error.
B. The command backs up the tablespace and creates a backup set of size 200 MB
C. The command backs up the tablespace and creates two backup sets of size 100 MB each.
D. The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
RMAN> BACKUP DATABASE;
Which files from the database will be backed up as a result of this BACKUP command?()
A. control file
B. all datafiles
C. password file
D. online redo log file
E. archive redo log file
F. server parameter file
G. only the SYSTEM datafile
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.
Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()
A. 0
B. 1
C. NONE
D. DEFAULT
最新试题
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()
The loss of the control file forced you to recreate the control file. After recreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a fivedigit number starting with 0. What could be the possible reason?()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()