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:
There are no privileges for the user Scott at this point. They are not added themselves to the user
immediately after creation. The DBA needs to grant all privileges explicitly.
Incorrect Answers
B:There are no privileges for the user Scott at this point. SELECT privilege needs to be added to
the user Scott.
C:There are no privileges for the user Scott at this point. CONNECT privilege needs to be added
to the user Scott.
D:There is no default user in Oracle.