Download IBM.C2090-320.Pass4Sure.2019-05-02.36q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-320 |
| Exam Name: | DB2 11 Fundamentals for z/OS |
| Date: | May 02, 2019 |
| File Size: | 471 KB |
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
