IBM C2090-600 Exam Questions Instant Access

Question 1

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

Adb2val

Bdb2set

Cdb2look

Ddb2greg

Answer : B

Question 2

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

AA local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.

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

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

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

Answer : C

Question 3

Which statement about NOT ENFORCED unique constraints is TRUE?

ANOT ENFORCED unique constraints can not be defined on primary key columns

BThe query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

CWhen attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

DStorage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer : A

Question 4

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

AREORG TABLE sales INPLACE RESETDICTIONARY

BREORG TABLE sales INPLACE REBUILDDICTIONARY

CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer : C

Question 5

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

AREORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

BREORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

CRUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

DRUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer : A

Question 6

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

AAll data, both new and existing, will becompressed.

BOnly new or updated data for XML columns will be compressed.

CNew and existing XML columns will be compressed but other columns remain unchanged.

DExisting data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

Answer : D

Question 7

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

ASet the DB2COMM registry variable to DB2COMM=SSL

BSet the DB2COMM registry variable to DB2COMM=SSL, TCPIP

CSet the AUTHENTICATION configuration parameter to DATA_ENCRYPT

DSet the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer : B

IBM DB2 11.1 DBA for LUW C2090-600 Exam Questions