12 Papers

CBSE Class 12 Computer Science 2025 Compartmental Exam

About this paper 37 questions · 70 marks · solved answers

About this paper

This is the CBSE Class 12 Computer Science (083) compartment (supplementary) exam paper, 2025. It carries 70 marks across 37 questions. Every question has a worked answer with an explanation: choose Solved Ans above to study them. You can read the paper here or download the PDF to practise offline.

Marks by unit

Programming: 40 marks · Networks: 10 marks · Database: 20 marks

Marks by chapter

ChapterMarks
Python Revision Tour I9
Python Revision Tour II12
Working with Python Function3
File Handling in Python (Text File)4
File Handling in Python (Binary & CSV file)9
Data Structures (Stack)3
Computer Networks-I1
Computer Networks-II9
Relational Databases2
Simple Queries in SQL11
Table Creation and Data Manipulation Commands3
Interface Python with MySQL4

Questions in this paper

  1. Q1 (1 mark, Python Revision Tour II) State if following statement is True or False: If T is a tuple and L is a list, then T+L is a valid statement in Python.
  2. Q2 (1 mark, Python Revision Tour II) Identify the output of the following code segment: s = "an apple. a toy." s = s.find('a', 2) print(s)
  3. Q3 (1 mark, Python Revision Tour I) What is the value of the following expression? 3 + 3.00, 3 3.0
  4. Q4 (1 mark, Python Revision Tour II) What is the output of the following expression? Sports="Paralympic Games" print(Sports.split("m"))
  5. Q5 (1 mark, Python Revision Tour II) What will be the output of the following code segment? p = list("Session 2024-25") print(p[10:20:])
  6. Q6 (1 mark, Python Revision Tour II) Which of the following is a mapped data type?
  7. Q7 (1 mark, Python Revision Tour II) If the dictionary D1 is defined as: D1={1:'a', 2:'b'}, then which of the following statements is incorrect and hence will result in an error?
  8. Q8 (1 mark, Python Revision Tour II) Which of the following list methods accepts exactly 2 parameters?
  9. Q9 (1 mark, Relational Databases) In a particular examination, there are 50 candidates with roll numbers from 997601 to 997650. The data of these candidates is stored in a table in a database.…
  10. Q10 (1 mark, File Handling in Python (Text File)) A text file song.txt contains the following contents in it: Life goes on as it never ends What will be the output of the following code snippet? f1 = open("son…
  11. Q11 (1 mark, Python Revision Tour I) State whether the following statement is True or False. In Python, the print() evaluates the expression before displaying it on the screen.
  12. Q12 (1 mark, Working with Python Function) What will be the output of the following code segment? a = 5 def func_1(b=10): global a a = b - 10 b += a print(a, b) func_1(a)
  13. Q13 (1 mark, Table Creation and Data Manipulation Commands) Write any two DDL commands.
  14. Q14 (1 mark, Simple Queries in SQL) Which of the following is not a valid relational operator used with WHERE clause in SQL?
  15. Q15 (1 mark, Simple Queries in SQL) What is the default format of date in MySQL?
  16. Q16 (1 mark, Simple Queries in SQL) Ginni has created a table, SCORES in MySQL containing the following records: Ranveer: 50, Sukesh: 35, Mirza: 10, John: 51, Murugan: 70. Which of the following…
  17. Q17 (1 mark, Computer Networks-II) Which of the following devices is essential to set up a wired LAN?
  18. Q18 (1 mark, Computer Networks-II) Which network device serves as the entry and exit point of a network, as all the data coming in or going out of a network must first pass through it?
  19. Q19 (1 mark, Computer Networks-I) Which of the following IP addresses is valid?
  20. Q20 (1 mark, Python Revision Tour I) Assertion (A): Every object in Python is assigned a unique identity (ID). Reason (R): ID remains the same for the lifetime of that object.
  21. Q21 (1 mark, Relational Databases) Assertion (A): Foreign key column of a table cannot have NULL entries. Reason (R): Primary key column of a table cannot have NULL entries.
  22. Q22 (2 marks, Python Revision Tour I) What is the difference between = and == in Python? Give an example of each.
  23. Q23 (2 marks, Python Revision Tour I) Give an example of each of the following: (i) An expression using any one identity operator. (ii) An arithmetic expression which uses any one augmented assignm…
  24. Q24 (2 marks, Python Revision Tour II) Assuming that D1 and D2 are Python dictionaries. Write statements using built-in functions: (I)(a) Delete all elements of D1 OR (b) Generate a list of values o…
  25. Q25 (2 marks, Working with Python Function) Identify the correct possible output(s) of the following code segment. Also write the minimum and the maximum possible values of the variable b. import random…
  26. Q26 (2 marks, Python Revision Tour I) Rewrite the code after removing all the syntax and logical errors. Underline all the corrections made. n = int(input("Enter a positive integer:") c=0 for i in…
  27. Q27 (2 marks, Table Creation and Data Manipulation Commands) (I) (a) Write any one difference between CHAR and VARCHAR data types in MySQL. OR (b) Write one difference between Primary key and Unique constraint. (II) (a)…
  28. Q28 (2 marks, Computer Networks-II) (I) (a) Expand POP, TCP. (b) Write any one difference between a hub and a switch. OR (II) (a) Difference between HTTP and HTTPS. (b) Write names of any two wir…
  29. Q29 (3 marks, File Handling in Python (Text File)) (a) Write a Python function that displays all lines ending with a dot (.) from a text file "Colors.txt". OR (b) Write a function to display the line which has…
  30. Q30 (3 marks, Data Structures (Stack)) (a) A stack named KeyStack contains records [Make, Keys, Connectivity]. Write functions push_key(KeyStack, new_key), pop_key(KeyStack), isEmpty(KeyStack). OR (…
  31. Q31 (3 marks, Python Revision Tour II) (a) Write the output on execution of the following Python code: P = [3, 5, 7, 4] P.insert(2, 3) P.extend([10, 6]) print(P) print(P.index(7)) print(P[::2]) OR (…
  32. Q32 (4 marks, Simple Queries in SQL) Write SQL queries for STAFF table: (I) Display average salary of each department. (II) Insert record ('S333', 'GURMEET', 15000, 'ADMIN', 'CLERK'). (III) Displa…
  33. Q33 (4 marks, File Handling in Python (Binary & CSV file)) Write Python code for a CSV file 'CLUB.CSV' [Mno, Name, Mobile, Fee]: NewMembers(): accept records from user and add to file. PriorityMember(): find and displa…
  34. Q34 (4 marks, Simple Queries in SQL) SQL Queries based on Work and Contractor tables: (I) Display all records from Work in alphabetical order of W_Name. (II) Display names of contractors where W_A…
  35. Q35 (4 marks, Interface Python with MySQL) Help Nutan write Python definition ChangeStatus() to connect to MySQL database PHARMACY and change Status to 'DISCARD' where Expiry is before '2022-12-31'.
  36. Q36 (5 marks, File Handling in Python (Binary & CSV file)) Records of doctors are stored in a binary file 'DOCTORS.DAT' [D_ID, D_Name, D_Dept, Experience]. (I) Write one difference between binary and CSV files. (II) Wr…
  37. Q37 (5 marks, Computer Networks-II) Patiala Branch Case Study: ADMIN (18 computers), SALES (30), SERVICE (20), INSURANCE (10). (I) Suggest server location. (II) Network type formed by interconnec…

Download and study this document offline

Download PDF

Loading Preview...