C2090-312 Latest Exam (Jan 2018)

[Free] 2018(Jan) EnsurePass Passguide IBM C2090-312 Dumps with VCE and PDF 1-10

January 31, 2018

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-312
100% Free Download! 100% Pass Guaranteed!

IBM DB2 11 DBA for z/OS

Question No: 1

Which statement is true?

  1. Unicode and EBCDIC have a different collating sequence.

  2. The collating sequence for ASCII and EBCDIC is identical.

  3. The collating sequence for Unicode and EBCDIC is identical.

  4. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.

Answer: A

Reference:http://www- 01.ibm.com/support/knowledgecenter/SS4LQ8_3.1.0/com.ibm.datatools.aqt3.doc/gui/conc epts/c_idaa_inconsistencies.html(first bulleted point on the page)

Question No: 2

Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?

  1. A period-specification placed in the FROM clause of a subselect.

  2. A period-specification placed in the WHERE clause of a subselect

  3. A SELECT statement predicate against the transaction start ID of the base table.

  4. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.

  5. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.

Answer: C,E

Question No: 3

Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?




  4. CREATEIN on the schema

Answer: A

Question No: 4

Which DB2 Client command can be used to identify the Client#39;s version?

  1. db2fm

  2. db2look

  3. db2level

  4. db2ldcfg

Answer: C

Question No: 5

The degree of parallelism can vary for the REBUILD INDEX utility.

What action should be taken to limit the use of real memory using the REBUILD INDEX utility?

  1. Increase the value of the PARALLEL option.

  2. Decrease the value of the PARALLEL option.

  3. Increase the value in the CURRENT DEGREE special register.

  4. Decrease the value in the CURRENT DEGREE special register.

Answer: A

Question No: 6

Which statement about an array data type is true?

  1. User-defined data types are allowed in an array.

  2. An array is a built-in data type and can only be numeric.

  3. Arrays can be used as direct input to a select-statement predicate.

  4. Associative arrays can only use INTEGER and VARCHAR data types as indexes.

Answer: D

Question No: 7

Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?

  1. Issue the ALTER INDEX REGENERATE statement.

  2. Use the ALTER INDEX statement to add a column to an index that was built with DEFINE NO.

  3. Add a new column to both a table and an index in the same commit operation when the table is in a partition-by-growth table space and the index is built with DEFINE YES.

  4. When you extend the length of a varying-length character (VARCHAR data type) or varying-length graphic (VARGRAPHIC data type) column that is contained in one or more indexes that are defined with the NOT PADDED option.

Answer: B

Question No: 8

A table space is successfully recovered by using RECOVER TABLESPACE db.ts TOLASTFULLCOPY. This table space is referenced by an index.

Which statement is true?

  1. The index has now a status of REFP.

  2. The index has now a status of RECP.

  3. The index has now a status of CHKP.

  4. The index has now a status of RBDP.

Answer: C

Question No: 9

Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?





Answer: B

Question No: 10

Which component is NOT shared between DB2 data sharing members?

  1. SCA

  2. IRLM

  3. DB2 catalog

  4. DB2 directory

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-312 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-312 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
Free VCE Simulator Yes No No
Instant Download Yes No No