What is the timestamp datatype used for?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the timestamp datatype used for?

Answer: This is a binary number that uniquely marks a row in a database.

Explanation: The timestamp datatype is an automatically generated binary number that is unique within a database. It is used to version stamp rows for changes.

(Continued on next question...)

Other Job Interview Questions

• What does SEND do in SQL Server 2005?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• How do you recover the snapshot?
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What port do you need to open on your server firewall to enable named pipes connections?
• Which framework would you use to manage this database programatically?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• More...