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

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

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

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

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

6.
JDBC stands for:

[A] Java Database Connectivity

[B] Java Database Components

[C] Java Database Control

[D] None of the above is correct.

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.

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

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

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.

Are these questions helpful for you?

Post your questions here and start a good conversation with experties and users.

Photo

or

Java Programming - JDBC Multiple Choice Questions and Answers

Related Quizzes