MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
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 assign getdate() as the default value |
| C. | Add a DATETIME column to the table and write a trigger that sets its value |
| D. | Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions |
| Answer» B. Add a DATETIME column to the table and assign getdate() as the default value | |