1. Home
  2. IBM
  3. C2090-610

DB2 10.1 Fundamentals

Exam Details

  • Exam Code
    :C2090-610
  • Exam Name
    :DB2 10.1 Fundamentals
  • Certification
    :IBM Certified Advanced Database Administrator
  • Vendor
    :IBM
  • Total Questions
    :138 Q&As
  • Last Updated
    :Mar 31, 2025

IBM IBM Certified Advanced Database Administrator C2090-610 Questions & Answers

  • Question 41:

    What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

    A. inline

    B. binary

    C. internal

    D. partitioned

  • Question 42:

    Which product replaced the Control Center used in versions prior to DB2 v10?

    A. IBM Data Studio

    B. IBM Administrator

    C. IBM Data Manager

    D. IBM Command Center

  • Question 43:

    Which DB2 product is NOT suitable for very large data warehouse applications?

    A. DB2 for i

    B. DB2 for AIX

    C. DB2 for z/OS

    D. DB2 for Linux

  • Question 44:

    Which platform supports DB2 pureScale environments?

    A. AIX

    B. iOS

    C. z/OS

    D. Windows

  • Question 45:

    Which tool allows users to connect to a DB2 database using a wizard?

    A. Control Center

    B. IBM Data Studio

    C. Universal Connection Expert

    D. DB2 Connection Pool Manager

  • Question 46:

    Which object is used to cache table and index data as it is read from disk?

    A. Database

    B. Buffer pool

    C. Table space

    D. Package cache

  • Question 47:

    Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

    A. View

    B. Table

    C. Sequence

    D. Identity Column

  • Question 48:

    What needs to be defined in order to track changes made to a system-period temporal table over time?

    A. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

    B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.

    C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.

    D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table.

  • Question 49:

    A table named EMPLOYEES was created as follows:

    What will be the results?

    A. 0

    B. 1

    C. 2

    D. 3

  • Question 50:

    Which two DB2 objects can a view be derived from? (Choose two.)

    A. View

    B. Index

    C. Table

    D. Trigger

    E. Procedure

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