Answer Posted / manoj kumar

Contraint is a provision to limit or enforce the data in
the sql tables. It is of five types:-
1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1036

---

What is the full form of dql?

935

---

Why and when do stored procedure recompile?

939

---

What are the advantages of passing name-value pairs as parameters?

1119

---

Why do we need normalization?

882

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

911

---

Is it safe to delete log files?

873

---

What is awe?

959

---

Can multiple columns be used in sql group by clause in ms sql server?

998

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

892

---

How to move database physical files in ms sql server?

967

---

What is dbcc? Give few examples.

962

---

How many triggers are possible per table?

1047

---

Define right outer join in sql server joins?

990

---