C2090-619 IBM Exam Questions and Free Practice Test

Question 13

You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

A. Using dbschema utility

B. Using 'oncheck -pT' command

C. Querying sysdepends system catalog table

D. Querying sysviolations system catalog table

Correct Answer:D

Question 14

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

A. onbar -E

B. dbexport

C. onsmsync

D. ontape -exp

Correct Answer:C

Question 15

When KAIO is available and raw disk is used, which statement is true?

A. Logical Log IO is performed by the LIO VP.

B. Physical Log IO is performed by the PIO VP.

C. Logical Log IO is performed by the KAIO VP.

D. Physical Log IO is performed by the CPU VP.

Correct Answer:D

Question 16

Which statement is valid about Data consolidation using send-only replicates?

A. You can have more than one target server.

B. You cannot modify a server to change its mode to send-only.

C. You cannot use this replicate for tables that include TimeSeries columns.

D. You need to define a different replicate for each send-only primary server.

Correct Answer:C

Question 17

Which SQL statement is valid to monitor database server sessions?

A. EXECUTE FUNCTION task ("onstat","-g ses");

B. EXECUTE FUNCTION task ("view sessions","all");

C. EXECUTE FUNCTION task ("check sessions","all");

D. EXECUTE FUNCTION task ("check server","sessions");

Correct Answer:A

Question 18

Which approach is always valid when migrating data across differing hardware and operating system architectures?

A. dbexport source system then dbimport into target.

B. ontape backup from source then restore backup onto target.

C. onunload the source to tape and onload the tape to the target.

D. Set up HDR primary and secondary between source and target.

Correct Answer:A

START C2090-619 EXAM