Quiz Space

Database Management Systems · Quiz 1 · 13 Jul 2025 · May 2025 term

Question 10: Consider the following relations: Book(<u>bookid</u>, ti…

Question 10

+3 marksOne correct option

Consider the following relations:

  • Book(bookid, title, genre)
  • Author(authorid, name)
  • Writes(bookid, authorid)

Choose the correct relational algebra expression to find the author IDs (authorid) of those authors who have written books of both the 'Science Fiction' and 'Fantasy' genres.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • A
See the whole paperTake it as a mock test

Question 10 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 13 Jul 2025, in the May 2025 term (IIT M DIPLOMA AN EXAM QDD2 13 July 2025). It carries 3 marks.

More questions from this paper

  1. Q1Consider the following table Sales: | EmpID | Region | Amount | |---|---|---| | 101 | East | 5000 | | 102 | East | 3000…
  2. Q2Consider the following SQL statements executed in sequence on a table students: What will be the content of the student…
  3. Q3Consider the following relations:\ auto_part(<u>pid</u>, pname, color)\ auto_suppliers(<u>sid</u>, sname, location)\ ca…
  4. Q4Consider the relational schema Employees: Employees(<u>EmpId</u>, Name, Salary, Department, Experience) Now consider th…
  5. Q5Consider the relational schemas Student, Course and Enrollment: Student(<u>SId</u>, Name, Age, DOB, Phone_Number)\ Cour…
  6. Q6Consider the relational schemas Student, Professor, Course, Enrolled and Teaches: Student(<u>StudentId</u>, Name, Age) …
  7. Q7Your task is to create a table Employee (EmpID, Name, Email, PAN, Department) The following rules must be enforced: Eve…
  8. Q8Consider the relation Product shown in Table 1: | pid | pname | price | |---|---|---| | P1 | Sunscreen cream | 70 | | P…
  9. Q9Figure question
  10. Q11Which of the following is the main role of the query parser in query processing?
  11. Q12Figure question
  12. Q13Figure question
  13. Q14Consider the tables Department, Employee and Project given below: | DeptID | DeptName | |---|---| | 1 | HR | | 2 | IT |…