C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 4)

C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • A table named SALES was created as follows:If management wants to use Label-Based ...

  • What authority must be held to create a trusted context?

  • The following statement is run:Which statement about the ACCT_BALANCE column is true?

  • Which statement about the REORGCHK command is true?

  • Table TAB_A resides within table space TBSP_1.Which statement is correct?

  • What is the FLUSH PACKAGE CACHE statement used for?

  • What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

  • Which statement about referential constraints is true?

  • Which statement about triggers is FALSE?

  • A table named CUSTOMER and an index named CUST_IDX were created as follows:Which o...

  • Which command will enable automatic reorg on a database?

  • How can you obtain information about any changes that have been made by the Self-T...

  • What must a user possess if they want to run a DB2 Command Line Processor (CLP) sc...

  • What is the correct procedure for recovering a dropped table when DROPPED TABLE RE...

  • In IBM Data Studio, where can you schedule script-based jobs?

  • Which statement is true regarding client-server database connectivity?

  • Which user-managed file system is required for DB2 pureScale deployments?

  • How can you remove all effects of compression from an index?

  • What authority is required to grant a user ACCESSCTRL authority?

  • Which statements will enable automatic storage in storage group SG_HOT for a given...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    0 completed
    0 takers

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