网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
Which of these are valid Flashback Database recovery point parameters?()
A
SCN
B
Timestamp
C
Named recovery point
D
Transaction ID
E
Session ID
参考答案
参考解析
解析:
暂无解析
更多 “多选题Which of these are valid Flashback Database recovery point parameters?()ASCNBTimestampCNamed recovery pointDTransaction IDESession ID” 相关考题
考题
Which three actions are required to configure the Flashback Database? ()
A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()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.
考题
Flashback Database relies on which technologies to recover to a point in time?() A、 Flashback Data ArchiveB、 Flashback logs in the flash recovery areaC、 FlashbUndo tablespaceD、 RMAN command lineE、 None of the above
考题
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database?()A、 DB_RECOVERY_FILE_DEST onlyB、 DB_FLASHBACK_RETENTION_TARGET onlyC、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST onlyD、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET onlyE、 DB_RECOVERY_FILE_DEST_SIZE, DB_RECOVERY_FILE_DEST andF、 DB_FLASHBACK_RETENTION_TARGET
考题
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
考题
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
考题
You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()A、 perform point-in-time recoveryB、 perform a Flashback Table operation to restore the table to the state it was in two days agoC、 perform a Flashback Database operation to restore the database to the state it was in two days agoD、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
考题
Which three actions are required to configure the Flashback Database?() A、 set Flash Recovery AreaB、 enable Flashback loggingC、 create FLASHBACK tablespaceD、 start the database in the ARCHIVELOG modeE、 start the database in the NOARCHIVELOG mode
考题
Which of these are valid Flashback Database recovery point parameters?() A、 SCNB、 TimestampC、 Named recovery pointD、 Transaction IDE、 Session ID
考题
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题Flashback Database relies on which technologies to recover to a point in time?()A
Flashback Data ArchiveB
Flashback logs in the flash recovery areaC
FlashbUndo tablespaceD
RMAN command lineE
None of the above
考题
多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode
考题
多选题Which of these are valid Flashback Database recovery point parameters?()ASCNBTimestampCNamed recovery pointDTransaction IDESession ID
考题
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
考题
单选题You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database?()A
DB_RECOVERY_FILE_DEST onlyB
DB_FLASHBACK_RETENTION_TARGET onlyC
DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST onlyD
DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET onlyE
DB_RECOVERY_FILE_DEST_SIZE, DB_RECOVERY_FILE_DEST andF
DB_FLASHBACK_RETENTION_TARGET
考题
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
单选题You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()A
perform point-in-time recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
考题
单选题You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()A
perform point-in-time recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
考题
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?()A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
考题
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A
point-in-time recoveryB
execute the ROLLBACK command with transaction numberC
flashback the database to before the transaction was committedD
determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature? ()AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
考题
单选题To perform a database point-in-time recovery using RMAN, after database restoration, you must ensure that the database is in which of the following states?()A
OPENB
MOUNTC
NOMOUNTD
CLOSE
考题
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
热门标签
最新试卷