000-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 5)

000-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 5)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • A user with SYSADM authority executes the following commands at host SERVER1:Assum...

  • Which registry variable is used to enable transparent Lightweight Directory Access...

  • Which command is used to import connectivity configuration information from a file...

  • Due to a hardware failure, it appears that there may be some corruption in databas...

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

  • Which is a valid statement about the Row and Column Access Control (RCAC) feature?

  • A table named SALES was created as follows:If management wants to use Label-Based ...

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

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

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

  • Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW ...

  • Which statement about triggers is FALSE?

  • Which registry variable should be used to specify that 20 percent of each index pa...

  • 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...

  • Which statement about DB2 aggregate registry variables is true?

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

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

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