3 hours
6 months
until last year
until last commit
until the point when the undotablespacewas refreshed
until the database is shut down and the memory erased
第1题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第2题:
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第3题:
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?()
第4题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第5题:
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()
第6题:
perform point-in-time recovery
perform a Flashback Table operation to restore the table to the state it was in two days ago
perform a Flashback Database operation to restore the database to the state it was in two days ago
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
第7题:
You must use automatic undo management in the database.
You must configure OMF in your database.
You must configure ASM for storing the datafiles.
You must multiplex the online redo log file.
第8题:
set SQL_TRACE=True
set UNDO_RETENTION=14400
set FAST_START_MTTR_TARGET=240
set LOG_CHECKPOINT_INTERVAL=240
set DB_FLASHBACK_RETENTION_TARGET=14400
set the RETENTION GUARANTEE clause for the undo tablespace
第9题:
An upper limit on how far you can flash back the database,depending on the information in the redo logs
An upper limit on how far you can flash back the database,depending on the information in the undo tablespace
The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace,provided that there is enough space
第10题:
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.
第11题:
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
第12题:
Set the UNDO_RETENTION parameter to AUTO.
Create an initial undo segment in undotablespace.
Set the UNDO_RETENTION parameter to 900 or more
Set the initialization parameter UNDO_MANAGEMENT to AUTO
Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
第13题:
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()
第14题:
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
第15题:
You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go?()
第16题:
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?()
第17题:
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?()
第18题:
3 hours
6 months
until last year
until last commit
until the point when the undotablespacewas refreshed
until the database is shut down and the memory erased
第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题:
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题:
V$DATABASE
V$UNDOSTAT
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
第22题:
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
第23题:
Set the UNDO_RETENTION parameter to AUTO.
Create an initial undo segment in undotablespace.
Set the UNDO_RETENTION parameter to 900 or more
Set the initialization parameter UNDO_MANAGEMENT to AUTO
Set the UNDO_MANAGEMENT parameter to the name of an undotablespace