When you add a filter to a second field ,where the results must reflect all of the criteria values, what type of condition have you created?

a) not
b) or
c) and
d) but

Option C is the correct answer.

Explanation:

And Clause is used to give the true value if there are both the condition is true. So when a user needs to add two criteria then the second criteria will be added by the help of AND condition.

Just for example when a user is using an ORACLE server and he needs to find the List of that employee whose salary lies in between to 10000 to 15000. Then the user needs to follow the condition of --

Here the user gets the result of that record whose salary lies between 10000 to 15000 because AND operator will give true result if and only if both the condition is true.The Question also means the same which is described above. Hence option C is the correct option while the other is not because--

b. xor is the correct answer