exam questions

Exam ACD100 All Questions

View all questions & answers for the ACD100 exam

Exam ACD100 topic 1 question 19 discussion

Actual exam question from Appian's ACD100
Question #: 19
Topic #: 1
[All ACD100 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Vanced3142
3 months, 3 weeks ago
Selected Answer: A
A is the right option
upvoted 2 times
...
Naaagu
4 months ago
Selected Answer: A
Answer is A
upvoted 2 times
...
yanoolthecool
5 months, 4 weeks ago
Selected Answer: A
A, ez.
upvoted 2 times
...
Ghaz
10 months, 1 week ago
Selected Answer: A
update statement is used to edit existing data, insert statement is used to create new data
upvoted 1 times
...
AaravRV
11 months, 1 week ago
Correct answer is A
upvoted 1 times
...
sriswethasri
1 year ago
A should be the answer
upvoted 1 times
...
farazahmedmirza
1 year ago
Selected Answer: A
A is the answer
upvoted 1 times
...
reika1914
1 year, 2 months ago
Selected Answer: A
Coreect answer is A
upvoted 1 times
...
RuliGap
1 year, 2 months ago
Correct answer is A. is this a joke?
upvoted 2 times
...
DivaLight
1 year, 3 months ago
Selected Answer: A
Update
upvoted 2 times
...
harshmp1007
1 year, 3 months ago
Correct answer is A.
upvoted 2 times
...
SAShinde
1 year, 4 months ago
I think the correct answer is A, as we need to edit the data. Create is used for creating table not the data
upvoted 3 times
...
test123135
1 year, 4 months ago
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, .... );
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago