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
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 to do Data integrity testing? Who does this testing (Developer or tester)?
Explain artificial key?
Explain inner and outer joins with examples.
What is the concept of Virtual field?
What is database collection?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Is redis in memory database?
What is a trace file?
Explain entity ?
Does facebook use graph database?
Display the employees whose salary is less than average salary.
How to do performance tunning a database in DB2 V8.2 UDB in linux
What is the best database?
what are wrappers and build ups and what it's use?