cs2001_2025T2_Q1_AN.pdf

Question 30 MCQ · 3.0 marks

1. [4, 8, 12]
2. [4, 8, 10]
3. [9, 10]
4. [6, 8, 12]       **DBMS** **Section Id :** 64065392554 **Section Number :** 3 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 15 **Number of Questions to be attempted :** 15 **Section Marks :** 50 **Display Number Panel :** Yes **Section Negative Marks :** 0 **Group All Questions :** No **Enable Mark as Answered Mark for Review and** No **Clear Response :** **Section Maximum Duration :** 0 **Section Minimum Duration :** 0 **Section Time In :** Minutes **Maximum Instruction Time :** 0

A published solution is not available for this question yet.

Question 32 MCQ · 4.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_3_1]]
   
2. [[IMAGE:6cdeec2bf6e8482d_3_2]]
   
3. [[IMAGE:6cdeec2bf6e8482d_3_3]]
   
4. [[IMAGE:6cdeec2bf6e8482d_3_4]]
   

A published solution is not available for this question yet.

Question 33 MCQ · 4.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_4_6]]
   
2. [[IMAGE:6cdeec2bf6e8482d_4_7]]
   
3. [[IMAGE:6cdeec2bf6e8482d_4_8]]
   
4. roll_no | name | marks 1 Amit 80 2 Neha 90 3 Ravi 70

A published solution is not available for this question yet.

Question 34 MCQ · 4.0 marks

1. 1-e, 2-d, 3-f, 4-c
2. 1-e, 2-a, 3-f, 4-b
3. 1-g, 2-a, 3-h, 4-b
4. 1-g, 2-d, 3-h, 4-c

A published solution is not available for this question yet.

Question 35 MCQ · 4.0 marks

1. Names of employees who earn less than the most experienced person in their department.
2. Names of employees who earn more than the most experienced person in their department.
3. Names of employees who earn more than all less experienced colleagues in their department.
4. Names of employees who earn less than all less experienced colleagues in their department.

A published solution is not available for this question yet.

Question 36 MCQ · 4.0 marks

1. Names of students who have enrolled in at least one course
2. Names of students who have enrolled in exactly one course
3. Names of students who have enrolled in all available courses
4. Names of students who have not enrolled in any course

A published solution is not available for this question yet.

Question 37 MCQ · 4.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_9_14]]
   
2. [[IMAGE:6cdeec2bf6e8482d_9_15]]
   
3. [[IMAGE:6cdeec2bf6e8482d_9_16]]
   
4. [[IMAGE:6cdeec2bf6e8482d_9_17]]
   

A published solution is not available for this question yet.

Question 38 MCQ · 3.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_10_19]]
   
2. [[IMAGE:6cdeec2bf6e8482d_10_20]]
   
3. [[IMAGE:6cdeec2bf6e8482d_10_21]]
   
4. [[IMAGE:6cdeec2bf6e8482d_10_22]]
   

A published solution is not available for this question yet.

Question 39 MCQ · 3.0 marks

1. 30.00
2. 35.00
3. 40.00
4. 42.00

A published solution is not available for this question yet.

Question 40 MCQ · 3.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_12_25]]
   
2. [[IMAGE:6cdeec2bf6e8482d_12_26]]
   
3. [[IMAGE:6cdeec2bf6e8482d_12_27]]
   
4. [[IMAGE:6cdeec2bf6e8482d_12_28]]
   

A published solution is not available for this question yet.

Question 41 MCQ · 3.0 marks

1. [[IMAGE:6cdeec2bf6e8482d_13_30]]
   
2. [[IMAGE:6cdeec2bf6e8482d_13_31]]
   
3. [[IMAGE:6cdeec2bf6e8482d_13_32]]
   
4. [[IMAGE:6cdeec2bf6e8482d_13_33]]
   

A published solution is not available for this question yet.

Question 42 MCQ · 2.0 marks

1. Optimize the query by reordering joins
2. Translate high-level queries into relational algebra
3. Execute the query on the database
4. Maintain transaction logs

A published solution is not available for this question yet.

Question 43 MSQ · 4.0 marks

1. The instructor can work in various courses and courses can have more than one instructors working in them.
2. We will not store the information about a health record once the instructor leaves the organization.
3. The instructor can manage more than one courses.
4. Total 5 tables are required to represent the given ERD into a relational schema.

A published solution is not available for this question yet.

Question 44 NAT · 4.0 marks

A published solution is not available for this question yet.

Question 45 NAT · 4.0 marks

A published solution is not available for this question yet.