Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data? A. DELIMITED B. SPANNED YES C. DSNTYPE HFS on the TEMPLATE D. DSNTYPE LIBRARY or PDS on the TEMPLATE
The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to…
What is one of the first key steps in preparing to use the BACKUP SYSTEM utility? A. Run the MODIFY RECOVERY utility. B. Alter the BSDS to allow BACKUP SYSTEM. C. Define one or more storage groups to a COPYPOOL.…
The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true? A. It shows how many keys are rejected when issued during the SORTBLD phase. B. It shows the elapsed…
Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each night. You create FULL image copies once a week and INCREMENTAL copies during the rest of the days. After migrating to DB2 10, you…
When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur? A. Function A.B is stopped and queues all access. B. Function A.B is stopped and rejects all…
Altering the DSSIZE is allowed for what type of table space? A. XML table space. B. Universal table space. C. Segmented table space. D. DSSIZE cannot be altered.
Which of the following tasks cannot be done via a single ALTER TABLE statement? A. Add a new partition to the table space. B. Change the VALIDPROC attribute of the table. C. Change a table check constraint on the table.…
Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS); A. The index must be partitioned. B. The index must use page size > 4K. C. The index must be defined as UNIQUE.…
A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur? A. Specify the column names to be hashed. B. Create a unique index on the hash columns. C. Create a clustering index on the hash…