IBM Db2 SQL Data Manipulation Quiz

1. In Db2, what clause modifies data based on values from another table?

UPDATE with JOIN

INSERT from SELECT

MERGE

All of the above

2. In Db2, what is the maximum number of rows that can be inserted in a single multi-row INSERT statement?

100 rows

1000 rows

No fixed limit (performance-dependent)

Limited by available memory

3. Which Db2 clause in an UPDATE statement allows conditional updates based on row values?

CASE

IF

WHEN

CONDITIONAL

4. True or False: Db2 allows inserting NULL values into columns with NOT NULL constraints.

True

False

5. In Db2, what happens if a DELETE statement violates a foreign key constraint?

The delete proceeds silently

An error is raised

Dependent rows are auto-deleted

The transaction auto-commits

6. Which Db2 statement is used to conditionally insert or update rows in one operation?

UPSERT

MERGE

REPLACE

INSERT OR UPDATE

7. True or False: You can update primary key values in Db2 without restrictions.

True

False

8. In Db2, what does a foreign key constraint enforce during INSERT or UPDATE?

Uniqueness of values

Referential integrity

Non-NULL values

Column ordering

9. Which Db2 feature allows inserting multiple rows in a single statement?

Bulk insert

Multi-row insert

VALUES clause with multiple rows

LOAD utility

10. True or False: The TRUNCATE statement in Db2 is faster than DELETE for removing all rows.

True

False

11. Which SQL statement is used to insert new rows into a Db2 table?

INSERT

ADD

APPEND

CREATE

12. Which isolation level in Db2 allows reading uncommitted data from other transactions?

READ COMMITTED

READ UNCOMMITTED

REPEATABLE READ

SERIALIZABLE

13. When inserting data into a Db2 table with an identity column, what value is auto-generated?

Random string

Current timestamp

Sequential integer

NULL

14. In Db2, what does the ROLLBACK statement do?

Saves changes permanently

Undoes all changes since the last COMMIT

Deletes the entire table

Creates a new transaction

15. Which function returns the number of rows affected by an UPDATE statement in Db2?

ROW_COUNT()

DB2_ROW_COUNT

@@ROWCOUNT

ROWCOUNT

16. What is the purpose of the COMMIT statement in Db2?

Undo all changes in a transaction

Permanently save changes to the database

Lock table rows

Create a backup copy

17. In Db2, which keyword prevents duplicate rows in INSERT operations?

UNIQUE

DISTINCT

PRIMARY KEY

CONSTRAINT

18. What does the DELETE statement remove from a Db2 table?

Only columns

Only the table structure

Entire rows

Database indexes

19. Which clause is required when updating specific rows in a Db2 table?

GROUP BY

WHERE

HAVING

ORDER BY

20. In Db2, what is the default isolation level for transactions?

READ UNCOMMITTED

READ COMMITTED

REPEATABLE READ

SERIALIZABLE

IBM Db2 SQL Data Manipulation Quiz

1. In Db2, what clause modifies data based on values from another table?

2.

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

2. In Db2, what is the maximum number of rows that can be inserted in a single multi-row INSERT statement?

3. Which Db2 clause in an UPDATE statement allows conditional updates based on row values?

4. True or False: Db2 allows inserting NULL values into columns with NOT NULL constraints.

5. In Db2, what happens if a DELETE statement violates a foreign key constraint?

6. Which Db2 statement is used to conditionally insert or update rows in one operation?

7. True or False: You can update primary key values in Db2 without restrictions.

8. In Db2, what does a foreign key constraint enforce during INSERT or UPDATE?

9. Which Db2 feature allows inserting multiple rows in a single statement?

10. True or False: The TRUNCATE statement in Db2 is faster than DELETE for removing all rows.

11. Which SQL statement is used to insert new rows into a Db2 table?

12. Which isolation level in Db2 allows reading uncommitted data from other transactions?

13. When inserting data into a Db2 table with an identity column, what value is auto-generated?

14. In Db2, what does the ROLLBACK statement do?

15. Which function returns the number of rows affected by an UPDATE statement in Db2?

16. What is the purpose of the COMMIT statement in Db2?

17. In Db2, which keyword prevents duplicate rows in INSERT operations?

18. What does the DELETE statement remove from a Db2 table?

19. Which clause is required when updating specific rows in a Db2 table?

20. In Db2, what is the default isolation level for transactions?