Java Database Connectivity MCQ

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

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

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

4. 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?

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

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

7. Microsoft has introduced UDA as an umbrella term that covers?

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?

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

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

11. Which models does JDBC API supports for database access?

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

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

14. Why do you need the JDBC API?

15. 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?