Which of the following record validation rules requires the user to enter a value into Field1 that is greater than Field2,and Field2 must have a value greater than 10? A) ([Field1] is Null)XOR ([Field2] is Null) B) [Field1] [Field2] C) (([Field1] [Field2])AND [Field2] 10)) D) none of the above

Question

Which of the following record validation rules requires the user to enter a value into Field1 that is greater than Field2,and Field2 must have a value greater than 10?
A) ([Field1] is Null)XOR ([Field2] is Null)
B) [Field1] < > [Field2]
C) (([Field1] > [Field2])AND [Field2] >10))
D) none of the above

Quizplus · Accepted Answer

Choice C checks for two conditions - Field1 must be greater than Field2, and Field2 must be greater than 10. This satisfies the requirement mentioned in the question. Choice A checks for either Field1 or Field2 to be null, which is not relevant to the given requirement. Choice B checks for Field1 and Field2 to not be equal, which is also not relevant. Choice D means none of the given choices satisfy the requirement stated in the question.

Which of the Following Record Validation Rules Requires the User