IncludeHelp_logo
Skip Navigation Links

Home » MCQs

DB2 Multiple-Choice Questions (MCQs)

DB2 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. Read more at Wikipedia

DB2 MCQs: This section contains multiple-choice questions and answers on the various topics of DB2. Practice these MCQs to test and enhance your skills on DB2.

List of DB2 MCQs

1. DB2 is a ____?

  1. NoSQL
  2. RDBMS

Answer: B) RDBMS

Explanation:

DB2 is a relational database management system.

Discuss this Question

2. Does DB2 support object-oriented features?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Yes, DB2 supports object-oriented features.

Discuss this Question

3. Which company developed DB2?

  1. Google
  2. Facebook
  3. IBM
  4. Apache

Answer: C) IBM

Explanation:

DB2 was developed by IBM.

Discuss this Question

4. DB2 can run on which of the following operating system?

  1. Linux
  2. Unix
  3. Windows
  4. All of the above

Answer: D) All of the above

Explanation:

DB2 can run on any operating system such as Linux, Unix, or windows.

Discuss this Question

5. An ____- is DB2 Database Manager's logical environment?

  1. Environment
  2. Directory
  3. Instance
  4. Object

Answer: C) Instance

Explanation:

An instance is DB2 Database Manager's logical environment.

Discuss this Question

6. The default instance for DB2 Database Server is ____?

  1. Database
  2. DB2
  3. databaseinstance

Answer: B) DB2

Explanation:

The default instance for DB2 Database Server is "DB2".

Discuss this Question

7. Can you modify the location of the Instance directory once it has been created?

  1. Yes
  2. No

Answer: B) No

Explanation:

It is not possible to modify the location of the Instance directory once it has been created.

Discuss this Question

8. Several databases can be managed by a single instance.

  1. True
  2. False

Answer: A) True

Explanation:

Several databases can be managed by a single instance.

Discuss this Question

9. In an instance, two or more databases can have the same name?

  1. Yes
  2. No

Answer: B) No

Explanation:

In an instance, each database has a unique name, its own set of catalog tables, configuration files, authorities, and privileges.

Discuss this Question

10. Is it possible to install multiple DB2Servers on a physical machine?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Several DB2Servers can be installed on a single physical computer.

Discuss this Question

11. Which command displays a list of all the instances available on a system?

  1. db2list
  2. db2listi
  3. listDB2
  4. db2ilist

Answer: D) db2ilist

Explanation:

db2ilist command displays a list of all the instances available on a system.

Discuss this Question

12. Which command displays information about the presently running instance?

  1. db2 get all instance
  2. db2 get present instance
  3. db2 get instance

Answer: C) db2 get instance

Explanation:

db2 get instance command displays information about the presently running instance.

Discuss this Question

13. Which of the following command starts an instance?

  1. DB2run
  2. DB2start
  3. DB2initiate

Answer: B) DB2start

Explanation:

DB2Start command starts an instance.

Discuss this Question

14. Which of the following command is used to stop a running instance?

  1. DB2pause
  2. DB2Stop
  3. DB2end
  4. DB2exit

Answer: B) DB2Stop

Explanation:

DB2stop command is used to stop a running instance.

Discuss this Question

15. Is instance id a root id.

  1. Yes
  2. No

Answer: B) No

Explanation:

Instance id is not a root id or a root name.

Discuss this Question

16. To update the instance, ____ command is used.

  1. Db2iupdt
  2. Db2update
  3. Db2updt

Answer: A) Db2iupdt

Explanation:

To update the instance, db2iupdt command is used.

Discuss this Question

17. Which command is used to drop an instance?

  1. DB2IDEL
  2. Db2idelete
  3. Db2idrop

Answer: C) Db2idrop

Explanation:

db2idrop command is used to drop an instance.

Discuss this Question

18. A ____ is a well-organized collection of databases.

  1. Database instance
  2. Database directory
  3. Database guide
  4. Database Catalog

Answer: B) Database directory

Explanation:

A database directory is a well-organized collection of databases.

Discuss this Question

19. Partition global directory is created in the ____ folder.

  1. Instance
  2. Object
  3. Data
  4. Database

Answer: A) Instance

Explanation:

The partition global directory is created in the instance folder.

Discuss this Question

20. Where a member-specific directory is created?

  1. Instance folder
  2. Global directory
  3. partition-global

Answer: C) partition-global

Explanation:

A member-specific directory is generated in the partition-global directory.

Discuss this Question

21. With the "____" command, you may create a database.

  1. CREATE DB
  2. CREATE NEW DB
  3. NEW DATABASE
  4. CREATE DATABASE

Answer: D) CREATE DATABASE

Explanation:

With the "CREATE DATABASE" command, you may create a database.

Discuss this Question

22. All database tables are kept in "____" in DB2?

  1. Database
  2. Directory
  3. Table
  4. Tablespace

Answer: D) Tablespace

Explanation:

All database tables are kept in "tablespace" in DB2.

Discuss this Question

23. Which command is used to view the directory list in the current instance?

  1. db2 list database directory
  2. db2 list directory
  3. db2 directory list
  4. db2 directory database list

Answer: A) db2 list database directory

Explanation:

db2 list database directory and the command is used to view the directory list in the current instance.

Discuss this Question

24. To utilize a database once it has been created, ____ command is used to connect or start the database.

  1. db2 connect <database name>
  2. db2 connection to <database name>
  3. db2 start to <database name>

Answer: A) db2 connect <database name>

Explanation:

To utilize a database once it has been created, db2 connect to <database name>, the command is used to connect or start the database.

Discuss this Question

25. The ____ is a section of main memory allocated by the database management.

  1. Cache
  2. Bufferpool
  3. Dram
  4. Tablespaces

Answer: B) Bufferpool

Explanation:

The bufferpool is a section of the main memory allocated by the database management.

Discuss this Question

26. Every database has its own bufferpool.

  1. True
  2. False

Answer: A) True

Explanation:

Every database has its own bufferpool.

Discuss this Question

27. The purpose of ____ is to cache table and index data from disk.

  1. BufferPools
  2. StoragePools
  3. CacheData
  4. Tablespaces

Answer: A) BufferPools

Explanation:

The purpose of bufferpools is to cache tables and index data from disk.

Discuss this Question

28. ____ bufferpool is coupled with ____ tablespace?

  1. One, many
  2. Many, one
  3. One, one
  4. Many, many

Answer: C) One, one

Explanation:

One bufferpool is coupled with one tablespace.

Discuss this Question

29. Once the bufferpool is created, Is it possible to modify the page size later?

  1. Yes
  2. No

Answer: B) No

Explanation:

Once the bufferpool is created, it is not possible to modify the page size later.

Discuss this Question

30. What is the default bufferpool page size?

  1. 10KB
  2. 100KB
  3. 5KB
  4. 4KB

Answer: D) 4KB

Explanation:

The default bufferpool page size is 4KB.

Discuss this Question

31. The size of bufferpool and tablespace must be the same.

  1. True
  2. False

Answer: A) True

Explanation:

The size of bufferpool and tablespace must be the same.

Discuss this Question

32. To build a new bufferpool for the database server, how many parameters are required?

  1. 3
  2. 4
  3. 2
  4. 5

Answer: C) 2

Explanation:

To build a new bufferpool for the database server, you will need two parameters: "bufferpool name" and "page size".

Discuss this Question

33. Is it necessary to check if the bufferpool is assigned to a tablespace before dropping it?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Yes, Before removing the bufferpool, it must be checked to see if it has any tablespaces assigned to it.

Discuss this Question

34. A ____ is a type of storage structure that contains tables, indexes, huge objects, and lengthy data.

  1. Table store
  2. table space
  3. Clear table
  4. Data fields

Answer: B) table space

Explanation:

A table space is a type of storage structure that contains tables, indexes, huge objects, and lengthy data.

Discuss this Question

35. Tablespaces includes only one container?

  1. Yes
  2. No

Answer: B) No

Explanation:

Tablespaces includes one or more containers.

Discuss this Question

36. A container can be ____.

  1. a device name
  2. a directory name
  3. a filename
  4. All of the above

Answer: D) All of the above

Explanation:

A container can be a device name, a directory name, or a filename.

Discuss this Question

37. A single tablespace in a database can have ____ containers on the same physical storage device.

  1. Only one
  2. Many
  3. More than 2 but less than 5

Answer: B) Many

Explanation:

A single tablespace in a database can have several containers on the same physical storage device.

Discuss this Question

38. What is SMS?

  1. Simple management service
  2. System-managed space
  3. System management service

Answer: B) System-managed space

Explanation:

SMS stands for system manages space.

Discuss this Question

39. What is DMS?

  1. Data management service
  2. Data management space
  3. Database managed space
  4. Database managed service

Answer: C) Database managed space

Explanation:

DMS stands for database manages space.

Discuss this Question

40. A set of Storage routes to store database tables or objects, called a ____.

  1. Storage group
  2. Memory group
  3. Retention group

Answer: A) Storage group

Explanation:

A set of Storage routes to store database tables or objects, called a storage group.

Discuss this Question

41. A ____ is a set of named items that are logically categorized in a database.

  1. Table
  2. Fields
  3. Schema
  4. Views

Answer: C) Schema

Explanation:

A schema is a set of named items that are logically categorized in a database.

Discuss this Question

42. Which of the following command will give you the currently active schema?

  1. db2 get schema
  2. db2 list schema
  3. db2 active schema

Answer: A) db2 get schema

Explanation:

db2 get schema, the command will give you the currently active schema.

Discuss this Question

43. A ____ is a collection of data kept in the form of columns and rows.

  1. Views
  2. Tables
  3. Schema
  4. Fields
  5. Datatype

Answer: B) Tables

Explanation:

A table is a collection of data kept in the form of columns and rows.

Discuss this Question

44. Which of the following commands lists the columns in a table?

  1. db2 desc table <table_name>
  2. db2 col table <table_name>
  3. db2 describe table <table_name>
  4. db2 descri table <table_name>

Answer: C) db2 describe table <table_name>

Explanation:

db2 describes table <table_name>, commands lists the columns in a table.

Discuss this Question

45. An ____ is a different name for a database entity?

  1. Rename
  2. Revoke
  3. Alias
  4. Pseudonym

Answer: C) Alias

Explanation:

An alias is a different name for a database entity.

Discuss this Question

46. To ensure database integrity, a set of rules known as ____ is specified?

  1. Limitations
  2. Constraints
  3. Limits
  4. Restraints

Answer: B) Constraints

Explanation:

To ensure database integrity, a set of rules known as constraints is specified.

Discuss this Question

47. An index is a collection of pointers that can refer to rows in a table.

  1. Pointer
  2. Index
  3. Score
  4. key

Answer: B) Index

Explanation:

An index is a collection of pointers that can refer to rows in a table.

Discuss this Question

48. How many types of indexes are there?

  1. 4
  2. 3
  3. 2
  4. 1

Answer: C) 2

Explanation:

Types of indexes: Unique and clustered.

Discuss this Question

49. A trigger is a series of activities, which are done for reacting to an INSERT, UPDATE, or DELETE operation on a particular table in the database.

  1. Events
  2. Triggers
  3. Actions

Answer: B) Triggers

Explanation:

A trigger is a series of activities, which are done for reacting to an INSERT, UPDATE or DELETE operation on a particular table in the database.

Discuss this Question

50. How many types of triggers are there?

  1. 5
  2. 4
  3. 3
  4. 2

Answer: D) 2

Explanation:

There are two types of triggers: Before triggers and After triggers.

Discuss this Question

51. A ____ is a software function that creates integer numbers in either ascending or descending order, within a specific range, to generate a primary key and coordinate other keys within the table.

  1. Pattern
  2. Ranks
  3. Sequence

Answer: C) Sequence

Explanation:

A sequence is a software function that creates integer numbers in either ascending or descending order, within a specific range, to generate a primary key and coordinate other keys within the table.

Discuss this Question

52. How many types of sequences are there?

  1. 4
  2. 5
  3. 2
  4. 3

Answer: C) 2

Explanation:

There are two types of sequence: NEXTVAL and PREVIOUS VALUE.

Discuss this Question

53. In which of the following sequence type an incremented value for a sequence number is returned?

  1. NEXTVAL
  2. PREVIOUS VALUE.

Answer: A) NEXTVAL

Explanation:

In the NEXTVAL sequence type an incremented value for a sequence number is returned.

Discuss this Question

54. ____ is not a genuine table and it does not have any permanent storage.

  1. View
  2. Schema
  3. Fields

Answer: A) View

Explanation:

View is not a genuine table and it does not have any permanent storage.

Discuss this Question

55. ____ type of logging is a mechanism in which existing transaction logs are rewritten when a new transaction log file is required, hence erasing log file sequences and reusing them.

  1. Archive logging
  2. Shutter logging
  3. Circular logging

Answer: C) Circular logging

Explanation:

Circular logging is a mechanism in which existing transaction logs are rewritten when a new transaction log file is required, hence erasing log file sequences and reusing them.

Discuss this Question

56. ____ type of logging mode allows Online Backup as well as database recovery using log files, known as roll-forward recovery.

  1. Archive logging
  2. Shutter logging
  3. Circular logging

Answer: A) Archive logging

Explanation:

Archive logging mode allows Online Backup as well as database recovery using log files, known as roll-forward recovery.

Discuss this Question

57. A role can own a database object?

  1. True
  2. False

Answer: B) False

Explanation:

A role cannot own the database objects.

Discuss this Question

58. A ____ is a database object that has a collection of rights that may be assigned to users, groups, PUBLIC, or other roles using the GRANT statement.

  1. Group
  2. Role
  3. Job
  4. Task

Answer: B) Role

Explanation:

A role is a database object that has a collection of rights that may be assigned to users, groups, PUBLIC, or other roles using the GRANT statement.

Discuss this Question

59. How many types of LDAP are there?

  1. 4
  2. 5
  3. 3
  4. 2

Answer: D) 2

Explanation:

There are two types of LDAP: Transparent and plugin.

Discuss this Question

60. What is LDAP?

  1. Lightweight directory access protocol
  2. Long directory access protocol
  3. Lengthy directory access protocol

Answer: A) Lightweight directory access protocol

Explanation:

LDAP stands for lightweight directory access protocol.

Discuss this Question




Comments and Discussions!

Load comments ↻




Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.