Which package level privileges does the user smith have when the following statement is executed?GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
Which of the following can activate a trigger?
In which address space would a native SQL stored procedure run?
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?
Which of the following statements about a table with a LOB column is TRUE?
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
