Answer Posted / vijay

there are 5 types of constraints that is as follow...
1.primary key
2.not null
3.check
4.default
5.unique
this are constraints types........

how to control the amount of free space in your index pages? : Sql server database administration

1029

---

ow to bring suspect mode datbase online from scratch

1800

---

Do you know how to send email from database?

989

---

How to find the list of fixed hard drive and free space on server?

1185

---

How to disable a login name in ms sql server?

1126

---

How to convert a numeric expression from one data type to another?

1003

---

What extended events?

999

---

What are the various editions of sql server 2017 that are available in the market?

888

---

How to Check if table exists in sql server?

1120

---

What is server-level principal?

122

---

Can we deploy SSRS reports on our personal website?

168

---

How to verify the port number of the sql server?

1139

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1378

---

What is used to replicate sessions between instances in coldfusion clusters?

1066

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1050

---