Q:

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

0

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


  1. Add TIMESTAMP column to the table
  2. Add a DATETIME column to the table and assign getdate() as the default value
  3. Add a DATETIME column to the table and write a trigger that sets its value
  4. Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Correct Answer:

A.Add TIMESTAMP column to the table

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Microsoft SQL Server MCQ Quiz (Multiple Choice Questions And Answers)

Similar questions


need a help?


find thousands of online teachers now
______________ is monetary data type in SQL Server... >>
<< Which of the following data type is not present in...