Answer Posted / pramod tiwari,mba-it,lpu

SQL Constraints-
Constraints are used to limit the type of data that can go
into a table.

Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).

We will focus on the following constraints:

•NOT NULL
•UNIQUE
•PRIMARY KEY
•FOREIGN KEY
•CHECK
•DEFAULT

‘Order by’ is not allowed in a view how can you sort information from a view?

1019

---

Explain the categories of stored procedure?

886

---

How to assign new column names in a view?

862

---

Do you know what is openxml in sql server?

1015

---

What is the difference between online clustering and Offline clustering?

2356

---

What is mssql?

927

---

What are the approximate numeric data types?

875

---

What are basics of policy management?

1049

---

Explain activity monitors

1004

---

What is the difference between for auto and for nested?

931

---

What happens to a statement batch if there is a compilation error?

897

---

How does Report Builder support Analysis Services cubes?

147

---

What is your recommendation for a query running very slow? : sql server database administration

993

---

Define inner join in sql server joins?

987

---

What is the difference in accessing db between sql server vs sql azure?

174

---