Appendix L. Sample Questions

This appendix contains sample certification exam questions that help verify your understanding of the topics discussed in this book.

Q01 SYSADM privileges are:

  1. Highest set of privileges available in DB2 ESE

  2. Lowest set of privileges available in DB2 ESE

  3. Set of privileges at the DBADM level

  4. None of the above

Q02 Given the following users:

User appusr1 belongs to group usr1grp and user appusr2 belongs to group db2grp.

User appusr1 is the owner of the instance db2inst1 and has updated the database manger configuration set the SYSADM_GROUP to usr1grp.

If user appusr2 wants to drop db2inst1 instance and create a new instance db2inst2, user appusr2 needs:

  1. User appusr1 to grant DBADM privilege to user appusr2

  2. User appusr1 to grant ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial