Quiz Space

Database Management Systems · Quiz 1 · 19 Jul 2026 · May 2026 term

Question 6: Consider the relational schemas Pilot, Aircraft_Type and …

Question 6

+4 marksOne correct option

Consider the relational schemas Pilot, Aircraft_Type and Certified:

Consider the relational schemas Pilot, Aircraft_Type and Certified:
  1. A

    Names of pilots who are certified for at least one aircraft type

  2. B

    Names of pilots who are certified for exactly one aircraft type

  3. C

    Names of pilots who are certified for all available aircraft types

  4. D

    Names of pilots who are not certified for any aircraft type

Show answer

Correct answer

  • C

    Names of pilots who are certified for all available aircraft types

See the whole paperTake it as a mock test

Question 6 of 16 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 19 Jul 2026, in the May 2026 term (Database Management Systems 16 Jul 26). It carries 4 marks.

More questions from this paper

  1. Q1Which of the following components of the Database Management System (DBMS) is primarily responsible for generating and …
  2. Q2Consider the relation Delivery_Fee:
  3. Q3Consider the following SQL statements are executed in sequence on a newly created table Shipment:
  4. Q4Create a table Assignment(AssignID, PilotID, FlightNo, Date) with the following criteria that must be satisfied: • Ever…
  5. Q5Figure question
  6. Q7Consider the following relational schema for a movie database:
  7. Q8Consider two relations R(A, B) and S(B, C). Which of the following SQL queries is/are logically equivalent to the Relat…
  8. Q9Consider the Entity-Relationship (ER) diagram below representing an organization’s logical schema of their database:
  9. Q10Consider the following two relations and
  10. Q11Suppose relation R(A,B,C,D) has candidate keys: {A,B} and {A,C}. How many distinct superkeys does relation R have?
  11. Q12Let R(A,B) = {(1,2),(2,3),(3,4)} and S(B,C) = {(2,5),(3,6)}. Find the number of tuples in .
  12. Q13Consider the following three tables:
  13. Q14Consider an EER model in which Person is a supertype entity type. Two subtype entity types, Employee and AccountHolder,…
  14. Q15Consider two relations R(A,B) and S(B). Relation R contains 10 tuples and relation S contains 2 tuples. Both relations …
  15. Q16Consider the following Employee table: