The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?
A.
no privileges
B.
only the SELECT privilege
C.
only the CONNECT privilege
D.
all the privileges of a default user
Explanation:
when a user is created, by default no privilege is grantedIncorrect answer:
B:
SELECT is not grant
C:
CONNECT is not grant
D:
default profile is grant by default not privilege.
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-6
A