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

Answer / siva kishore

Def:- Stored Procedure is a set of pre-compiled sql statements.

Advantages:
* No need to compile the sql queries again n again when
using frequently.

* Increases execution performance and also reduces the
burden on the database connection.

Answer / ravishankar

Stored procedures are pre-compiled object in the Database
which is used to reduce the network traffic.

Answer / arshi

Stored procedure is bunch of query. it more beneficial
then query.

What is the candidate key used for?

0 Answers   BirlaSoft,

---

What does currency type mean in database?

0 Answers   Amazon,

---

Explain storage manager?

0 Answers  

---

diff b/w inter process and in process

0 Answers   Aptara, TCS,

---

How heap is implemented in database?

0 Answers   Amazon,

---

---

What is a database example?

0 Answers  

---

Write a query to retrieve for many to many relationships?

0 Answers   CGI,

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

0 Answers   3i Infotech,

---

What is the use of graph database?

0 Answers  

---

Explain entity set?

0 Answers  

---

List various types of log-based recovery in DBMS.

0 Answers   Verifone,

---

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

---