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, c2CHAR(20))
C.
CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
D.
CREATE TABLE t1 (c1 XML, c2 XML)
A
0
0
XML columns cannot be unique
0
0
An XML column has several restrictions. The column cannot:
Be specified as part of the primary key
Be specified as part of a UNIQUE key
Have a DEFAULT value specified
Be specified as part of the FOREIGN KEY references clause
Be specified as part of the REFERENCES table-name clause
Be specified in the PARTITION BY RANGE clause
Be used in a materialized query table even if the table is specified WITH NO DATA
Be referenced in CHECK constraints
Have GENERATED specified
Have a FIELDPROC specified
Have AS SECURITY LABEL specified
Be added to a created temporary table
The table that contains an XML column will not have its XML column value passed to a VALIDPROC
Be part of a transition table
0
0