C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 4)

C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which table function can be used to determine whether all of a particular table sp...

  • Which statement about DB2 Merge Backup is FALSE?

  • What can be done to prevent applications from failing when DB2 cannot create a new...

  • What values can be assigned to the HADR_SYNCMODE configuration parameter?

  • Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used ...

  • With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failo...

  • What is the default user workload class that is created for each database table?

  • Which configuration parameter is used to designate a storage area for archived log...

  • Prior to migrating to DB2 10.1, a DBA executed the following command on a daily ba...

  • Which diagnostic tool can be used to show high-watermark consumptions of Fast Comm...

  • You need to restore a table space that was backed up earlier, but before you begin...

  • In what situation should you use a redirected restore operation?

  • In which situation would you NOT use a redirected restore?

  • After starting a series of LOAD operations it appears that one LOAD is failing. Wh...

  • If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

  • Which constraints are used to tell the DB2 Optimizer to consider business rules th...

  • Given the following database design:A Explain plan shows that a broadcast join is ...

  • Which statement about the initiation of parallel I/O is correct?

  • The following message is frequently seen in the DB2 Diagnostics Log file (db2diag....

  • Consider the following statement:Which indexes should be created for optimal query...

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
    5 views
    people
    0 takers
    folder
    IBM

  • C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 4) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings