Java Database Connectivity MCQs
Java Database Connectivity MCQs
Answer these Java Database Connectivity MCQs and assess your grip on the subject of Java Database Connectivity. Scroll below and get started!
1: 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?
A. 2
B. 4
C. 3
D. 5
2: Why do you need the JDBC API?
A. A literal translation of the ODBC C API into a Java API would not be desirable
B. All
C. ODBC is not appropriate for direct use from the Java programming language because it uses a C interface
D. ODBC is hard to learn
3: Which method is used for an SQL statement that is executed frequently?
A. PrepareStatement
B. None
C. CreateStatement
D. PrepareCall
4: In which model a Java applet or application talks directly to the data source?
A. Three-tier models And Two-tier models
B. None
C. Three-tier models
D. Two-tier models
5: Which models does JDBC API supports for database access?
A. Two-tier models
B. None
C. Three-tier models
D. Three-tier models And Two-tier models
6: In which the JDBC type represents a "single precision" floating point number that supports seven digits of mantissa?
A. Float
B. Integer
C. Double
D. REAL
7: Which method is used for retrieving streams of both ASCII and Unicode characters is new in the JDBC 2.0 core API?
A. GetAsciiStream
B. GetUnicodeStream
C. GetBinaryStream
D. GetCharacterStream
8: 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?
A. CLOB
B. Array
C. BLOB
D. DISTINCT
9: Microsoft has introduced UDA as an umbrella term that covers?
A. ADO
B. All
C. OLE DB
D. RDS And ODBC
10: The JDBC API is what allows access to a data source from a Java middle tier?
A. True
B. False
11: JDBC technology-based drivers generally fit into how many categories?
A. 3
B. 7
C. 6
D. 4
12: 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?
A. JDBC API
B. ODBC API
C. None
D. JDBC API And ODBC API
13: Drivers that are JDBC Compliant should normally support scrollable result sets, but they are not required to do so?
A. False
B. True
14: Which list gives a quick way to determine which Connection method is appropriate for creating different types of SQL statements?
A. CreateStatement
B. All
C. PrepareStatement
D. PrepareCall
15: In Advanced JDBC Data types which have defined new data types that are commonly referred to as SQL3 types?
A. ISO( International Organization for Standardization) And IEC( the International Electrotechnical Commission)
B. IEC( the International Electrotechnical Commission)
C. None
D. ISO( International Organization for Standardization)
List of Java Database Connecti...
Available in:
Java Database Connectivity MCQs
