Answer Posted / ramesh.n

constraints are the restrictions or limitations that are
being imposed on the columns of a table to validate the data
either for insertion or updation constraints can be imposed
either during the process of table creation of a level.

There are 8 types of constraints
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
7.composite primary key
8.composite unique key

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

1024

---

Why normalization is used?

970

---

What is the sql profiler?

908

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

856

---

What is the difference between char, varchar and nvarchar?

986

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

896

---

Explain the steps to use transact-sql cursor?

975

---

What are the different Topologies in which Replication can be configured?

1130

---

What is the return type of executeupdate ()?

869

---

How many types of stored procedures are there in sql server?

963

---

How to create “dependant” parameter “make, model, year”

124

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

949

---

What are the types of database schema? : sql server analysis services, ssas

1078

---

What are the differences between ms sql server & oracle?

1012

---

How to test subquery results with the exists operator?

1048

---