← Back to exam page

C2090-552 – IBM InfoSphere Optim for Distributed Systems - V7.3.1

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Volume B)

Which two statements are true for a Delete Request? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The Delete Process will delete Tables, Rows and Indexes.
  • ○

    The Delete Process uses an Extract or Archive File to identify the set of Rows to be removed.
  • ○

    Specifications for the Delete Process are stored as an Archive Request.
  • ○

    It is not necessary to save the delete request before it is run.
  • ○

    Delete requests must be run separately.
Question 5 (Volume B)

When performing a Delete Request against an Oracle Database, you notice that Oracle is not using the Oracle Array Delete capability even though this feature has been enabled. Which two of the following might be causing this feature to not be used? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Compare Row Contents is not selected in the Delete Request Editor.
  • ○

    Compare Row Contents is selected in the Delete Request Editor
  • ○

    The table in the database has a unique primary key, but the table in the file has a non-unique primary key.
  • ○

    The table in the database has a non-unique primary key, but the table in the file has a unique primary key.
  • ○

    The table to be deleted has file attachments.
Question 6 (Volume B)

Where can the Optim Directory be stored?

Select an option, then click Submit answer.

  • ○

    Microsoft Access database running on Windows platforms
  • ○

    SQL Server running on UNIX platform
  • ○

    DB2 UDB for z/OS running on mainframe platform
  • ○

    Oracle running on Windows, UNIX or Linux platforms