The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第1题:
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? ()
第2题:
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
第3题:
In which two cases would you perform only consistent backup?()
第4题:
These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? ()
第5题:
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第6题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第7题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第8题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第9题:
SYSDATE should not be used with TIMESTAMP.
The database must have multiplexed redo log files.
The database must be in the MOUNT state to execute the command.
The database must be opened with the RESETLOGS option after the flashback operation.
The entire database needs to be restored from the most recent backup before the flashback operation.
第10题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第11题:
The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第12题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
第13题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第14题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
第15题:
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
第16题:
Which three statements are true about Flashback Database?()
第17题:
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()
第18题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第19题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第20题:
The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
第21题:
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
第22题:
You have to shut down the database to perform the backups.
Archiving information is written to the data files and redo log files.
You can perform complete database backups without closing the database.
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
第23题:
You are working on a database where downtime is not tolerated.
You are working on a database where downtime can be tolerated.
You are working on a database that operates in ARCHIVELOG mode.
You are working on a database that operates in NOARCHIVELOG mode.
You are working on a database where all the tablespaces are locally managed.
You are working on a database where control files and redo log files are multiplexed.
You are working on a database where control files and redo log files are not multiplexed.
第24题:
Flashback logs are not archived.
Flashback logs are maintained in redo log files.
Flashback logs are maintained in the Flash Recovery Area.
Flashback logs are used to maintain Flashback Database related errors.
Flashback logs need to be cleared manually after you disable Flashback Database.