INSERT

CREATE

UPDATE

DELETE

PreparedStatement

ParameterizedStatement

ParameterizedStatement and CallableStatement

All kinds of Statements (i.e. which implement a sub interface of Statement)

java.jdbc and javax.jdbc

java.jdbc and java.jdbc.sql

java.sql and javax.sql

java.rdb and javax.rdb

The executeUpdate method returns all the rows that were affected

The executeUpdate method returns the no. of rows that were affected

Depends , as there is more than one version of this method with different return types

None

A transaction is a set of sql statements

Auto commit to be set off before Transaction

Auto commit to be set off after transaction

Commit permanently records to database all changes waiting with current Connection

Rollback is used in case of any error to undo transaction

5

6

Compile error

Runtime error

ClassCastException

IllegalStateException

NumberFormatException

None

addSize

getCust

deleteRep

putDimensions

jspInit(), _jspService() & jspDestroy()

init(), service(), destroy()

doPost()

none of the above

Parsing JSP using an XML Parser.

Converting JSP into static Html content.

Generating Servlet Code for the Jsp

None

Applets

Web Browsers

Wireless clients.

All the above

True

False

True

False

True

False

True

False

page, request & session

page, request & application.

page, request, session & application

request, session & application.

only request, response

only request, response & application

request, response, session & application

None

Query length is limited in POST, not limited in GET.

POST is secured whereas data is been submitted as part of URL in GET (not secured).

By using POST method, we cannot submit the form.

None

True

False

True

False