When running an append query,what happens if a record violates the primary key rule for the destination table?
A)The record is rejected.
B)The original record is selected.
C)The record is added without the primary key field.
D)The append query is rejected.

Question

Quizplus · Accepted Answer

When running an append query, if a record violates the primary key rule for the destination table, the record is rejected. This is because the primary key constraint ensures that each record in a table is unique, and violating this rule could result in data integrity issues. Therefore, the database will not allow the addition of a record that violates the primary key constraint.

When Running an Append Query,what Happens If a Record Violates