Most recent IBM C2090-320 – An Overview 2 to 11

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
(Full Version!)

Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions

Free Instant Download NEW C2090-320 Exam Dumps (PDF & VCE):
Available on:
https://www.certleader.com/C2090-320-dumps.html

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

Answer: A

Q2. Which catalog tables are populated by RTS? (Choose two.)

A. SYSIBM.SYSTABLES

B. SYSIBM.SYSINDEXES

C. SYSIBM.SYSINDEXPART

D. SYSIBM.SYSINDEXSPACESTATS

E. SYSIBM.SYSTABLESPACESTATS

Answer: DE

Q3. Which DB2 address space manages DB2 locking?

A. IRLM

B. DIST

C. DBM1

D. MSTR

Answer: A

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?

A. No

B. Yes

C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES

D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

Answer: B

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

Answer: B

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

Answer: D

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

Answer: B

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

Answer: C

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?

A. MSTR

B. DBM1

C. DIST

D. IRLM

Answer: A

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

Answer: C

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)