What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio? A. Permission to log in to the database client using telnet. B.…
Which statement about DB2 aggregate registry variables is true? A. An aggregate registry variable that is explicitly set by an application cannot be overwritten. B. An aggregate registry variable overrides any corresponding explicitly set registry variable. C. A registry variable…
How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)? A. By using the change history event monitor. B. By using the DB2 problem determination tool. C. By examining the contents of…
Which command will enable automatic reorg on a database? A. UPDATE DB CFG USING AUTO_REORG ON B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON D. UPDATE DB CFG USING AUTO_MAINT…
Which statement about triggers is FALSE? A. A statement-level trigger fires only once for each SQL statement. B. A trigger’s code block can be executed either before or after a triggering event. C. A row-level trigger fires once for each…
Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database? A. DB2_INDEX_DEFAULT B. DB2_EXTENDED_OPTIMIZATION C. DB2_INDEX_PCTFREE_DEFAULT D. DB2_ENABLE_AUTOCONFIG_DEFAULT
A table named CUSTOMER and an index named CUST_IDX were created as follows: Which operation would you expect to see in the access plan diagram produced? A. NLJOIN B. HSJOIN C. IXSCAN D. TBSCAN
Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data? A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED B. ALTER TABLE mytab CHECK…
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command? A. To terminate a failed INGEST command. B. To restart a failed INGEST command from the beginning. C. To clean up the log records of a…
What are two types of check options that can be used to create views? (Choose two.) A. Local B. Client C. Server D. Remote E. Cascaded