Consider the following table /relation. What is the output for the below Query?

CREATE TABLE Persons

(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('101','A','Ram','1-2 Ramnagar','mumbai');

INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('102','B','Ravi','1-2 samnagar','mumbai');

INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('103','C','Raju','1-2 Narayanapuram','Mahabubabad');

INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('104','D','Ramraju','1-3 Narayanapuram','Hyderabad');

Query:

Select *

from Persons

Where City in('Mumbai', 'Hyderabad');

1
Find all the persons of city neither Hyderabad nor Mumbai.
2
Find all the persons of city Hyderabad or Mumbai.
3
Find all the persons of city Hyderabad but not Mumbai.
4
Find all the persons of cityis not Hyderabad but Mumbai.
5
Question Not Attempted

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation