Question

If the function used with eval: What is the field value of SalesTerritory for a VendorID of 80000 in the following evaluation?

| eval SalesTerritory = if((VendorID >= 7000 AND VendorID <8000), "Asia", "Rest of the World")
a) Asia
b) Rest of the World
c) 80000
d) VendorID

Answer 1

The field value of SalesTerritory for a VendorID of 80000 would be 'Rest of the World' according to the given eval function condition.

Step-by-step explanation:

The eval function in the given expression is used to assign a SalesTerritory based on the value of VendorID. According to the condition specified, if the VendorID is greater than or equal to 7000 and less than 8000, the SalesTerritory should be 'Asia'. Otherwise, it should be 'Rest of the World'. For a VendorID of 80000, the condition is false, because 80000 is not less than 8000. Therefore, the field value of SalesTerritory for a VendorID of 80000 would be 'Rest of the World'.