Answer Posted / prashanthi g

Types of StoredProcedures

1.Userdefined StoredProcedures
2.SystemDefined storedprocedure
3.Temporary
4.Remote
5.Extended

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

936

---

What is sql server locking?

1034

---

do you know how to configure db2 side of the application? : Sql server database administration

1093

---

Explain an automatic checkpoint

1011

---

Explain what is the purpose of sql profiler in sql server?

1126

---

How to create a dml trigger using create trigger statements?

1081

---

What is dbcc?

1179

---

What is 'Join' and explain its various types.

1211

---

What do you mean by an execution plan? How would you view it?

958

---

Do you know what is openxml in sql server?

1113

---

Explain transaction server implicit?

1026

---

What is read committed?

1169

---

Suggest a method of joining two tables.

1228

---

What are scheduled tasks in sql server?

1135

---

What is normalization 1nf 2nf 3nf?

1107

---