Answer Posted / vijaya

Constraints are rool of data integrity.

Types of Constraints are:
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References.

What is merge statement?

800

---

What is a raid and what are different types of raid configurations?

845

---

Explain user defined views?

746

---

What is dbcc updateusage?

847

---

What command is used to rename the database?

682

---

---

how you can list all the tables in a database?

739

---

How is table type constraint applied to a table?

733

---

How do I create a stored procedure in sql server?

690

---

what information is maintained within the msdb database? : Sql server administration

700

---

Give me any three differences between Truncate and Delete.

759

---

Why de-normalization required?

737

---

Explain the collation?

824

---

Do you have any idea about the tcl commands?

716

---

What are the advantages of mirroring?

736

---

How will you add a dimension to cube? : sql server analysis services, ssas

748

---