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 elements is affected by a ROLLBACK statement?

  1. LOB table spaces
  2. Changes in cursor positioning
  3. Acquisition and release of locks
  4. Caching of rolled back statements

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html



Which statement is TRUE regarding ROLLBACK processing?

  1. It only reads active logs
  2. It always needs archive logs
  3. It can never be processed just from memory
  4. It uses output buffers, active and archive logs

Answer(s): D



Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

  1. SQLCA
  2. SQLDA
  3. SQLCODE
  4. SQLSTATE

Answer(s): B



Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2. AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create the index?

  1. SET CURRENT SQLID = ‘DB2’;
  2. SET CURRENT RULES = ‘DB2’;
  3. No preceding statement is needed
  4. SET CURRENT SCHEMA = ‘DB2’;

Answer(s): A




Darwin
I passed the Novell 640-822 exam on this last Thursday after using your online test and IPad. This is my first experience with your exams. I'll be using your material from now on. In a few days I'll purchase my last study material for the C
- France
Upvote


Bila
Thanks! I passed 070-284 with 880 070-219 next to complete my MCSE.
- Colorado
Upvote


Passed
I just took my Certification testing for 10-184 Microsoft CRM Installation and Configuration. Your test questions definitely covered the essence of the exam material and I easily passed the exam.
- UNITED STATES
Upvote


Ed
I passed the IBM exam successfully
- UNITED STATES
Upvote


Tina
Last week I took the Citrix exam and I passed with a very high mark, more than what I expected. Thanks!!
- Israel
Upvote


Calvin B.
I just took my Certification testing for 10-184 Microsoft CRM Installation and Configuration. Your test questions definitely covered the essence of the exam material and I easily passed the exam.
- Lafayette
Upvote


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

Read more ...