최신 DB2 A2090-614 무료샘플문제:

1. Given the following CREATE TABLE statement:

Which statement is correct?

A) A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
B) A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
C) A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
D) A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

2. Which command will be executed successfully on every database partition if db2_all is used?

A) RESTART DATABASE
B) FORCE APPLICATION
C) CONNECT
D) ACTIVATE DATABASE

3. Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

A) EXPLAIN_FROM_SECTION
B) EXPLAIN_FROM_ACTIVITY
C) EXPLAIN_FROM_CATALOG
D) EXPLAIN_FROM_DATA

4. If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

A) Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
B) Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
C) Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.
D) Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

5. Where is the HADR_TARGET_LIST configuration parameter set?

A) On the tertiary standby databases.
B) On the primary database only.
C) On the auxiliary standby databases only.
D) On all participating databases.

질문과 대답: