Câu 38: C2090-612: DB2 10 DBA for zOS
The following DDL statements are executed to create the following objects: CREATETABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEXUSER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in order): 1)…
Nội dung câu hỏi
The following DDL statements are executed to create the following objects: CREATETABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEXUSER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in order): 1) ALTER TABLESPACEDB1.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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Nothing needs to be done.
- B. REORG INDEX USER1.IX1 SHRLEVEL CHANGE
- C. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE — đáp án hiện tại
- D. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.