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

Given the following queries:
SELECT c1 FROM tab1;

SELECT c1 FROM tab2;
Which set operators can be used to produce a result data set that contains only records that are
not found in the result data set produced by each query after duplicate rows have been
eliminated?

Which is a valid wildcard character in a LIKE clause of a SELECT statement?

Which two statements are true about the HAVING clause?

The following SQL statement:
DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR
Is used to perform which type of delete operation?

Given the following table definition:
If the following SELECT statement is executed, which describes the order of the rows in the result
data set produced?
SELECT * FROM sales

Which DB2 data types does NOT have a fixed length?

Given the requirements to store employee names, employee numbers, and when employees were
hired, which built-in data types CANNOT be used to store the day an employee was hired?

Which two are optional and do not have to be specified when creating a table?

Which CANNOT be used to restrict specific values from being inserted into a column in a
particular table?