SQL Query Multiple Choice Questions with Answer | SQL Quiz

Published: 15 August 2020
on channel: ItJunction4all

15,361

294

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);

Watch video SQL Query Multiple Choice Questions with Answer | SQL Quiz online without registration, duration hours minute second in high quality. This video was added by user ItJunction4all 15 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,361 once and liked it 294 people.

2,305