cs2001_2026T1_Q1_NA.pdf

Question 2 MCQ · 1.0 marks

1. Data Definition Language
2. Data Manipulation Language
3. Data Control Language
4. All of these

A published solution is not available for this question yet.

Question 3 MSQ · 4.0 marks

1. CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor(id) )
2. CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor.id )
3. CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor, )
4. CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) PRIMARY KEY (id), FOREIGN KEY (instructor_id) REFERENCES Instructor(id) )

A published solution is not available for this question yet.

Question 4 MSQ · 4.0 marks

1. [[IMAGE:41d97408dfb8d756_5_4]]
   
2. [[IMAGE:41d97408dfb8d756_5_5]]
   
3. [[IMAGE:41d97408dfb8d756_5_6]]
   
4. [[IMAGE:41d97408dfb8d756_5_7]]
   

A published solution is not available for this question yet.

Question 5 MCQ · 4.0 marks

1. [[IMAGE:41d97408dfb8d756_6_9]]
   
2. [[IMAGE:41d97408dfb8d756_6_10]]
   
3. [[IMAGE:41d97408dfb8d756_7_11]]
   
4. [[IMAGE:41d97408dfb8d756_7_12]]
   

A published solution is not available for this question yet.

Question 6 MCQ · 4.0 marks

1. [[IMAGE:41d97408dfb8d756_8_14]]
   
2. [[IMAGE:41d97408dfb8d756_8_15]]
   
3. [[IMAGE:41d97408dfb8d756_8_16]]
   
4. [[IMAGE:41d97408dfb8d756_8_17]]
   

A published solution is not available for this question yet.

Question 7 MCQ · 4.0 marks

1. WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT * FROM AvgMarks WHERE avg_marks > 60
2. CREATE VIEW AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id WHERE m.marks > 60 GROUP BY s.student_id ) SELECT * FROM AvgMarks
3. WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id ) SELECT * FROM AvgMarks WHERE avg_marks > 60
4. SELECT student_id, student_name, AVG(marks) FROM Student NATURAL JOIN Marks WHERE AVG(marks) > 60

A published solution is not available for this question yet.

Question 8 MCQ · 4.0 marks

1. a-8, b-8, c-8, d-5, e-6
2. a-8, b-7, c-7, d-4, e-7
3. a-8, b-8, c-7, d-5, e-8
4. a-8, b-7, c-6, d-4, e-6

A published solution is not available for this question yet.

Question 9 NAT · 3.0 marks

A published solution is not available for this question yet.

Question 10 MCQ · 3.0 marks

1. The table is empty.
2. Only movies 201 (Baahubali), 203 (RRR), 204 (Roja), and 207 (Bombay) remain.
3. Only movies 202 (PK) and 206 (3 Idiots) remain.
4. The delete fails due to foreign key constraint violation.

A published solution is not available for this question yet.

Question 11 MCQ · 3.0 marks

1. [[IMAGE:41d97408dfb8d756_13_23]]
   
2. [[IMAGE:41d97408dfb8d756_13_24]]
   
3. [[IMAGE:41d97408dfb8d756_13_25]]
   
4. [[IMAGE:41d97408dfb8d756_14_26]]
   

A published solution is not available for this question yet.

Question 12 MCQ · 2.0 marks

1. [[IMAGE:41d97408dfb8d756_14_28]]
   
2. [[IMAGE:41d97408dfb8d756_14_29]]
   
3. [[IMAGE:41d97408dfb8d756_15_30]]
   
4. [[IMAGE:41d97408dfb8d756_15_31]]
   

A published solution is not available for this question yet.

Question 13 NAT · 4.0 marks

A published solution is not available for this question yet.

Question 14 MSQ · 2.0 marks

1. Weak Entity cannot exist independently and it has its own primary key.
2. It must have total participation in the identifying relationship.
3. Discriminator and Identifying relationship need not exist.
4. Discriminator is represented by underlining with a dashed line.

A published solution is not available for this question yet.

Question 15 NAT · 4.0 marks

A published solution is not available for this question yet.

Question 16 MCQ · 4.0 marks

1. Ram
2. Frank
3. Suresh
4. Thomas

A published solution is not available for this question yet.