Consider the following scenario： 
You have a directory， data， under the disk group tdgroup 
A. You want to create an alias for one of the data files and you execute the following command：
ALTER DISKGROUP tdgroupA 
ADD ALIAS ’+tdgroupA/data/datafile.dbf’ 
FOR ’+tdgroupA. 231.45678’； 
Which task would be accomplished by the command？（）

单项选择题WhichbackgroundprocessdoesAutomaticSharedMemoryManagementusetocoordinatethesizingofmemorycomponents？（）

A.PMON
B.SMON
C.MMNL
D.MMAN
E.MMON

单项选择题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

A.You performed rollback after commit.
B.If a log switch occurs in your database.
C.Thearchiverfails to generate an archived log file.
D.Instance recovery fails to find one of the redo log files.
E.A long-running query is unable to get read-consistent image.
F.If you perform manual undo management operations in auto mode.

单项选择题You work as a database administrator for Certkiller .com. 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 recovers control 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.

单项选择题YouworkasadatabaseadministratorforCertkiller.com.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）

多项选择题YouworkasadatabaseadministratorforCertkiller.com.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