IBM Db2 Practice Test

1. In IBM Db2, which command is used to create a new database?

CREATE DATABASE

NEW DATABASE

INIT DATABASE

SETUP DATABASE

2. What is the primary purpose of an index in Db2?

To speed up data retrieval by reducing full table scans

To encrypt sensitive data

To automatically backup the database

To limit user access to tables

3. True or False: In Db2, a composite index can improve performance for queries filtering on multiple columns.

True

False

4. Which Db2 utility is used to reorganize table data and reclaim unused space?

REORG

OPTIMIZE

COMPRESS

DEFRAG

5. What is a 'deadlock' in the context of Db2 transactions?

A situation where two transactions wait indefinitely for each other to release locks

A permanent lock on a table preventing all access

An error in SQL syntax

A backup failure during transaction processing

6. True or False: A foreign key constraint in Db2 can reference a column in the same table.

True

False

7. Which Db2 feature allows you to partition a large table across multiple physical storage locations?

Table Partitioning

Sharding

Replication

Clustering

8. True or False: Db2 supports recursive queries using Common Table Expressions (CTEs).

True

False

9. Which isolation level in Db2 prevents dirty reads, non-repeatable reads, and phantom reads?

Serializable

Read Committed

Read Uncommitted

Repeatable Read

10. In Db2, which statement is used to add a new column to an existing table?

ALTER TABLE

MODIFY TABLE

ADD COLUMN

UPDATE SCHEMA

11. What is the maximum size of a Db2 database table row?

32 KB (including LOB columns)

1 MB

Unlimited

64 KB

12. In Db2 SQL, what does the HAVING clause do?

Filters grouped data based on aggregate conditions

Joins multiple tables together

Orders result sets

Limits the number of rows returned

13. Which Db2 command is used to grant SELECT permission on a table to a user?

GRANT SELECT ON table_name TO user_name

ALLOW SELECT ON table_name FOR user_name

PERMIT SELECT ON table_name TO user_name

AUTHORIZE SELECT ON table_name TO user_name

14. What does ACID stand for in the context of database transactions?

Atomicity, Consistency, Isolation, Durability

Access, Control, Index, Data

Availability, Concurrency, Integrity, Distribution

Authentication, Credentials, Identity, Deployment

15. What does the term 'tablespace' refer to in IBM Db2?

A logical storage area that contains database objects

A backup copy of a table

A temporary workspace for queries

A user-defined permission level

IBM Db2 Practice Test

1. In IBM Db2, which command is used to create a new database?

2.

What first name or nickname would you like us to use?

2. What is the primary purpose of an index in Db2?

3. True or False: In Db2, a composite index can improve performance for queries filtering on multiple columns.

4. Which Db2 utility is used to reorganize table data and reclaim unused space?

5. What is a 'deadlock' in the context of Db2 transactions?

6. True or False: A foreign key constraint in Db2 can reference a column in the same table.

7. Which Db2 feature allows you to partition a large table across multiple physical storage locations?

8. True or False: Db2 supports recursive queries using Common Table Expressions (CTEs).

9. Which isolation level in Db2 prevents dirty reads, non-repeatable reads, and phantom reads?

10. In Db2, which statement is used to add a new column to an existing table?

11. What is the maximum size of a Db2 database table row?

12. In Db2 SQL, what does the HAVING clause do?

13. Which Db2 command is used to grant SELECT permission on a table to a user?

14. What does ACID stand for in the context of database transactions?

15. What does the term 'tablespace' refer to in IBM Db2?