1. Home
  2. IBM
  3. C2090-544

IBM C2090-544 Online Practice Questions and Exam Preparation

C2090-544 Exam Details

  • Exam Code
    :C2090-544
  • Exam Name
    :DB2 9.7 Advanced DBA for LUW
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :106 Q&As
  • Last Updated
    :Dec 04, 2021

IBM C2090-544 Online Questions & Answers

  • Question 101:

    Which tool or command will display only the automatic storage paths in an existing backup image?

    A. db2dart
    B. db2ckbkp
    C. INSPECT
    D. db2pd

  • Question 102:

    If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

    A. db2dart
    B. db2apptrk
    C. db2acsutil
    D. db2pd

  • Question 103:

    If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

    A. db2dart
    B. db2apptrk
    C. db2acsutil
    D. db2pd

  • Question 104:

    Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

    A. The ADMINGETTABCOMPRESSINFO table function.
    B. The ADMINGETTABCOMPRESSINFO_V97 table function.
    C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
    D. The ADMIN_GET_TAB_INFO table function.

  • Question 105:

    Which two operators would indicate inter-partition parallelism in an Optimizer Plan? (Choose two.)

    A. LTQ
    B. HSJOIN
    C. BTQ
    D. IP
    E. DTQ

  • Question 106:

    What is the minimum authority required to execute the LOAD command?

    A. DATAACCESS
    B. SQLADM
    C. ACCESSCTRL
    D. SYSCTRL

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