Quiz Space

Database Management Systems · End Term · 10 May 2026 · January 2026 term · Set 1

Question 9: Consider the instance of a relation V. Which among the fo…

Question 9

+2 marksOne correct option

Consider the instance of a relation V. Which among the following functional dependency set(s) can be inferred from the given information?

Consider the instance of a relation V. Which among the following functional dependency set(s) can be inferred from the g
  1. A

    {P → R, R → S, P Q → R, S → P }

  2. B

    {R → S, P Q → S, Q → P, P → S}

  3. C

    {P → S, R → S, P Q → R, S → Q}

  4. D

    {R → S, P Q → S, P → S, Q → R}

Show answer

Correct answer

  • B

    {R → S, P Q → S, Q → P, P → S}

See the whole paperTake it as a mock test

Question 9 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 10 May 2026, in the January 2026 term (Database Management Systems 06 May 26). It carries 2 marks.

More questions from this paper

  1. Q1Consider a B-tree index to be built on the attribute EmployeeID of a table Employees, with the following properties: • …
  2. Q2Consider the table BandRecords as given below: Let us create two different bitmap indices, one on the Tour attribute an…
  3. Q3Consider the relational schemas Student, Course and Enrolled: Now consider the following SQL query: The query returns:
  4. Q4Consider the hash functions given below. • • • • Identify the hash function(s) that can generate unique hash values for…
  5. Q5Consider the definition of the table Products: The following sequence of queries is executed on this table: Which of th…
  6. Q6Schedule S is as given: Which of the following options is/are correct?
  7. Q7Consider a relation schema T(A,B,C,D,E,F) and the set of functional dependencies, F= {A → BC, C → D, D → C, B → E, E → …
  8. Q8Consider the following monthly backup schedule used by a company: If a failure occurs on the 24th day of the month afte…
  9. Q10Consider the following relational schema: Choose the correct SQL query to find the names of departments where the total…
  10. Q11Choose the relational algebra expression that is equivalent to the following tuple calculus expression:
  11. Q12Consider a B+ tree index built on the key attribute of a data file having 62,50,000 records. Let the order of the B+ tr…
  12. Q13Choose the correct statement(s).
  13. Q14Consider the ER Diagram as shown below: Which of the following statement(s) is/are correct?
  14. Q15Consider the given log records at an instance of time: Suppose there is a system crash after the last log record. What …
  15. Q16Consider you have a file in your hard disk of size 900 KB. Seek time of your hard disk read head is 5 ms and rotational…
  16. Q17Consider a system using the Most Recently Used (MRU) page replacement policy. The system has a main memory buffer with …
  17. Q18Consider the following schedule S with five transactions T1, T2, T3, T4, T5: Where, Ri(X) denotes a read operation by t…
  18. Q19Consider the relation R(A, B, C, D, E, F) and the following functional dependencies set F = {AB → C, C → D, D → E, E → …
  19. Q20Consider a block nested-loop join for the two relations students and enrollments: Assuming the worst-case memory availa…