IBM Certified Database Administrator - DB2 10 for z/OS - 000-612 Exam Practice Test
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
Correct Answer: A
Vote an answer
What IBM provided stored procedure will access DB2 real time statistics tables?
Correct Answer: C
Vote an answer
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?
Correct Answer: B
Vote an answer
A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
Correct Answer: D
Vote an answer
The application will be handling a large volume of input data that will need to be added to or update 4 differenttables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?
Correct Answer: C
Vote an answer
For monitoring space growth over time, which statistics should NOT be considered?
Correct Answer: C
Vote an answer