Act now and download your IBM C2090-612 test today! Do not waste time for the worthless IBM C2090-612 tutorials. Download Updated IBM DB2 10 DBA for z/OS exam with real questions and answers and begin to learn IBM C2090-612 with a classic professional.
♥♥ 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
Q41. Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?
A. The DB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 accounting trace.
D. The DB2 performance trace.
Answer: D
Explanation:
Q42. Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)
A. LOG NO
B. SORTKEYS 16
C. FASTSWITCH YES
D. AUTOESTSPACE YES
E. DRAIN_WAIT & RETRY
Answer: C,E
Explanation:
Q43. Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
D. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0
Answer: B
Explanation:
Q44. The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?
A. Recovery will need to be done on the children table first.
B. No recovery is allowed since the tables have been updated.
C. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.
D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.
Answer: D
Explanation:
Q45. For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?
A. Catalog tables
B. Directory tables
C. Auxiliary tables
D. Declared global temporary tables
Answer: A
Explanation:
Q46. What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?
A. Recover the table space to current.
B. Run the REORG utility with SHRLEVEL NONE.
C. Run a Point In Time RECOVER or the LOAD REPLACE utility.
D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).
Answer: C
Explanation:
Q47. Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
A. ALTER TABLE TB1 AUDIT CHANGES;
B. ALTER TABLE TB1 ADD COLUMN COLC DATE;
C. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
D. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;
Answer: B
Explanation:
Q48. The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of
14.6 seconds, what should be done to increase page residency time?
A. Increase DWQT to 10.
B. Decrease VPSIZE by 45,000 pages.
C. Increase VPSIZE to 180,000 pages.
D. Change the buffer pool to use PGFIX(YES).
Answer: C
Explanation:
Q49. The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?
A. Issue a LOCK TABLE for all 4 tables.
B. Execute the SQL INSERT before the SQL UPDATE.
C. Provide an effective commit / restart process.
D. Run a QUIESCE utility before the process starts.
Answer: C
Explanation:
Q50. In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?
A. Index
B. Table
C. Schema
D. Database
Answer: B
Explanation: