DB2 10 DBA for z/OS (C2090-612) Free Practice Test

Question 1

Which of the following statements is NOT correct?

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

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

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

D. UNLOAD with NOPAD improves performance.

Correct Answer: C

Question 2

For which table type could you specify ALTERTABLE tb1 DATA CAPTURE CHANGES?

A. Declared global temporary tables

B. Directory tables

C. Auxiliary tables

D. Catalog tables

Correct Answer: D

Question 3

In order to retain an access path across a rebind which of the following commands could be used?

A. BIND PACKAGE (PK1) EXPLAIN(YES)

B. REBIND PACKAGE(PK1) REOPT(ONCE)

C. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

D. BIND PLAN

Correct Answer: C

Question 4

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.

Correct Answer: D

Question 5

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

A. This is expected behavior and independent of the encoding scheme.

B. Theencoding scheme of the table is EBCDIC.

C. The encoding scheme of the table is UNICODE.

D. This could never happen, this is an error and must be reported.

Correct Answer: C

Question 6

Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

A. DRAIN_WAIT & RETRY

B. AUTOESTSPACE YES

C. FASTSWITCH YES

D. LOG NO

E. SORTKEYS 16

Correct Answer: A,C

Question 7

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?

A. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS
SECURITY LABEL;

B. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;

C. ALTER TABLE TB1 AUDIT CHANGES;

D. ALTER TABLE TB1 ADD COLUMN COLC DATE;

Correct Answer: D

Welcome to TestSimulate

IBM DB2 10 DBA for z/OS (C2090-612) Free Practice Test