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

DB2 10 DBA for z/OS

Question No: 11 – (Topic 1)

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

  1. Theencoding scheme of the table is EBCDIC.

  2. The encoding scheme of the table is UNICODE.

  3. This could never happen, this is an error and must be reported.

  4. This is expected behavior and independent of the encoding scheme.

Answer: B

Question No: 12 – (Topic 1)

When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered toMEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?

  1. DB2 does not allow the command.

  2. DB2 applies the changes immediately.

  3. DB2 allows the command only if the table is empty.

  4. DB2 places the table space in AREOR (Advisory Reorg).

Answer: D

Question No: 13 – (Topic 1)

DB2 does not take system checkpoints in which circumstance?

  1. During an application rollback.

  2. At the end of a successful restart.

  3. When switching from one active log data set to another.

  4. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.

Answer: A

Question No: 14 – (Topic 1)

Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

  1. Append

  2. Inline LOBs

  3. Member cluster

  4. Volatile table

  5. Includecolumns

Answer: A,C

Question No: 15 – (Topic 1)

What IBM provided stored procedure will access DB2 real time statistics tables?





Answer: C

Question No: 16 – (Topic 1)

When planning for backup/recovery (including disaster recovery), which statement is correct?

  1. When you remote copy everything (PPRC, XRC) there is no need to take DB2 image copies anymore.

  2. As data is shared in adata sharing group, disaster recovery in a data sharing environment is identical to a non-data sharing environment.

  3. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual

    objects locally.

  4. When you want to create a consistent backup point, you must use the -SET LOG SUSPEND command to freeze all activity, and then take your

backups with whatever technology you prefer.

Answer: C

Question No: 17 – (Topic 1)

The UNLOAD utility can be used to do which of the following functions?

  1. Unload compressed data.

  2. Unload rows from a FlashCopy image copy.

  3. Unload data from an image copy of an index.

  4. Unload rows from an image copy that has rows from a dropped table.

Answer: A

Question No: 18 – (Topic 1)

What is the result of the command -RECOVER POSTPONEDCANCEL if the postponed- abort thread that you cancel was in the middle of a series of updates when DB2 abended?

  1. The underlying page sets are stopped.

  2. The underlying page sets are placed in REFP restrictive state.

  3. The underlying page sets are placed in REORP restrictive state.

  4. No restrictive state is set. It is your responsibility to ensure data consistency.

Answer: B

Question No: 19 – (Topic 1)

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

  1. Turn on a monitortrace.

  2. Always have a performance trace running.

  3. Perform a DISPLAY DATABASE (LOCKS ) command often.

  4. Always have statistics classes 1鈥?, and 4 and accounting classes 1 and 3 running.

Answer: D

Question No: 20 – (Topic 1)

In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?

  1. Index

  2. Table

  3. Schema

  4. Database

Answer: B

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