Correct Answer: The PREFETCHSIZE and EXTENTSIZE columns in SYSCAT.TABLESPACES.
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Administration MCQ Questions
What condition would lead to distribution statistics not being collected?
What should be considered when specifying an optimization level?
What two types of configuration files does DB2 use?
If your columns are indexed, what clause would you run for the RUNSTATS command to collect statistics?
Given the following code: EXEC SQL EXECUTE IMMEDIATE: sqlstmt Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?
Which allows index data to be stored on separate devices from table data?
Given the following statements: CREATE TABLE T1 (COL1 INT NOT NULL PRIMARY KEY, COL2 CHAR, COL3 CLOB (40K), COL4 VARCHAR(10)); CREATE UNIQUE INDEX IND_1 ON T1 (COL1, COL2) INCLUDE (COL3) ALLOW REVERSE SCANS; The CREATE UNIQUE INDEX statement will fail because:
What technique can be used to reduce the number of calculations in a query?
What does it mean if the the null indicator = 0
Which of the following DSNZPARMs is necessary to influence access path selection for certain queries?