Java Programming - JDBC Multiple Choice Questions and Answers

JDBC is a Java-based data access technology (Java Standard Edition platform) from Oracle Corporation. Java Programming Multiple Choice Questions and Answers on JDBC for Interviews.
1. The JDBC-ODBC bridge is
[A] Multithreaded
[B] Singlethreaded
[C] Both of the above
[D] none of the above
Loading...
2. Which statements about JDBC are true?
[A] JDBC is an API to connect to relational-, object- and XML data sources
[B] JDBC stands for Java DataBase Connectivity
[C] JDBC is an API to access relational databases,
[D] JDBC is an API to bridge the object-relational mismatch between OO programs and relational databases
Loading...
3. Which packages contain the JDBC classes?
[A] java.jdbc and javax.jdbc
[B] java.jdbc and java.jdbc.sql
[C] java.sql and javax.sql
[D] java.rdb and javax.rdb
Loading...
4. Which type of driver provides JDBC access via one or more ODBC drivers?
[A] Type 1 driver
[B] Type 2 driver
[C] Type 3 driver
[D] Type 4 driver
Loading...
5. Which type of driver converts JDBC calls into the network protocol used by the database management system
directly?
[A] Type 1 driver
[B] Type 2 driver
[C] Type 3 driver
[D] Type 4 driver
Loading...
6.
JDBC stands for:

[A] Java Database Connectivity
[B] Java Database Components
[C] Java Database Control
[D] None of the above is correct.
Loading...
7. What MySQL property is used to create a surrogate key in MySQL?

A. UNIQUE
B. SEQUENCE
C. AUTO_INCREMENT
D. None of the above -- Surrogate keys are not implemented in MySQL.
[A] UNIQUE
[B] SEQUENCE
[C] AUTO_INCREMENT
[D] None of the above -- Surrogate keys are not implemented in MySQL.
Loading...
8.
________ is an open source DBMS product that runs on UNIX, Linux and Windows.

[A] MySQL
[B] JSP/SQL
[C] JDBC/SQL
[D] Sun ACCESS
Loading...
9.
Which JDBC driver Type(s) can be used in either applet or servlet code?

A. Both Type 1 and Type 2
B. Both Type 1 and Type 3
C. Both Type 3 and Type 4
D. Type 4 only
Answer & Explanation
Answer: Option C
[A] Both Type 1 and Type 2
[B] Both Type 1 and Type 3
[C] Both Type 3 and Type 4
[D] Type 4 only
Loading...
10. Where is metadata stored in MySQL?

[A] In the MySQL database metadata
[B] n the MySQL database metasql
[C] In the MySQL database mysql
[D] None of the above is correct.
Loading...
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)