ExamTopics Logo
Mail Us[email protected]
Menu
 

C2090-614 Actual Exam Questions

Last updated on Nov. 16, 2024.
Vendor:IBM
Exam Code:C2090-614
Exam Name:DB2 10.1 Advanced DBA for Linux UNIX and Windows
Exam Questions:108
97% Passed the exam with this material
 

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 🗳️

file Viewing page 1 out of 27 pages.
Viewing questions 1-4 out of 108 questions
Next Questions
Browse atleast 50% to increase passing rate cup
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.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago