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

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 72 discussion

Actual exam question from Microsoft's 98-364
Question #: 72
Topic #: 1
[All 98-364 Questions]

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?

  • A. The table will be corrupted.
  • B. Forty (40) rows will be deleted from the table.
  • C. The transaction will restart.
  • D. No rows will be deleted from the table.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by bulat at Aug. 31, 2020, 6:44 p.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
bulat
Highly Voted 4 years, 9 months ago
If transaction has failed statements inside - then all changes are rolled back.
upvoted 8 times
...
bongo2020
Most Recent 3 years, 11 months ago
this explains ACID property of a transaction
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