Consider a database name “interviewmania” whose attributes

Home » MYSQL » Mysql miscellaneous » Question

Consider a database name “interviewmania” whose attributes are internid (primary key), subject.
Internid= {1, 2, 3, 4, 5, 6}
Subject= {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following query?
```
SELECT internid
FROM interviewmania
WHERE subject NOT IN (c, c++);
```

1. {1, 2, 3}
2. {3, 4}
3. {5, 6}
4. All of above
5. None of these

Correct Option: E

Only those value whose subjects are not c and c++ therefore answer is {1, 2, 3, 4}.