← Back to exam page

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

Loading demo links...

Showing 1–3 of 5 questions

Question 1

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 2

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

Select an option, then click Submit answer.

  • ○

    This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
  • ○

    The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
  • ○

    This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
  • ○

    STMM allows DBAs to inspect the current memory allocation by buffer pools.
Question 3

What is the DB2 Load utility?

Select an option, then click Submit answer.

  • ○

    The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.
  • ○

    The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.
  • ○

    The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.
  • ○

    The DB2 Load utility can be used to load and create external functions in a DB2 database.