JDBC Quiz # 2

When a Driver Class is loaded, it creates an instance of itself and registers it with:

SocketManager

ClassManager

ConnectionManager

DriverManager

True or False? If executing a Statement object many times, a PreparedStement object will reduce execution time.

True

False

True or False? SQLWarning objects are a subclass of SQLException.

False

True

_______ extends the RowSet interface.

WebRowSet

All of the above

JoinRowSet

CachedRowSet

If the column you are interested in viewing contains an int, which of the following methods of Resultset can be used?

getString()

getInt()

getNumber()

getDate()

The Class.forname() method is used to:

Call another method

get name for the Class

register the jdbc driver

Rename class

If the ResultSet type is TYPE_FORWARD_ONLY, it implies:

the cursor can scroll backwards and forwards

the cursor can move forward in the result set

the cursor can scroll forwards and backwards

the cursor can move backards in the result set

A ______ object lets you access the data returned by an SQL statement.

Result

ResultSet

SQLCursor

ReturnSet

Which of the following is NOT needed to set up a JDBC Environment:

Database

.Net

Java

Database drivers

The SQLXML interface provides the _____ method to access its internal content.

getBinaryStream

getString

getCharacterStream

All of the above

In order to commit changes to the database, use:

confirm

save

apply

commit

If a database operation fails, JDBC raises an:

NullException

SQLException

SecurityException

AccessException

JDBC stands for _______.

Java Data Behavior Control

Java Database Connectivity

Java Direct Binary Connection

Java Database Control

What kind of database is the command jdbc:mysql:://localhost:3306/ is connecting to?

JavaDB

IBM DB2

MySQL

Microsoft Access

True or False? JDBC will work with many different database management systems.

False

True

You must register your JDBC driver in your program before using it? True or False

False

True

Which package contains the JDBC classes?

javax.swing

java.nio

java.net

java.sql

In the syntax {ts 'yyyy-mm-dd hh:mm:ss'}, ts stands for

time

date

seconds

timestamp

The most common exception you'll deal with JDBC:

ArithmeticException

NullPointerException

FileNotFoundException

SQLException

In order to undo the previous transaction, use

rollback

escape

undo

back

Autocommit must be set to false when using batch processing with Statement object? True or Flase

True

False

________ is NOT a step you must perform to process an SQL statement.

Execute the query.

Ping the data source.

Establish a database connection.

Process the ResultSet object.

A _______ is used to access the data in a ResultSet.

cursor

pointer

variable

loop

True or False? JDBC is an API to connect object and XML data sources.

True

False

_______ driver type(s) are for use over communication networks.

Type 3 and 4

Type 1 and 2

Type 1 and 3

Type 3

_______ JDBC driver type(s) can be used in either applet or servlet code.

Type 1

Type 1, 2, and 3

Type 3

Type 3 and 4

_______ driver type(s) can be used in a three-tier architecture and if the web server and DBMS are running on the same machine.

Type 1 and 2

Type 1, 2, 3, and 4

Type 2, and 3

Type 1 and 3

_______ driver type is the JDBC-ODBC bridge?

Type 4

Type 2

Type 3

Type 1

Transaction_read_committed (one example of transaction isolation level) does not alow:

Dirty reads

Clean reads

Non-Repeatable reads

Phantom Reads

If you are going to use Static SQL statements at runtime, the best JDBC interface to use is:

Statememt

StaticStatement

PreparedStatement

CallableStatement