Consider the relation student shown in Table 5. | roll_no | name | house_name | |---|---|---| | 1 | John | Nilgiri | | 2 | Ramesh | Nilgiri | | 3 | Dilip | Arawali | | 4 | Suresh | Shiwalik | | 5 | Kiran | Udaygiri | | 6 | Vijay | Nilgiri | Table 5: Relation student Which of the following SQL command is used to provide INSERT authorization of the table student to instructor.

(D) Option figure from the original question paper

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

Figure from the original question paper

(D) Option figure from the original question paper

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

Relational schema diagram (Drivers, Brands, Designations tables with foreign-key arrows) followed by an SQL query using NATURAL JOIN, ALL subqueries and EXCEPT

(A) Names of all the drivers whose salary is greater than all Mercedes drivers but not less than all Ferrari drivers

(B) Names of all the drivers whose salary is less than all Mercedes drivers but not greater than all Ferrari drivers

(C) Names of all the drivers whose salary is greater than all Mercedes drivers as well as all Ferrari drivers

(D) Names of all the drivers whose salary is less than all Mercedes drivers as well as all Ferrari drivers

Figure from the original question paper

(A) Option figure from the original question paper

(D) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

ER diagram with Company, Items and Customer entities and Produces and Orders relationships (Figure 1: ER Diagram)

(A) Every company must have produced at least one item

(C) Every customer must have bought at least one item

(D) An item can be bought by more than one customer

(B) An item can be produced by more than one company

Consider the following Students table | student_id | name | grade | marks | |---|---|---|---| | 1001 | Alice | A | 85 | | 1002 | Bob | B | 70 | | 1003 | Charlie | A | 90 | | 1004 | David | B | 60 | | 1005 | Eve | A | 95 | Figure 1: Students Choose the correct SQL query to calculate the average marks scored by students in each grade and sort the result by average marks in descending order.

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(A) Option figure from the original question paper

(D) Option figure from the original question paper

January 2025 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 1: 23 February 2025 (January 2025 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 23 Feb 2025, in the January 2025 term: 14 questions for 50 marks in 120 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions: 14
Marks: 50
Duration: 120 min
MCQ: 9
MSQ: 3
Numerical: 2

Take as mock test Practise with answers

Updated 25 Sept 2026

Official paper: IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025 · No negative marking.

Question 1

+2 marksOne correct option

Which level of abstraction is responsible for providing data security by limiting access to specific data views?

A
Physical level
B
Logical level
C
View level
D
Physical level and Logical level

Show answer

Correct answer

C
View level

Question 1 on its own page

Question 2

+3 marksOne correct option

Consider the relation student shown in Table 5.

roll_no	name	house_name
1	John	Nilgiri
2	Ramesh	Nilgiri
3	Dilip	Arawali
4	Suresh	Shiwalik
5	Kiran	Udaygiri
6	Vijay	Nilgiri

Table 5: Relation student

Which of the following SQL command is used to provide INSERT authorization of the table student to instructor.

Show answer

Correct answer

Question 2 on its own page

Question 3

+4 marksOne correct option

Consider the tables Products and Suppliers given below:

P_ID	P_Name	S_ID
1	Laptop	3
2	Smartphone	2
3	Tablet	3
4	Headphones	1

Table 1: Products

S_ID	S_Name
1	Sony
2	Samsung
3	Apple

Table 2: Supplier

Now consider the SQL query given below:

sql

1Select *
2From Products P, Supplier S
3Where P.P_ID<>S.S_ID

How many attributes and rows will be present in the resultant output table?

A
4 attributes and 9 rows
B
5 attributes and 8 rows
C
4 attributes and 8 rows
D
5 attributes and 9 rows

Show answer

Correct answer

D
5 attributes and 9 rows

Question 3 on its own page

Question 4

+4 marksOne correct option

Consider a relational database for Formula One Racing containing the following tables.

D_ID	D_Name	T_ID	Points	Podium
1	Carlos Sainz	101	92	P1
2	Charles Leclerc	102	56	P2
3	Lando Norris	101	90	P3
4	George Russell	103	71	P4
5	Lewis Hamilton	102	95	P5
6	Max Verstappen	103	64	P1
7	Ayrton Senna	101	100	P4
8	Michael Schumacher	103	72	P2
9	Kimi Raikkonen	102	91	P5

Table 3: Drivers

T_ID	T_Name	Country
101	Scuderia Ferrari	Italy
102	Mercedes AMG	Germany
103	McLaren	UK

Table 4: Teams

Now consider the following query:

sql

1Select T.T_ID, T.T_Name
2From Drivers D, Teams T
3Where D.T_ID=T.T_ID and
4Points > (Select avg (Points)
5          From Drivers
6          Where Podium='P1') ;

The number of rows returned by the above SQL query is:

Show answer

Correct answer

Question 4 on its own page

Question 5

+4 marksOne correct option

Consider the following relations:
auto_part(pid, pname, color)
auto_suppliers(sid, sname, location)
catalog(pid, sid, price)

Consider the TRC expression:

$\{x \mid \exists s \in auto\_suppliers\ \exists c \in catalog\ \exists p \in auto\_part(s.location = \textit{‘Mumbai’} \land c.price = 5000 \land x.sid = c.sid \land x.pname = p.pname \land s.sid = c.sid \land p.pid = c.pid)\}$

Choose the correct DRC expression equivalent to the TRC expression shown above.

Show answer

Correct answer

Question 5 on its own page

Question 6

+4 marksOne correct option

Show answer

Correct answer

Question 6 on its own page

Question 7

+4 marksOne correct option

A
Names of all the drivers whose salary is greater than all Mercedes drivers but not less than all Ferrari drivers
B
Names of all the drivers whose salary is less than all Mercedes drivers but not greater than all Ferrari drivers
C
Names of all the drivers whose salary is greater than all Mercedes drivers as well as all Ferrari drivers
D
Names of all the drivers whose salary is less than all Mercedes drivers as well as all Ferrari drivers

Show answer

Correct answer

A
Names of all the drivers whose salary is greater than all Mercedes drivers but not less than all Ferrari drivers

Question 7 on its own page

Question 8

+4 marksOne or more correct options

Select all that apply.

Show answer

Correct answers

Question 8 on its own page

Question 9

+4 marksOne or more correct options

Select all that apply.

A
Every company must have produced at least one item
B
An item can be produced by more than one company
C
Every customer must have bought at least one item
D
An item can be bought by more than one customer

Show answer

Correct answers

A
Every company must have produced at least one item
C
Every customer must have bought at least one item
D
An item can be bought by more than one customer

Question 9 on its own page

Question 10

+4 marksOne or more correct options

Consider the following Students table

student_id	name	grade	marks
1001	Alice	A	85
1002	Bob	B	70
1003	Charlie	A	90
1004	David	B	60
1005	Eve	A	95

Figure 1: Students

Choose the correct SQL query to calculate the average marks scored by students in each grade and sort the result by average marks in descending order.

Select all that apply.

Show answer

Correct answers

Question 10 on its own page

Question 11

+4 marksNumerical answer

Consider relations Book and Author shown in Table 6 and Table 7

BookID	Title	AuthorID	Genre
1	Harry Potter and the Sorcerer's Stone	101	Fantasy
2	Pride and Prejudice	103	Fiction
3	The Great Gatsby	104	Fiction
4	The chamber of secrets	101	Adventure
5	The Catcher in the Rye	105	Fiction
6	1984	101	Dystopian

Table 6: Book Table

AuthorID	Name
101	J.K. Rowling
102	F. Scott Fitzgerald
103	Jane Austen
104	Herman Melville

Table 7: Author Table

How many rows will be in the output of below query?

sql

1SELECT *
2FROM Book LEFT OUTER JOIN Author
3ON Book.AuthorID = Author.AuthorID
4WHERE Genre LIKE 'F%';

Show answer

Correct answer: 4

Question 11 on its own page

Question 12

+4 marksNumerical answer

Consider the tables student and course as shown below.

ID	name	dept_name
21f11	Ram	CS
21f12	Rakesh	ME
21f13	Pranav	EE
21f14	Rajib	CS
21f15	Vikash	BT

Table 8: student

course_id	title	dept_name
C001	DBMS	CS
C002	CAD	ME
C003	Digital	EE
C004	PDSA	CS

Table 9: course

How many rows are returned by the below query?

sql

1(SELECT ID FROM student,course
2EXCEPT ALL
3SELECT ID FROM student)
4EXCEPT
5SELECT ID FROM student

Show answer

Correct answer: 0

Question 12 on its own page

Question 13

+3 marksOne correct option

Consider the following scenario and answer the given subquestions
A startup company is building an online learning platform that hosts courses on various subjects. In this platform, students can enroll in multiple courses, and each course can be taught by one or more instructors. The company wants to design the database schema to manage the core entities: Student, Instructor, Course, and Enrollment.

In the Enrollment table, which of the following is a typical way to handle the primary key?

A
Use an auto-increment column (e.g., EnrollmentID) as the primary key.
B
Use a composite primary key consisting of StudentID and CourseID.
C
There is no need to have a primary key for the Enrollment table.
D
Use a primary key consisting of StudentID.

Show answer

Correct answer

B
Use a composite primary key consisting of StudentID and CourseID.

Question 13 on its own page

Question 14

+2 marksOne correct option

In a typical design, what is the relationship between the Student table and the Enrollment table?

A
One-to-One
B
One-to-Many
C
Many-to-Many
D
Many-to-One

Show answer

Correct answer

D
Many-to-One

Question 14 on its own page