What is Stored procedure ?
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
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is the Lock Based Protocol used for?
Explain data independence & its types.
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What advantages does DBMS have over traditional file systems?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
Is storing images in a database a good idea?
What is a trace file?
Why do we need distributed database?
If the master device is full, how do I make the master database bigger?
5. Explain about relational algebra.
How do you pass parameter in stored procedure?