Which statement correctly grants a system privilege?
A.
GRANT EXECUTE
ON proc1
TO PUBLIC;
B.
GRANT CREATE VIEW
ON table1 TO
user1;
C.
GRANT CREATE TABLE
TO user1,user2;
D.
GRANT CREATE SESSION
TO ALL;
Which statement correctly grants a system privilege?
Which statement correctly grants a system privilege?
B. GRANT CREATE VIEW ON table1 to user1 <= table1 is object. It is granting object privilege.
D. It should be grant create session to public; ALL is invalid.
Option A is incorrect because it is a object privilege.
The correct answer is C.
c
I have the same idea. C
Do you have question for 1Z0-071 oracle exam?
Thank you