Answer / muhammad usman(lahore)

An extended stored procedure is simply a procedure that is
implemented in a dynamic link library (DLL) — a library
that is called by an application at runtime. Extended
stored procedures can be used in much the same way as
database stored procedures, except that extended stored
procedures normally perform tasks related to the
interaction of SQL Server with its operating environment

What is an application role and explain a scenario when you would use one?

1 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Explain about a primary key?

1 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

1 Answers  

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

What is the physical representation for a many-to-many relationship?

1 Answers  

---

what is difference between primary key and unique key ?

2 Answers  

---

Explain about query and reporting.

1 Answers  

---

What is a database development?

1 Answers  

---

How can you fix a poorly performing query?

1 Answers  

---

Explain the process of the user request and data generating?

1 Answers  

---

What is dbms and its application?

1 Answers  

---