Question No 1

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

Choose the Choices:

UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

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

ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

Question No 2

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

Choose the Choices:

Catalog a storage access alias in the DB2 database

Create an FTP account on IBM Softlayer Object Storage

Use the DB2REMOTE parameter of the LOAD command

Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect

Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Question No 3

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

Choose the Choices:

Compression must be explicitly enabled for BLU MPP tables

Compression requires decompression to evaluate partition joins

Unique compression dictionaries are generated for each partition

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

Question No 4

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes). Sunday – Delta Monday – Incremental Tuesday – Delta Wednesday – Delta Thursday – Incremental Friday – Delta Saturday – Full Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?

Choose the Choices:

Question No 5

Which statement about NOT ENFORCED unique constraints is TRUE?

Choose the Choices:

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

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

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

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

Practice IBM C2090-600 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

C2090-600 Exam Features

C2090-600 PDF Dumps