Quiz for Executing Queries

Q1: What does rs.getString("name") do?

A. Gets int value from ResultSet B. Fetches name as String C. Prints ResultSet D. Returns column type

Q2: Which interface is used to execute dynamic SQL queries in JDBC?

A. ResultSet B. PreparedStatement C. Statement D. CallableStatement

Q3: What does executeUpdate() return?

A. Number of rows affected B. ResultSet object C. Boolean value D. SQL query string

Q4: Which method is used to execute SELECT statements?

A. execute() B. executeQuery() C. executeUpdate() D. executeSelect()

Q5: Which class is used to execute stored procedures in JDBC?

A. PreparedStatement B. ResultSet C. CallableStatement D. Connection

Q6: Which method is used to execute INSERT, UPDATE, DELETE commands?

A. execute() B. executeQuery() C. executeUpdate() D. executeCommand()

Q7: Which object is returned by executeQuery()?

A. Statement B. ResultSet C. Connection D. CallableStatement

Q8: What is the use of setInt() method in PreparedStatement?

A. To execute SQL B. To set integer parameter in query C. To commit transaction D. To close connection

Q9: Which method is used to set a String value in PreparedStatement?

A. setInt() B. setString() C. setObject() D. setValue()

Q10: What does PreparedStatement help prevent in SQL?

A. NullPointerException B. StackOverflowError C. SQL Injection D. Deadlock

Q11: Which method can execute both queries and updates?

A. execute() B. executeQuery() C. executeUpdate() D. runQuery()

Q12: Which JDBC interface provides methods to execute SQL queries?

A. DriverManager B. Statement C. Connection D. DatabaseMetaData

Q13: Which method is used to prevent SQL injection?

A. execute() B. createStatement() C. prepareStatement() D. runQuery()

Q14: How are parameters represented in PreparedStatement SQL?

A. ? B. :param C. $1 D. @param

Q15: Which interface returns data from a SELECT query?

A. ResultSet B. Connection C. Statement D. SQLException

Q16: How do you release JDBC resources?

A. Use try-catch B. Use rollback() C. Call close() on objects D. Use exit()

Q17: How can you get metadata of a ResultSet?

A. rs.getInfo() B. rs.getMetaData() C. rs.getDetails() D. rs.meta()

Q18: What happens if you forget to close a ResultSet?

A. Exception thrown B. Memory leak risk C. SQL error D. Code won’t compile

Q19: Can one PreparedStatement be reused with different values?

A. No B. Yes C. Only for SELECT D. Only for INSERT

Q20: Which is the most secure way to insert user input into SQL?

A. String concatenation B. Statement C. PreparedStatement D. TextInput