Answer Posted / henry

Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null

What is role playing dimension with two examples? : sql server analysis services, ssas

1054

---

What is the meaning of sql server?

1038

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

---

what are triggers? : Sql server database administration

954

---

Can you edit the .rdl code associated with a linked report?

168

---

How can you tell if a database object is invalid?

1118

---

What is a group function explain with an example?

1040

---

What are the characteristics of modern DBMS?

1140

---

What are the approximate numeric data types?

988

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1161

---

Name few endpoints exposed by ssrs 2012?

366

---

What are the different types of triggers in SQL SERVER?

1192

---

Tell me when is the update_statistics command used?

1202

---

Explain raiserror in sql server?

1079

---

What is difference between aggregate and analytic function?

978

---