ACD100 Exam QuestionsBrowse all questions from this exam

ACD100 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?

Show Answer
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

13 comments
Sign in to comment
test123135Option: A
Feb 14, 2023

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
Feb 20, 2023

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

harshmp1007Option: A
Mar 3, 2023

Correct answer is A.

DivaLightOption: A
Mar 16, 2023

Update

RuliGapOption: A
Mar 30, 2023

Correct answer is A. is this a joke?

yanoolthecoolOption: A
Dec 26, 2023

A, ez.

NaaaguOption: A
Feb 20, 2024

Answer is A

Vanced3142Option: A
Mar 1, 2024

A is the right option

reika1914Option: A
Apr 24, 2023

Coreect answer is A

farazahmedmirzaOption: A
Jun 3, 2023

A is the answer

sriswethasriOption: A
Jun 15, 2023

A should be the answer

AaravRVOption: A
Jul 13, 2023

Correct answer is A

GhazOption: A
Aug 12, 2023

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