单项选择题
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 -
单项选择题
The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database if facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）
A.A
B.B
C.C
D.D
E.E -
多项选择题
You want to enforce a company’s business policy on several objects by using a singlepolicy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？（）
A.DBMS_RLS.STATIC
B.DBMS_RLS.DYNAMIC
C.DBMS_RLS.SHARED_STATIC
D.DBMS_RLS.CONTEXT_SENSITIVE
E.DBMS_RLS.SHARED_CONTEXT_SENSITIVE
