COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PreparedStatement
|
|
|
ParameterizedStatement
|
|
|
ParameterizedStatement and CallableStatement
|
|
|
All kinds of Statements (i.e. which implement a sub interface of Statement)
|
Detailed explanation-1: -In Athena, parameterized queries can take the form of execution parameters in any DML query or SQL prepared statements.
Detailed explanation-2: -PreparedStatement interface. The PreparedStatement interface is a subinterface of Statement. It is used to execute parameterized query.
Detailed explanation-3: -Although you can use PreparedStatement objects for SQL statements with no parameters, you probably use them most often for SQL statements that take parameters. The advantage of using SQL statements that take parameters is that you can use the same statement and supply it with different values each time you execute it.
Detailed explanation-4: -PreparedStatement interface in JDBC API represents the precompiled statement and you can create a precompiled statement by passing the query with bind variables to the prepareStatement() method of the Connection interface.
Detailed explanation-5: -Q 19-Which of the following is correct about PreparedStatement? A-PreparedStatement allows mapping different requests with same prepared statement but different arguments to execute the same execution plan.