GRANT ALL PRIVILEGES WHERE FROM ON TO

GRANT ALL PRIVILEGES TO WHERE FROM

GRANT ALL PRIVILEGES WHERE FROM TO

GRANT ALL PRIVILEGES ON TO

GRANT ALL PRIVILEGES ON WHERE FROM

confusion in selection of optimal query execution method

disk space consumption

performance overhead

security

Either AB&C

hardware requirements

data compression support

encryption support

All of the above

Pure Java

JDBC-ODBC Bridge

Native-API

JDBC-net

Class.callName("sun.jdbc.odbc.JdbcOdbcDriver");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Class.callfunc("JdbcOdbcDriver");

Class.Name.init("sun.jdbc.odbc.JdbcOdbcDriver");

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS intercepts the request DBMS presents the request to the user.

User issues request -> DBMS intercepts the request DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user.

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user DBMS intercepts the request.

None of the above

repetition of data

separation of data

incompatibility of files

data dependence

All of the above

A CachedRowSet class

A JavaSource class

A WebRowSet class

A JDBCRowSet class

Either AC&D

A read lock prevents other transactions from reading the locked data

A write lock prevents other transactions from reading or writing to the locked data

Multiple transactions can have write locks on the same data item.

Multiple transactions can have read locks on the same data item.

Either B&D

Fixed length string of n characters

Variable length string up to n characters

Floating point number of p bits precision

16-bit signed integer

32-bit signed integer