1. Home
  2. IBM
  3. C2090-320

DB2 11 Fundamentals for z/OS

Exam Details

  • Exam Code
    :C2090-320
  • Exam Name
    :DB2 11 Fundamentals for z/OS
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :123 Q&As
  • Last Updated
    :Apr 11, 2025

IBM IBM Certifications C2090-320 Questions & Answers

  • Question 51:

    Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

    A. Data Facility Storage Management

    B. z/OS Parallel Sysplex Configuration

    C. Workload Manager

    D. z Systems Processor Resource

  • Question 52:

    Which of the following coupling facility structures are used by DB2 in a data sharing environment?

    A. List structure, DB2 logs, and group buffer pools

    B. Work file database, list structure, and virtual buffer pools

    C. Lock structure, shared communications area, and group buffer pools

    D. Lock structure, shared communications area, and bootstrap data sets

  • Question 53:

    Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

    A. Declaring a cursor

    B. Using the WHENEVER statement

    C. Using DCLGEN to produce declarations for tables

    D. Dynamically executing a statement with parameter markers

  • Question 54:

    Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?

    A. EBCDIC tables

    B. z/OS Unicode support

    C. DB2 catalog table SYSIBM.SYSCOLUMNS

    D. DB2's Distributed Relational Database Architecture

  • Question 55:

    Which of the following are valid objects created using DDL? (Choose two.)

    A. PLAN

    B. PACKAGE

    C. DATABASE

    D. SEQUENCE

    E. USAGE LISTS

  • Question 56:

    A view is considered read only if which of the following is TRUE?

    A. The first FROM clause identifies only one table

    B. The outer fullselect contains an ORDERED BY clause

    C. The first SELECT clause specifies the DISTINCT option

    D. The fullselect includes a column of a base table that is defined as implicitly hidden

  • Question 57:

    What is the proper sequence for running the steps of the program preparation process?

    A. Precompile, compile, link edit, bind

    B. Bind, precompile, compile, link edit

    C. Precompile, bind, link edit, compile

    D. Link edit, precompile, compile, bind

  • Question 58:

    Given the following: Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?

    A. The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table

    B. The logically deleted rows are removed from POLICY_INFO_ARC table during the REORG

    C. The deleted rows are removed from both POLICY_INFO_AET and POLICY_INFO_ARC tables

    D. The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table during the REORG

  • Question 59:

    Which type of index will cause DB2 to store the data in a given physical order?

    A. UNIQUE

    B. PRIMARY

    C. CLUSTER

    D. PARTITIONED

  • Question 60:

    Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

    A. Create the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND QUALIFIER clause

    B. Create the object after activating the SEPARATE_SECURITY=YES DSNZPARM

    C. Let somebody with SYSCTRL authority create the object

    D. Create the object after activating an audit policy that will apply to the table that you are about to create

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-320 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.