Java Programming Section 6

You must explicitly close ResultSet and Statement objects once they are no longer in use.

• True

• False

Which of the following is a valid JDBC URL?

• oracle:thin:localhost@dfot/dfot:1521/xepdb1

• jdbc::oracle-thin:dfot/dfot@oracle:1521/xepdb1

• jdbc:oracle:thin:dfot/dfot@localhost:1521/xepdb1

• oracle:thin:jdbc:dfot/dfot@localhost:1521/xepdb1

Given the following code, assume there are rows of data in the table EMP. What is the result?

• Compiler error on line 2

• Runtime error on line 3

• 2

• 0

• Compile error on line 1

Which of the following classes or interfaces are included in the database vendor driver library? (Choose two)

• Statement interface implementation

• Java.sql.Connection

• Javax.sql.Datasource

• Javax.sql.DataSource implementation

• Java.sql.DriverManager implementation

Which of the following is NOT a JDBC interface used to execute SLQ statements?

• Statement Interface

• PreparedStatement Interface

• PrePreparedStatement Interface

• CallableStatement Interface

What type of JDBC driver will convert the database invocation directly into network protocol?

• Type 1 driver

• Type 2 driver

• Type 3 driver

• Type 4 driver

To execute a stored SQL procedure, which JDBC interface should be used?

• Statement Interface

• PreparedStatement Interface

• PrepreparedStatement Interface

• CallableStatement Interface

Which of the following is the correct statement be inserted at //INSERT CODE location that calls the database-stored procedure sayHello?

• CallableStatement cstat = con.prepareCall("{sayHello(?, ?)}");

• CallableStatement cstat = con.prepareCall("{call procedure_sayHello (?, ?)}");

• CallableStatement cstat = con.prepareCall("{call sayHello}");

• CallableStatement cstat = con.prepareCall("sayHello(?, ?)");

• CallableStatement cstat = con.prepareCall("{call sayHello(?, ?)}");

Which type of Statement can execute parameterized queries?

• ParameterizedStatement

• CallableStatement and ParameterizedStatement

• PreparedStatement

• All of the above

JDBC has a type system that can control the conversion between Oracle database types and Java types.

• True

• False