Database Fundamentals — Question 138

Which of the following commands can be used to change the authorization type in DB2 9? Each correct answer represents a complete solution. (Choose all that apply.)

Answer options

• A. UPDATE DATABASE CONFIGURATION
• B. SET AUTHORISATION
• C. RESET DATABASE CONFIGURATION
• D. UPDATE DBM CFG

Correct answer: A, D

Explanation

The correct answers are A and D, as both 'UPDATE DATABASE CONFIGURATION' and 'UPDATE DBM CFG' commands can modify the authorization settings in DB2 9. Options B and C are incorrect because 'SET AUTHORISATION' is not a valid command in this context and 'RESET DATABASE CONFIGURATION' does not change the authorization type.