[Free] 2017(Oct) CollectDumps Dumpsleader IBM C2090-312 V13 Dumps with VCE and PDF Download 41-50

CollectDumps 2017 Oct IBM Official New Released C2090-312 V13
100% Free Download! 100% Pass Guaranteed!
http://www.CollectDumps.com/C2090-312 V13.html

IBM DB2 11 DBA for z/OS

Question No: 41

Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?

  1. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column.

  2. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column.

  3. If the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the first partition.

  4. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the last partition.

Answer: C

Question No: 42

Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?

  1. MAXDBAT

  2. CTHREAD

  3. CONDBAT

  4. CONTSTOR

Answer: C

Question No: 43

Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?

  1. CLASS(2,7,8)

  2. CLASS(1,2,3)

C. CLASS(1,5,10)

D. CLASS(1, 2,3,7,8)

Answer: D

Question No: 44

An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID.

What other DB2 supplied information could be reviewed to learn more about the updated

data?

  1. BSDS

  2. SYSIBM.SYSPACKDEP

  3. DB2 Active and Archive Logs

  4. SYSIBM.SYSAUDITPOLICIES

Answer: D

Question No: 45

Which DB2 subsystem parameter limits the number of concurrent active TSO requests?

  1. IDBACK

  2. IDFORE

  3. MAXDBAT

  4. CONDBAT

Answer: B

Question No: 46

Given this statement:

RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH

Which statement is FALSE?

  1. It resets all real-time statistics (RTS) for DB1TS1.

  2. It resets all access path statistics for DB1TS1 in the catalog.

  3. It invalidates the dynamic statement cache for table space DB1TS1.

  4. It externalizes current access paths statistics for DB1 TS1 to HIST catalog tables.

Answer: C

Question No: 47

In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement?

  1. It cannot be a join.

  2. The authids do not have to match.

  3. It must include more than one literal.

  4. It cannot have both literals and parameter markers.

Answer: D

Question No: 48

When would DB2 NOT use list prefetch?

  1. Fast log apply operations.

  2. Reading leaf pages of a disorganized index.

  3. RUNSTATS TABLESPACE without table sampling.

  4. Incremental image copies of a table space defined with TRACKMOD YES.

Answer: B

Question No: 49

You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:

ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5;

What should be your next step?

  1. COPY the table space.

  2. REORG the table space.

  3. REBUILD all of the indexes.

  4. DROP the segmented table space.

Answer: D

Question No: 50

An application receives an 00C90110 reason code. See the following manual explanation of the code.

quot; 00C90110Explanation:The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P#39; catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD). The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database.quot;

Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team.

Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?

  1. REPAIR

  2. REPORT

  3. DIAGNOSE

  4. DSN1LOGP

Answer: C

100% Free Download!
Download Free Demo:C2090-312 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 CollectDumps C2090-312 V13 Full Exam PDF and VCE

CollectDumps 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 CollectDumps IT Certification PDF and VCE