Answer Posted / md. aftab alam

It is a part of the table definition that are used to limit the values entered into its columns.its type are
1. Not null
2. Unique
3. primary key
4. Ckeck
5. Reference key

How to create new databases with "create database" statements?

1015

---

What to perform pattern match with the like operator?

874

---

What is bcnf normalization form?

1103

---

Explain the difference between delete,drop and truncate in SQL Server?

1087

---

How many databases instances are there in sql server 2000?

1091

---

What is isolation levels?

1019

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1063

---

How to Insert multiple rows with a single insert statement?

1044

---

What is create command?

962

---

What are the different authentication modes in sql server? How can it be changed?

1073

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1084

---

What are audit control procedures?

981

---

Name few endpoints exposed by ssrs 2012?

355

---

Define the one-to-one relationship while designing tables.

898

---

What happens when transaction log is full?

923

---