A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database.
您可能感兴趣的试卷
你可能感兴趣的试题
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51)
ORA-01110: data file 5:’/u01/app/oracle/oradata/orcl/example01.dbf’
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file and all the archived logs are accessible.
Which option would you choose?()
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery
A. use the ALTER SYSTEM command to change the time zone
B. use the ALTER SESSION command to change the time zone
C. use the ALTER DATABASE command to change the time zone
D. set the value for the operating system variable ORA_SDTZ on the client machine
E. set the value for the operating system variable ORA_SDTZ on the database server machine
Exhibit,View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting? ()
A. The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.
B. The members of SYS_GROUP would get most of the CPU allocation at level 1.
C. The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.
D. The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.
E. The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).
A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery
A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery.
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.
A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
最新试题
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 decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
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? ()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()
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 lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
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?()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()