P2090-070 by IBM Valid Free Exam Practice Test

IBM Information Management Optim z/OS Technical Mastery Test v1 - P2090-070 Exam Practice Test

Question 1

Which of the following file formats is NOT supported by the Browse Utility?

A. Control File B. Extract File C. Compare File D. Sequential File

Correct Answer: D

Question 2

Which of the following statements is FALSE about Optim Edit Utility?

A. "Undo All" primary command removes all changes made to all the rows in the current fetch set. B. If data are refetched, you CANNOT undo changes to the previous fetch set. C. "Undo" line command removes all changes made to the current row in the fetch set. D. If AUTOCOMMIT is on, changes are committed to the database when the ENTER key is used.

Correct Answer: C

Question 3

What identifies the tables, relationship traversals, and selection criteria for the data to be archived?

A. Storage Profile B. Access Definition C. Browse Utility D. Archive File

Correct Answer: B

Question 4

Which of the following actions does NOT require a primary key?

A. visiting a table more than once in a process B. defining Optim relationships C. deleting data D. enabling Point and Shoot feature for a Start Table in an Access Definition

Correct Answer: B