IBM Exam Questions

How many rows will be inserted in TB1?

Consider TB1 has no rows initially and that the auto commit feature is disabled. After execution of
the following statements:
INSERT INTO TB1 VALUES (1, ‘ABC’)
INSERT INTO TB1 VALUES (2, ‘DEF’)
COMMIT
INSERT INTO TB1 VALUES (3, ‘GHI’)
ROLLBACK
COMMIT
How many rows will be inserted in TB1?

A.
0

B.
1

C.
2

D.
3

Explanation: