Multiple choice technology programming languages

Which one is a system privilege?

  1. SELECT

  2. EXECUTE

  3. ALTER TABLE

  4. CREATE TABLE

  5. DELETE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

CREATE TABLE is a system privilege that allows a user to create tables in their schema. SELECT, EXECUTE (when on procedures), DELETE, and ALTER TABLE are object privileges that must be granted on specific database objects. System privileges are schema-wide authorities, while object privileges operate on named objects.

Keep practicing — related questions