Java Reference
In-Depth Information
Review Questions
1.
What does JDBC stand for?
2.
If you have a JDBC driver that was provided by your database vendor, written entirely
in Java, what type of driver do you probably have?
a.
type 1
b.
type 2
c.
type 3
d.
type 4
3.
If you have a JDBC driver that works on multiple databases from different vendors,
what type of driver do you probably have?
a.
type 1
b.
type 2
c.
type 3
d.
type 4
4.
If you have a JDBC driver that requires a middleware application to convert the JDBC
calls into native calls using an intermediate protocol, which type of driver do you
have?
a.
type 1
b.
type 2
c.
type 3
d.
type 4
5.
How do you load a JDBC driver so that it is available in your Java application?
6.
If I am using the JDBC-ODBC bridge driver that comes with the J2SE and my database
has a data source name of “contactsDSN”, what is the URL used to connect to this
database using the getConnection() method?
7.
Describe the result set of the SQL statement:
SELECT * FROM SomeTable WHERE someColumn LIKE '%java%'
8.
List the three types of statements you can create from a java.sql.Connection object.
9.
Suppose that you want to execute an SQL statement once. Which of the three types of
statements would best fit this situation?
10.
Suppose you want to execute an SQL statement repeatedly. Which of the three types
of statements would best fit this situation?
11.
What is the parent interface of PreparedStatement?
