QUESTION: 08

On 20 de July de 2007, in 1Z0-001, OCA (PL/SQL Developer), ORACLE, by Fabiano Anjos

Which privilege concerns with system level security?

A: DROP ANY TABLE
B: DELETE
C: ALTER
D: INDEX
E: UPDATE

ANSWER: A

EXPLANATION: Answer A is correct because only DROP ANY TABLE privilege from all choices belongs to SYSTEM level security, all others not.

INCORRECT ANSWERS:

B: DELETE is object privilege. Permits the grantee of this object privilege to delete data from a table or view.
C: ALTER is object privilege. Permits the grantee of this object privilege to alter the definition of a table or sequence only. The ALTER privileges on all other database objects are considered system privileges.
D: INDEX is object privilege. Permits the grantee of this object privilege to create an index on a table already defined.
E: UPDATE is object privilege. Permits the grantee of this object privilege to update data into a table or view.

 

Comments are closed.