Multiple choice technology

Which of the following is true for 0...n cardinality?

  1. The cardinality is optional and a union will be performed.

  2. The cardinality is optional and an inner join will be performed.

  3. The cardinality is optional and an outer join will be performed.

  4. The cardinality is unknown and an inner join will be performed.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Cardinality of 0...n means the relationship is optional (0 or more records may exist) and Framework Manager generates an outer join to preserve all records from the primary table even when no matching records exist in the related table. An inner join would only return matching records, while a union combines result sets. The '0' indicates optionality, which requires an outer join.

Keep practicing — related questions