JDBC

What is the return type of executeUpdate() method?

• byte

• short

• int

• long

What is the return type of executeQuery() method?

• int

• ResultSet

• array

• none of the above

what is the package name of "Class"?

• java.util

• java.sql

• java.lang

• java.io

What is true about DriverManager class?

• It is class from java.lang package

• It is a class from java.sql package

• It is a interface from java.sql package

• It is a class from java.lang package

What is JDBC?

• JDBC is a java based protocol.

• JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

• JDBC is a specification to tell how to connect to a database.

• Joint Driver for Basic Connection

Which of the following encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed?

• DriverManager

• JDBC driver

• Connection

• Statement

Which of the following is not a valid type of statement in JDBC?

• Statement

• PreparedStatement

• CallableStatement

• QueryStatement

Which of the following is correct about PreparedStatement?

• Used when you plan to use the SQL statements many times.

• The PreparedStatement interface accepts input parameters at runtime.

• Both of the above.

• None of the above.

what is true about getConnection() method?

• It is a static method from DriverManager class

• It is a non static method from DriverManager class

• It is a static method from DriverManager interface

• It is a non static method from DriverManager interface

Which package contains JDBC classes and interfaces?

• java.lang

• java.io

• java.sql

• java.jdbc