Search Interview Questions |  More than 3000 questions in repository. There are more than 900 unanswered questions. Click here and help us by providing the answer. Have a video suggestion. Click Correct / Improve and please let us know. |
|
|||
|
| |||||
| Database - Interview Questions and Answers for 'Benefits of prepared statements' - 2 question(s) found - Order By Newest | |||||
| |||||
| Ans. 1. Precompilation , DB-side caching and reuse of same execution plan leads to overall faster execution. 2. Automatic prevention of SQL injection attacks by escaping special characters | |||||
| Help us improve. Please let us know the company, where you were asked this question : | |||||
 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 ? 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 ? | |||||
| Where the prepared Statement object creating - In Java application or DB ? | |||||
| |||||
| 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 : | |||||
| 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 ? | |||||
