← Back to exam page

P2090-054 – IBM Information Management DB2 10 pureScale Technical Mastery Test v3

Loading demo links...

Showing 1–3 of 10 questions

Question 1

The following are true about the Configuration Advisor, EXCEPT:

Select an option, then click Submit answer.

  • ○

    It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
  • ○

    It creates database objects such as indexes and MQTs to improve performance.
  • ○

    By default, the Configuration Advisor is automatically executed when you create a new database.
  • ○

    To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
Question 2

Which one of the following options is CORRECT about Temporal Tables?

Select an option, then click Submit answer.

  • ○

    System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
  • ○

    Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
  • ○

    System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
  • ○

    Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
Question 3

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?

Select an option, then click Submit answer.

  • ○

    Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
  • ○

    Table data is protected against direct access to the table. Access using views is unrestricted.
  • ○

    In order to take advantage of this feature, applications must be changed to work with the RCAC feature.
  • ○

    Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.