2017 Nov IBM Official New Released C2090-612
100% Free Download! 100% Pass Guaranteed!

DB2 10 DBA for z/OS

Question No: 91 – (Topic 2)

Using the -SET LOG command, what logging characteristics CANNOT be modified?

  1. The number of minutes between the start of successive checkpoints.

  2. Add a newly defined active log data set to the active log inventory.

  3. Altering DB2 from dual active logging mode to single active logging mode.

  4. The number of log records that DB2 writes between the start of successive checkpoints.

Answer: C

Question No: 92 – (Topic 2)

Which statement about encoding schemes is correct?

  1. A view can have columns with different encoding schemes.

  2. A table can have columns with different encoding schemes.

  3. A table space can have tables with different encoding schemes.

  4. All objects in the subsystem must use the same encoding schemes.

Answer: A

Question No: 93 – (Topic 2)

A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?

  1. Specify the column names to be hashed.

  2. Create a unique index on the hash columns.

  3. Create a clustering index on the hash columns.

  4. Create a unique clustering index on the hash columns.

Answer: A

Question No: 94 – (Topic 2)

Which of the following types of table spaces allow multiple tables?

  1. Segmented

  2. LOB table space

  3. Partition-by-range

  4. Partition-by-growth

Answer: A

Question No: 95 – (Topic 2)

Which of the following tasks cannot be done via a single ALTER TABLE statement?

  1. Add a new partition to the table space.

  2. Change the VALIDPROC attribute of the table.

  3. Change a table check constraint on the table.

  4. Change the DATA CAPTURE attribute of the table.

Answer: C

Question No: 96 – (Topic 2)

In which situation does adding a referential constraint place a table space containing data into check-pending status?

  1. When a primary key is defined on a table with no unique index.

  2. When a foreign key isdefined on a table with the ENFORCED option.

  3. When a foreign key is defined on a table and a corresponding primary key has not been defined.

  4. When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.

Answer: B

Question No: 97 – (Topic 2)

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

  1. col2 is converted to EBCDIC

  2. col1 is converted to UNICODE

  3. SQLCode-270: Function not supported

  4. col2 and col1 are converted to UTF-32

Answer: B

Question No: 98 – (Topic 2)

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

  1. Audit trace class(4)

  2. Monitor trace class(6)

  3. Performance trace class(3)

  4. Accounting trace class(1,2,3,7,8)

Answer: C

Question No: 99 – (Topic 2)

When is a merge scan join a well performing access path?

  1. When the number of qualifying rows of the inner and outer table are both large.

  2. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

  3. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

  4. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

Answer: A

Question No: 100 – (Topic 2)

Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

  1. LOG NO

  2. SORTKEYS 16




Answer: C,E

100% Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-612 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE