单项选择题
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
A.Start the instance and open the database, instance recovery automatically recoverscontrol files
B.Create a file based on the contents of the trace file and save it to the control file locations and start the database
C.Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
D.Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E.Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
相关考题
-
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Clientconnectionrequestsarefailingbecausethelistenerisnotresponding.Youwanttoforwardclientconnectrequeststoanotherlistenerifonelistenerisnotresponding.Howdoyouachievethis?()
A.Enable instance failover
B.Configure shared server
C.Enable database failover
D.Enable connect-time failover
E.Enable Transparent Application Failover (TAF) -
多项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisintheMOUNTstateandyouexecutethefollowingcommandtoopenitALTERDATABASEOPEN;Whattwoactionsareperformedasaresultofthiscommand?()
A.All control files are opened
B.All redo files are opened
C.The password file is opened
D.The parameter file is opened
E.All online data files are opened -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Yoususpectthatinoneofyourapplicationsthecustomertableisbeingaccessedbysomeunauthorizedusers.Whichoptionwouldyouusetomonitorthequeriesbeingexecutedonthecustomertable?()
A.Monitor thealert.logfile
B.Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
D.Enable Fine-Grained Access Control (FGAC) for the customer table
E.Write a database trigger on the customer table on the SELECT event
