최신IBM DB2 11 DBA for z/OS - C2090-312무료샘플문제
문제1
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?
정답: A
문제2
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
정답: C
문제3
What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?
What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?
정답: A
문제4
What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?
A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?
정답: D
문제6
Which technique can be utilized for the reporting of real-time statistics?
Which technique can be utilized for the reporting of real-time statistics?
정답: B
문제7
You have defined the array type PHONENUMBERS using the following DDL:
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
You have defined the array type PHONENUMBERS using the following DDL:
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
정답: C