JDBC Quiz

What does JDBC stand for?

• Java Database Connectivity

• Java Data Communication
  

• Java Direct Binary Communication

• Java Database Code

Which package contains JDBC classes and interfaces?

• javax.sql
• java.jdbc
• java.sql
• java.database

What is the correct order to connect to a database using JDBC?

• 1. Establish connection, 2. Load JDBC driver, 3. Create Statement, 4. Execute query, 5. Close connection, 6. Process results.
• 1. Create Statement, 2. Load JDBC driver, 3. Establish connection, 4. Process results, 5. Execute query, 6. Close connection.
• 1. Load JDBC driver, 2. Establish connection, 3. Create Statement, 4. Execute query, 5. Process results, 6. Close connection.
• 1. Load JDBC driver, 2. Create Statement, 3. Process results, 4. Close connection, 5. Execute query, 6. Establish connection.

Which JDBC interface is used to execute SQL queries?

• ResultSet
• CallableStatement
• Statement
• PreparedStatement

Which method is used to execute SELECT queries in JDBC?

• executeUpdate()
• executeStatement()
• executeQuery()
• runQuery()

What type of object does executeQuery() return?

• String
• ResultSet
• HashMap
• ArrayList

What does executeUpdate() return?

• A list of affected table names.
• An integer representing the number of rows affected.
• A string indicating the operation type.
• A boolean indicating success or failure.

Which method is used to close a Connection object?

• disconnect()
• close()
• terminate()
• endConnection()

Which interface is used to store the result returned by a SQL query?

• DataSet
• QueryResult
• SQLResponse
• ResultSet

Which JDBC class is used to execute parameterized SQL statements?

• PreparedStatement
• ResultSet
• QueryBuilder
• StatementExecutor