You want to track date and time of the last write access per row?

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

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

Explore topic-wise MCQs in SQL Server.

This section includes 2 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.	7._________ is a spatial data type.
A.	geometry
B.	sql_variant
C.	cursor
D.	all of the mentioned
Answer» C. cursor

Discussion

2.	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

Discussion

Explore topic-wise MCQs in SQL Server.

7._________ is a spatial data type.

You want to track date and time of the last write access per row?