AJP Vidyalankar Polytechnic CHP 5 Part 3

For execution of INSERT SQL query in JDBC, ............. method must be used.

• executeUpdate()

• executeStatement()

• executeQuery()

• Execute()

For execution of SELECT SQL query in JDBC, _________________ method must be used.

• executeQuery()

• Execute()

• executeUpdate()

• executeAll()

forName is a _______________________ type method

• Static

• Dynamic

getConnection() method is of which class

• DriverManager

• Statement

• Connection

• None of above

How many JDBC driver types are available by sun Microsystem?

• 6

• 4

• 5

• 3

If a PreparedStatement is a SQL SELECT statement, you execute the statement using ________.

• PreparedStatement.execute();

• Statement.executeQuery();

• PreparedStatement.executeQuery();

• PreparedStatement.executeUpdate();

If you need to use a stored procedure with output parameters, which of the following statement type should be used to call the procedure?

• CallableStatement

• PreparedStatement

• Statement

• ProcedureStatement

In 2-tier architecture, the first tier is generally ___________________

• GUI

• Server

• Client

• database

In the following JDBC drivers which is known as partly java driver?

• Pure-Java Driver

• JDBC-net Pure Java

• JDBC driver

• Native-API driver

In the three-tier model the middle tier of the services acts as a mediator between ________________________ and _________________.

• Java application and databases

• Client and Server

• Java application and client

• Java application and server