The following question is taken from DB2 9 Fundamentals Certification Study Guide, by Roger E. Sanders (copyright...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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)