Evaluate the SQL statement.
CREATE ROLE manager;
CREATE ROLE clerk;
CREATE ROLE warehouse;
CREATE USER john IDENTIFIED BY john123;
GRANT warehouse TO clerk;
GRANT clerk TO manager;
GRANT warehouse TO john;
GRANT manager TO john
/
How many roles will user john have access to?
A. 0
B. 1
C. 2
D. 3
Answer:[D]
Highlight to find out the answer.
Saturday, March 27, 2010
ROLE
at 9:02 PM
Labels: Oracle, Oracle Query, Oracle Test, PL/SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment