A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?A . All...
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping...
What is an advantage of using range partitioned tables?A . Abilityto run utilities against the partitions in parallelB . Increased query performance through data partition eliminationC . Block indexes are much smaller than RID...
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?A . UPDATE DB CFG USING CF_LOCK_SZ AUTOMATICB . UPDATE DB CFG USING OPT_DIRECT_WRKLD YESC . UPDATE DB CFG USING LOCKLIST 4096...
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes...
You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?A . BLOBB . CLOBC . DBCLOBD . VARGRAPHICView AnswerAnswer: A...
Which operation can be performed with trusted context privileges that are acquired through a role?A . DML operationsB . DDL operationsC . Server maintenance operationsD . Security administration operationsView AnswerAnswer: A
Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?A . SYSIBB . SYSSTMTC . SYSIBD . SYSPARMSE . SYSIBF . SYSROUTINESG . SYSIBH . SYSVARIABLESView AnswerAnswer: B
Which of the following is TRUE about indexes on column organized tables?A . No indexes are allowedB . Indexes are only allowed on numeric columnsC . Indexes are automatically created to enforce unique constraintsD...
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The...
