Multiple choice technology databases

Which authority or privilege is granted by the DB2 Database Manager configuration file?

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

  4. EXECUTE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The DB2 Database Manager configuration file (dbm cfg) is used to set instance-level authorities including SYSMAINT, SYSCTRL, and SYSADM. CONNECT, CONTROL, and EXECUTE are database or object-level privileges granted through SQL statements, not configuration file settings. SYSMAINT is a system maintenance authority defined at the instance level.

Keep practicing — related questions