單項(xiàng)選擇題

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

A. flash back the database
B. import the temporary tablespace from the last export
C. restore all the data files and temporary files from the last full database backup and perform a recovery
D. not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

題目列表

你可能感興趣的試題

多項(xiàng)選擇題

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_STATview aretrue？ （）

A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
微信掃碼免費(fèi)搜題