1. which of the following are JDBC drivers?(chon
4)(1.5d)
A, JDBC –ODBC bridge
B ,native API party – java driver
C, Net –protoco all – java
D, ,JDBC – network driver
E, Native protocol all – java driver
2. The naming class extend the -----class
A serializable
B Object
C System
D Remote
3. -the------Class of java RMI provides stati methods for accep
A .MarshalledObject
B. Naming
C RMI Security Manager
D log Stream
E Remote Server
4 . the -----use local native libraries to commulicate with the database
A JDBC – ODBC Bridge
B native – API – Party-java driver
C ODBC net all java driver
D Native Protoco – all –java driver
5 . which interface of the JDBC API contains method used to execute SQL stored procedures (1d)
A statement
B resultset
C CallableStatement
6 which interface of the JDBC API execute pre – compied SQL statement(1d)
A preparedStatement
B statement
C Resultset
7 which of the following three interfaces the JDBC API provides for sending SQL
statements to the database? (2d)
A Statement
B PreparedStatement
C callablestatement
D Connection
E Getconnection
8 the ----- class is the traditional managerment layer of JDBC working
between the ….
The driver
a Driver manager
b Connection
c Resultset
9 The java software provides three JDBC product components they are (2d)
A The JDBC DriverManager facility
B The JDBC driver test suite
C The JDBC – ODBC bridge
D The callable stament
10 obiect is used to send SQL statement to a database
A Connection
B Statement
C Drive
11 . Which interface of the JDBC API provides mothod to sentive data that an SQL statement returns?
A ResultSet
B Statement
C Driver
D Connection
12 Which two of the following are valid JDBC driver(choose 2)
a JDBC –ODBC bridge plus ODBC driver
b native – API /partly –Java drivr
c ODBC Driver
d Native java driver
13 Which kind of driver converts ODBC calls drectly into the network protocol
A JDBC _ODBC bridge plus ODBC driver
B Native API partly java driver
C Native protocol pure java driver
14. Depending upon scrollabity how many types of result sets are av…..
A One
B Four
C three
D Two
15. Which of the following classes contain the Execute() method?
A ResultSet
B RescordSet
C Statement
D Connection
16. The method is used to retreve the name of
A getColumName()
B GetColumCaption()
C GetColumLabel()
D None of the others
17 The statement interface provides three different methods for executing SQL statement, they are (2d)
A ExecuteQuery
B ExecuteUpdate
C Execute
D ExecuteDelete
E ExecuteInsert
18 Once the Drver classes have been loaded and registered with the driver avaitable for
eatablahing a connection with a database
is the statement correct?
A true
B False
19 the method -------- is designed for statement that produce ….SELECT statement
A ExecuteUpdate
B Execute .
Tiêu đề: Đề thi lý thuyết Working with Database and Security in Java DBSJ) 
Tue May 17, 2011 10:55 pm
