About this paper
About this paper
This is the CBSE Class 12 Computer Science (083) board exam question paper (Set 1), 2025. It carries 70 marks across 40 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 | 6 |
| Python Revision Tour II | 10 |
| Working with Python Function | 7 |
| Exception Handling | 1 |
| File Handling in Python (Text File) | 3 |
| File Handling in Python (Binary & CSV file) | 10 |
| Data Structures (Stack) | 3 |
| Computer Networks-I | 1 |
| Computer Networks-II | 9 |
| Relational Databases | 1 |
| Simple Queries in SQL | 10 |
| Table Creation and Data Manipulation Commands | 4 |
| Grouping Records, Joins in SQL | 1 |
| Interface Python with MySQL | 4 |
Questions in this paper
- Q1 (1 mark, Python Revision Tour II) State True or False: "A Python List must always contain all its elements of same data type."
- Q2 (1 mark, Python Revision Tour I) What will be the output of the following statement? print(14%3 2*4)
- Q3 (1 mark, Python Revision Tour II) Identify the correct output of the following code snippet: game="Olympic2024" print(game.index("C"))
- Q4 (1 mark, Python Revision Tour I) Which of the following is the correct identifier?
- Q5 (1 mark, Python Revision Tour I) Identify the invalid Python statement out of the following options:
- Q6 (1 mark, Python Revision Tour II) Consider the statements given below and then choose the correct output from the given options: L=['TIC', 'TAC'] print(L[::-1])
- Q7 (1 mark, Python Revision Tour I) Which of the following operator evaluates to True if the variable on either side of the operator points towards the same memory location and False otherwise?
- Q8 (1 mark, Python Revision Tour II) Consider the statements given below and then choose the correct output from the given options: D={'S01':95, 'S02':96 } for I in D : print(I,end='#')
- Q9 (1 mark, Table Creation and Data Manipulation Commands) While creating a table, which constraint does not allow insertion of duplicate values in the table?
- Q10 (1 mark, Working with Python Function) Consider the statements given below and then choose the correct output from the given options: def Change(N): N=N+10 print(N,end='$$') N=15 Change(N) print(N)
- Q11 (1 mark, Exception Handling) Consider the statements given below and then choose the correct output from the given options: N='5' try: print('WORD' + N, end='#') except: print('ERROR',end=…
- Q12 (1 mark, Python Revision Tour II) Which of the following built-in function/method returns a dictionary?
- Q13 (1 mark, Table Creation and Data Manipulation Commands) Which of the following is a DML command in SQL?
- Q14 (1 mark, Simple Queries in SQL) Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
- Q15 (1 mark, Simple Queries in SQL) In MYSQL, which type of value should not be enclosed within quotation marks?
- Q16 (1 mark, Grouping Records, Joins in SQL) State True or False: If table A has 6 rows and 3 columns, and table B has 5 rows and 2 columns, the Cartesian product of A and B will have 30 rows and 5 column…
- Q17 (1 mark, Computer Networks-II) Which of the following networking devices is used to regenerate and transmit the weakened signal ahead?
- Q18 (1 mark, Computer Networks-II) Which of the following options is the correct protocol used for phone calls over the internet?
- Q19 (1 mark, Computer Networks-I) Expand ARPANET.
- Q20 (1 mark, File Handling in Python (Binary & CSV file)) Assertion (A): For a binary file opened using 'rb' mode, the pickle.dump() method will display an error. Reason (R): The pickle.dump() method is used to read f…
- Q21 (1 mark, Relational Databases) Assertion (A): We can retrieve records from more than one table in MYSQL. Reason (R): Foreign key is used to establish a relationship between two tables.
- Q22 (2 marks, Working with Python Function) What does the return statement do in a function? Explain with the help of an example.
- Q23 (2 marks, Python Revision Tour I) Write one example of each of the following in Python: (i) Syntax Error (ii) Implicit Type Conversion
- Q24 (2 marks, Python Revision Tour II) Consider the following dictionaries, D and D1: D={"Suman": 40, "Raj":55, "Raman":60} D1={"Aditi":30, "Amit":90,"Raj":20} (Answer using built-in Python function…
- Q25 (2 marks, Working with Python Function) What possible output from the given options is expected to be displayed when the following code is executed? import random Cards=["Heart","Spade","Club","Diamo…
- Q26 (2 marks, Working with Python Function) The code given below accepts N as an integer argument and returns the sum of all integers from 1 to N. Observe the following code carefully and rewrite it afte…
- Q27 (2 marks, Table Creation and Data Manipulation Commands) Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with at…
- Q28 (2 marks, Computer Networks-II) (a) Expand and explain the term URL. OR (b) Expand the term PPP. What is the use of PPP?
- Q29 (3 marks, File Handling in Python (Text File)) (a) Write a Python function that displays all the lines containing the word 'vote' from a text file "Elections.txt". For example, if the file contains: In an e…
- Q29 (3 marks, File Handling in Python (Text File)) (b) Write a Python function that displays all the words starting and ending with a vowel from a text file "Report.txt". The consecutive words should be separat…
- Q30 (3 marks, Data Structures (Stack)) (a) A stack, named ClrStack, contains records of some colors. Each record is represented as a tuple containing four elements - ColorName, RED, GREEN, BLUE. Col…
- Q30 (3 marks, Data Structures (Stack)) (b) Write the following user-defined functions in Python: (i) push_trail(N,myStack): Here N and mystack are lists, and myStack represents a stack. The function…
- Q31 (3 marks, Python Revision Tour II) Predict the output of the following code: def ExamOn(mystr): newstr = "" count = 0 for i in mystr: if count%2 != 0: newstr = newstr + str(count-1) else: newstr…
- Q31 (3 marks, Python Revision Tour II) Write the output on execution of the following Python code: def Change(X): for K,V in X.items(): L1.append(K) L2.append(V) D={1:"ONE",2:"TWO",3:"THREE"} L1=[]…
- Q32 (4 marks, Simple Queries in SQL) Suman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, a…
- Q33 (4 marks, File Handling in Python (Binary & CSV file)) A csv file "P_record.csv" contains the records of patients in a hospital. Each record of the file contains the following data: - Name of a patient - Disease -…
- Q34 (4 marks, Simple Queries in SQL) Assume that you are working in the IT Department of a Creative Art Gallery (CAG), which sells different forms of art creations like Paintings, Sculptures etc.…
- Q35 (4 marks, Interface Python with MySQL) A table, named THEATRE, in CINEMA database, has the following structure: Field | Type Th_ID | char(5) Name | varchar(15) City | varchar(15) Location | varchar(…
- Q36 (5 marks, File Handling in Python (Binary & CSV file)) A file, PASSENGERS.DAT, stores the records of passengers using the following structure: [PNR, PName, BRDSTN, DESTN, FARE] where: PNR - Passenger Number (string…
- Q37 (5 marks, Computer Networks-II) 'Swabhaav' is a big NGO working in the field of Psychological Treatment and Counselling, having its Head Office in Nagpur. It is planning to set up a center in…
Download and study this document offline
Download PDF