최신 DB2 000-612 무료샘플문제:

1. An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

A) col1 is converted to UNICODE
B) col2 and col1 are converted to UTF-32
C) SQLCode-270: Function not supported
D) col2 is converted to EBCDIC

2. What WLM action will establish performance objectives for DDF threadsand their related address space?

A) Createa WLM service definition that assigns service classes to the DDF threads.
B) Execute the WLM_REFRESH stored procedure for the DDF application environment.
C) Insure the NUMTCB is set to a value greater than 10.
D) Specify DDF for the value of APPLENV to the name of the WLM environment.

3. Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?

A) Make the table space table-partitioned, then issue ALTER TABLESPACE with a validSEGSIZE > 0
B) Issue ALTER TABLESPACE with a valid SEGSIZE > 0
C) Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
D) Drop the partitioning index, ALTER the table definition by addingpartition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0

4. Whichstatement is true about table check constraints?

A) The LOAD utility cannot enforce the constraint.
B) A constraint placed on a table does not apply to a view defined on the table.
C) A row meets the requirement of the constraint if the condition evaluates to true or unknown.
D) Only one constraint per column is allowed.

5. Which minimum system privilege allows you to create a trusted context?

A) ACCESSCTRL
B) DBADM
C) SYSCTRL
D) SECADM

질문과 대답: