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?

Question

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?

Accepted Answer

D. XML

Answer

A. nvarchar(max)

Answer

B. varchar(max)

Answer

C. varbinary

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…

Question

Options

How the community answered

Community Discussion