Answer Posted / vinod

Constraints are used to restrict the insertion of unwanted data.
Using constraints you can maintain data integrity by preventing invalid data being entered.

Constraints are Five type
Primary key
Unique Key
Foreign Key
Not Null
Check

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

972

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

969

---

Explain sql delete command?

1034

---

How to add the custom code in Report?

126

---

Give main differences between "Truncate" and "Delete".

1086

---

What is dirty page?

963

---

What is a trigger and types of a trigger?

975

---

How to create an index on a view?

1058

---

What are policy management terms?

975

---

What is the purpose of the tempdb database?

989

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1375

---

Explain what are magic tables in sql server?

983

---

What is the use of toad or sqldbx.?

1143

---

Explain Geography datatype in SQL Server

1115

---

What is order of B+tree?

1101

---