File Info
| Exam | DB2 11 Fundamentals for z/OS |
| Number | C2090-320 |
| File Name | IBM.C2090-320.Pass4Sure.2019-05-02.36q.tqb |
| Size | 471 KB |
| Posted | May 02, 2019 |
| Download | IBM.C2090-320.Pass4Sure.2019-05-02.36q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which of the following are contained in the PLAN_TABLE? (Choose two.)
- RUNSTATS recommendations
- Access to LOB values, which are stored separately from the base table
- Access to parent or dependent tables needed to enforce referential constraints
- Whether an index access or table space scan is used for each access to a table
- The join methods and types that are used, and the order in which DB2 joins the tables
Correct answer: DE
Question 2
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?
- COPY
- REORG
- STOSPACE
- BACKUP SYSTEM
Correct answer: D
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_useutilitiespaneldb2i.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_useutilitiespaneldb2i.html
Question 3
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?
- 10 row locks
- 200 page locks
- A single table space lock
- 6 partition locks (given a table space with a total of 10 partitions)
Correct answer: C
