nerdexam
IBM

C2090-312 · Question #31

The following 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…

The correct answer is C. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE. See the full explanation below for the reasoning.

Question

The following 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 the changes with the least amount of work?

Options

  • ANothing needs to be done.
  • BREORG INDEX USER1.IX1 SHRLEVEL CHANGE
  • CREORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
  • DREORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE

How the community answered

(41 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    83% (34)
  • D
    10% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice