C2090-600 Online Practice Questions and Answers

You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

A. db2cluster -verify

B. db2cluster -cm -list -alert

C. db2cluster -verify -configuration

D. db2cluster -cm -verify -resource

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

A. db2pd

B. db2dart

C. db2expln

D. db2advis

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The PAGESIZE database configuration parameter is set to 32K.

B. The AUTO_REORG database configurationparameter is set to NO.

C. The DFT_EXTENT_SZ database configuration parameter is set to 8.

D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

What is the result of the following scenario?

A. The row is updated to (2, NULL)

B. The row is updated to (2, 110.00)

C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

An HADR environment has two standby databases ?one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

A. SYNC

B. ASYNC

C. NEARSYNC

D. SUPERASYNC

Given the following: What will be the result of the following SQL statement?

INSERT INTO v3 (col1) values (30);

A. The insert will succeed as it passes validation.

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

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

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

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

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

A. You can change the principal standby of the primary without first stopping HADR on the primary.

B. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

C. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

D. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

E. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. LOAD

B. INGEST

C. IMPORT

D. TRANSPORT

Which of the following are all valid types of trigger?

A. AFTER, ATOMIC, BEFORE

B. AFTER, ATOMIC, INSTEAD OF

C. AFTER, BEFORE, INSTEAD OF

D. ATOMIC, BEFORE, INSTEAD OF