SELECT empname , paygrade , salary FROM emp, salgrade WHERE salary BETWEEN lowsal AND highsal ORDER BY paygrade The above is an example of a

Which statement concerning locking on TABLESPACE level is correct?

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

Which of the following is not a DB2 datatype

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?

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?

What does DBRM Stand for?

What is returned by the VALUE function?

When would you choose to run RUNSTATS?

What is a subselect?

What are the disadvantages of PAGE level lock?