MARKS FORMING TEST 2 FOR WEB DESIGNING

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

NAME

Roll Number

1) What are the major components of the JDBC?

1 point

DriverManager, Driver, Connection, Statement, and ResultSet

DriverManager, Driver, Connection, and Statement

DriverManager, Statement, and ResultSet

DriverManager, Connection, Statement, and ResultSet

Clear selection

2) Select the packages in which JDBC classes are defined?

1 point

jdbc and javax.jdbc

rdb and javax.rdb

jdbc and java.jdbc.sql

sql and javax.sql

Clear selection

3) Thin driver is also known as?

1 point

Type 3 Driver

Type-2 Driver

Type-4 Driver

Type-1 Driver

Clear selection

4) 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 point

i, ii, iii, v, iv, vii, viii, vi

i, iii, ii, v, iv, vii, vi, viii

ii, i, iii, iv, viii, vii, v, vi

i, iii, ii, iv, v, vi, vii, viii

Clear selection

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

1 point

executeResult()

executeQuery()

executeUpdate()

execute()

Clear selection

6) How many transaction isolation levels provide the JDBC through the Connection interface?

1 point

Clear selection

7) Which of the following method is static and synchronized in JDBC API?

1 point

getConnection()

prepareCall()

executeUpdate()

executeQuery()

Clear selection

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

1 point

getConnection()

registerDriver()

forName()

Both b and c

Clear selection

9) Parameterized queries can be executed by?

1 point

ParameterizedStatement

PreparedStatement

CallableStatement and Parameterized Statement

All kinds of Statements

Clear selection

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

1 point

Statement

PreparedStatement

QueryStatement

CallableStatement

Clear selection

Submit

Clear form

Never submit passwords through Google Forms.

Forms

This content is neither created nor endorsed by Google.