Exam 2

Exam 2

SQL- Be able to explain and use:

Four basic operations on data (Create, Read, Update, Delete)
Three basic operations on objects (Create, Alter, Drop)

Clauses (SELECT, INSERT, UPDATE, DELETE, WHERE, CREATE, CONSTRAINT)

JDBC

The layers as explained in topic19.html for both Access and Oracle

java.sql Package- Be able to explain and use:

Exceptions thrown (SQLException)

Connection object
Statement Object
PreparedStatement Object
ResultSet Object

executeQuery method
executeUpdate method
executeBatch method
addBatch method