Quiz Space

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

DBMS Quiz 1 13 Jul 2025 — Question 13

Question 13

+4 marksNumerical answer
Show answer

Correct answer: 100

See the whole paperTake it as a mock test

Question 13 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. 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. Q10Consider the following relations: Book(<u>bookid</u>, title, genre) Author(<u>authorid</u>, name) Writes(<u>bookid, aut…
  11. Q11Which of the following is the main role of the query parser in query processing?
  12. Q12Figure question
  13. Q14Consider the tables Department, Employee and Project given below: | DeptID | DeptName | |---|---| | 1 | HR | | 2 | IT |…