Quiz Space

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

DBMS Quiz 1 19 Jul 2026 — Question 10

Question 10

+4 marksOne or more correct options

Consider the following two relations and

Consider the following two relations and

Select all that apply.

  1. A

    —

  2. B

    —

  3. C

    —

  4. D

    —

Show answer

Correct answers

  • B

    —

  • D

    —

See the whole paperTake it as a mock test

Question 10 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. Q6Consider the relational schemas Pilot, Aircraft_Type and Certified:
  7. Q7Consider the following relational schema for a movie database:
  8. Q8Consider two relations R(A, B) and S(B, C). Which of the following SQL queries is/are logically equivalent to the Relat…
  9. Q9Consider the Entity-Relationship (ER) diagram below representing an organization’s logical schema of their database:
  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: