Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

IBM C2090-614 Exam Actual Questions

The questions for C2090-614 were last updated on April 13, 2024.
  • Viewing page 1 out of 27 pages.
  • Viewing questions 1-4 out of 117 questions
 

Topic 1 - Single Topic

Question #1 Topic 1

Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

  • A. Check constraints
  • B. Default constraints
  • C. Informational constraints
  • D. Referential integrity constraints
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #2 Topic 1

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?

  • A. Create a replicated summary table for the SALES table using the table space TS_REPL.
  • B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
  • C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
  • 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.
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #3 Topic 1

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

  • A. EXPLAIN_FROM_DATA
  • B. EXPLAIN_FROM_ACTIVITY
  • C. EXPLAIN_FROM_SECTION
  • D. EXPLAIN_FROM_CATALOG
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #4 Topic 1

Which statement about the initiation of parallel I/O is correct?

  • 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.
  • 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.
  • 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.
  • 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
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel