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

question 10

Multiple Choice

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.

---

Definitions:

Safer

Relates to conditions, practices, or items that minimize or reduce risk and enhance security.

Market Wage Rate

The average or prevailing wage paid to workers in a specific market or industry.

Out-of-town Travel

Journeys made to destinations outside one's usual residence or place of work, often implying leisure or business travel that takes place away from the local area.

Work Hours

The specific times or period during which an employee is expected to carry out their job duties.