About this paper
About this paper
This is the CBSE Class 12 Computer Science (083) sample question paper (SQP) for the 2026 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 | 12 |
| Working with Python Function | 7 |
| Exception Handling | 1 |
| File Handling in Python (Text File) | 3 |
| File Handling in Python (Binary & CSV file) | 9 |
| Data Structures (Stack) | 3 |
| Computer Networks-II | 10 |
| Relational Databases | 2 |
| Simple Queries in SQL | 4 |
| Table Creation and Data Manipulation Commands | 4 |
| Grouping Records, Joins in SQL | 6 |
| Interface Python with MySQL | 4 |
Questions in this paper
- Q1 (1 mark, Working with Python Function) State if the following statement is True or False: Using the statistics module, the output of the below statements will be 20: import statistics statistics.med…
- Q2 (1 mark, Python Revision Tour II) What will be the output of the following code? L = ["India", "Incredible", "Bharat"] print(L[1][0] + L[2][-1])
- Q3 (1 mark, Python Revision Tour I) Consider the given expression: print(1919 or not 75>30) Which of the following will be the correct output of the given expression?
- Q4 (1 mark, Grouping Records, Joins in SQL) In SQL, which type of Join(s) may contain duplicate column(s)?
- Q5 (1 mark, Python Revision Tour II) What will be the output of the following Python code? str= "Soft Skills" print(str[-3::-3])
- Q6 (1 mark, Python Revision Tour I) Write the output of the following Python code: for k in range(7,40,6): print ( k + '-' )
- Q7 (1 mark, Python Revision Tour I) What will be the output of the following Python statement: print(10-3 2 2+144/12)
- Q8 (1 mark, Grouping Records, Joins in SQL) Consider the given SQL Query: SELECT department, COUNT(*) FROM employees HAVING COUNT(*) > 5 GROUP BY department; Saanvi is executing the query but not getting…
- Q9 (1 mark, Exception Handling) What will be the output of the following Python code? try: x = 10 / 0 except Exception: print("Some other error!") except ZeroDivisionError: print("Division by…
- Q10 (1 mark, Python Revision Tour II) What will be the output of the following Python code? my_dict = {"name": "Alicia", "age": 27, "city": "DELHI"} print(my_dict.get("profession", "Not Specified"))
- Q11 (1 mark, Working with Python Function) What possible output is expected to be displayed on the screen at the time of execution of the Python program from the following code? import random L=[10,30,5…
- Q12 (1 mark, Working with Python Function) What will be the output of the following Python code? i = 5 print(i,end='@@') def add(): global i i = i+7 print(i,end='##') add() print(i)
- Q13 (1 mark, Table Creation and Data Manipulation Commands) Which SQL command can change the cardinality of an existing relation?
- Q14 (1 mark, Python Revision Tour II) What is the output of the given Python code? st='Waterskiing is thrilling!' print(st.split("i"))
- Q15 (1 mark, Relational Databases) In SQL, a relation consists of 5 columns and 6 rows. If 2 columns and 3 rows are added to the existing relation, what will be the updated degree of a relation?
- Q16 (1 mark, Table Creation and Data Manipulation Commands) Which SQL command is used to remove a column from a table in MySQL?
- Q17 (1 mark, Computer Networks-II) _________ is a protocol used for retrieving emails from a mail server.
- Q18 (1 mark, Computer Networks-II) Which of the following is correct about using a Hub and Switch in a computer network?
- Q19 (1 mark, Computer Networks-II) Which of the following is used to create the structure of a web page?
- Q20 (1 mark, Python Revision Tour II) Assertion (A): The expression (1, 2, 3, 4).append(5) in Python will modify the original sequence datatype. Reason (R): The append() method adds an element to t…
- Q21 (1 mark, Relational Databases) Assertion (A): A primary key must be unique and cannot have NULL values. Reasoning (R): The primary key uniquely identifies each row in the table.
- Q22 (2 marks, Python Revision Tour I) A. Explain the difference between explicit and implicit type conversion in Python with a suitable example. OR B. Explain the difference between break and conti…
- Q23 (2 marks, Working with Python Function) The code provided below is intended to remove the first and last characters of a given string and return the resulting string. However, there are syntax and lo…
- Q24 (2 marks, Python Revision Tour II) A. (Answer using Python built-in methods/functions only): I. Write a statement to find the index of the first occurrence of the substring "good" in a string na…
- Q25 (2 marks, Working with Python Function) A. Write a function remove_element() in Python that accepts a list L and a number n. If the number n exists in the list, it should be removed. If it does not e…
- Q26 (2 marks, Python Revision Tour II) Predict the output of the Python code given below: emp = {"Arv": (85000,90000),"Ria": (78000,88000),"Jay": (72000,80000),"Tia": (80000,70000)} selected = [ ] f…
- Q27 (2 marks, Table Creation and Data Manipulation Commands) A. Write suitable commands to do the following in MySQL. I. View the table structure. II. Create a database named SQP OR B. Differentiate between drop and dele…
- Q28 (2 marks, Computer Networks-II) A. Define the following terms: I. Modem II. Gateway OR B. I. Expand the following terms: HTTP and FTP II. Differentiate between web server and web browser.
- Q29 (3 marks, File Handling in Python (Text File)) A. Write a Python function that displays the number of times the word "Python" appears in a text file named "Prog.txt". OR B. Write and call a Python function…
- Q30 (3 marks, Data Structures (Stack)) A list containing records of products as L = [("Laptop", 90000), ("Mobile", 30000), ("Pen", 50), ("Headphones", 1500)] Write the following user-defined functio…
- Q31 (3 marks, Python Revision Tour II) A. Predict the output of the following Python code: s1="SQP-25" s2="" i=0 while i='0' and s1[i]='A' and s1[i]
- Q32 (4 marks, Simple Queries in SQL) Consider the table SALES as given below: sales_id | customer_name | product | quantity_sold | price S001 | John Doe | Laptop | 5 | 50000 S002 | Jane Smith | Sm…
- Q33 (4 marks, File Handling in Python (Binary & CSV file)) Raj is the manager of a medical store. To keep track of sales records, he has created a CSV file named Sales.csv, which stores the details of each sale. The co…
- Q34 (4 marks, Grouping Records, Joins in SQL) Pranav is managing a Travel Database and needs to access certain information from the Hotels and Bookings tables for an upcoming tourism survey. Help him extra…
- Q35 (4 marks, Interface Python with MySQL) MySQL database named WarehouseDB has a product_inventory table in MySQL which contains the following attributes: - Item_code: Item code (Integer) - Product_nam…
- Q36 (5 marks, File Handling in Python (Binary & CSV file)) Mr. Ravi, a manager at a tech company, needs to maintain records of employees. Each record should include: Employee_ID, Employee_Name, Department and Salary. W…
- Q37 (5 marks, Computer Networks-II) XYZNova Inc. is planning a new campus in Hyderabad while maintaining its headquarters in Bengaluru. The campus will have four buildings: HR, Finance, IT, and L…
Download and study this document offline
Download PDF