Elance JDBC Test Answers 2015



JDBC is an API for the _________ programming language.

ABAP
PHP
Java
C#

 

 

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

Type 1 and 3
Type 3 and 4
Type 3
Type 1 and 2

 

 

Which object has the ability to use input and output streams to supply parameter data?

StreamingStatement
PreparedStatement
Statement
CallableStatement

 

 

In order to access Database stored procedures, the best JDBC interface is:

ProcedureStatement
CallableStatement
Statememt
PreparedStatement

 

 

To jump back to a specific point in the program, create a:

Marker
Reference
Anchor
Savepoint

 

 

To close existing database connections, you should call

shutdown() method
close() method
escape() method
exit() method

 

 

In the command jdbc:derby:testdb;create=true, testdb stands for

Port name
Client name
Database name
Server name

 

 

In order to accept input parameters at runtime, use the following JDBC interface:

ParameterStatement
Statement
RuntimeStatement
PreparedStatement

 

 

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

Result
ReturnSet
ResultSet
SQLCursor

 

 

If the ResultSet type is TYPE_FORWARD_ONLY, it implies:

the cursor can scroll forwards and backwards
the cursor can move forward in the result set
the cursor can scroll backwards and forwards
the cursor can move backards in the result set

 

 

If a database operation fails, JDBC raises an:

SecurityException
AccessException
SQLException
NullException

 

 

JDBC stands for _______.

Java Data Behavior Control
Java Direct Binary Connection
Java Database Connectivity
Java Database Control

 

 

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

IBM DB2
MySQL
JavaDB
Microsoft Access

 

 

In order to undo the previous transaction, use

rollback
back
escape
undo

 

 

Which package contains the JDBC classes?

java.nio
javax.swing
java.net
java.sql

 

 

The most common exception you'll deal with JDBC:

ArithmeticException
NullPointerException
SQLException
FileNotFoundException

 

 

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

time
date
seconds
timestamp

 

 

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

False
True

 

 

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

All of the above
getString
getBinaryStream
getCharacterStream

 

 

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

True
False

 

 

_______ extends the RowSet interface.

WebRowSet
JoinRowSet
All of the above
CachedRowSet

 

 

In order to commit changes to the database, use:

save
apply
confirm
commit

 

 

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

.Net
Java
Database
Database drivers

 

 

______ is NOT a valid parameter mode for a stored procedure.

OUT
IN
CONSTANT
INOUT

 

 

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

False
True

 

 

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

getNumber()
getString()
getInt()
getDate()

 

 

{fn length('Friday')} will return

Friday
null
12
6

 

 

The Class.forname() method is used to:

get name for the Class
register the jdbc driver
Call another method
Rename class

 

 

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

False
True

 

 

True or False? JDBC is an API to access relational databases, spreadsheets, and flat files.

False
True

 

 

At the end of the JDBC program, it is explicity required to close al the connections to the database? True or False

False
True

 

 

Which of the following in not required by the getConnection() method to create a connecton object?

Username
Website url
Password
Database url

 

 

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

SocketManager
ClassManager
DriverManager
ConnectionManager

 

 

True or False? A transaction is closed when close() is called on the Connection object.

True
False

 

 

True or False? The RowSet object holds data in a tabular form that is more flexible and easier to use than the ResultSet object.

False
True

 

 

________ is an object used for precompiling SQL statements that may contain input parameters.

Query
Stored Procedure
Prepared Statement
Callable Statement

 

 

True or False? The default mode when a connection is created is auto-commit mode.

False
True

 

 

JDBC API uses which drivers to connect to the database?

jdbc
.Net
Microsoft
odbc

 

 

The ______ packages contain the JDBC classes.

java.sql and java.jdbc
java.jdbc and javax.jdbc
java.sql and javax.sql
java.rdb and java.sql

 

 

All JDBC Rowset objects are derived from which interface?

CallableStatement
Statement
PreparedStatement
ResultSet

 

 

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

False
True

 

 

boolean execute (String SQL) returns:

the number of rows affected by the executon of the SQL statement
boolean value of true if a resultset object can be retrieved
Returns a Resultset object
the number of columns affected by the executon of the SQL statement

 

 

A ________ is used to mark intermediate points inside a transaction in order to get a more fine-grained control.

savepoint
connection point
pointer
stored procedure

 

 

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

Process the ResultSet object.
Execute the query.
Establish a database connection.
Ping the data source.

 

 

The executeUpdate method from Statement returns:

true if the first object that the query returns is a ResultSet object
multiple ResultSet objects
one ResultSet object
an integer representing the number of rows affected by the SQL statement

 

 

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

True
False

 

 

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

loop
variable
pointer
cursor

 

 

A ______ is not contained in an SQLException.

description of the error
SQLState code
error code
effect

 

 

_____ will create a RowSet object.

Using an instance of RowSetFactory, which is created from the class RowSetProvider
Using the reference implementation constructor that takes a Connection object
Using the reference implementation default constructor
All of the above

 

 

Which of the following is not an overloaded DriverManager.getConnection () method?

getConnection(String url, String user, String password)
getConnection(String url, Properties prop)
getConnection(String url)
getConnections()

 

 

The _______ method adds SQL commands to the list associated with a Statement object.

select
addBatch
addSQL
updateList

 

 

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

Type 1
Type 3
Type 1, 2, and 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 2, and 3
Type 1, 2, 3, and 4
Type 1 and 3

 

 

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

Dirty reads
Clean reads
Non-Repeatable reads
Phantom Reads

 

 

public void updateString(int columnIndex, String s) throws SQLException

Changes the String in the specified column specified by its name to the value of s
Changes the String in the specified row specified by its name to the value of s
Changes the String in the specified column specified by its index to the value of s
Changes the String in the specified row specified by its index to the value of s

 

 

_______ driver type is the JDBC-ODBC bridge?

Type 2
Type 1
Type 4
Type 3

 

 

Which of the following parameters is used by the Preparedstatement object?

OUT
INOUT
IN
OR

 

 

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

StaticStatement
CallableStatement
Statememt
PreparedStatement

 

 

_______ is not a method of a ResultSet cursor.

beforeFirst
end
next
previous

 

 

While accessing databses such as Oracle, Sybase or IBM, the preferred driver type is:

Type 4: 100% Pure Java
Type 3: JDBC-Net pure Java
Type 1: JDBC-ODBC Driver Bridge
Type 2: JDBC-Native API

 

 

A ________ is a subclass of SQLException.

Exception
SQLWarning
SQLError
SQLMethod

 

 

A _______ is a set of one or more statements that is executed as a unit.

stored procedure
prepared statement
transaction
callable statement

 

 

The DATALINK SQL data type maps to the JDBC _____ object.

Ref interface
java.net.URL
java.net
SQLXML interface

 

 

_______ is NOT a valid example of a transaction isolation level.

TRANSACTION_READ_COMMITTED
TRANSACTION_READ_UNCOMMITTED
TRANSACTION_REPEATABLE_COMMIT
TRANSACTION_REPEATABLE_READ

 

 

_______ is not a valid ResultSet type.

TYPE_BACKWARD_ONLY
TYPE_SCROLL_SENSITIVE
TYPE_SCROLL_INSENSITIVE
TYPE_FORWARD_ONLY

 

 

Which driver type is best suited for development and testing purpose?

Type 2: JDBC-Native API
Type 4: 100% Pure Java
Type 1: JDBC-ODBC Driver Bridge
Type 3: JDBC-Net pure Java

 

 

The _______ of a ResultSet object determines what level of update functionality is supported.

concurrency
class
holdability
type

 

 

True or False? MySQL and Java DB support the ARRAY SQL data type.

True
False

 

 

Which of the following is not an Advanced Data type in JDBC API?

varbinary (max)
DATALINK
Structured type
ROWID

 

 

For storing file into the database, which datatype is used in table?

DATALINK
BLOB
CLOB
NLOB

 

 

______ is NOT a subclass of SQLException

BatchUpdateException
SQLTransientException
SQLFailureException
SQLNonTransientException

 

 

True or False? Applications may release Blob, Clob, and NClob resources by invoking their release method.

True
False

 

 

True or False? After fetching an instance of the Connection object, a live connection must first be established before making queries to the database.

False
True

 

 

Resources used by Blob, Clob an NClob Java objects can be released by using which method?

close
exit
free
release

 

 

If your Java aplication is accessing multiple databases at the same time, the preferred driver type is:

Type 4: 100% Pure Java
Type 2: JDBC-Native API
Type 3: JDBC-Net pure Java
Type 1: JDBC-ODBC Driver Bridge

 

 

True or False? The list associated with a Statement object may contain a statement that produces a ResultSet object.

True
False

 

 

True or False? A transaction is finished when commit() or rollback() is called on the Transaction object.

False
True

 

 

General SQL escape syntax format is:

[keyword 'parameters']
(keyword 'parameters')
{keyword 'parameters'}
{keyword "parameters"}

 

 

A ______ RowSet object makes a connection to a data source only to read or write data based on a ResultSet object.

transient connected
disconnected
overloaded
connected