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

Can you move the resources after pausing the node? : sql server database administration

1163

---

What happens if you are trying to access a schema not owned by you?

1020

---

What are the fixed server level roles? : sql server security

1219

---

what are defaults? : Sql server database administration

1162

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1023

---

What is the difference between left and right outer join?

1113

---

What are different types of table joins?

1052

---

Name 3 ways to get an accurate count of the number of records in a table?

1086

---

Scalability, Availability, Integration with internet, etc.)?

2934

---

How can you check the level of fragmentation on a table?

1087

---

Which autogrowth database setting is good?

1096

---

Can primary key be a foreign key?

1109

---

Should you normalize audio?

1004

---

Explain about local stored procedure?

1028

---

How to create a trigger for insert only?

1084

---