Answer Posted / shelly

Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.

1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default

what are the core components of SSRS?

129

---

What is database replication? What are the different types of replication you can set up in sql server?

959

---

Explain the properties of subqueries in sql server?

1082

---

How can we delete a table in sql server?

976

---

What are window functions in sql server?

1009

---

What is a trigger and its types?

991

---

what is raid? : Sql server database administration

1041

---

What is self contained multi valued query?

1020

---

Write a sql query to display the current date?

1095

---

Which are the two editions in which SQL Azure database available?

119

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

985

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

---

Explain alternate key, candidate key and composite key in sql server?

916

---

How many categories of data types used by sql server?

1020

---

Explain logical operators in sql server?

1110

---