SQL Query Multiple Choice Questions with Answer | SQL Quiz
SQL Query based Multiple Choice Questions with Answer | SQL Quiz | SQL GATE Questions
Most of the Questions has been asked in GATE exams.
Follow me on Social Networking Sites :
------------------------------------------------------------------------------------
*Twitter:
/ sunilkr5672
*Instagram :
/ itjunction4all
-------------------------------------------------------------------------------------
Table and Insert Scripts for Practice
------------------------------------------------------------------
Create Table Passenger (
pid int,
PassengerName Varchar(20),
Age int
);
Insert into Passenger Values(0,'Mark',65)
Insert into Passenger Values(1,'David',66)
Insert into Passenger Values(2,'Tom',69)
Insert into Passenger Values(3,'John',70)
Create Table Reservation (
pid int,
Class Varchar(10),
tid int
);
Insert into Reservation Values (0,'AC',5100)
Insert into Reservation Values (1,'AC',5101)
Insert into Reservation Values (2,'Sleeper',5102)
Insert into Reservation Values (5,'AC',5103)
Insert into Reservation Values (1,'Sleeper',5104)
Insert into Reservation Values (3,'AC',5105)
Create Table Book (
Title Varchar(10),
Price Bigint )
insert into Book Values ('ABC',100);
insert into Book Values ('XYZ',200);
insert into Book Values ('DEF',300);
insert into Book Values ('MNO',400);
insert into Book Values ('PQR',500);