1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Why we use stored procedure instead of query?

Question Posted / nani


Why we use stored procedure instead of query?..

Answer / Idreesh Ahamad

Stored procedures are pre-compiled SQL scripts that can be reused multiple times in a database. They offer several advantages over regular queries: improved performance due to pre-compilation and execution plan caching, enhanced security through parameterization, and the ability to perform complex business logic.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between trigger and constraint?

3 Answers   HSBC,

Is keyword pl sql?

1 Answers  

What is AUTH_ID and AUTH_USER in pl/sql ?

1 Answers   INDUS,

What is the life of an sql statement?

1 Answers  

what is index? : Sql dba

1 Answers  

How can use stored procedures in sql?

1 Answers  

What is the size of partition table?

1 Answers  

When are we going to use truncate and delete?

1 Answers  

Differentiate pl/sql and sql?

1 Answers  

Explain the purpose of %type and %rowtype data types?

1 Answers  

Does pdo prevent sql injection?

1 Answers  

what is collation? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories