Download IBM.C2090-320.ActualTests.2019-08-01.61q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-320 |
| Exam Name: | DB2 11 Fundamentals for z/OS |
| Date: | Aug 01, 2019 |
| File Size: | 638 KB |
Demo Questions
Question 1
Which of the following elements is affected by a ROLLBACK statement?
- LOB table spaces
- Changes in cursor positioning
- Acquisition and release of locks
- Caching of rolled back statements
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_rollback.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_rollback.html
Question 2
Which statement is TRUE regarding ROLLBACK processing?
- It only reads active logs
- It always needs archive logs
- It can never be processed just from memory
- It uses output buffers, active and archive logs
Correct answer: D
Explanation:
Question 3
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?
- SET CURRENT SQLID = ‘DB2’;
- SET CURRENT RULES = ‘DB2’;
- No preceding statement is needed
- SET CURRENT SCHEMA = ‘DB2’;
Correct answer: A
