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

Specialization hierarchy: Person to Staff (total; Security Officer, Office Superintendent) and Student (Regular with TA and RA, Non-Regular), with statements a to d including a Student specialization figure

(B) Only b, c, and d are correct

(C) Only a, c and d are correct

Figure from the original question paper

(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

Figure from the original question paper

(B) Option figure from the original question paper

(D) Option figure from the original question paper

(A) Option figure from the original question paper

(C) Option figure from the original question paper

Consider the student relation given below. Select the correct query/queries to obtain the last name of students whose age is more than 25. Student | Fname | Lname | Age | Course | |---|---|---|---| | David | Sharma | 27 | DBMS | | Aaron | Lilly | 17 | JAVA | | Sahil | Khan | 19 | Python | | Sachin | Rao | 20 | DBMS | | Varun | George | 23 | JAVA | | Simi | Verma | 22 | JAVA |

(A) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

(B) Option figure from the original question paper

May 2023 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 1: 16 July 2023 (May 2023 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term: 17 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: 17
Marks: 50
Duration: 120 min
MCQ: 8
MSQ: 4
Numerical: 5

Take as mock test Practise with answers

Updated 25 Sept 2026

Official paper: IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023 · No negative marking.

Question 1

+2 marksOne correct option

The lowest level of data abstraction is

A
physical level
B
logical level
C
view level
D
application level

Show answer

Correct answer

A
physical level

Question 1 on its own page

Question 2

+2 marksOne correct option

Suppose a company wants to determine whether the ’price’ of the commodity will be an attribute in the shopping database or not. Which of the following holds good about this?

A
This is a physical-level decision.
B
This is a logical level decision.
C
This is an application-level decision.
D
This is a view-level decision.

Show answer

Correct answer

B
This is a logical level decision.

Question 2 on its own page

Question 3

+2 marksOne correct option

Consider the following scenario:
The Reserve Bank of India (RBI) has issued guidelines declaring that the Rs. 2000 note will no longer be considered legal tender, starting from a specific date. The RBI wants to update its database to reflect this change and ensure that transactions involving the Rs. 2000 note are flagged as invalid.
Which DBMS concept would be most relevant for the RBI to update its database and flag transactions involving the Rs. 2000 note as invalid after the specified date?

A
CASCADE
B
Data Definition Language (DDL)
C
Triggers
D
Indexing

Show answer

Correct answer

C
Triggers

Question 3 on its own page

Question 4

+2 marksOne correct option

Consider the schema given below :

Emp (eid, ename, age, salary)
Works (eid, did, pct_time)
Dept (did, budget, managerid)

Identify the correct SQL command to create a view named, EMPLOYEE, by selecting attributes like eid, salary, and managerid. Select those employees whose salary is greater than 1,00,000 and are atleast 45 years old.

Show answer

Correct answer

Question 4 on its own page

Question 5

+2 marksOne correct option

An instance of the relation students is given below.

sid	name	age	gpa
53831	Madayan	11	1.8
53832	Guldu	12	2
53666	Jones	18	3.4
53688	Smith	19	3.2
53650	Smith	19	3.8

Figure 3: Relation students

Which of the following query executed on relation students would result in the output given below ?

sid	name	age	gpa
53832	Guldu	12	2
53666	Jones	18	3.4
53831	Madayan	11	1.8
53650	Smith	19	3.8
53688	Smith	19	3.2

Figure 4: Output

Show answer

Correct answer

Question 5 on its own page

Question 6

+3 marksOne correct option

Consider two relations R and S as shown below.

A	B	C
1	2	3
2	4	6
3	7	3
4	3	4

Table 1: R

B	C	D
7	3	4
2	3	5
3	7	6
2	3	7

Table 2: S

The number of tuples in R ⟕ S are : [Note : ⟕ denotes left outer join.]

A
3
B
4
C
5
D
16

Show answer

Correct answer

Question 6 on its own page

Question 7

+3 marksOne correct option

Show answer

Correct answer

Question 7 on its own page

Question 8

+4 marksOne correct option

A
Only a and b are correct
B
Only b, c, and d are correct
C
Only a, c and d are correct
D
All a, b, c, d are correct

Show answer

Correct answer

D
All a, b, c, d are correct

Question 8 on its own page

Question 9

+4 marksOne or more correct options

Consider the relation G20(country_name, foreign_minister_name, events, date, venue)
Questions:

Find the name of foreign ministers whose names start with 'j' and have at least 5 characters.
Find out the number of events taking place in venue 'GIFT City'.
Find out the venue name and number of events taking place in each venue

SQL queries:

sql

1a. Select foreign_minister_name from G20
2where foreign_minister_name like 'j____'
3
4b. Select foreign_minister_name from G20
5where foreign_minister_name like 'j____%'
6
7c. Select count(events) from G20 where venue = 'GIFT City'
8
9d. Select count(events) from G20 where venue = 'GIFT City'
10   Group By venue
11
12e. Select venue, count(events) from G20
13   Group By venue
14
15f. Select venue, count(events) from G20

Match the correct SQL queries with the corresponding Questions.

Select all that apply.

A
1-a, 2-c, 3-f
B
1-b, 2-c, 3-e
C
1-a, 2-d, 3-f
D
1-b, 2-d, 3-e

Show answer

Correct answers

B
1-b, 2-c, 3-e
D
1-b, 2-d, 3-e

Question 9 on its own page

Question 10

+4 marksOne or more correct options

Select all that apply.

Show answer

Correct answers

Question 10 on its own page

Question 11

+4 marksOne or more correct options

Select all that apply.

Show answer

Correct answers

Question 11 on its own page

Question 12

+2 marksOne or more correct options

Consider the student relation given below. Select the correct query/queries to obtain the last name of students whose age is more than 25.

Student

Fname	Lname	Age	Course
David	Sharma	27	DBMS
Aaron	Lilly	17	JAVA
Sahil	Khan	19	Python
Sachin	Rao	20	DBMS
Varun	George	23	JAVA
Simi	Verma	22	JAVA

Select all that apply.

Show answer

Correct answers

Question 12 on its own page

Question 13

+2 marksNumerical answer

Consider the two relations R and S.

A	B	C
0	9	0
2	2	2
1	1	1

A	B	C
0	Cat	0
2	Dog	2
1	Lion	1

Figure 1: R and S

Let 'X' be the number of columns and 'Y' be the number of rows of the (R $\bowtie$ S ) relations.
What is the value of (X + Y) ?

Show answer

Correct answer: 3

Question 13 on its own page

Question 14

+2 marksNumerical answer

Consider the relation student shown in Table 3

Roll_no	Name	marks
1	Ram	50
2	Rakesh	65
3	Ram	45
4	Pranav	89
5	Rakesh	99
6	Emily	99
7	Grace	100
8	Lily	95

Table 3: student

What is the number of tuples returned by the following relational algebra expression $\prod_{name}(\sigma_{marks>50}(student))$

Show answer

Correct answer: 5

Question 14 on its own page

Question 15

+4 marksNumerical answer

Consider the following table which has four attributes: A, B, C, and D where A is the primary key and C is the foreign key referencing to A.

A	B	C	D
1	1	5	6
2	2	5	7
8	4	7	4
3	1	5	8
4	2	4	9
5	2	4	1
6	1	1	2
7	4	1	3

How many tuples will be left in the table if the tuple (1,1,5,6) is deleted and ON DELETE CASCADE construct is applied over the table?

Show answer

Correct answer: 4

Question 15 on its own page

Question 16

+4 marksNumerical answer

Show answer

Correct answer: 17

Question 16 on its own page

Question 17

+4 marksNumerical answer

Show answer

Correct answer: 8

Question 17 on its own page