Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam MB-500 Topic 16 Question 6 Discussion

Actual exam question for Microsoft's MB-500 exam
Question #: 6
Topic #: 16
[All MB-500 Questions]

An organization has two million customers that are part of the International customer group.

Validation must occur when customer records are updated. For all customers where the value of the customer group field is international, you must the delivery mode to Air.

You need to update the customer records.

Which two segments can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer: D, E

This is Update and Update_RecordSet Code sample. Result of both will be same .

TestTable TestTable;


update_recordset TestTable setting Name ='New Enterprises' where TestTable.Accountnum =='uS-027';



while select forupdate TestTable where TestTable.Accountnum =='uS-027'


TestTable.Name ='New Enterprises';






Currently there are no comments in this discussion, be the first to comment!

Save Cancel