IBM DB2 9 Fundamentals certification (Exam 730): Answer key No. 8

Get the answer and a detailed explanation to a sample question about CREATE TABLE statements from the IBM DB2 9 Fundamentals certification exam (Exam 730) study guide.

IBM DB2 9 Fundamentals certification exam answer key

 

The correct answer is A --

CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

The XML data type can be used to store well-formed XML documents in their native format. A table can contain any number of XML columns; however each XML column used has the following restrictions:

•             It cannot be part of any index except an XML index.

•             It cannot be included as a column of a primary key or unique constraint.

•             It cannot be a foreign key of a referential constraint.

•             It cannot have a specified default value or a WITH DEFAULT clause—if the column is nullable, the default value for the column is the null value.

•             It cannot be used in a table with a distribution key.

•             It cannot be used in range-clustered or range-partitioned tables.

 

In addition, XML columns can only be referenced in a check constraint if the check constraint contains the VALIDATED predicate...

 

•             To read the rest of this question's explanation, and to practice with more sample questions from the IBM DB2 9 Fundamentals exam, (Exam 730), purchase the book at MC Press.

 

•             Go back to the list of sample exam questions.

This was last published in November 2007

Dig Deeper on IBM DB2 management

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close