Answer Posted / professor r.arjunarao

TimeStamp field to detect update collisions in order to
reduce the amount of data sent to the server

example
CREATE TABLE emp (empno int PRIMARY KEY, tax int, TS timestamp)
GO
INSERT INTO emp (empno, tax) VALUES (1, 0)
GO
INSERT INTO emp (empno, tax) VALUES (2, 0)
GO
select * from emp;

1 0 0x0000000000000FA1<---Unique values
2 0 0x0000000000000FA2<---Unique values

Explain activity monitors

1076

---

What are the system database in sql server 2005?

1044

---

How to use union to merge outputs from two queries together in ms sql server?

1069

---

What is trigger and different types of Triggers?

1146

---

Can you always create a cache of a report?

172

---

What is a view and what are its advantages?

1114

---

How do I view a stored procedure in sql server query?

929

---

How to insert new line characters into strings?

991

---

Mention the different types of replication in sql server.

1026

---

How to list all stored procedures in the current database using ms sql server?

1134

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1005

---

What is Service Broker in sql server 2012?

1020

---

Explain transaction server auto commit?

1040

---

Explain what are the authentication modes in sql server?

1017

---