In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）

单项选择题You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr hr@pdserver.us.oracle.com：1521 proddb   Which naming method is being used in this case？（）

A.Local Naming
B.Easy Connect
C.External Naming
D.Directory Naming

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase：ORA-01555：snapshottooold，Inwhichsituationwouldyoureceivesuchanerror？（）

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.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youaddedatablespacetoyourdatabase.Becauseofthechangestothephysicalstructureofyourdatabase，youperformedabackupofthecontrolfiletotrace.Afterthis，youlostonlythecontrolfilesandtheinstanceabortedduetoahardwarefailure.Howwouldyouproceedtorecoverthedatabase？（）

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