Home > Databases > Quizzes > DB2 Test Questions
DB2 Test Questions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 54% Most missed: “Which of the following command starts an instance?”

DB2 (IBM Database 2) is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML.

DB2 Test Questions
Time left 00:00
25 Questions

1. The size of bufferpool and tablespace must be the same.
2. The ____ is a section of main memory allocated by the database management.
3. A ____ is a well-organized collection of databases.
4. What is LDAP?
5. Several databases can be managed by a single instance.
6. What is SMS?
7. How many types of indexes are there?
8. Every database has its own bufferpool.
9. With the '____' command, you may create a database.
10. To build a new bufferpool for the database server, how many parameters are required?
11. A container can be ____.
12. ____ type of logging mode allows Online Backup as well as database recovery using log files, known as roll-forward recovery.
13. A set of Storage routes to store database tables or objects, called a ____.
14. Where a member-specific directory is created?
15. Which company developed DB2?
16. Is it possible to install multiple DB2Servers on a physical machine?
17. How many types of sequences are there?
18. To ensure database integrity, a set of rules known as ____ is specified?
19. Does DB2 support object-oriented features?
20. How many types of LDAP are there?
21. A ____ is a set of named items that are logically categorized in a database.
22. Which of the following command starts an instance?
23. Partition global directory is created in the ____ folder.
24. Is it necessary to check if the bufferpool is assigned to a tablespace before dropping it?
25. In an instance, two or more databases can have the same name?