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 are different types of data models available? Explain with example?

0 Answers   Accenture,

---

Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,

---

How to do Data size testing? Who does this testing (Developer or tester)?

0 Answers  

---

Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,

---

Explain about ur projets on teradata???

0 Answers   Wipro,

---

Differentiate between unique key and foreign key?

0 Answers   CGI,

---

How is image stored in database?

0 Answers  

---

Differentiate between delete and truncate table?

0 Answers  

---

What are the advantages of views in a database?

0 Answers  

---

What are different types of resources?

0 Answers  

---

What is replicaset?

0 Answers  

---

How many indexes can be created on a table?

0 Answers   Abacus,

---