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.
