Multiple choice technology mainframe

Which of the following is not DATABASE privilege?

  1. A. REPAIR

  2. B. UPDATE

  3. C. LOAD

  4. D. IMAGCOPY
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In DB2, REPAIR, LOAD, and IMAGCOPY are database-level utilities that require special privileges. UPDATE is a standard DML (Data Manipulation Language) operation that operates on table-level data, not a database administration privilege.

AI explanation

In DB2 (z/OS), DATABASE-level privileges control operations scoped to a whole database — examples include LOAD (load data into tablespaces), IMAGCOPY (take image copies for backup/recovery), REPAIR (repair database structures via the REPAIR utility), CREATETAB, DROPIN, STARTDB, STOPDB, etc. UPDATE, by contrast, is a TABLE (or plan/package) privilege — it grants the ability to modify rows in a specific table, not to administer the database as a whole. So UPDATE is correctly identified as not a DATABASE privilege, while REPAIR, LOAD, and IMAGCOPY are genuine DATABASE privileges/utility grants.

Keep practicing — related questions