Consider the definition of table STUDENTS. CREATE TABLE STUDENTS (SID CHAR(20), NAME CHAR(30), LOGIN CHAR(30), AGE INTEGER, GPA Numeric(2,1), UNIQUE (NAME,AGE), PRIMARY KEY (SID)) The sequence of queries is executed on this table. 1. INSERT INTO STUDENTS VALUES (30000, 'Jones', 'jones@cs', 18, 3.4) 2. INSERT INTO STUDENTS VALUES (35670, 'Smith', 'Smith@ee', 18, 7.2) 3. INSERT INTO STUDENTS VALUES (56780, 'Jones', 'jones@ece', 28, 10) Which of the following results in an invalid operation to the table STUDENTS?

(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

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

(D) Option figure from the original question paper

DBMS End Term: 3 September 2023, Set QPD1-S1 (May 2023 term)

Question 1

+3 marksOne or more correct options

Consider the definition of table STUDENTS.

sql

1CREATE TABLE STUDENTS (SID CHAR(20),
2                       NAME CHAR(30),
3                       LOGIN CHAR(30),
4                       AGE INTEGER,
5                       GPA Numeric(2,1),
6                       UNIQUE (NAME,AGE),
7                       PRIMARY KEY (SID))

The sequence of queries is executed on this table.

INSERT INTO STUDENTS VALUES (30000, 'Jones', 'jones@cs', 18, 3.4)
INSERT INTO STUDENTS VALUES (35670, 'Smith', 'Smith@ee', 18, 7.2)
INSERT INTO STUDENTS VALUES (56780, 'Jones', 'jones@ece', 28, 10)

Which of the following results in an invalid operation to the table STUDENTS?

Select all that apply.

Question 2

+1 markOne or more correct options

Select all that apply.

Question 3

+2 marksOne correct option

A
1 NF
B
2 NF
C
3 NF
D
BCNF

19 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 End Term 3 Sept 2023 Set QPD1-S1 paper

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 3 Sept 2023, in the May 2023 term, set QPD1-S1: 22 questions for 50 marks in 180 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 End Term 3 Sept 2023 Set QPD1-S1 at a glance
Term	May 2023 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	22
Marks	50
Duration	180 min
MSQ	6
MCQ	12
Numerical	4
Official paper	IIT M DIPLOMA ET1 EXAM QPD1 S2 03 Sep
Negative marking	No negative marking.
Updated	25 Sept 2026

Other sets that day

Set QPD1-S2