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........

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1108

---

What is nolock?

1038

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

1099

---

What extended events?

1062

---

Mention the different authentication modes in sql server.

1107

---

What happens when unicode strings concatenate with non-unicode strings?

1185

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1088

---

What is the new security features added in sql server 2014? : sql server security

1050

---

What is sql service broker?

1026

---

Explain table valued parameters in sql server? Why tvp used?

1068

---

What is the difference between functions and scalar functions?

1280

---

What is TDS(Tabular Data Stream) Gateway?

127

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1063

---

how can a database be repaired? : Sql server administration

1018

---

When to use Inner join & when to use subquery?

1238

---