JDBC Connection Interface

Question 1

Creates a statement that can b e used to send SQL statements to the database.

Answer 1

Statement createStatement()

Question 2

Creates a PreparedStatement object that can contain SQL statements. The SQL statement can have IN parameters; they may contain ‘?’ symbol(s), which are used as placeholders for passing actual values later.

Answer 2

PreparedStatement prepareStatement(String sql)

Question 3

Creates a CallableStatement object for calling stored procedures in the database. The SQL statement can have IN or OUT parameters; they may contain ‘?’ symbol(s), which are used as placeholders for passing actual values later.

Answer 3

CallableStatement prepareCall(String sql)

Question 4

Gets the DataBaseMetaData object. This metadata contains useful information, such as schema information, table information etc., which is especially useful when you don’t know the underlying database.

Answer 4

DatabaseMetaData getMetaData()

Question 5

Returns a Clob object. CLOB (Character Large Object) is a built in type in SQL; it can be used to store a column value in a row of a database table.

Answer 5

Clob createClob()

Question 6

Returns a blob object. BLOB (Binary Large Object) is a built in type in SQL; it can b e used to store a column value in a row of a database table.

Answer 6

Blob createBlob()

Question 7

When passed the schema name, it sets this Connection object to the database schema to access.

Answer 7

void setSchema(String schema)

Question 8

Returns the schema name of the database associated with this connection object; returns null if no schema is associated with it.

Answer 8

String getSchema()

Question 9

Gets a connection object from the driver manager.

Answer 9

DriverManager.getConnection()

Question 10

Closes the connection. Automatically called if try-with-resources is used.

Answer 10

close()

Question 11

Sets the auto-commit mode to true or false. By default, this is set to true.

Answer 11

void setAutoCommit(boolean autoCommit)

Question 12

Returns the auto commit mode currently set (true means auto commit mode is set, false means it is not).

Answer 12

boolean getAutoCommit()

Question 13

Creates a Savepoint object in the current transaction and returns that object.

Answer 13

Savepoint setSavepoint()

Question 14

Creates a Savepoint object in the current transaction with a name associated with it and returns that object.

Answer 14

Savepoint setSavepoint(String name)

Question 15

Removes the given Savepoint object and subsequent Savepoint objects from the current transaction.

Answer 15

void releaseSavepoint(Savepoint savepoint)

Question 16

Rolls back to the given Savepoint state. Throws a SQLException if the rollback cannot be done.

Answer 16

void rollback(Savepoint savepoint)

Question 17

Rolls back all changes made in the current transaction. Throws a SQLException if there is nothing to roll back, like if auto-commit mode is on.

Answer 17

void rollback()

Question 18

Commits all changes done so far in the transaction to the database.

Answer 18

void commit()