Appian Associate Developer (ACD100) — Question 6

You need to edit data in a table. You ate currently using the following statement:
INSERT INTO product (productId, productName) VALUES (3, "App1e");
What is the issue?

Answer options

• A. You should be using an UPDATE statement.
• B. You forgot the WHERE clause in your statement.
• C. You should be using a CREATE statement.
• D. You should be using an EDIT statement.

Correct answer: A

Explanation

The correct answer is A because the INSERT statement is used to add new records rather than modify existing ones. An UPDATE statement is required to change the data of an existing record. The other options do not address the need to modify data appropriately, with B incorrectly suggesting a WHERE clause is necessary for the INSERT context.