Free IBM C2090-552 Exam Dumps Questions & Answers

When editing a table, one can right-click on any column and select "Lock". What does the
Lock function do?

• A."Lock" will request a table lock from the DBMS so that no other changes can be made.
• B."Lock" will lock the editing session so that no additional changes can be made to that column.
• C."Lock" will lock the column in place so that it is always visible during horizontal scrolling.
• D."Lock" will lock the named Edit Request and finalize it in the Optim Directory.

After an Archive File and associated Archive Index has been created, you discover that you need to add an additional column tothe Archive File Index. Which process would Optim support to accomplish this task?

• A.Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the appropriate index from the menu and delete it.
  Create a new Archive Index with the appropriate columns and save this index.
• B.Once created, Archive Indexes cannot be deleted or modified. You must restore the archived data to a database and then run the Archive Request again (creating a new
  Archive File) while specifying the correct Archive Index as part of the Archive Request.
• C.Since the Archive File cannot be modified, you must create an additional Archive Index with the correct columns and instruct your users to use this index when performing queries against the Archive File.
• D.Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the appropriate table and modify the Archive Index with the additional columns needed.
  Execute this modification and then save it.

Which statement describes advantages of using an Optim Insert process instead of a Load process to populate a test database?

• A.An Insert process allows for Update/Insert processing in one step; a Load process may not.
• B.An Insert process will be faster than a Load process when inserting large volumes of data.
• C.An Insert process allows you to use Column Maps to transform data; a Load processdoes not.
• D.An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.

The Optim Directory is built in an Oracle Database. If the project Database is Unicode enabled, which of the following is true?

• A.The Optim Directory can be enabled as either Unicode or Non-Unicode.
• B.The Optim Directory and the DB Alias must both be initialized the same, either both as
  Unicode or both as Non-Unicode.
• C.The Optim Directory and the DB Alias both must be Unicode enabled.
• D.The DB Alias must be enabled as Non-Unicode.

Which statement describes a generic relationship?

• A.A generic relationship is a default relationship that Optim creates between any primary keys declared either in the database or Optim where the column names and datatypes match and have an index.
• B.A generic relationship is established when Optim Security is enabled and allows the security administrator to remove duplicate relationships between tablesand automatically point Access Definitions to the unique relationship.
• C.A generic relationship is used for one or more pairs of tables that have the same base name, column names, and attributes, but different creator ids.
• D.A generic relationship is used by Optim when two tables don't have a declared relationship but the columns of the primary key match in name and data type.