• Connection of JDBC
    1. What is SQL injection? Why does a' or '1'='1 work?
    1. What does PreparedStatement do?
    1. What is DatabaseMetaData? How is it useful, and how do we use it to fetch the metadata of the DB?
    1. How can a stored procedure and a function be called using CallableStatement, and how does it return data?
    1. Create a ConnectionPool (PoolConnection + ConnectionPool with Singleton and Factory)
    1. Use of the LocalDate class
    1. What is the Joda-Time API?
    1. What is the use of var in Java (introduced recently)?
    1. What is the Properties class, and how can it be implemented?
  • JDBC with MySQL Programming Practice Questions