JDBC

What are the major components of the JDBC?

• 1. DriverManager, Driver, Connection, Statement, and ResultSet

• 1. DriverManager, Driver, Connection, and Statement

• 1. DriverManager, Statement, and ResultSet

• DriverManager, Connection, Statement, and ResultSe

Select the packages in which JDBC classes are defined?

• 1. jdbc and javax.jdbc

• 1. rdb and javax.rdb

• 1. jdbc and java.jdbc.sql

• 1. sql and javax.sql

Thin driver is also known as?

• 1. Type 3 Driver

• 1. Type-2 Driver

• 1. Type-1 Driver

• 1. Type-4 Driver

What is the correct sequence to create a database connection?

i. Import JDBC packages.

ii. Open a connection to the database.

iii. Load and register the JDBC driver.

iv. Execute the statement object and return a query resultset.

v. Create a statement object to perform a query.

vi. Close the resultset and statement objects.

vii. Process the resultset.

viii. Close the connection.

• 1. i, ii, iii, v, iv, vii, viii, vi

• 1. ii, i, iii, iv, viii, vii, v, vi

• 1. i, iii, ii, iv, v, vi, vii, viii

• 1. i, iii, ii, v, iv, vii, vi, viii

Which of the following method is used to perform DML statements in JDBC?

• 1. executeResult()

• 1. xecuteUpdate()

• 1. executeQuery()

  2. e

• 1. execute()