C2090-600 Online Practice Questions and Answers

Which of the following are valid Explain operators? (Choose two.)

A. CTQ

B. XSCAN

C. IXSCAN

D. SELECT

E. COLSCAN

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

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

A. Catalog a storage access alias in the DB2 database

B. Create an FTP account on IBM Softlayer Object Storage

C. Use the DB2REMOTE parameter of the LOAD command

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

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

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. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

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

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

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

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

If the following SQL statements are executed:

CREATE DATABASE testdb AUTOMATIC STORAGE NO;

CONNECT TO testdb;

CREATE STOGROUP sg1 ON `/data1';

CREATE STOGROUP ibmstogroup ON `/data2';

CREATE STOGROUP sg2 ON `/data3';

Which storage group is the default storage group for the TESTDB database?

A. SG1

B. SG2

C. IBMSTOGROUP

D. IBMDEFAULTTSG

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 statement about the db2move command is TRUE?

A. The LOAD actions can be run from a client machine.

B. Object ownership cannot be changed after a successful schema copy operation.

C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

D. Loading data into tables containing XML columns is only supported for the LOAD actions.

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

A. As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000

B. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

C. As the db2 instance owner (db2inst1) execute the command:db2set 璱 DB2_FMP_COMM_HEAPSZ=256000

D. As the db2 instance owner (db2inst1)execute the command:db2set 璱 db2inst1 DB2_FMP_COMM_HEAPSZ=256000