Uses undo data for roll forward
Uses Flashback Log for recovery
Uses online redo logs to roll back
Uses undo data to roll back the transaction
Uses Recovery Manager (RMAN) to roll back
Uses the System Monitor (SMON) background process to perform instance recovery
第1题:
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()
第2题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
第3题:
Which three statements are true about Flashback Database?()
第4题:
You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第5题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()
第6题:
Flashback logs are written sequentially, and are archived.
Flashback Database uses a restored control file to recover a database.
The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
Flashback Database can recover a database to the state that it was in before a reset logs operation.
Flashback Database can recover a data file that was dropped during the span of time of the flashback.
Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
第7题:
Use a flashback query to retrieve the rows that were deleted
Useconventialincremental export and then import the affected object
Shutdown the database inNORMALmode and restart the database instance
Use DBMS_META package to reconstruct the object using undo segments
UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
第8题:
uses undo data for roll forward
uses Flashback Log for recovery
uses online redo logs to roll back
uses undo data to roll back the transaction
uses Recovery Manager (RMAN) to roll back
uses the System Monitor (SMON) background process to perform instance recovery
第9题:
Restore all the data files and open the database
Create the data file and perform tablespace recovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第10题:
V$DATABASE
V$UNDOSTAT
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
第11题:
Oracle Flashback uses undo information to construct consistent data.
You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.
You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.
Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
第12题:
Uses undo data for roll forward
Uses Flashback Log for recovery
Uses online redo logs to roll back
Uses undo data to roll back the transaction
Uses Recovery Manager (RMAN) to roll back
Uses the System Monitor (SMON) background process to perform instance recovery
第13题:
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第14题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第15题:
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第16题:
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第17题:
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?()
第18题:
use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
restore the entire database from the most recent backup and open it
recover the table by using the Flashback Table feature
perform point-in-time recovery to recover the table
第19题:
Use a flashback query to retrieve the rows that were deleted
Useconventialincremental export and then import the affected object
Shutdown the database inNORMALmode and restart the database instance
Use DBMS_META package to reconstruct the object using undo segments
UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
第20题:
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undo tablespace
第21题:
Restore all the data files and open the database
Create the data file and performtablespacerecovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第22题:
to recover a dropped tablespace
to recover data from a truncated table
to recover a data file that has been shrunk
to recover a database to the state that existed before the RESETLOGS operation
第23题:
Check the alert log file
Query the V$FLASHBACK_DATABASE_LOG view
Query the V$RECOVERY_FILE_DEST_SIZE view
Query the V$FLASHBACK_DATABASE_STAT view
Check the value assigned for the UNDO_RETENTION parameter