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

  • 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 #1
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
  1. A
    Check constraints
  2. B
    Default constraints
  3. C
    Informational constraints
  4. D
    Referential integrity constraints

Correct Answer:
C

Question #2
Given the following database design:

A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
  1. A
    Create a replicated summary table for the SALES table using the table space TS_REPL.
  2. B
    Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
  3. C
    Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
  4. D
    Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.

Correct Answer:
B

Question #3
Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?
  1. A
    EXPLAIN_FROM_DATA
  2. B
    EXPLAIN_FROM_ACTIVITY
  3. C
    EXPLAIN_FROM_SECTION
  4. D
    EXPLAIN_FROM_CATALOG

Correct Answer:
C

Question #4
Which statement about the initiation of parallel I/O is correct?
  1. A
    For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
  2. B
    For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
  3. C
    For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
  4. D
    For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into

Correct Answer:
C

Question #5
The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE:

ADM5502W -
The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful.
Which two database configuration parameter settings should be checked? (Choose two.)
  1. A
    LOCKLIST
  2. B
    MAXAPPLS
  3. C
    MAXLOCKS
  4. D
    MAXAGENTS
  5. E
    LOCKTIMEOUT

Correct Answer:
AC

Next Questions

All Pages