ExamTopics Logo
Mail Us[email protected]
Menu
Appian Discussions
exam questions

Exam ACD100 All Questions

View all questions & answers for the ACD100 exam
Go to Exam

Exam ACD100 topic 1 question 17 discussion

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

Review the following table.

Given the following options are in mySQL, which option correctly alters the last row on the table?

  • A. INSERT price = 0.9 -

    INTO product -
    WHERE product_id = 3;
  • B. MODIFY product -

    UPDATE price = 0.9 -
    WHERE product_id = 3;
  • C. SET product -
    (price) VALUES (0.9)
    WHERE product_id = 3;
  • D. UPDATE product -

    SET price = 0.9 -
    WHERE product_id = 3;
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by yanoolthecool at Dec. 26, 2023, 11:44 a.m.

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
Submit Cancel
yanoolthecool
5 months, 4 weeks ago
Selected Answer: D
D, no brainer, if it didn't start with UPDATE (or MERGE(or FLASHBACK (or etc.. advanced stuff))) then its not gonna 'alter' the row.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago