Multiple choice

Employee table has salary field in this case if we give the query : select * from employee where sal<2000 and sal>9000 which will yield result as ____.

  1. rows with Sal<2000 and Salary>9000 will be displayed

  2. all the rows are displayed with any one of the condition satisfied

  3. no rows will be selected

  4. between sal 2000 and 9000 will be displayed
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The condition sal<2000 AND sal>9000 is logically impossible - a value cannot be both less than 2000 and greater than 9000 simultaneously. Therefore, no rows will satisfy both conditions, and the query returns zero rows. This is a classic example of a mutually exclusive condition.

Keep practicing — related questions