Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

IBM C2090-312 IBM DB2 11 DBA for z/OS Exam Practice Test

Demo: 10 questions
Total 67 questions

IBM DB2 11 DBA for z/OS Questions and Answers

Question 1

What is the minimum buffer pool page size for a compressed index?

Options:

A.

4K

B.

8K

C.

16K

D.

32K

Question 2

When we use multilevel-security using a security label column, which sentence is true?

Options:

A.

A unique constraint is allowed on a security label column.

B.

A check constraint is not allowed on a security label column.

C.

A referential constraint is not allowed on a security label column.

D.

Multilevel security with row-level checking is enforced when DB2 checks a referential constraint.

Question 3

You have defined the array type PHONENUMBERS using the following DDL:

CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];

You also defined a variable named RECENT_CALLS based on this new array type as follows:

CREATE VARIABLERECENT_CALLS PHONENUMBERS:

Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?

Options:

A.

SET LIST_SIZE = MAX(RECENT_CALLS)

B.

SET LIST_SIZE = ARRAY_MAX(RECENT_CALLS)

C.

SET LIST_SIZE = ARRAY_LAST(RECENT_CALLS)

D.

SET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS)

Question 4

Given the following output:

DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS -

DSNV402I _DB2D ACTIVE THREADS -

NAME ST A REQ ID AUTHID PLAN ASID TOKEN

DB2CALL T 17039 BBISS BBISS 00AF 19855

TSO T * 3 KSTTEST KSTTEST 0135 20172

A51OTEST N* 13 CICSTEST 0125 19625

You receive a call that user KSTTEST is holding resources and needs to be canceled.

Which command should be issued?

Options:

A.

-CANCEL THREAD( 3)

B.

-CANCEL THREAD(20172)

C.

-CANCEL USER(KSTTEST)

D.

User KSTTEST does not hold an active connection, no way he blocks anything.

Question 5

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?

Options:

A.

The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.

B.

The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.

C.

The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.

D.

The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache.

Question 6

DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?

Options:

A.

SYSIBM.SYSDBAUTH

B.

SYSIBM.SYSAUTOALERTS

C.

SYSIBM.SYSAUDITPOLICIES

D.

SYSIBM.SYSTABLESPROFILES

Question 7

Which statement about an array data type is true?

Options:

A.

User-defined data types are allowed in an array.

B.

An array is a built-in data type and can only be numeric.

C.

Arrays can be used as direct input to a select-statement predicate.

D.

Associative arrays can only use INTEGER and VARCHAR data types as indexes.

Question 8

Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?

Options:

A.

XML column

B.

LOB column

C.

DOCID column

D.

Hidden ROWID column

Question 9

DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format.

What processing is NEVER allowed?

Options:

A.

Changes to the BSDS.

B.

RECOVER to CURRENT.

C.

REORG with RBALRSN_CONVERSION EXTENDED.

D.

SQL update activities (INSERT. UPDATE, DELETE, MERGE).

Question 10

Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?

Options:

A.

XML

B.

CLOB

C.

DBCLOB

D.

VARBINARY

Demo: 10 questions
Total 67 questions