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 20484

In order to retain an access path across a rebind which of the following commands could be used?

Option A

BIND PLAN

Option B

REBIND PACKAGE(PK1) REOPT(ONCE)

Option C

 BIND PACKAGE (PK1) EXPLAIN(YES)

Option D

 REBIND PACKAGE (PK1) PLANMGMT(BASIC)

Correct Answer D
Explanation


Question ID 20485

Thefollowing DDL statements are executed to create the following objects: CREATE
TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1
INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON
USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES;Next, the following ALTER
statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0
MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX
USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of
thechanges with the least amount of work?

Option A

Nothing needs to be done.

Option B

REORG INDEX USER1.IX1 SHRLEVEL CHANGE

Option C

REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE

Option D

 REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE REORG INDEX USER1.IX1 SHRLEVEL CHANGE

Correct Answer C
Explanation

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