which of the following insert queries will be inserted in xml field..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question:Which of the following "insert queries" will be inserted in the XML field?

The creation query of the table is:
CREATE TABLE Branches(recordID int, description XML)

A INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales</application><description>The connection timed out.</description></log>') 
B INSERT UniversalLog(recordID, description) VALUES(1, 'database unavailable') 
C INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales<description>The connection timed out') 
D XML cannot be inserted into database 
E XML can be inserted but syntax in all queries is wrong

/76

+ AnswerA

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 547

Question:Which of the following "insert queries" will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)

A INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales</application><description>The connection timed out.</description></log>')

B INSERT UniversalLog(recordID, description) VALUES(1, 'database unavailable')

C INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales<description>The connection timed out')

D XML cannot be inserted into database

E XML can be inserted but syntax in all queries is wrong

A