Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-612
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-612.html

DB2 10 DBA for z/OS

Question No: 51 – (Topic 1)

Which of the following results in improving performance of a load job to loaddata into an indexed partitioned table space with multiple indexes?

  1. LOG YES

  2. PREFORMAT

  3. SORTKEYS integer

  4. convert input data

Answer: C

Question No: 52 – (Topic 1)

Whichstatement is true about table check constraints?

  1. Only one constraint per column is allowed.

  2. The LOAD utility cannot enforce the constraint.

  3. A constraint placed on a table does not apply to a view defined on the table.

  4. A row meets the requirement of the constraint if the condition evaluates to true or unknown.

Answer: D

Question No: 53 – (Topic 1)

On what type of index would an ALTER INDEX ADD COLUMN be allowed?

  1. An XML index.

  2. An auxiliary index.

  3. A user defined catalog index.

  4. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.

Answer: C

Question No: 54 – (Topic 1)

Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?

  1. PREF.DISABLED-NO BUFFER

  2. PREF.DISABLED-NO READ ENG

  3. BUFF.UPDATES/PAGESWRITTEN

  4. PAGES WRITTEN PER WRITE I/O

Answer: A

Question No: 55 – (Topic 1)

In the CFRM policy, what is the purpose of the PREFLIST?

  1. Toidentify the size of the structure.

  2. To identify all the DB2 members in the group.

  3. To identify the preferences for DB2 restart in the event of a disconnection.

  4. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.

Answer: D

Question No: 56 – (Topic 1)

Objects DB1.TS1 …. DB1.TS10 are in copy pending status. Which of the following actions removes the copy pendingstate AND creates an entry in SYSIBM.SYSCOPY?

  1. Run the BACKUP SYSTEM utility.

  2. Run the REPAIR SET NOCOPYPEND utility.

  3. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

  4. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 – 10.

Answer: C

Question No: 57 – (Topic 1)

Which connection type canexploit trusted connections?

  1. IMS

  2. CAF

  3. CICS

  4. RRSAF

Answer: D

Question No: 58 – (Topic 1)

What DB2 command when issued displays what migration mode the catalog is in?

  1. DSNC DISPLAY

  2. DISPLAY GROUP

  3. MODIFY irlmproc,STATUS

  4. DISPLAY DATABASE (DSNDB06)

Answer: B

Question No: 59 – (Topic 1)

What two parameters allow DB2to keep a copy of a dynamically prepared statement in the cache?

  1. KEEPDYNAMIC(YES) and CACHEDYN=YES

  2. KEEPDYNAMIC(NO) and CACHEDYN=NO

  3. KEEPDYNAMIC(NO) and REOPT(ALWAYS)

  4. KEEPDYNAMIC(YES) and REOPT(ALWAYS)

Answer: A

Question No: 60 – (Topic 1)

You take image copies ofyour table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement. Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?

  1. Every FLASHCOPY generated with SHRLEVEL CHANGE will automatically be

    consistent.

  2. If you use the generated SHRLEVEL CHANGE option with RECOVER .. TOCOPY later on, DB2 determines the open URs and backs them out

    so that in the end your data will be consistent.

  3. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies

    generated during the same utility execution will be inconsistent.

  4. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies

generated during the same utility execution will also be consistent.

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-612 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE