Consider the Student schema

Create table Student (id Integer primary key, Name varchar(50));

Create table Course (Courseid Integer primary key, id Integer references Student(id) on delete cascade);

Create table Marks(mark Integer primary key,Courseid Integer references Course(Courseid) on delete NULL);

INSERT INTO Student VALUES (1, 'Ajay');

INSERT INTO Student VALUES (2, 'Vijay');

INSERT INTO Course VALUES (11, 1);

INSERT INTO Course VALUES (22, 1);

INSERT INTO Marks VALUES (100, 22);

INSERT INTO Marks VALUES (200, 22);

Delete Student;

What tuples will be in the DB in any relation after completion of above Queries?

1
(1, NULL), (2, NULL)
2
(100, NULL)
3
(11, NULL) (22, NULL)
4
(200, NULL)

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation