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- A2090-612





Question ID 22432

Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?

Option A

MAXPARTITIONS

Option B

MAXPARTITIONS, DSSIZE

Option C

MAXPARTITIONS, page size

Option D

MAXPARTITIONS, DSSIZE, page size

Correct Answer D
Explanation


Question ID 22433

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA
SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of
the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic
cache statements associated with the table TB1?

Option A

ALTER TABLE TB1 AUDIT CHANGES;

Option B

ALTER TABLE TB1 ADD COLUMN COLC DATE;

Option C

ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;

Option D

ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL; 

Correct Answer B
Explanation

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