Multiple choice

Which privilege can only be granted to a user and not to a role?

  1. DELETE

  2. ALTER

  3. INSERT

  4. EXECUTE

  5. REFERENCES
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The REFERENCES privilege (foreign key constraint) can only be granted to a specific user, not to a role. This is because foreign key constraints require explicit permission to reference another user's table, and Oracle doesn't allow this through roles for security and integrity reasons. All other privileges listed (DELETE, ALTER, INSERT, EXECUTE) can be granted to both users and roles.

Keep practicing — related questions