Answer Posted / nitin bisht

A stored procedure is a group of Transact-SQL statements
compiled into a single execution plan.

Stored procedures return data in four ways:
* Output parameters, which can return either data (such
as an integer or character value) or a cursor variable
(cursors are result sets that can be retrieved one row at a
time).
* Return codes, which are always an integer value.
* A result set for each SELECT statement contained in
the stored procedure or any other stored procedures called
by the stored procedure.
* A global cursor that can be referenced outside the
stored procedure.

What are different types of blocks used in stored procedure?

1073

---

Explain entity type?

950

---

What is the best database software for small businesses?

876

---

Explain entity set?

962

---

What are indexes in oracle?

1047

---

What is the function of cluster index?

1105

---

How much does it cost to build a database?

969

---

Explain buffer manager?

902

---

How do you pass parameter in stored procedure?

1155

---

What are the types of joins?

1034

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1880

---

What are different types of joins used in?

1058

---

What is a sequence? Explain it with one example?

1113

---

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8442

---

how do you do sql tuning?

2051

---