Consider the following SQL statements executed in sequence on a table students: CREATE TABLE students ( roll_no INT PRIMARY KEY, name VARCHAR(50), marks INT ); INSERT INTO students VALUES (1, 'Amit', 80); INSERT INTO students VALUES (2, 'Neha', 90); INSERT INTO students VALUES (3, 'Ravi', 70); UPDATE students SET marks = marks + 10 WHERE marks < 85; DELETE FROM students WHERE name = 'Neha'; INSERT INTO students (roll_no, name, marks) VALUES (4, 'Neha', 95); What will be the content of the students table after execution?

(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

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

Question 2: Consider the following SQL statements executed in sequenc…

Question 2

+4 marksOne correct option

Consider the following SQL statements executed in sequence on a table students:

sql

1CREATE TABLE students (
2    roll_no INT PRIMARY KEY,
3    name VARCHAR(50),
4    marks INT
5);
6
7INSERT INTO students VALUES (1, 'Amit', 80);
8INSERT INTO students VALUES (2, 'Neha', 90);
9INSERT INTO students VALUES (3, 'Ravi', 70);
10
11UPDATE students
12SET marks = marks + 10
13WHERE marks < 85;
14
15DELETE FROM students
16WHERE name = 'Neha';
17
18INSERT INTO students (roll_no, name, marks)
19VALUES (4, 'Neha', 95);

What will be the content of the students table after execution?

Show answer

Correct answer

See the whole paper Take it as a mock test

Question 2 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.

Question 2: Consider the following SQL statements executed in sequenc…

Question 2

More questions from this paper