Quiz Space

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

Question 6: Consider the relational schemas Student, Professor, Cours…

Question 6

+4 marksOne correct option

Consider the relational schemas Student, Professor, Course, Enrolled and Teaches:

Student(StudentId, Name, Age)

Professor(ProfId, Name, Age)

Course(CourseId, Title, Credits)

Enrolled(StudentId, CourseId, Grade)

Teaches(ProfId, CourseId)

Which of the following relational algebra queries will list the names of all students who have taken every course taught by Professor 'Smith' ?

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

Correct answer

  • A
See the whole paperTake it as a mock test

Question 6 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 4 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. Q7Your task is to create a table Employee (EmpID, Name, Email, PAN, Department) The following rules must be enforced: Eve…
  7. Q8Consider the relation Product shown in Table 1: | pid | pname | price | |---|---|---| | P1 | Sunscreen cream | 70 | | P…
  8. Q9Figure question
  9. Q10Consider the following relations: Book(<u>bookid</u>, title, genre) Author(<u>authorid</u>, name) Writes(<u>bookid, aut…
  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 |…