Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C2090-600 Questions and Answers

Note! Following C2090-600 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-600 Questions and Answers

Question # 6

Which of the following statements about compression for BLU MPP tables is TRUE?

A.

Compression must be explicitly enabled for BLU MPP tables

B.

Compression requires decompression to evaluate partition joins

C.

Unique compression dictionaries are generated for each partition

D.

Each table has a single compression dictionary that getsreplicated across all partitions

Full Access
Question # 7

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time “pit”.

BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE

QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE

QUIESCE TABLESPACES FOR TABLE tab1 RESET

Which of the following is TRUE?

A.

The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.

B.

Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.

C.

After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might besome uncommitted data in TS1.

D.

After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.

Full Access
Question # 8

Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

A.

Select from the ADMIN_GET_ENCRYPTION_INFO table function

B.

Run the db2ckbkp command and verify the compression settings

C.

Checkthe encrypted database parameter in database configuration

D.

Check ENCROPTS database configuration parameter for encryption options

Full Access
Question # 9

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

A.

db2val

B.

db2set

C.

db2look

D.

db2greg

Full Access