Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

  • (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
πŸ’¬ Discuss
βœ… Correct Answer: (A) Add TIMESTAMP column to the table

You must be Logged in to update hint/solution

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
195
Total Visits
πŸ“½οΈ
4 y ago
Published
πŸŽ–οΈ
Ram Sharma
Publisher
πŸ“ˆ
91%
Success Rate