최신IBM DB2 10 DBA for z/OS - C2090-612무료샘플문제
문제1
What two parameters allow DB2to keep a copy of a dynamically prepared statement in the cache?
What two parameters allow DB2to keep a copy of a dynamically prepared statement in the cache?
정답: A
문제2
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1(COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1(COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?
정답: D
문제3
You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?
You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?
정답: B
문제4
You take image copies ofyour table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement.
Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?
You take image copies ofyour table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement.
Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?
정답: D
문제5
What is the maximum levels of backup that DB2 plan stability can support?
What is the maximum levels of backup that DB2 plan stability can support?
정답: A
문제6
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
정답: A
문제7
What must be in place forthe support of index compression?
What must be in place forthe support of index compression?
정답: C
문제8
The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class
3 Synchronous database I/O time. All of the DB2 objects for thenew billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class
3 Synchronous database I/O time. All of the DB2 objects for thenew billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
정답: D
문제9
Which trace gives information about frequent log space shortages?
Which trace gives information about frequent log space shortages?
정답: D