Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

898

---

What are different type of Collation Sensitivity?

994

---

What are parameterized reports?

200

---

How can a user-defined datatype be created?

981

---

What is model database in sql server?

1043

---

What is the maximum size of column in sql server?

885

---

what is the information that can be stored inside a bit column? : Sql server database administration

950

---

What is difference between equi join and inner join?

937

---

What is apply operator in sql?

1007

---

What is inner join? Explain with an example?

1205

---

Can you explain different types of locks in sql server?

939

---

What is the most common trace flags used with sql server?

1034

---

How to define the name and server for a new dsn?

1099

---

How we can compare two database data?

934

---

What is the difference between locking and multi-versioning?

981

---