If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?
A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?
When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTERTABLESPACE command. Which statement is correct?
Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 INDB1 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 onCOL1 on TB1?
Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?
