5 years ago in JDBC

Which type of Statement can execute parameterized queries?

[A] PreparedStatement
[B] ParameterizedStatement
[C] ParameterizedStatement and CallableStatement
[D] All kinds of Statements
Next Question

Overall Stats

Attempted 576
Correct 294
Incorrect 59
Viewed 223


Shamsa hafeez
Shamsa hafeez - 3 days ago

Shamsa hafeez from Lahore, Pakistan is saying PreparedStatement is correct answer

Belandje Indonesia
Belandje Indonesia - 1 week ago

Belandje Indonesia is saying ParameterizedStatement is correct answer

Sailaja - 1 week ago

Sailaja from Surat, India is saying PreparedStatement is correct answer

Francis Fabul
Francis Fabul - 1 week ago

Francis Fabul is saying ParameterizedStatement and CallableStatement is correct answer

Sagar Gawari
Sagar Gawari - 4 weeks ago

Sagar Gawari from Pune, India is saying PreparedStatement is correct answer

Related Questions

What happens if you call the method close() on a ResultSet object?

  • [A] the method close() does not exist for a ResultSet. Only Connections can be closed.
  • [B] the database and JDBC resources are released
  • [C] you will get a SQLException, because only Statement objects can close ResultSets
  • [D] the ResultSet, together with the Statement which created it and the Connection from which the Statement was retrieved, will be closed and release all database and JDBC resources

JDBC stands for:

  • [A] Java Database Connectivity
  • [B] Java Database Components
  • [C] Java Database Control
  • [D] None of the above is correct.

Which of the following statements is false as far as different type of statements is concern in JDBC?

  • [A] Regular Statement
  • [B] Prepared Statement
  • [C] Callable Statement
  • [D] Interim Statement

Which type of driver provides JDBC access via one or more ODBC drivers?

  • [A] Type 1 driver
  • [B] Type 2 driver
  • [C] Type 3 driver
  • [D] Type 4 driver

How can you retrieve information from a ResultSet?

  • [A] By invoking the method get(..., String type) on the ResultSet, where type is the database type
  • [B] By invoking the method get(..., Type type) on the ResultSet, where Type is an object which represents a database type
  • [C] By invoking the method getValue(...), and cast the result to the desired Java type.
  • [D] By invoking the special getter methods on the ResultSet: getString(...), getBoolean (...), getClob(...)