SQL Server Database Fundamentals

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 20

You want to track date and time of the last write access (INSERT, UPDATE) per row. How can you achieve that?

Select Your Answer:

Add a TIMESTAMP column to the table; SQL Server will automatically track date and time of every change.

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

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

Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built functions

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current