What are the benefits of using prepared statements ? Does that benefit extend only if similar prepared statements are used within a application or it extends even with multiple applications having similar prepared statement ?

Interview Questions and Answers

Q1. What are the benefits of using prepared statements ? Does that benefit extend only if similar prepared statements are used within a application or it extends even with multiple applications having similar prepared statement ?

Database

Ans. Prepared Statements helps in reuse of database execution plan which can be cached at Database level and hence helps achieving faster execution and performance. As cached ps objects are creating at Database level and not application level, the use and benefit extends across multiple applications.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Prepared statements benefits of prepared statements Asked in 1 Companies}

Try 1 Question(s) Test

Related Questions

What are the benefits of using Prepared statements ?

Where the prepared Statement object creating - In Java application or DB ?

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.