It is class from java.lang package

It is a class from java.sql package

It is a interface from java.sql package

It is a class from java.lang package

DriverManager

JDBC driver

Connection

Statement

Statement

PreparedStatement

CallableStatement

QueryStatement

Used when you plan to use the SQL statements many times.

The PreparedStatement interface accepts input parameters at runtime.

Both of the above.

None of the above.

It is a static method from DriverManager class

It is a non static method from DriverManager class

It is a static method from DriverManager interface

It is a non static method from DriverManager interface

java.lang

java.io

java.sql

java.jdbc

JDBC is an API to connect to relational-, object- and XML data sources

DBC stands for Java DataBase Connectivity

JDBC is an API to access relational databases, spreadsheets and flat files

JDBC is an API to bridge the object-relational mismatch between OO programs and relational databases

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

ALL MENTIONED ABOVE

prepareStatement

prepareCall

createStatement

None of the above

java.jdbc and javax.jdbc

. java.jdbc and java.jdbc.sql

java.sql and javax.sql

ava.rdb and javax.rdb

Type 1 driver

Type 2 driver

Type 3 driver

Type 4 driver

Type 1 driver

Type 2 driver

Type 3 driver

Type 4 driver

By invoking the method get(…, String type) on the ResultSet, where type is the database type

By invoking the method get(…, Type type) on the ResultSet, where Type is an object which represents a database type

By invoking the method getValue(…), and cast the result to the desired Java type.

By invoking the special getter methods on the ResultSet: getString(…), getBoolean (…), getClob(…),…

By making use of the InsertStatement, DeleteStatement or UpdateStatement classes

By invoking the execute(…) or executeUpdate(…) method of a normal Statement object or a sub-interface object thereof

By invoking the executeInsert(…), executeDelete(…) or executeUpdate(…) methods of the DataModificationStatement object

By making use of the execute(…) statement of the DataModificationStatement object

registerDriver() method

Class.forName()

Both A and B

getConnection()

Call method execute() on a CallableStatement object

Call method executeProcedure() on a Statement object

Call method execute() on a StoredProcedure object

Call method run() on a ProcedureCommand object

java.sql.TimeStamp

java.sql.Time

java.io.Time

java.io.TimeStamp

java.sql.TimeStamp

java.sql.Time

java.io.Time

java.io.TimeStamp

DriverManager

JDBC driver

Connection

Statement

Used when you plan to use the SQL statements many times.

The PreparedStatement interface accepts input parameters at runtime.

Both of the above.

None of the above.

byte

short

int

long

It is a static method from DriverManager class

It is a non static method from DriverManager class

It is a static method from DriverManager interface

It is a non static method from DriverManager interface

a) java.io.date

b) java.sql.date

c) java.util.date

d) java.util.dateTime

a) Slow performance

b) Using more memory

c) Using less memory

d) Better performance

a) commits transaction after each query

b) explicitly commits transaction

c) does not commit transaction automatically after each query

d) never commits transaction

a) Statement

b) PreparedStatement

c) CallableStatment

d) CalledStatement

a) rollback()

b) rollforward()

c) deleteTransaction()

d) RemoveTransaction()