> > Java MCQs > Java Database Connectivity MCQs

Java Database Connectivity MCQ

In Advanced JDBC Data types which have defined new data types that are commonly referred to as SQL3 types?

ISO( International Organization for Standardization) And IEC( the International Electrotechnical Commission)

IEC( the International Electrotechnical Commission)

None

ISO( International Organization for Standardization)

Answer

Correct Answer: ISO( International Organization for Standardization) And IEC( the International Electrotechnical Commission)

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

Which list gives a quick way to determine which Connection method is appropriate for creating different types of SQL statements?

CreateStatement

All

PrepareStatement

PrepareCall

Answer

Correct Answer: All

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

Drivers that are JDBC Compliant should normally support scrollable result sets, but they are not required to do so?

False

True

Answer

Correct Answer: True

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

Which was first most widely used programming interface for accessing relational databases, It offers the ability to connect to almost all databases on almost all platforms?

JDBC API

ODBC API

None

JDBC API And ODBC API

Answer

Correct Answer: ODBC API

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

JDBC technology-based drivers generally fit into how many categories?

Answer

Correct Answer: 4

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

The JDBC API is what allows access to a data source from a Java middle tier?

True

False

Answer

Correct Answer: True

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

Microsoft has introduced UDA as an umbrella term that covers?

ADO

All

OLE DB

RDS And ODBC

Answer

Correct Answer: All

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

In Which type may optionally have a custom mapping to a class in the Java programming language,A custom mapping consists of a class that implements the interface SQLData and an entry in a java.util.Map object?

CLOB

Array

BLOB

DISTINCT

Answer

Correct Answer: DISTINCT

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

Which method is used for retrieving streams of both ASCII and Unicode characters is new in the JDBC 2.0 core API?

GetAsciiStream

GetUnicodeStream

GetBinaryStream

GetCharacterStream

Answer

Correct Answer: GetCharacterStream

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

In which the JDBC type represents a "single precision" floating point number that supports seven digits of mantissa?

Float

Integer

Double

REAL

Answer

Correct Answer: REAL

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

Which models does JDBC API supports for database access?

Two-tier models

None

Three-tier models

Three-tier models And Two-tier models

Answer

Correct Answer: Three-tier models And Two-tier models

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

In which model a Java applet or application talks directly to the data source?

Three-tier models And Two-tier models

None

Three-tier models

Two-tier models

Answer

Correct Answer: Two-tier models

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

Which method is used for an SQL statement that is executed frequently?

PrepareStatement

None

CreateStatement

PrepareCall

Answer

Correct Answer: PrepareStatement

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

Why do you need the JDBC API?

A literal translation of the ODBC C API into a Java API would not be desirable

All

ODBC is not appropriate for direct use from the Java programming language because it uses a C interface

ODBC is hard to learn

Answer

Correct Answer: All

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

How many Result sets available with the JDBC 2.0 core API, The following constants, defined in the ResultSet interface, are used to specify these?

Answer

Correct Answer: 3

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