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

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

  1. 10 row locks
  2. 200 page locks
  3. A single table space lock
  4. 6 partition locks (given a table space with a total of 10 partitions)

Answer(s): C



Which of the following is NOT TRUE?

  1. An index can be created on XML columns
  2. Length must be specified for an XML column
  3. XML columns can be added to existing tables
  4. Triggers can be created on tables with XML columns

Answer(s): D



Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?





Answer(s): D



The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

  1. SELECT * FROM MYUSER.EMP;
  2. CONNECT TO MYREMOTE; SELECT * FROM MYUSER.EMP;
  3. SELECT * FROM MYUSER.MYREMOTE.EMP;
  4. CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP; SELECT * FROM MYUSER.EMP_ALIAS;

Answer(s): B




950+
I just finished my exam this week. It was a good score of 950+.
- UNITED STATES
Upvote


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

Read more ...