AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For IBM- C2090-612





Question ID 20508

Given the following statements have been run successfully and the buffer pools BP1 and
BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES
BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATETABLE TB1
(COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE
TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the
sequence to CREATE an index IX1 on COL1 on TB1?

Option A

ALTER TABLESPACE TS1 MAXPARTITIONS 15;

Option B

COMMIT;

Option C

CREATE INDEX IX1 ON TB1 (COL1);

Option D

REORG TABLESPACE TS1;

Correct Answer C
Explanation


Question ID 20509

What IBM provided stored procedure will access DB2 real time statistics tables?

Option A

DSNAEXP

Option B

 DSNAIMS

Option C

DSNACCOX

Option D

 DSNLEUSR

Correct Answer C
Explanation

Send email to admin@getfreedumps for new dumps request!!!