← Back to exam page

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

Loading demo links...

Showing 4–5 of 5 questions

Question 4

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.
Question 5

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.