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 granted
Incorrect answer:
BSELECT is not grant
CCONNECT is not grant
Ddefault profile is grant by default not privilege.Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-6
To get a privilege the query has to mention grant or revoke in the statement.