C2090-600試験無料問題集（60題）「IBM DB2 11.1 DBA for LUW 認定」

出題：1

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density.
What can cause an MDC table to use much more space?

A. The extent size is too small.

B. Low cardinality of the dimension(s) chosen.

C. The page size is too small.

D. High cardinality of the dimension(s) chosen.

正解：D 解答を投票する

出題：2

Which options are valid for an online reorganization operation?

A. CLEAN OVERFLOWS and RECLAIM EXTENTS

B. CLASSIC and RECLAIM EXTENTS

C. FULL and RECLAIM EXTENTS

D. FULL and CLEANUP OVERFLOWS

正解：C 解答を投票する

出題：3

Given the following:

What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);

A. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

B. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

C. The insert will succeed as it passes validation.

D. The insert will succeed as there is no WITH CHECK OPTION on view V3.

正解：A 解答を投票する

出題：4

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

B. ATTACH TO db2instl;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

C. CONNECT TO sample; UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

D. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

正解：C 解答を投票する

出題：5

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

A. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.

B. A local keystore is not needed if a Hardware Security Module (HSM) is used to manage master keys.

C. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

正解：A 解答を投票する

出題：6

What is the default value of the DB2 registry variable DB2LDAP SEARCH_SCOPE?

A. LOCAL

B. GLOBAL

C. NONE

D. DOMAIN

正解：B 解答を投票する

C2090-600試験無料問題集「IBM DB2 11.1 DBA for LUW 認定」