SQL Server Database Fundamentals

Casual Mode - Take your time!

1 / 20
✓
Correct
0
✗
Incorrect
0
★
Score
0%
Multiple Choice

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

  1. Add a TIMESTAMP column to the table; SQL Server will automatically track date and time of every change.
  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 functions
Change Mode