Western Governors University (WGU) ITEC2117 D427 Data Management - Applications Pre-Assessment Practice

The correct command to delete a specific customer named Amy Lin from the Customer table involves utilizing the DELETE statement, which is fundamentally used to remove rows from a table based on a specified condition. In this case, the intention is to delete a row that identifies the customer by their first and last names.

The syntax for the DELETE command correctly employed in the correct answer is effective because it clearly outlines the objective of removing records from the Customer table where both the first name and last name match 'Amy' and 'Lin', respectively. This precision is crucial in ensuring that the query targets the correct row(s), particularly in tables where multiple records could exist for various customers.

Using Customer_ID to delete records would be valid if the condition identified a specific customer uniquely within the database context. However, without knowing the specific Customer_ID, it must be noted that if the ID was stated without ensuring it aligns with Amy Lin, the query could delete the wrong record or not delete the intended one at all.

The command that is presented as the correct answer encapsulates the essential elements for this deletion process and adheres to SQL syntax correctly, thus serving as an appropriate solution for the requirement of removing a record corresponding to the customer named Amy Lin.