Which of the following can activate a trigger?A . A row is insertedB . A table or view is createdC . A check constraint is definedD . A referential constraint is violatedView AnswerAnswer: D Explanation:...
An application program is running much longer than expected. The PLAN_TABLE shows the following access path information: ACCESSTYPE = ‘R’ PREFETCH = ‘S’ What access path does this represent?A . IN-list accessB . Direct row...
If a scrollable cursor is INSENSITIVE, which of the following applies?A . The cursor is read onlyB . WITH ROWSET POSITIONING is not allowedC . The select-statement must not contain an SQL data change statementD...
Which statement about an application-period temporal table is TRUE?A . It has SYSTEM_TIME definedB . It has an end column defined using WITH DEFAULT NULLC . It must have the index clause BUSINESS_TIME WITHOUT OVERLAPSD...
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 ....
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...
In a unique referential constraint, which type of key does a foreign key reference?A . Child keyB . Collation keyC . Parent keyD . Secondary keyView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?A . All held LOB locators are retainedB . All locks that are implicitly acquired during the unit of recovery are...
You have created a new index. What is the command to potentially change the access path for a static package?A . FREEB . RESETC . REBINDD . REFRESHView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/ db2z_influenceaccesspaths.html
Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?A . CDISPLAY DATABASE(MYDB) OVERVIEWB . CDISPLAY DATABASE(MYDB) SPACENAM(*)C . CDISPLAY DATABASE(MYDB) SPACENAM(*) RESD ....