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

How many types of objects are there?

1008

---

Explain what are sparse columns?

992

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

---

1 01 101 01010

2054

---

Ways to improve the performance of a SQL Azure Database?

125

---

List the data types available in mssql?

1033

---

What is table join?

1115

---

What is sparse columns of sql server 2008?

1057

---

How to download and install microsoft sql server management studio express?

1037

---

How to disconnect from a sql server using mssql_close()?

1109

---

Explain DBCC?

961

---

What are the new features of sql server 2012 reporting service?

133

---

Explain how you can deploy an SSRS report?

150

---

Why union all is faster than union?

913

---

Explain about remote stored procedure?

1008

---