Black Friday Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! C2090-312 has been withdrawn.

Practice Free C2090-312 IBM DB2 11 DBA for z/OS Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the IBM C2090-312 Exam the most current and reliable questions . To help people study, we've made some of our IBM DB2 11 DBA for z/OS exam materials available for free to everyone. You can take the Free C2090-312 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 67 Questions Search Other IBM Exam
Question # 6

What is necessary in order to enable optimization hints?

A.

ASYSIBM.PLAN_TABLEtable.

B.

INSERT authority on SYSIBM.SYSQUERY table.

C.

A required index on the PLAN_TABLE used for optimization hints.

D.

ADSN USERQUERY TABLE table under the schema in which hints will be created.

Question # 7

You want to determine which objects of your database DB1 are in LPL. What command should be used?

A.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')

B.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')

C.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)

D.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)

Question # 8

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?

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 # 9

The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE).

Where can this be verified?

A.

In the DSN1PRNT job output of the header page.

B.

In the DB2 MSTR address space joblog as all DB2 commands are shown there.

C.

In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log.

D.

In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log.

Question # 10

What is required before you begin your installation of DB2 11?

A.

Data sets for catalog and directory tables must be user-managed.

B.

Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.

C.

Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.

D.

Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.