Ensurepass.com : Ensure you pass the IT Exams
2018 Jan 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: 21 – (Topic 1)

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATETABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE

TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the

sequence to CREATE an index IX1 on COL1 on TB1?

  1. ALTER TABLESPACE TS1 MAXPARTITIONS 15;

  2. COMMIT;

  3. CREATE INDEX IX1 ON TB1 (COL1);

  4. REORG TABLESPACE TS1;

Answer: C

Question No: 22 – (Topic 1)

Which attribute(s) determine the absolute maximum number of partitions for a partition-by- growth table space?

  1. MAXPARTITIONS

  2. MAXPARTITIONS, DSSIZE

  3. MAXPARTITIONS, page size

  4. MAXPARTITIONS, DSSIZE, page size

Answer: D

Question No: 23 – (Topic 1)

When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

  1. List prefetch

  2. Dynamic prefetch

  3. Sequential prefetch

  4. Skip sequential prefetch

Answer: B

Question No: 24 – (Topic 1)

Which DB2 online utility job output provides you with information about the BACKUP SYSTEM history?

  1. DSNJU003

  2. DSNJU004

  3. DIAGNOSE

  4. REPORT with RECOVERY option

Answer: D

Question No: 25 – (Topic 1)

Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME, E.LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT);

Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and EMP?

  1. No, an UPDATE statement against the EMPD view is not allowed at all.

  2. Yes, the view EMPD can be updateddirectly via an UPDATE statement.

  3. No, only a clone of the view EMPD can be updated via an UPDATE statement.

  4. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.

Answer: D

Question No: 26 – (Topic 1)

What trace class will show deadlock information?

  1. Audit class 3.

  2. Statistic class 3.

  3. Accounting class 1.

  4. Performance class 8.

Answer: B

Question No: 27 – (Topic 1)

Which DSNZPARM will define the number of RIDBlocks in the RID Pool?

  1. NUMTCB

  2. MAXRBLK

  3. CONDBAT

  4. URLGWTH

Answer: B

Question No: 28 – (Topic 1)

A single table should allow for up to 100 Terabytes of application data. How do you design your table space?

  1. A segmented compressed table space, BUFFERPOOL BP0.

  2. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.

  3. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.

  4. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.

Answer: D

Question No: 29 – (Topic 1)

What should be implemented in order to audit all the activity of the install SYSADM?

  1. DATA CAPTURE CHANGES should be set on all tables.

  2. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.

  3. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.

  4. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.

Answer: B

Question No: 30 – (Topic 1)

You have to design a numeric column, which is also the primary key. The column should

cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?

  1. BIGINT

  2. INTEGER

  3. DECFLOAT (34)

  4. DECIMAL (31,18)

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Ensurepass Free Guaranteed!
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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.