单项选择题
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
A.flash back the database
B.perform point-in-time recovery
C.perform a full database recovery
D.drop and re-create the tablespace
E.use Recovery Manager （RMAN） to recover the database
相关考题
-
多项选择题
our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）
A.All control files are opened.
B.All redo log files are opened
C.The password file is opened.
D.The parameter file is opened.
E.All online data files are opened. -
单项选择题
Anyonewhoknowsjustthehostnameandthelistenernamecanhavefullcontroloverthelistener.Theycanstopthelistenerandalsoobtaindetailedinformationaboutthelistener，database，andtheconfigurationoftheapplication.Howwouldyouavoidthisscenario？（）
A.lock the listener
B.hide the listener
C.create multiple listeners
D.run listener on a remote client
E.set a password for the listener
F.store listener.ora in a non-default location -
单项选择题
Youareworkingona24x7（available24hoursperday，7daysperweek）productiondatabase.Anoperatingsystem（OS）userdeletesthealertlogfileaccidentally.Whichstatementinthisscenarioistrue？（）
A.The database crashes.
B.The DBA needs to re-create the file.
C.The file gets re-created automatically.
D.The file gets restored automatically from the last backup.
E.The DBA needs to perform a complete database recovery.
F.The DBA needs to perform an incomplete database recovery.
