1. Home
  2. IBM
  3. C2090-600

IBM DB2 11.1 DBA for LUW

Exam Details

  • Exam Code
    :C2090-600
  • Exam Name
    :IBM DB2 11.1 DBA for LUW
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :60 Q&As
  • Last Updated
    :Apr 11, 2025

IBM IBM Certifications C2090-600 Questions & Answers

  • Question 51:

    Which phase of the LOAD utility is unique to loading column organized tables?

    A. LOAD

    B. BUILD

    C. DELETE

    D. ANALYZE

  • Question 52:

    Which statement about Data Server Manager (DSM) is TRUE?

    A. DSM can be used for reviewing audit trails

    B. DSM cannot be used for database administration

    C. DSM can be used for configuration management of DB2 Data Server drivers

    D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

  • Question 53:

    Which of the following enables the user to connect to the HADR standby database and execute select statements?

    A. DB2_HADR_ROS

    B. HADR_SPOOL_LIMIT

    C. DB2_HADR_SOSNDBUF

    D. DB2_HADR_PEER_WAIT_LIMIT

  • Question 54:

    When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

    A. The PAGESIZE database configuration parameter is set to 32K.

    B. The AUTO_REORG database configurationparameter is set to NO.

    C. The DFT_EXTENT_SZ database configuration parameter is set to 8.

    D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

    E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

  • Question 55:

    What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

    A. SYSIBM

    B. SYSFUN

    C. SYSCAT

    D. SYSIBMADM

  • Question 56:

    Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

    A. To prunethe contents of a staging table.

    B. To prune the contents of a synopsis table.

    C. To prune the contents of a materialized query table (MQT).

    D. To prune the contents of a declared global temporary table.

  • Question 57:

    Which of the following are valid Explain operators? (Choose two.)

    A. CTQ

    B. XSCAN

    C. IXSCAN

    D. SELECT

    E. COLSCAN

  • Question 58:

    Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

    A. db2pd

    B. db2dart

    C. db2expln

    D. db2advis

  • Question 59:

    If the following SQL statements are executed:

    How many rows will be added to the DEPARTMENT table?

    A. 1

    B. 2

    C. 3

    D. 4

  • Question 60:

    You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

    A. db2cluster -verify

    B. db2cluster -cm -list -alert

    C. db2cluster -verify -configuration

    D. db2cluster -cm -verify -resource

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