Microsoft
Amazon
CompTIA
Salesforce
Cisco®
SAP
PMI
ISC
ISACA
VMware
HP
Palo Alto Networks
EC-Council
LPI
Google
Fortinet
All Vendors
  2. Home
  3. Exam List
  4. IBM
  5. C2090-320

DB2 11 Fundamentals for z/OS exam
C2090-320 Exam

Given the tables:



Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.





Answer(s): A



Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

  1. Reduced active logs
  2. Reduced storage use
  3. Higher transaction rates
  4. Reduced lock contention
  5. Increased data availability

Answer(s): C,E



The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

  1. DSSIZE
  2. PRIQTY
  3. NUMPARTS
  4. BUFFERPOOL
  5. MAXPARTITIONS

Answer(s): A,C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html



Which of the following statements about a system-period temporal table is TRUE?

  1. Rows can be archived into a history table which is always read only
  2. Every row has a pair of timestamps which is set and managed by the application
  3. AN SQL query for auditing can be run against current data or history data, but not both
  4. The table contains only the current active rows

Answer(s): B

Explanation:

In a system-period temporal table, every row has a pair of timestamps, which are set by the DB2 system and recorded in the begin_column and end_column columns. DB2 uses the SYSTEM_TIME period to audit the data changes. It provides the application with the database managed row begin and row end timestamp maintenance, providing non-overlapping time periods with no gaps in time.


Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-1410temporal-tables-db2zos/ index.html




Abdul
I passed the exam on Monday morning and was amazed at how much this site had covered, fortunately that's it for another three years. The tests really did help so thanks!!
- Doha
Upvote


Rose
I passed that exam the first time. And I thank you folks for that. I could not have passed it with out your help.
- South Africa
Upvote


Shourya
I've just done my exam and passed (890) - your materials are spot on.
- UNITED STATES
Upvote


90%
I have sat and passed.
- Haidarabad
Upvote


Jessica
Thanks to this site! i passed my 310-055 exam with 90%
- UNITED STATES
Upvote


George
I passed my VCP Exam this week with an 87. I hadn't taken a cert exam in 10 years. Your product was very helpful and helped me hone the areas where I was lacking. Thank you.
- UNITED ARAB EMIRATES
Upvote


David B.
I would like to thank this site for the great support and passing 920-105 exam with excellent result. Thanks once again!
- UNITED STATES
Upvote


Bruce Gord
Thanks Well I just passed the exam with high score. Anyway, thanks for providing the good material.
- Malaysia
Upvote


Parag
Hi, Let me appreciate your Study Guide. I passed the exam with 92%. All the questions were from the study guide. I am still wondering where I went wrong for not scoring 100%. I will not hesitate to recommend your site to my friends and colleagues. Thanks
- UNITED STATES
Upvote


J M
Hello, I purchased your 640-801 last week and I was able to pass my exam with 96%. The questions were all the same. I wondering how you guys do it? Keep up the good job. I appreciate your service and your best price. Thanks
- UNITED STATES
Upvote

Read more ...