JDBC MCQs (Chapterwise Multiple Choice Questions)

Which of the following is not an overloaded DriverManager.getConnection () method?

getConnection(String url, Properties prop)

getConnection(String url, String user, String password)

getConnections()

getConnection(String url)

Answer & Explanation

Correct Answer: getConnections()

Note: This Question is unanswered, help us to find answer for this one

_______ driver type(s) can be used in a three-tier architecture and if the web server and DBMS are running on the same machine.

Type 1 and 2

Type 1, 2, 3, and 4

Type 2, and 3

Type 1 and 3

Answer & Explanation

Correct Answer: Type 1, 2, 3, and 4

Note: This Question is unanswered, help us to find answer for this one

_______ is not a valid ResultSet type.

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

TYPE_BACKWARD_ONLY

TYPE_FORWARD_ONLY

Answer & Explanation

Correct Answer: TYPE_BACKWARD_ONLY

Note: This Question is unanswered, help us to find answer for this one

Which of the following is not an Advanced Data type in JDBC API?

ROWID

DATALINK

Structured type

varbinary (max)

Answer & Explanation

Correct Answer: varbinary (max)

Note: This Question is unanswered, help us to find answer for this one

JDBC API uses which drivers to connect to the database?

jdbc

.Net

odbc

Microsoft

Answer & Explanation

Correct Answer: jdbc

Note: This Question is unanswered, help us to find answer for this one

_____ will create a RowSet object.

All of the above

Using the reference implementation constructor that takes a Connection object

Using an instance of RowSetFactory, which is created from the class RowSetProvider

Using the reference implementation default constructor

Answer & Explanation

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

General SQL escape syntax format is:

{keyword "parameters"}

[keyword 'parameters']

(keyword 'parameters')

{keyword 'parameters'}

Answer & Explanation

Correct Answer: {keyword 'parameters'}

Note: This Question is unanswered, help us to find answer for this one

True or False? JDBC is an API to connect object and XML data sources.

True

False

Answer & Explanation

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

True or False? MySQL and Java DB support the ARRAY SQL data type.

False

True

Answer & Explanation

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Which package contains the JDBC classes?

javax.swing

java.nio

java.net

java.sql

Answer & Explanation

Correct Answer: java.sql

Note: This Question is unanswered, help us to find answer for this one

JDBC Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.