# Objectives
+ In this chapter, you will learn to:
  + Describe the reasons for using prepared statements and their limitations
  + Use `mysql` command line client to `PREPARE`, `EXECUTE`, and `DEALLOCATE` prepared statements
  + Describe the execution plan cache
  + Use prepared statements in your code by Connector API
  + Use JDBC batch processing API
------------------------------------------------------------