PrepAway - Latest Free Exam Questions & Answers

Which data type should you use?

You are designing a database that contains a data definition language (DDL) trigger. The DDL trigger will provide the maximum amount of data available when any attempt is made to change the database schema. You need to design a table to meet the following requirements:
* Accept the EVENTDATA information that is provided by the trigger
* Support the searching and retrieval of nodes and values
* Minimize development time
Which data type should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
nvarchar(max)

B.
varchar(max)

C.
varbinary

D.
XML


Leave a Reply