IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 49

Which of the following authorities are sufficient for creating a database? (Choose two.)

Answer options

• A. DBADM
• B. SYSADM
• C. SECADM
• D. SYSCTRL
• E. SYSMAINT

Correct answer: B, D

Explanation

The SYSADM and SYSCTRL authorities are required for database creation because SYSADM has overall control of the database, while SYSCTRL has permissions to manage the database's control functions. The other options, while they have their own roles, do not provide the necessary permissions for creating a database.