JDBC

Which package provides the core JDBC classes?

• java.net

• java.lang

• java.util

• java.sql

Which method is used to establish a connection to a database in JDBC?

• connect()

• getConnection()

• openConnection()

• createConnection()

Which method is used to execute a query and obtain a ResultSet in JDBC?

• execute()

• executeUpdate()

• executeQuery()

• executeBatch()

Which interface is used to execute SQL statements in JDBC?

• Connection

• Statement

• ResultSet

• PreparedStatement

Which interface represents a table of data in a database in JDBC?

• PreparedStatement

• Connection

• Statement

• ResultSet

What is the purpose of a ResultSetMetaData?

• To retrieve metadata about the database connection

• To retrieve metadata about the result set

• To retrieve metadata about the SQL statement

• To retrieve metadata about the database schema

What does the ResultSet.next() method do in JDBC?

• Moves the cursor to the previous row in the ResultSet

• Moves the cursor to the first row in the ResultSet

• Moves the cursor to the next row in the ResultSet

• Moves the cursor to a specific row in the ResultSet

What is the purpose of the SQLException class in JDBC?

• Represents a connection to a database

• Represents an error or warning encountered during database access

• Represents a result set of a database query

• Represents a prepared statement in JDBC

The primary purpose of constraints in a database is to:

• Improve query performance

• Ensure data consistency and integrity

• Provide security for the database

• Simplify database administration

Which constraint is used to limit the values that can be stored in a column?

• Primary key constraint

• Foreign key constraint

• Check constraint

• Default constraint