Test your knowledge of DB2 9 by answering the question below, which is from a real, previous DB2 9 Fundamentals certification exam (exam 730). When you are finished, check your answer and read an explanation using the answer key.
IBM DB2 9 Fundamentals certification exam study guide
Which of the following CREATE TABLE statements will NOT be successful?
A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
B. CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))
C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
D. CREATE TABLE t1 (c1 XML, c2 XML)
• Read the answer and explanation
• Go back to the list of sample exam questions
This was first published in November 2007