What is Stored procedure ?
- 4 Answers
- 9294 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 table scan and index scan?
Difference between sql and mysql?
What is a database lookup?
What are the advantages of using database?
What do you mean by cluster and non cluster index?
What is the candidate key used for?
What does specialization in DBMS mean?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Can you create a database in word?
What is the difference between data source and database?
Which is the best graph database?
What are the advantages of views in a database?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is the use of default key?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
