Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 14

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this? (Choose the best answer.)

Answer options

• A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints on the data store.
• B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.
• C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.
• D. You cannot add a primary key if it does not physically exist on the related database catalog. You can reverse engineer only the existing constraints.

Correct answer: D

Explanation

The correct answer is D because a primary key must exist in the underlying database to be defined in ODI metadata. Options A and B misstate the capability to add a non-existent primary key, while option C incorrectly suggests that non-null conditions can replace the primary key functionality.