Week 5 Quiz

What does JDBC stand for?

• Java Database Connectivity

• Java Data Base Connection

• Java Driver Connection

• Java Dynamic Binding

Which class is the core interface for interacting with a database in JDBC?

• Connection

• Statement

• ResultSet

• Driver

What is the purpose of the DriverManager class in JDBC?

• To establish a connection to the database.

• To execute SQL queries.

• To store the results of a query.

• To load the database driver.

What is a PreparedStatement object in JDBC?

• A pre-compiled SQL statement that improves performance.

• A statement that can be executed multiple times with different parameters.

• A statement used for inserting data into the database.

• A statement used for retrieving data from the database.

How do you handle exceptions that might occur during database operations in JDBC?

• Using try-catch blocks.

• By throwing custom exceptions.

• By using the throws keyword.

• All of the above.

What is the purpose of the ResultSet interface in JDBC?

• To store the results of a database query.

• To execute SQL queries.

• To establish a connection to the database.

• To load the database driver.

How do you close database resources (Connection, Statement, ResultSet) properly?

• By using the finally block.

• By calling the close() method on each resource.

• By using a try-with-resources statement.

• All of the above.

What are the benefits of using a database for task storage compared to file-based storage?

• Improved data security and reliability.

• Better performance for large datasets.

• Easier data sharing and collaboration.

• All of the above.

How can you ensure data integrity when using JDBC for database interactions?

• By using transactions.

• By validating user input.

• By implementing proper error handling.

• All of the above.

What is the importance of testing database connectivity and operations thoroughly?

• To ensure data is stored and retrieved correctly.

• To identify and fix potential database-related issues.

• To improve the overall stability and reliability of the application.

• All of the above.