Which one of the following authorities can create a database?
-
SYSMAINT
-
SYSCTRL
-
DBCTRL
-
SYSADM
B
Correct answer
Explanation
SYSCTRL authority has the privilege to create databases in DB2. SYSMAINT can perform maintenance operations but cannot create databases. DBCTRL is not a standard DB2 authority level. While SYSADM (System Administrator) has all privileges including database creation, the question specifically asks for which authority CAN create a database, and SYSCTRL is the minimal authority with this privilege. The answer key is correct.