R

Ram Sharma • 193.86K Points
Coach 

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
  • Correct Answer - Option(A)
  • Views: 116
  • Filed under category SQL Server

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on SQL Server

Q. Which of these backups are taken in full recovery models only or in bulk?

Q. What is the full form of ANSI.

Q. What is the standard form of RDBMS.

Q. SQL does not need to know

Q. Which of the following operating system is Supported by IA-64 Edition?

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

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

Q. For every unique constraint on a column, SQL server will create

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

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

Learn All SQL Server MCQs

Question analytics