Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 17

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

Answer options

• A. conditions
• B. foreign keys
• C. primary keys
• D. alternate keys
• E. not null

Correct answer: B, E

Explanation

Foreign keys (B) ensure uniqueness by linking to unique records in another table, while not null (E) ensures that a field must have a value, which can also contribute to uniqueness in certain contexts. Conditions (A), primary keys (C), and alternate keys (D) do not directly ensure uniqueness in the same way in this context.