Exam ACD100 All QuestionsBrowse all questions from this exam
Question 16

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?

    Correct Answer: A

    To edit data in a table, you should use an UPDATE statement. The INSERT INTO statement is used to add new rows to a table, not to update existing data. Therefore, the correct approach would be to use an UPDATE statement specifying which row to update and what the new values should be.

Discussion
test123135Option: A

I think the correct answer is A, because you use "CREATE" when you create the database not to update values: CREATE TABLE table_name ( column1 datatype, column2 datatype, .... );

SAShindeOption: A

I think the correct answer is A, as we need to edit the data. Create is used for creating table not the data

Vanced3142Option: A

A is the right option

NaaaguOption: A

Answer is A

yanoolthecoolOption: A

A, ez.

RuliGapOption: A

Correct answer is A. is this a joke?

DivaLightOption: A

Update

harshmp1007Option: A

Correct answer is A.

GhazOption: A

update statement is used to edit existing data, insert statement is used to create new data

AaravRVOption: A

Correct answer is A

sriswethasriOption: A

A should be the answer

farazahmedmirzaOption: A

A is the answer

reika1914Option: A

Coreect answer is A