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: 61 – (Topic 1)

During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

  1. RBA

  2. LRSN

  3. ROWID

  4. SYSPITRT

Answer: B

Question No: 62 – (Topic 1)

In order to retain an access path across a rebind which of the following commands could be used?

  1. BIND PLAN

  2. REBIND PACKAGE(PK1) REOPT(ONCE)

  3. BIND PACKAGE (PK1) EXPLAIN(YES)

  4. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

Answer: D

Question No: 63 – (Topic 1)

Which ALTER TABLE statement will generate a new table space version?

  1. ALTER TABLE … ADD PARTITION …

  2. ALTER TABLE … ADD COLUMN COL2 …

  3. ALTER TABLE … DATA CAPTURE CHANGES …

  4. Altering an already existing VARCHAR column on the table to shorten its maximum length.

Answer: B

Question No: 64 – (Topic 1)

Which stored procedures need to be set up properly in order to register an XML schema?

  1. XSR_ADD_SCHEMA

  2. XSR_REGISTER and XSR_COMPLETE

  3. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE

  4. The commands to register a XML schema do not invoke stored procedures.

Answer: B

Question No: 65 – (Topic 1)

Which trace gives information about frequent log space shortages?

  1. Audit trace class(8)

  2. Statistics trace class(3)

  3. Accounting trace class(10)

  4. Performance trace class(4)

Answer: B

Question No: 66 – (Topic 1)

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

  1. SECADM authority.

  2. ACCESSCTRL authority.

  3. DATAACCESS authority.

  4. SYSADM authority when SEPARATE_SECURITY=NO.

  5. The owner of the object as he/she has that authority implicitly.

Answer: A,D

Topic 2, Volume B

Question No: 67 – (Topic 2)

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?

  1. Issue ALTER TABLESPACE with a valid SEGSIZE gt; 0

  2. Make the table space table-partitioned, then issue ALTER TABLESPACE with a validSEGSIZE gt; 0

  3. 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 gt; 0

  4. Drop the partitioning index, ALTER the table definition by addingpartition ranges to the existing table definition, create a partitioned index and

issue ALTER TABLESPACE with a valid SEGSIZE gt; 0

Answer: B

Question No: 68 – (Topic 2)

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

  1. The data is only stored in the auxiliary table.

  2. The data is only stored in the base table.

  3. The complete data is storedboth in auxiliary and in base table.

  4. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

Answer: B

Question No: 69 – (Topic 2)

What is the one significant difference between sequenceobjects and identity columns?

  1. Identity columns can cache values and sequence objects cannot.

  2. Identity columns can be defined on tables and sequence objects cannot.

  3. Sequence objects can have a character data type and identity columns cannot.

  4. Sequence object values can be used as primary keys and identity column values cannot.

Answer: B

Question No: 70 – (Topic 2)

Altering the DSSIZE is allowed for what type of table space?

  1. XML table space.

  2. Universal table space.

  3. Segmented table space.

  4. DSSIZEcannot be altered.

Answer: B

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