×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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 ↻





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