单项选择题
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？（）
A.no profiles
B.the default profile
C.same as the profile of SYS user
D.same as the profile of SYSTEM user
相关考题
-
单项选择题
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.
