1. If you need to use a stored procedure with output
parameters, which of the following statement type should be used to call the
procedure?
- Statement
- PreparedStatement
- CallableStatement
2. From which object do you ask for DatabaseMetaData
?
A.
Connection
DriverManager
ResultSet
Driver
3.
If one
intends to work with a ResultSet,
which of
these PreparedStatement
methods
will not work?
A.execute()
- executeQuery()
- executeUpdate()
4.
Which character is used to represent an input
parameter in a CallableStatement?
A.
%
*
?
#
5.
Which one
of the following will not get the data from the first column of ResultSet rs,
returned from executing the following SQL statement: SELECT name, rank,
serialNo FROM employee.?
A.rs.getString(0)
- rs.getString(“name”)
- rs.getString(1)
6.
Which class or interface contains the transaction control methods setAutoCommit, commit, and rollback?
A.
Statement
Connection
ResultSet
7. What interface must all interfaces for remote services extend?
java.rmi.RemoteService
java.rmi.Remotable
java.rmi.server.Remote
java.rmi.Remote