Home » Oracle » 1z0-051 » What privileges does the user Scott have at this point?
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.
Correct Answer: A
Explanation/Reference:
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.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 348-351
Chapter 8: User Access in Oracle
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
