Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-614

IBM C2090-614 Exam Practice Questions (P. 2)

  • Full Access (108 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Consider the following statement:

Which indexes should be created for optimal query performance?
  1. A
    CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
  2. B
    CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
  3. C
    CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
  4. D
    CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;

Correct Answer:
C

Question #7
What will occur when a database administrator adds a new automatic storage path to an existing storage group?
  1. A
    New table spaces will start consuming storage on the new path.
  2. B
    Existing table spaces will not consume storage on the new path.
  3. C
    The storage group will be placed in "Rebalance Pending" mode.
  4. D
    DB2 will verify that space is available on the storage path specified.

Correct Answer:
B

Question #8
Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?
  1. A
    The MON_GET_CONTAINER table function.
  2. B
    The SNAP_GET_TBSP_PART table function.
  3. C
    The SNAPTBSP_RANGE administrative view.
  4. D
    The TS_GET_CONTAINER administrative view.

Correct Answer:
A

Question #9
Which statement about value compression is correct?
  1. A
    To use value compression, you must have a license for the DB2 Storage Optimization Feature.
  2. B
    Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
  3. C
    Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
  4. D
    When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same

Correct Answer:
C

Question #10
Which statement about compression dictionaries is FALSE?
  1. A
    Page-level dictionaries are stored in hidden rows within the table.
  2. B
    Table-level dictionaries are stored in hidden rows within the table.
  3. C
    Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
  4. D
    Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

Correct Answer:
D

Previous Questions Next Questions

All Pages