What are the various locks available?

When you COMMIT, is the cursor closed?

What are the disadvantages of PAGE level lock?

What is a subselect?

When would you choose to run RUNSTATS?

What is returned by the VALUE function?

Consider the following SQL statement, executed by user S001: CREATE VIEW BOSTON_TEAMS AS SELECT * FROM TEAMS WHERE STATE = 'MA' User S002 has INSERT authority on this view, what would happen if he tries to insert a row into this view, where the STATE field of that line contains a value of ‘IN’?

Given the following cursor declaration: DECLARE CLASSUPDATE CURSOR FOR SELECT CSTITLE FROM T001.CLASSS FOR UPDATE OF CDUR Which of the following embedded SQL statements will use this cursor correctly?

When a column has an extension of WITH DEFAULT NULL and a unique index is created on this column, what will be the effects on the possible null values in that column?

Which of the following is not a DB2 datatype

If the SQLCA is included in the program, which of the following host-variables is NOT known and as such unavailable for the program?