Question

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

Posted under SQL Server

Answer: (a).Add TIMESTAMP column to the table

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Add Comment

Similar Questions

Discover Related MCQs

Q. ________ is a spatial data type.

View solution

Q. Which of the following data type is not present in SQL Server?

View solution

Q. ______________ is monetary data type in SQL Server.

View solution

Q. Which of the data type has a storage size of 8 bytes?

View solution

Q. ______________ function returns current date and time.

View solution

Q. Which of the following function checks whether the expression is a valid date or not?

View solution

Q. Which of the following is not a mathematical function?

View solution

Q. @@NESTLEVEL function falls under which of the following category?

View solution

Q. __________ are used for supporting encryption, decryption, digital signing and their validation.

View solution

Q. DecryptByKeyAutoCert is ________________ type function.

View solution

Q. Text and Image Functions are ___________

View solution

Q. Which of the following is not a conversion function?

View solution

Q. ______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.

View solution

Q. Built in Functions in SQL Server is categorized into how many categories?

View solution

Q. Which SQL function is used to count the number of rows in a SQL query?

View solution

Q. Which of the following SQL clauses is used to DELETE tuples from a database table?

View solution

Q. ___________removes all rows from a table without logging the individual row deletions.

View solution

Q. Which of the following is not a DDL command?

View solution

Q. Which of the following are TCL commands?

View solution

Q. ________________ is not a category of SQL command.

View solution

View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...