DB2 11 Fundamentals for z/OS exam (C2090-320) - IBM

Exam Questions

94%

Students found the real exam almost the same

1,057

Students passed this exam after ExamsQA Prep

95.1%

Average score during Real Exams at the Testing Centre

Browse 124 Questions
💡

Browse at least 50% questions to maximize your chances of passing

Free Preview Questions

Sample C2090-320 Exam Questions & Explanations

Practice with real question formats, multiple choice options, and detailed answer explanations for IBM C2090-320.

Question #1 Verified Q&A
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64.<br />
If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of<br />
the following levels?
A PAGE
B PARTITION
C TABLE
D TABLESPACE
Correct Answer: PARTITION
Question #2 Verified Q&A
Which of the following are contained in the PLAN_TABLE? (Choose two.)
A The join methods and types that are used, and the order in which DB2 joins the tables
B RUNSTATS recommendations
C Access to parent or dependent tables needed to enforce referential constraints
D Access to LOB values, which are stored separately from the base table
E Whether an index access or table space scan is used for each access to a table
Correct Answer: The join methods and types that are used, and the order in which DB2 joins the tables, Whether an index access or table space scan is used for each access to a table
Question #3 Verified Q&A
Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?<br />
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;
A BIND
B TRIGGER
C REORG
D EXECUTE
Correct Answer: EXECUTE
Question #4 Verified Q&A
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?
A COPY
B STOSPACE
C REORG
D BACKUP SYSTEM
Correct Answer: BACKUP SYSTEM
Question #5 Verified Q&A
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?
A 10 row locks
B A single table space lock
C 200 page locks
D 6 partition locks (given a table space with a total of 10 partitions)
Correct Answer: A single table space lock

Want to practice all 124 questions?

Practice under real exam conditions with instant grading, timed simulations, and community insights.

Start Full C2090-320 Practice Test

Frequently Asked Questions

Common questions about the IBM C2090-320 certification practice test

How many questions are in the IBM C2090-320 practice exam on ExamsQA?
Our C2090-320 (DB2 11 Fundamentals for z/OS exam) practice question bank currently includes 124 verified questions with comprehensive explanations.
Are the C2090-320 exam practice questions up to date for 2026?
Yes, all IBM C2090-320 practice questions are regularly updated and verified against current exam objectives.
Will the C2090-320 practice questions help me pass on my first attempt?
The C2090-320 (DB2 11 Fundamentals for z/OS exam) question bank is built to mirror the real exam's format and topics, with detailed explanations for every answer so you understand the reasoning — not just memorize responses.
Is there a free demo available for C2090-320 DB2 11 Fundamentals for z/OS exam?
Yes, ExamsQA offers free demo questions for the C2090-320 exam so you can test the interface and question quality before purchasing full access.