If multiple contacts meet the search criteria for a single record, what may occur in the results?

If multiple contacts meet the search criteria for a single record, what may occur in the results?

• A. The record appears as a single result
• B. The record may appear many times
• C. The system raises an error
• D. The record is excluded

Answer: (B)

When a single record is linked to multiple related contacts that meet the search criteria, the results can include duplicates—one row for each matching contact. This happens because the query returns a row for every related match, so if several contacts under the same record satisfy the criteria, that record may appear multiple times in the results. It’s not an error or an exclusion; it’s a natural consequence of how joined data sets produce rows. If you want to avoid duplicates, you’d typically fetch distinct records or group by the primary record to collapse multiple matches into a single entry.

When a single record is linked to multiple related contacts that meet the search criteria, the results can include duplicates—one row for each matching contact. This happens because the query returns a row for every related match, so if several contacts under the same record satisfy the criteria, that record may appear multiple times in the results. It’s not an error or an exclusion; it’s a natural consequence of how joined data sets produce rows. If you want to avoid duplicates, you’d typically fetch distinct records or group by the primary record to collapse multiple matches into a single entry.