Exam C2090-600 All QuestionsBrowse all questions from this exam
Question 38

What levels of authority are needed to create a storage group? (Choose two.)

    Correct Answer: B, D

    To create a storage group in a DB2 database, the required levels of authority are SYSADM and SYSCTRL. SYSADM is the highest level of administrative authority and allows the holder to perform any administrative task, including creating storage groups. SYSCTRL, while more limited, still provides sufficient authority to manage storage groups along with other system-level tasks.

Discussion
db2testerOptions: BD

The privileges that are held by the authorization ID of the statement must include SYSCTRL or SYSADM authority. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0058606.html