You want to track date and time of the last write access per row?

A) Add TIMESTAMP column to the table

B) Add a DATETIME column to the table and write a trigger that sets its value

C) Add a DATETIME column to the table and assign getdate() as the default value

D) Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

Correct Answer : Add TIMESTAMP column to the table

Explanation : The correct answer is Add a DATETIME column to the table and write a trigger that sets its value.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions