1. Home
  2. IBM
  3. C2090-612

DB2 10 DBA for z/OS

Exam Details

  • Exam Code
    :C2090-612
  • Exam Name
    :DB2 10 DBA for z/OS
  • Certification
    :IBM Certified Database Administrator
  • Vendor
    :IBM
  • Total Questions
    :134 Q&As
  • Last Updated
    :Apr 11, 2025

IBM IBM Certified Database Administrator C2090-612 Questions & Answers

  • Question 111:

    When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?

    A. DB2

    B. RACF

    C. USER

    D. DEFINER

  • Question 112:

    Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

    A. SECADM authority.

    B. ACCESSCTRL authority.

    C. DATAACCESS authority.

    D. SYSADM authority when SEPARATE_SECURITY=NO.

    E. The owner of the object as he/she has that authority implicitly.

  • Question 113:

    Which connection type can exploit trusted connections?

    A. IMS

    B. CAF

    C. CICS

    D. RRSAF

  • Question 114:

    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)

  • Question 115:

    When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

    A. DSMAX may have to be increased.

    B. Storage requirements for EDMDBDC will decrease.

    C. Storage requirements for some applications will increase.

    D. The dynamic statement cache should be increased to handle the additional SQL statements.

  • Question 116:

    What would be a reason for altering the clustering index of a table?

    A. To increase free space.

    B. Because the clustering index has to match the primary index.

    C. To choose a clustering index to favor batch sequential processing.

    D. To choose a clustering index to promote sequential inserts at the end of the table space.

  • Question 117:

    What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?

    A. MAXRBLK

    B. MAXDBAT

    C. MAXKEEPD

    D. MAXTEMPS

  • Question 118:

    In the CFRM policy, what is the purpose of the PREFLIST?

    A. To identify the size of the structure.

    B. To identify all the DB2 members in the group.

    C. To identify the preferences for DB2 restart in the event of a disconnection.

    D. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.

  • Question 119:

    The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recent activity with no recent RUNSTATS execution?

    A. SYSIBM.SYSCOPY

    B. SYSIBM.SYSTABLES

    C. SYSIBM.SYSINDEXES

    D. SYSIBM.SYSTABLESPACESTATS

  • Question 120:

    Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

    A. The DB2 audit trace.

    B. The DB2 statistics trace.

    C. The DB2 connection trace.

    D. The DB2 accounting trace.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-612 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.