IBM DB2 9 Fundamentals certification (Exam 730): Sample question No. 8

Answer a sample question about CREATE TABLE statements from the IBM DB2 9 Fundamentals certification exam (Exam 730) to prepare you for the test.

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)

This was first published in November 2007

Dig deeper on Data management jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close