C2090-320

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?A . 10 row locksB . 200 page locksC . A single table space lockD . 6 partition locks (given a table space with a total of 10 partitions)View AnswerAnswer: C

Which of the following elements is affected by a ROLLBACK statement?A . LOB table spacesB . Changes in cursor positioningC . Acquisition and release of locksD . Caching of rolled back statementsView AnswerAnswer: A

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;A . GRANT, COPY, BIND, RUNB . BIND, EXECUTE, COPY, RUNC . CREATE, COPY, RUN, EXECUTED . COPY, BINDADD, SQL, EXECUTEView AnswerAnswer: B

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?A . TRUNCATE employee;B . DELETE FROM employee;C . DELETE FROM employee WHERE…;D . TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;View AnswerAnswer: B

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?A . COPYB . REORGC . STOSPACED . BACKUP SYSTEMView AnswerAnswer: D

Which statement is TRUE regarding ROLLBACK processing?A . It only reads active logsB . It always needs archive logsC . It can never be processed just from memoryD . It uses output buffers, active and archive logsView AnswerAnswer: D