C2090-612 Online Practice Questions and Answers

What DB2 command when issued displays what migration mode the catalog is in?

A. DSNC DISPLAY

B. DISPLAY GROUP

C. MODIFY irlmproc,STATUS

D. DISPLAY DATABASE (DSNDB06)

What WLM action will establish performance objectives for DDF threads and their related address space?

A. Insure the NUMTCB is set to a value greater than 10.

B. Specify DDF for the value of APPLENV to the name of the WLM environment.

C. Execute the WLM_REFRESH stored procedure for the DDF application environment.

D. Create a WLM service definition that assigns service classes to the DDF threads.

What must be in place for the support of index compression?

A. User defined algorithm.

B. Compression dictionary.

C. Table space compression.

D. Page size larger than 4K.

Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

A. Using a view.

B. Using a VALIDPROC.

C. Using multi-level security.

D. Using masks and permissions.

Which clone table statement is correct?

A. A clone table can have its own indexes.

B. A clone table has its own catalog statistics.

C. The clone and base tables share a table space.

D. The clone and base tables must have different schema names.

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

A. col2 is converted to EBCDIC

B. col1 is converted to UNICODE

C. SQLCode-270: Function not supported

D. col2 and col1 are converted to UTF-32

When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?

A. Function A.B is stopped and queues all access.

B. Function A.B is stopped and rejects all access.

C. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.

D. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.

What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?

A. Recover the table space to current.

B. Run the REORG utility with SHRLEVEL NONE.

C. Run a Point In Time RECOVER or the LOAD REPLACE utility.

D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).

The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

A. Issue a LOCK TABLE for all 4 tables.

B. Execute the SQL INSERT before the SQL UPDATE.

C. Provide an effective commit / restart process.

D. Run a QUIESCE utility before the process starts.

Which of the following statements is NOT correct?

A. UNLOAD with NOPAD improves performance.

B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.

D. Clone table allows replacing data without renames and rebinds to support online load replace.