← Back to exam page

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

Loading demo links...

Showing 7–9 of 10 questions

Question 7

How can you verify that a DB2 installation was successful?

Select an option, then click Submit answer.

  • ○

    Verification is performed by running the VERIFY INSTALL command.
  • ○

    Verification is completed by the DBA using the database verification toolkit.
  • ○

    Verification is automatically performed by the AUTO_CONFIGURE feature.
  • ○

    Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.
Question 8

Which of the following memory heaps is NOT configurable on the cluster caching facility?

Select an option, then click Submit answer.

  • ○

    Shared Communication Area (SCA) Memory.
  • ○

    Lock Memory.
  • ○

    Local Buffer Pool Memory.
  • ○

    Group Buffer Pool Memory.
Question 9

Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?

Select an option, then click Submit answer.

  • ○

    RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.
  • ○

    RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
  • ○

    LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.
  • ○

    With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBAC protected column.