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 to list all objects in a given schema?

996

---

Tell me what is log shipping?

942

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

994

---

Do you know what are various aggregate functions that are available?

1030

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

919

---

What is sharding?

116

---

Write a sql query to sort on different column name according to the parameters passed in the function?

856

---

Explain following error properties?

965

---

What is coalesce in sql server?

999

---

How many types of functions are there in sql server?

883

---

Difference between group by clause and having clause in SQL?

933

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

116

---

How you can get the list of largest tables in a database?

949

---

How to find table changes in sql server?

1062

---

What are information schema views?

928

---