I am preparing for 700 certification .Is there someone can help me ?Thanks!
Which of the following is NOT a valid data type on CREATE TABLE?
DATETIME or DOUBLE
CREATE TABLE T1(C1 CHAR(3))
INSERT INTO T1 VALUES ('A')
ROLLBACK
COMMIT
The value A insert into c1 or not?

datatype is date or time or timestamp
insert yes-but rollbacked= empty table

thank you !

I'm curious because I sometimes supervise such exams: Is there a reason why you don't want to take the 730 exam (DB2 V9 Fundamentals)?