A. The log sequence for the database will restart from 1.
B. The log sequence number will be written to the control file.
C. The log sequence number will be written to the datafile headers.
D. The log sequence number will be written to the initialization parameter file.
您可能感兴趣的试卷
你可能感兴趣的试题
A. The control file will be multiplexed.
B. The control file will be recreated.
C.The script containing the CREATE CONTROLFILE statement will be created.
D. The binary backup of the control file will be created.
A. The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B. You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C. The control file must be recreated.
D. The database must be opened with the RESETLOGS option.
A. by using the Flashback Table feature
B. by using the Flashback Database feature
C. by performing incomplete recovery using RMAN utility
D. by performing incomplete recovery using user-managed recovery
You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement:
SQL>ALTER DATABASE OPEN RESETLOGS;
What will be the resultant log sequence numbers?()
A. 0 and 1
B. 1 and 2
C. 1005 and 1006
D. 1006 and 1007
A. when a table is dropped and stored in the Recycle Bin
B.when a table is dropped and purged from the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when you are required to view all the versions of a row of an existing table between a specific time period
A. all the datafiles in the database
B. the datafiles associated with the SYSTEM tablespace
C. the datafiles associated with the DATA1 tablespace
D. all the datafiles in the database except those associated with the DATA1 tablespace
A. MOUNT mode
B. RESTRICTED mode
C. OPEN mode
D. NOMOUNT mode
A. when all the control files are lost
B. when all the members of a redo log group are lost
C. when a table is dropped and purged from the Recycle Bin
D. when a temporary file of the default temporary tablespace is lost
A. when a tablespace is dropped and you have only RMAN-based backup of the database
B. when a table is dropped and stored in the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when a tablespace is dropped and you have only a user-managed full backup of the database
A. Start the database in the MOUNT stage.
B. Back up the control file to trace.
C. Set the DBID
D. Issue the RECOVER DATABASE command.
最新试题
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
Your database operates in ARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
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?()
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?()
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
In which case would you use the Flashback Database feature to perform a recovery?()