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

IBM C2090-612 Exam Actual Questions

The questions for C2090-612 were last updated on Nov. 5, 2024.
  • Viewing page 1 out of 34 pages.
  • Viewing questions 1-4 out of 134 questions
 

Topic 1 - Single Topic

Question #1 Topic 1

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

  • A. NUMTCB parameter must be set to 1 for Java stored procedures.
  • B. NUMTCB parameter must be set to 1 for REXX stored procedures.
  • C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
  • D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

  • A. The next sort step will perform two sorts.
  • B. There are multiple sorts in the plan step.
  • C. One sort in the plan step will accomplish two tasks.
  • D. Two sorts are performed on the new table of a star join.
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #3 Topic 1

What IBM provided stored procedure will access DB2 real time statistics tables?

  • A. DSNAEXP
  • B. DSNAIMS
  • C. DSNACCOX
  • D. DSNLEUSR
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #4 Topic 1

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

  • A. Filter factor information.
  • B. Stage 1 and stage 2 information.
  • C. Number of columns used in an index.
  • D. Number of times an SQL statement is executed.
Reveal Solution Hide Solution   Discussion  

Correct Answer: D 🗳️

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