Full Stack development quiz 17

 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

• 1. DriverManager, Connection, Statement, and ResultSet

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

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. i, iii, ii, v, iv, vii, vi, viii

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

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

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

• 1. executeResult()

• 1. executeQuery()

• 1. executeUpdate()

• 1. execute()

Which methods are required to load a database driver in JDBC?

• 1. getConnection()

• 1. registerDriver()

• 1. forName()

• 1. Both b and c

What should be the correct order to close the database resource?What should be the correct order to close the database resource?

• 1. Connection, Statements, and then ResultSet

• 1. ResultSet, Connection, and then Statements

• 2. Statements, ResultSet, and then Connection

• 1. ResultSet, Statements, and then Connection

JDBC-ODBC driver is also known as?

• 1. Type 4

• 1. Type 3

• 2. Type 1

• 1. Type 2

Which of the following driver is the fastest one?

• 1. JDBC-ODBC Bridge Driver

• 1. Native API Partly Java Driver

• 2. Network Protocol Driver

• 1. JDBC Net Pure Java Driver

Which of the following driver converts the JDBC calls into database-specific calls?

• 1. JDBC-ODBC Bridge Driver (Type 1)

• 1. Native API-partly Java Driver (Type 2)

• 2. Net Protocol-pure Java Driver (Type 3)

• 1. Native Protocol-pure Java Driver (Type 4)

JDBC API supports____________ and __________ architecture model for accessing the database.

• 1. Two-tier

• 1. Three-tier

• 1. Both a and b

• 1. Only b