> > >

Microsoft SQL Server MCQs

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)

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

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

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

XML cannot be inserted into database

XML can be inserted but syntax in all queries is wrong

Answer

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

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

Microsoft SQL Server MCQs

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)

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)