Interested to Buy Any Domain ? << Click Here >> for more details...
What is Stored procedure ?
- 4 Answers
- 10798 Views
- IBM, iGate, Inspira Technologies, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Write a query to retrieve for many to many relationships?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is database client?
What is the Lock Based Protocol used for?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
What is the difference between a stored procedure and a query?
What is table scan and index scan?
Explain buffer manager?
define primary key index, bitmap index, hash index,virtual indwx
Explain normalization in one line?
What is the use of graph database?
what is the role of auditor in auditing data oriented applications?
How is image stored in database?
Explain the various types of normalization.
Which is the best graph database?
