Which of the following defines a table column named ErrorData that can contain X

Question

Which of the following defines a table column named ErrorData that can contain XML data and that will be validated using an XML schema named ErrorDataSchema?
Assume that the column can’t contain null values.

ErrorData xml (ErrorDataSchema) NOT NULL

ErrorData xml (ErrorDataSchema) NULL

ErrorData xml = NOT NULL

Error xml (ErrorDataSchema) NOT NULL

2.

If you want to make sure that the data you attempt to store in the xml data type is valid, you can

convert the data to the varchar type

none of the above

specify an XSD for the xml data type when you define a column or variable

use the ISVALID function to check the data before storing it as XML

3.

What can you call the set of rules that an XML document must follow to be valid?

XML schema

XML tag

XML namespace

XML rulebook

4.

What is used to structure the data in an XML document?

root tags

XML tags

parent tags

start tags

ErrorData xml (ErrorDataSchema) NOT NULL

ErrorData xml (ErrorDataSchema) NULL

ErrorData xml = NOT NULL

Error xml (ErrorDataSchema) NOT NULL

Explanation / Answer

1.-- a ErrorData XML(ErrorDatSchema) NOT NULL // ErrorData is column name , XML is data type , not null constraint

2-- c. specify an XSD for the XML data type when you define a column or variable

XSDs are documents that specify the structure of an XML document and help in their validation

3-- a .xml schema

XML must be well-formed, and valid. This means that it contains a reference to a Document Type Definition (DTD) and that its elements and attributes are declared in that DTD and follow the grammatical rules for them that the DTD specifies. DTD is an example of a Schema.

4-- b.XML tags

we identify each and every line using tags

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.