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.

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

DBMS Quiz 1: 23 February 2025 (January 2025 term)

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

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.

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

11 more questions in this paper

Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.

More on the DBMS Quiz 1 23 Feb 2025 paper

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. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.

Feature	DBMS Quiz 1 23 Feb 2025 at a glance
Term	January 2025 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	14
Marks	50
Duration	120 min
MCQ	9
MSQ	3
Numerical	2
Official paper	IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025
Negative marking	No negative marking.
Updated	25 Sept 2026