C2090-612 DB2 10 DBA for z OS (Exam 4)

C2090-612 DB2 10 DBA for z OS (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • When defining a foreign key on a table, which statement is true?

  • If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be...

  • In a normalized design, in third normal form, the entity defined in the logical de...

  • For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

  • When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER ...

  • Given the following statements have been run successfully and the buffer pools BP1...

  • Which stored procedures need to be set up properly in order to register an XML sch...

  • You have to design a table and application layout, in which automatic number gener...

  • Which statement is true about table check constraints?

  • The threads initiated by the distributed transactions are no longer active in DB2,...

  • Which DB2 online utility job output provides you with information about the BACKUP...

  • Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following a...

  • During a recovery of a table space in a data sharing environment, what value is us...

  • When planning for backup/recovery (including disaster recovery), which statement i...

  • DB2 does not take system checkpoints in which circumstance?

  • What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort...

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

  • In determining whether a REORG on an index space would improve performance, which ...

  • Poorly tuned memory can affect application performance, such as having sequential ...

  • The I/O patterns for objects in database NEWBILL need to be reviewed in detail. Al...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    4 views
    people
    0 takers
    folder
    IBM

  • C2090-612 DB2 10 DBA for z OS (Exam 4) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings