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. 3)

  • 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 #11
What advantage do block-based buffer pools offer compared to regular buffer pools?
  1. A
    They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.
  2. B
    They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.
  3. C
    They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.
  4. D
    They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing

Correct Answer:
A

Question #12
The following query is executed frequently against the SALES table:
SELECT sales_person, region FROM sales WHERE region = 'Quebec'
Which statement will create an index for optimal query performance?
  1. A
    CREATE INDEX sales_idx ON sales (region)
  2. B
    CREATE INDEX sales_idx ON sales (sales_person)
  3. C
    CREATE INDEX sales_idx ON sales (region, sales_person)
  4. D
    CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Correct Answer:
C

Question #13
Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?
  1. A
    The MON_DB_SUMMARY administrative view.
  2. B
    The MON_BP_UTILIZATION administrative view.
  3. C
    The MON_GET_ACTIVITY_DETAILS table function.
  4. D
    The MON_GET_EXTENT_MOVEMENT_STATUS table function.

Correct Answer:
B

Question #14
What is the FAILARCHPATH database configuration parameter used for?
  1. A
    To specify a path that DB2 will use to look for archive log files that are needed for a roll forward recovery operation.
  2. B
    To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
  3. C
    To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
  4. D
    To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a

Correct Answer:
D

Question #15
An auxiliary HADR standby database must use which HADR sync mode?
  1. A
    SYNC
  2. B
    ASYNC
  3. C
    NEARSYNC
  4. D
    SUPERASYNC

Correct Answer:
D

Previous Questions Next Questions

All Pages