You Want To Track Date And Time Of The Last Write Access Per Row #36
You want to track date and time of the last write access per row?
This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Laying the Foundation - Data Types in SQL Server - Quiz No.1.
You want to track date and time of the last write access per row?
Add TIMESTAMP column to the table
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-in functions
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes