C2090-614 Online Practice Questions and Answers

An auxiliary HADR standby database must use which HADR sync mode?

A. SYNC

B. ASYNC

C. NEARSYNC

D. SUPERASYNC

Which category must be enabled before db2audit will record the creation of new buffer pools?

A. OBJMAINT

B. SECMAINT

C. CHECKING

D. OBJCREATE

On which two operating systems can DB2 pureScale run? (Choose two.)

A. AIX

B. Linux

C. HP-UX

D. Solaris

E. Windows

A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?

A. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.

B. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.

C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

Given the following CREATE TABLE statement:

Which statement is correct?

A. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

Which would not significantly benefit from having the RUNSTATS command run on it?

A. Tables that have had little change.

B. Tables where a new index has been created.

C. Tables that have been reorganized (using REORG).

D. Tables that have been populated with a LOAD operation.

Which is NOT a valid method for prefetching data?

A. Smart data prefetching

B. Read-ahead prefetching

C. Consecutive prefetching

D. Sequential detection prefetching

You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?

A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.

B. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.

C. Issue a LIST UTILITIES statement with the 'SUSPEND ' option specified.

D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.

Which operation can be performed by executing an ALTER STOGROUP statement?

A. Change the name of an existing storage group.

B. Make an existing storage group the default storage group.

C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.

D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

A. Data class, work class, and a limit

B. Data class, action class, and a threshold

C. Service subclass, action class, and a limit

D. Service subclass, work class, and a threshold