About this paper
About this paper
This is the CBSE Class 12 Computer Science (083) sample question paper (SQP) for the 2025 board exam. 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
| Chapter | Marks |
|---|---|
| Python Revision Tour I | 5 |
| Python Revision Tour II | 11 |
| Working with Python Function | 6 |
| Exception Handling | 2 |
| File Handling in Python (Text File) | 4 |
| File Handling in Python (Binary & CSV file) | 9 |
| Data Structures (Stack) | 3 |
| Computer Networks-I | 3 |
| Computer Networks-II | 7 |
| Relational Databases | 1 |
| Simple Queries in SQL | 7 |
| Table Creation and Data Manipulation Commands | 3 |
| Grouping Records, Joins in SQL | 5 |
| Interface Python with MySQL | 4 |
Questions in this paper
- Q1 (1 mark, Exception Handling) State True or False: The Python interpreter handles logical errors during code execution.
- Q2 (1 mark, Python Revision Tour II) Identify the output of the following code snippet: text = "PYTHONPROGRAM" text=text.replace('PY','#') print(text)
- Q3 (1 mark, Python Revision Tour I) Which of the following expressions evaluates to False?
- Q4 (1 mark, Python Revision Tour II) What is the output of the expression? country='International' print(country.split("n"))
- Q5 (1 mark, Python Revision Tour II) What will be the output of the following code snippet? message= "World Peace" print(message[-2::-2])
- Q6 (1 mark, Python Revision Tour II) What will be the output of the following code? tuple1 = (1, 2, 3) tuple2 = tuple1 tuple1 += (4,) print(tuple1 == tuple2)
- Q7 (1 mark, Python Revision Tour II) If my_dict is a dictionary as defined below, then which of the following statements will raise an exception? my_dict = {'apple': 10, 'banana': 20, 'orange': 30}
- Q8 (1 mark, Python Revision Tour II) What does the list.remove(x) method do in Python?
- Q9 (1 mark, Relational Databases) If a table which has one Primary key and two alternate keys. How many Candidate keys will this table have?
- Q10 (1 mark, File Handling in Python (Text File)) Write the missing statement to complete the following code: file = open("example.txt", "r") data = file.read(100) ____________________ #Move the file pointer t…
- Q11 (1 mark, Exception Handling) State whether the following statement is True or False: The finally block in Python is executed only if no exception occurs in the try block.
- Q12 (1 mark, Working with Python Function) What will be the output of the following code? c = 10 def add(): global c c = c + 2 print(c,end='#') add() c=15 print(c,end='%')
- Q13 (1 mark, Table Creation and Data Manipulation Commands) Which SQL command can change the degree of an existing relation?
- Q14 (1 mark, Simple Queries in SQL) What will be the output of the query? SELECT * FROM products WHERE product_name LIKE 'App%';
- Q15 (1 mark, Simple Queries in SQL) In which datatype the value stored is padded with spaces to fit the specified length.
- Q16 (1 mark, Simple Queries in SQL) Which aggregate function can be used to find the cardinality of a table?
- Q17 (1 mark, Computer Networks-II) Which protocol is used to transfer files over the Internet?
- Q18 (1 mark, Computer Networks-II) Which network device is used to connect two networks that use different protocols?
- Q19 (1 mark, Computer Networks-I) Which switching technique breaks data into smaller packets for transmission, allowing multiple packets to share the same network resources.
- Q20 (1 mark, Working with Python Function) Assertion (A): Positional arguments in Python functions must be passed in the exact order in which they are defined in the function signature. Reasoning (R): T…
- Q21 (1 mark, Grouping Records, Joins in SQL) Assertion (A): A SELECT command in SQL can have both WHERE and HAVING clauses. Reasoning (R): WHERE and HAVING clauses are used to check conditions, therefore,…
- Q22 (2 marks, Python Revision Tour I) How is a mutable object different from an immutable object in Python? Identify one mutable object and one immutable object from the following: (1,2), [1,2], {1…
- Q23 (2 marks, Python Revision Tour I) Give two examples of each of the following: (I) Arithmetic operators (II) Relational operators
- Q24 (2 marks, Python Revision Tour II) If L1=[1,2,3,2,1,2,4,2, . . . ], and L2=[10,20,30, . . .], then (Answer using builtin functions only) (I) A) Write a statement to count the occurrences of 4 in…
- Q25 (2 marks, Working with Python Function) Identify the correct output(s) of the following code. Also write the minimum and the maximum possible values of the variable b. import random a="Wisdom" b=rand…
- Q26 (2 marks, Working with Python Function) The code provided below is intended to swap the first and last elements of a given tuple. However, there are syntax and logical errors in the code. Rewrite it…
- Q27 (2 marks, Table Creation and Data Manipulation Commands) (I) A) What constraint should be applied on a table column so that duplicate values are not allowed in that column, but NULL is allowed. OR B) What constraint…
- Q28 (2 marks, Computer Networks-I) A) List one advantage and one disadvantage of star topology. OR B) Expand the term SMTP. What is the use of SMTP?
- Q29 (3 marks, File Handling in Python (Text File)) A) Write a Python function that displays all the words containing @cmail from a text file "Emails.txt". OR B) Write a Python function that finds and displays a…
- Q30 (3 marks, Data Structures (Stack)) A) You have a stack named BooksStack that contains records of books. Each book record is represented as a list containing book_title, author_name, and publicat…
- Q31 (3 marks, Python Revision Tour II) Predict the output of the following code: d = {"apple": 15, "banana": 7, "cherry": 9} str1 = "" for key in d: str1 = str1 + str(d[key]) + "@" + "\n" str2 = str…
- Q32 (4 marks, Simple Queries in SQL) Consider the table ORDERS as given below O_Id | C_Name | Product | Quantity | Price 1001 | Jitendra | Laptop | 1 | 12000 1002 | Mustafa | Smartphone | 2 | 1000…
- Q33 (4 marks, File Handling in Python (Binary & CSV file)) A csv file "Happiness.csv" contains the data of a survey. Each record of the file contains the following data: ● Name of a country ● Population of the country…
- Q34 (4 marks, Grouping Records, Joins in SQL) Saman has been entrusted with the management of Law University Database. He needs to access some information from FACULTY and COURSES tables for a survey analy…
- Q35 (4 marks, Interface Python with MySQL) A table, named STATIONERY, in ITEMDB database, has the following structure: Field | Type itemNo | int(11) itemName | varchar(15) price | float qty | int(11) Wr…
- Q36 (5 marks, File Handling in Python (Binary & CSV file)) Surya is a manager working in a recruitment agency. He needs to manage the records of various candidates. For this, he wants the following information of each…
- Q37 (5 marks, Computer Networks-II) Event Horizon Enterprises is an event planning organization. It is planning to set up its India campus in Mumbai with its head office in Delhi. The Mumbai camp…
Download and study this document offline
Download PDF