Time Left - 10:00 mins
GATE 2020 : Database Quiz 4
Attempt now to get your rank among 830 students!
Question 1
Which of the following SQL query find all the tuples having temperature greater than that of Paris.
Question 2
Which of the following is NOT a GROUP BY function?
Question 3
Consider the following relations containing airline flight information:
Flights(flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time)
Aircraft (aid: integer, aname: string, cruisingrange: integer)
Certified (eid: integer, aid: integer)
Employees (eid: integer, ename: string, salary: integer)
Note that the Employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft (otherwise, he or she would not qualify as a pilot), and only pilots are certified to fly.Which of the following Query will result into name of the pilots who can fly a distance greater than 3000 miles but not certified on any Boeing Aircraft?
Flights(flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time)
Aircraft (aid: integer, aname: string, cruisingrange: integer)
Certified (eid: integer, aid: integer)
Employees (eid: integer, ename: string, salary: integer)
Note that the Employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft (otherwise, he or she would not qualify as a pilot), and only pilots are certified to fly.Which of the following Query will result into name of the pilots who can fly a distance greater than 3000 miles but not certified on any Boeing Aircraft?
Question 4
SELECT operation in SQL is equivalent to?
Question 5
Consider the relations
Proj(pid ,pname,budget,city)
SELECT pname
FROM proj P1
WHERE NOT EXISTS
(SELECT budget
FROM proj P2
WHERE city =’DELHI’
AND P1 budget <=P2 budget)
The output of the query finds the project name whose budget is.
Proj(pid ,pname,budget,city)
SELECT pname
FROM proj P1
WHERE NOT EXISTS
(SELECT budget
FROM proj P2
WHERE city =’DELHI’
AND P1 budget <=P2 budget)
The output of the query finds the project name whose budget is.
Question 6
Which of the following operators is used to search a specified pattern in a column?
- 830 attempts
- 3 upvotes
- 8 comments
Tags :
GATE & PSU CSDatabasesSep 26GATE & PSU CS
