Answer Posted / haritha

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

What is the temp table?

539

---

how many no of arguments can be passed in procedures and functions

4768

---

Where views are stored in sql server?

557

---

Explain trigger classes i.e. Instead of and after trigger?

483

---

What is the primary use of the model database?

613

---

---

Which sql server table is used to hold the stored procedure scripts?

603

---

between cast and convert which function would you prefer and why?

528

---

Explain SSRS Architecture?

139

---

explain the storage models of olap? : Sql server database administration

512

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

5755

---

What are the essential components of sql server service broker?

556

---

What is attribute hierarchy? : sql server analysis services, ssas

513

---

What is the new security features added in sql server 2016? : sql server security

610

---

Do you know the policy based administration feature of sql server 2008?

571

---

What stored by the model?

544

---