Exam Code: C2090-320 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 11 Fundamentals for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-320 Exam.
2018 NEW RECOMMEND
Free VCE & PDF File for IBM C2090-320 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
P.S. Realistic C2090-320 bundle are available on Google Drive, GET MORE: https://drive.google.com/open?id=1XIupSsBUtO-ijoq0DwWZR2atFXSuzaPm
New IBM C2090-320 Exam Dumps Collection (Question 2 – Question 11)
Q1. Which of the following elements is affected by a ROLLBACK statement?
A. LOB table spaces
B. Changes in cursor positioning
C. Acquisition and release of locks
D. Caching of rolled back statements
Q2. Which catalog tables are populated by RTS? (Choose two.)
Q3. Which DB2 address space manages DB2 locking?
Q4. Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?
C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1
Q5. Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
A. GRANT, COPY, BIND, RUN
B. BIND, EXECUTE, COPY, RUN
C. CREATE, COPY, RUN, EXECUTE
D. COPY, BINDADD, SQL, EXECUTE
Q6. Which of the following describes OLTP workload rather than an analytics workload?
A. Extreme data volume
B. Temporary or intermediate staging of data
C. Set-oriented processing and bulk operations
D. A large number of short, discrete, atomic transactions
Q7. Which of the following statements concerning a bi-temporal table is TRUE?
A. It provides business history, but is not useful for audit purposes
B. It is defined with both an application period and a system period
C. It is useful for audit purposes, but is not useful for business history
D. It contains data reflecting two different times u2013 current time and one previous time
Q8. Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?
A. The resource limit facility table authid.DSNRLMTxx
B. The DB2 catalog table SYSIBM.SYSENVIRONMENT
C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES
D. The communications database table SYSIBM.USERNAMES
Q9. You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?
Q10. Given the following table and index definitions, what type of index will be created?
A. Non-partitioned index
B. Non-partitioned secondary index
C. Data-partitioned secondary index
D. Data-partitioned partitioning index
P.S. Easily pass C2090-320 Exam with Certleader Realistic Dumps & pdf vce, Try Free: https://www.certleader.com/C2090-320-dumps.html ( New Questions)