Answer Posted / mudit

Constraint are the rules enforced on data columns on table.

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

How many types of the database links?

1119

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1010

---

How to drop an existing schema in ms sql server?

1145

---

Explain the difference between function and stored procedure?

997

---

How to update muliple row in single query?

1116

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1060

---

Explain different types of lock modes in sql server 2000?

984

---

How to list all stored procedures in the current database using ms sql server?

1194

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

959

---

What happens when transaction log is full?

992

---

How to use the inserted and deleted pseudo tables?

1004

---

What is query optimization process?

1081

---

Is a primary key unique?

1036

---

What happens if null values are involved in comparison operations?

1042

---

What is a rownum?

1060

---