Question

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

Answer 1

Answer:

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 --

• Salary>=10000 and salary<=15000.

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--

• Option A suggests about 'NOT' condition which gives true if the condition is false.
• Option B suggest about OR condition which gives true if any of the condition is true.
• Option D suggests about BUT condition which is not the condition in any programming language.