JAVA DATABASE CONNECTIVITY

Which of the following is a benefit of using JDBC in a Java application?

• Improved performance

• Platform independence

• Easy integration with databases

• All of the above

In JDBC, which interface is used to establish a connection with a database?

• Statement

• ResultSet

• Connection

• DriverManager

Which method is used to execute SQL statements in JDBC?

• executeQuery()

• executeUpdate()

• execute()

• executeBatch()

What does the acronym "CRUD" stand for in the context of database operations?

• Create, Retrieve, Update, Delete

• Connect, Retrieve, Update, Disconnect

• Compile, Run, Update, Debug

• Collect, Register, Update, Delete

How can you retrieve data from a ResultSet object in JDBC?

• Using the next() method

• Using the get() methods

• Using the fetch() method

• Using the retrieve() method

Which statement is used to insert data into a database using JDBC?

• INSERT INTO

• UPDATE

• SELECT

• CREATE

What is the purpose of using a PreparedStatement in JDBC?

• To improve performance by precompiling SQL statements

• To handle SQL exceptions

• To retrieve data from the database

• To create database tables

What is the role of a ResultSetMetaData object in JDBC?

• It provides metadata about the ResultSet object, such as column names and types.

• It executes SQL statements.

• It establishes a connection with the database.

• It retrieves data from the database.

Which of the following is NOT a type of JDBC driver?

• Type 1

• Type 2

• Type 3

• Type 4

How can you handle transactions in JDBC?

• Using the commit() method

• Using the rollback() method

• Using the setAutoCommit() method

• All of the above