IBM
C2090-312 · Question #29
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…
The correct answer is C. CREATE INDEX IX1 ON TB1. See the full explanation below for the reasoning.
Question
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 ; CREATE TABLE 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?
Options
- AALTER TABLESPACE TS1
- BCOMMIT;
- CCREATE INDEX IX1 ON TB1
- DREORG TABLESPACE TS1;
How the community answered
(31 responses)- A10% (3)
- B3% (1)
- C84% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.