Multiple choice technology web technology

The result of below statement will be - Select * from employee where EMPID = 100 AND CITY = "NEW YORK"

  1. All Employees data

  2. Employees data whose employee ID is 100 and City is NEW YORK

  3. Employees data whose employee ID is either 100 or city is NEW YORK

  4. Employees data whose employee ID lies between 1000 and 100 and city is NEW YORK
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The AND operator requires both conditions to be true - employee ID must be 100 AND city must be 'NEW YORK'. Option A returns all data, option C uses OR (either condition), option D is nonsense with 'between'.

Keep practicing — related questions