AJP Vidyalankar Polytechnic CHP 5 Part 1

The following classes belong to which package: Connection management, Database Access, Data Types, Database Metadata, Exceptions Warnings:

• javax.sql

• java.sql

• javax.swing

• None of the above

Which of the following classes/interface allows you to establish a connection to database:

• java.sql.Driver

• java.sql.DriverManager

• java.sql.connection

• All of the above

Which of the following classes/interface allows you to send SQL statement to database for execution and read the result:

• java.sql.Statement

• java.sql.PreparedStatement

• java.sql.ResultSet

• All of the above

What is the description of java.sql.DriverManager?

• This class provides the functionality necessary for managing one or more database drivers.

• This is an interface that abstracts the vendor specific connection protocol

• This class is used to discover properties required to obtain the connection

• This interface abstracts most of the interaction with the database.

What is the description of java.sql.Driver?

• This class provides the functionality necessary for managing one or more database drivers.

• This is an interface that abstracts the vendor specific connection protocol

• This class is used to discover properties required to obtain the connection

• This interface abstracts most of the interaction with the database

What is the description of java.sql.DriverPropertyInfo?

• This class provides the functionality necessary for managing one or more database drivers.

• This is an interface that abstracts the vendor specific connection protocol

• This class is used to discover properties required to obtain the connection

• This interface abstracts most of the interaction with the database.

What is the description of java.sql.Connection?

• This class provides the functionality necessary for managing one or more database drivers.

• This is an interface that abstracts the vendor specific connection protocol

• This class is used to discover properties required to obtain the connection

• This interface abstracts most of the interaction with the database.

Which interface lets you execute SQL statements over the underlying connection and access the results?

• java.sql.Statement

• java.sql.PreparedStatement

• java.sql.ResultSet

• java.sql.CallableStatement

This interface lets you execute stored procedures.

• java.sql.Statement

• java.sql.PreparedStatement

• java.sql.ResultSet

• java.sql.CallableStatement

The java.sql package provides several Java _______ class that correspond to some of the SQL types.

• Connection Management

• Database Access

• Data Types

• Both (a) and (b)