We provide real C2090-612 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass IBM C2090-612 Exam quickly & easily. The C2090-612 PDF type is available for reading and printing. You can print more and practice many times. With the help of our IBM C2090-612 dumps pdf and vce product and material, you can easily pass the C2090-612 exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-612 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-612 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-612-exam-dumps.html
Q31. The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?
A. Index is created with PCTFREE of zero.
B. The number of columns in the index is less than four.
C. RUNSTATS were run when there were no rows in the table.
D. RUNSTATS were run when there was a million rows in the table.
Answer: C
Explanation:
Q32. When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. An inbound ID is subject to translation.
B. A request does not need an authentication token.
C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
D. For outbound requests, the encrypted password is extracted from RACF.
Answer: B
Explanation:
Q33. In a data sharing environment, how is the LRSN value created?
A. It is selected from the DB2 catalog.
B. It is generated from a sequence object.
C. It is derived from the sysplex timer (store clock).
D. It is derived from combining RBAs from multiple members.
Answer: C
Explanation:
Q34. What should be implemented in order to audit all the activity of the install SYSADM?
A. DATA CAPTURE CHANGES should be set on all tables.
B. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.
D. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
Answer: B
Explanation:
Q35. When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?
A. Function A.B is stopped and queues all access.
B. Function A.B is stopped and rejects all access.
C. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.
D. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.
Answer: D
Explanation:
Q36. Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?
A. LOG YES
B. PREFORMAT
C. SORTKEYS integer
D. convert input data
Answer: C
Explanation:
Q37. Which authority level allows a user to run utilities that change the data in an application database?
A. DBCTRL
B. SYSOPR
C. DBMAINT
D. INSTALL SYSOPR
Answer: A
Explanation:
Q38. When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?
A. List prefetch
B. Dynamic prefetch
C. Sequential prefetch
D. Skip sequential prefetch
Answer: B
Explanation:
Q39. When is changing an index from non-clustering to clustering NOT allowed?
A. If the table space is defined as member cluster.
B. If the data is not ordered by the new clustering index.
C. If the new clustering index is for a table that uses hash organization.
D. If the new clustering index OBID is greater than the old clustering index OBID.
Answer: C
Explanation:
Q40. The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?
A. SYSIBM.SYSCOPY
B. SYSIBM.SYSSTATS
C. SYSIBM.SYSTABLES
D. SYSIBM.SYSTABLESPACESTATS
Answer: D
Explanation: