NIELIT 2016 DEC Scientist B (IT) - Section B: 41

Question

Which type of Statement can execute parameterized queries?

• A. PreparedStatement
• B. ParameterizedStatement
• C. ParameterizedStatement and CallableStatement
• D. All kinds of Statements

Answer 1

answer (A)PreparedStatement       Sometimes it is more convenient to use a PreparedStatement object for sending SQL statements to the database

Answer 2

Option A

The PreparedStatement interface extends the Statement interface. It represents a precompiled SQL statement that can be executed multiple times. It accepts parameterized SQL quires. We can pass 0 or more parameters to this query.

CallableStatement: It is used to execute SQL stored procedures.

Src : https://www.javatpoint.com/jdbc-mcq