← Back to exam page

C2090-600 – IBM DB2 11.1 DBA for LUW

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

Select an option, then click Submit answer.

  • ○

    db2pd
  • ○

    db2dart
  • ○

    db2expln
  • ○

    db2advis
Question 8

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

Select an option, then click Submit answer.

  • ○

    A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.
  • ○

    If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.
  • ○

    A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.
  • ○

    After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.
Question 9

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

Select an option, then click Submit answer.

  • ○

    REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
  • ○

    REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;
  • ○

    RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
  • ○

    RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;