Tag: architecture

At the root of the collection hierarchy is a class called Collection

The collection interface contains a method called enumerator

The interator method returns an instance of the Vector class

The Set interface is designed for unique elements

Update Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;

Update Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;

Update table Employee set salary = salary * 1.5, grade=’Promo’ where salary < 10000;

Update table Employee set salary = salary * 1.5 and grade=’Promo’ where salary < 10000;

INSERT

CREATE

UPDATE

DELETE

PreparedStatement

ParameterizedStatement

ParameterizedStatement and CallableStatement

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

CallableStatement

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 of the above

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

Static void doCalc(int x, int… args) {}

Static void doCalc(int… args, int x) {}

Static void doCalc(int[] args)

Static void doCalc(int args…)

5

6

Compile error

Runtime error