The following question is taken from DB2 9 Fundamentals Certification Study Guide, by Roger E. Sanders (copyright
2007) and is reprinted here with permission from MC Press.
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.
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)