The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
(a)yes    (b) No

What is the query used to display all tables names in SQL Server (Query analyzer)?
(a)select * from information_schema.tables 
(b)select * to information_schema.tables 
(c)select * to information_schema 
(d)select * to tables 

Can we implement an interface in a JSP?
(a)Yes
(b)N0
(c)None
(d)Can't say

What are the new features added to JDBC 4.0?
(a)DataSet implementation of SQL using Annotations
(b)SQL exception handling enhancements
(c)both A & B
(d)None of these

which are thw new features adding in to the JDBC 4.0 ?
(a)Auto-loading of JDBC driver class
(b)Connection management enhancements
(c)Support for RowId SQL type
(d)All of the above

Steps in writing a Java program using JDBC?
(a)Load the RDBMS specific JDBC driver because this driver actually communicates with the database 
(b)Create JDBC Statement object. This object contains SQL query.
(c)Execute statement which returns resultset(s). ResultSet contains the tuples of database table as a result of SQL query.
(d)all of above

what is the main components of JDBC ?
(a)Driver Manager (b)Driver
(c)Connection    (d)both a&b

What is JDBC Driver interface
(a)java.sql.Connection   (b)Statement
(c)java.connection  (d)both a & b

 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, spreadsheets and flat files

 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

 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

 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

Which type of Statement can execute parameterized queries?    
(a) PreparedStatement    
(b) ParameterizedStatement    
(c) ParameterizedStatement and CallableStatement    
(d) All kinds of Statements 

How can you retrieve information from a ResultSet?    
(a) By invoking the method get(..., String type) on the ResultSet, where type is thedatabase type    
(b) By invoking the method get(..., Type type) on the ResultSet, where Type is an objectwhich represents a database type    
(c) By invoking the method getValue(...), and cast the result to the desired Java type.    
(d) By invoking the special getter methods on the ResultSet: getString(...),getBoolean (...), getClob(...),...

 How can you execute DML statements (i.e. insert, delete, update) in the database?    
(a) By making use of the InsertStatement, DeleteStatement or UpdateStatement classes    
(b) By invoking the execute(...) or executeUpdate(...) method of a normal Statementobject or a sub-interface object thereof    
(c) By invoking the executeInsert(...), executeDelete(...) or executeUpdate(...)methods of the DataModificationStatement object    
(d) By making use of the execute(...) statement of the DataModificationStatement object

How do you know in your Java program that a SQL warning is generated as a result of executing a SQL statement in the database?
(a) You must catch the checked SQLException which is thrown by the method which executes the statement
(b) You must catch the unchecked SQLWarningException which is thrown by the method
which executes the statement
(c) You must invoke the getWarnings() method on the Statement object (or a sub interface
thereof)
(d) You must query the ResultSet object about possible warnings generated by the database

What is, in terms of JDBC, a DataSource?
 (a) A DataSource is the basic service for managing a set of JDBC drivers
 (b) A DataSource is the Java representation of a physical data source
 (c) A DataSource is a registry point for JNDI-services
 (d) A DataSource is a factory of connections to a physical data 

What is the meaning of ResultSet.TYPE_SCROLL_INSENSITIVE 
(a) This means that the ResultSet is insensitive to scrolling 
(b) This means that the Resultset is sensitive to scrolling, but insensitive to updates, i.e. notupdateable 
(c) This means that the ResultSet is sensitive to scrolling, but insensitive to changes madeby others 
(d) The meaning depends on the type of data source, and the type and version of the driveryou use with this data source

 Are ResultSets updateable?
 (a) Yes, but only if you call the method openCursor() on the ResultSet, and if the driver and database support this option
 (b) Yes, but only if you indicate a concurrency strategy when executing the statement, and if the driver and database support this option
 (c) Yes, but only if the ResultSet is an object of class UpdateableResultSet, and if the driver
and database support this option (d) No, ResultSets are never updateable. You must explicitly execute DML statements 

What statements are correct about JDBC transactions (2 correct answers)?
(a) A transaction is a set of successfully executed statements in the database
(b) A transaction is finished when commit() or rollback()  is called on the Connection object,
(c) A transaction is finished when commit() or rollback()  is called on the Transaction object
(c) A transaction is finished when close() is called on the Connection object.