Interested to Buy Any Domain ? << Click Here >> for more details...
What is Stored procedure ?
- 4 Answers
- 10947 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
What is a Database?
Does facebook use graph database?
What is a super key?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
Under which circumstance should you create an index on a table?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Which three commands cause a transaction to end?
Can a database table exist without a primary key?
Which is the best graph database?
What is sharded database?
How to produce such kind of file?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
Is database a hardware or software?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is a database string?
