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

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1111

---

Describe in brief system database.

999

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1045

---

What is local temp table?

933

---

What's the information that can be stored inside a bit column?

978

---

What are joins in sql and what are the different types of joins?

993

---

Explain how you can configure a running aggregate in SSRS?

163

---

What is it unwise to create wide clustered index keys?

990

---

What is an example of a primary key?

957

---

Explain the stored procedure?

1031

---

How many servers can we create in a single subscription?

160

---

Where are stored procedures in sql server?

1050

---

How to create a simple user defined function in ms sql server?

999

---

Are null values the same as that of zero or a blank space?

1021

---

How to Insert multiple rows with a single insert statement?

1035

---