IBM Db2 Practice Test

1. 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

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

CREATE DATABASE

NEW DATABASE

INIT DATABASE

SETUP DATABASE

3. 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

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

Serializable

Read Committed

Read Uncommitted

Repeatable Read

5. 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

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

True

False

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

REORG

OPTIMIZE

COMPRESS

DEFRAG

8. 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

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

ALTER TABLE

MODIFY TABLE

ADD COLUMN

UPDATE SCHEMA

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

True

False

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

32 KB (including LOB columns)

1 MB

Unlimited

64 KB

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

Table Partitioning

Sharding

Replication

Clustering

13. 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

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

True

False

15. 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

IBM Db2 Practice Test

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

2.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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