Free C2090-552 – IBM InfoSphere Optim for Distributed Systems - V7.3.1 Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Use the Collections tab on the Archive Request Editor to specify the collection(s) in which the Archive File should be added automatically.

• ○

  An Archive File may belong to multiple Archive Collections, and an Archive Collection may contain multiple Archive Files.

• ○

  Archive Files contained within a collection do not need to be registered in the Archive Directory.

• ○

  ODM, by default, processes the Archive Files in the collections in ascending date order based on the dates the Archive Files were created.

• ○

  An Archive File containing multiple tables with the same names and creator ids, but with different DB Aliases, may be stored in an Archive Collection.
  

Select all that apply, then click Submit answer.

• ○

  String literals or hexadecimal literals

• ○

  SUBSTR, RAND, or SEQ Functions

• ○

  Data privacy functions

• ○

  NULL, CURRENT_DATE, CURRENT_TIME

• ○

  Numeric Constants and Boolean Constants
  

Select all that apply, then click Submit answer.

• ○

  The Optim Directory can reside on DB2 LUW, Oracle or Microsoft Access.

• ○

  There may be more than one Optim Directory and they may reside on both Windows and UNIX.

• ○

  The Optim Directory can reside on DB2 z/OS, Teradata or Microsoft SQL Server.

• ○

  The definitions can be migrated from one Optim Directory to another with an Export and Import process.

• ○

  The Optim Directory is always stored on a Windows workstation.
  

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.
  

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.
  

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
  

Select an option, then click Submit answer.

• ○

  Create new Archive Entries for Archive Files imported from a different location or for which the entry has been removed.

• ○

  Create new Archive Files for Archive Files imported from a different location or for which the file has been removed.

• ○

  Create new Archive Directories for Archive Files exported to a different location or for which the entry has been removed.

• ○

  Create new Archive Entries for Archive Files exported to a different location or for which the file has been moved.
  

Select an option, then click Submit answer.

• ○

  The name of the export file is missing.

• ○

  The name of the report file is missing.

• ○

  The name of the Optim Directory is missing.

• ○

  The name of the parameter file is missing.
  

Select an option, then click Submit answer.

• ○

  with ODM/Optim Connect and an ODBC/JDBC enabled query tool

• ○

  in a non-relational fashion as the relationships changed as part of the Convert process

• ○

  with Optim's table Edit or Browse functions since the data is now in a table format

• ○

  in a relational fashion as the relationships are maintained as part of the Convert process
  

Select an option, then click Submit answer.

• ○

  an AIX Server, Windows Desktop, and Optim DRA

• ○

  a Sun Solaris Server and Multiple Windows Desktops with Rhumba

• ○

  Optim Data Growth with ODM/Optim Connect

• ○

  Optim TDM, DP, and Archive with ODM/Optim Connect