About this paper
About this paper
This is the CBSE Class 12 Computer Science (083) board exam question paper (Set 1), 2026. 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 | 2 |
| Python Revision Tour II | 14 |
| 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 | 2 |
| Computer Networks-II | 8 |
| Relational Databases | 3 |
| Simple Queries in SQL | 6 |
| Table Creation and Data Manipulation Commands | 3 |
| Grouping Records, Joins in SQL | 4 |
| Interface Python with MySQL | 4 |
Questions in this paper
- Q1 (1 mark, Python Revision Tour I) State True or False: In Python, data type of 74 is same as the data type of 74.0.
- Q2 (1 mark, Python Revision Tour II) Identify the output of the following code snippet: s = "the Truth" print(s.capitalize())
- Q3 (1 mark, Python Revision Tour I) Which of the following expressions in Python evaluates to True?
- Q4 (1 mark, Python Revision Tour II) What is the output of the following code snippet? s = 'War and Peace by Leo Tolstoy' print(s.partition("by"))
- Q5 (1 mark, Python Revision Tour II) What will be the output of the following statement? print("PythonProgram"[-1:2:-2])
- Q6 (1 mark, Python Revision Tour II) What will be the output of the following code snippet? t = tuple('tuple') t2 = t[2], t += t2 print(t)
- Q7 (1 mark, Python Revision Tour II) Which of the following statements is true about dictionaries in Python?
- Q8 (1 mark, Python Revision Tour II) If L is a list with 6 elements, then which of the following statements will raise an exception?
- Q9 (1 mark, Working with Python Function) What will be the output of the following code? def f1(a, b=1): print(a+b, end='-') c = f1(1, 2) print(c, sep='*')
- Q10 (1 mark, File Handling in Python (Binary & CSV file)) Consider the statement given below: f1 = open("pqr.dat", "_______") Which of the following is the correct file mode to open the file in read only mode?
- Q11 (1 mark, Exception Handling) State whether the following statement is True or False: In Python, Logical errors can be handled using try...except...finally statement.
- Q12 (1 mark, Relational Databases) A table has two candidate keys, one of which is chosen as the primary key. How many alternate keys does this table have?
- Q13 (1 mark, Table Creation and Data Manipulation Commands) Which of the following SQL command can change the degree of the existing relation?
- Q14 (1 mark, Simple Queries in SQL) What will be the output of the query? SELECT MACHINE_ID, MACHINE_NAME FROM INVENTORY WHERE QUANTITY
- Q15 (1 mark, Relational Databases) A relation in MySQL database consists of 2 tuples and 3 attributes. If 2 attributes are deleted and 4 tuples are added, what will be the cardinality of the rel…
- Q16 (1 mark, Simple Queries in SQL) Which aggregate function in SQL returns the smallest value from a column in a table?
- Q17 (1 mark, Computer Networks-II) With respect to computer networks, which of the following is the correct expanded form of RJ 45?
- Q18 (1 mark, Computer Networks-II) Which network device serves as the entry and exit point of a network, as all data coming in or going out of a network must first pass through it in order to us…
- Q19 (1 mark, Computer Networks-II) Expand the term XML.
- Q20 (1 mark, Python Revision Tour II) Assertion (A): [1, 2, 3] + '123' is an invalid expression in Python. Reason (R): In Python, a list cannot be concatenated with a string.
- Q21 (1 mark, Relational Databases) Assertion (A): The PRIMARY KEY constraint in SQL ensures that each value in the column(s) is unique and cannot be NULL. Reason (R): Candidate keys are not elig…
- Q22 (2 marks, Working with Python Function) What is the difference between default parameters and positional parameters in Python? Also give an example of a function header which uses both.
- Q23 (2 marks, Python Revision Tour II) Write a Python statement to perform the following tasks: (USE BUILT_IN FUNCTIONS/METHODS ONLY) (i) To create a new list L1 containing the elements of list L ar…
- Q24 (2 marks, Python Revision Tour II) Assuming that D1 is a dictionary in Python, (i) (a) Write a Python expression to check if the key, 'RNo' is present in D1. OR (b) Write a Python expression to…
- Q25 (2 marks, Working with Python Function) What possible output(s) from the given options will NOT be displayed when the following code is executed? Also, mention, for how many iterations the for loop i…
- Q26 (2 marks, Working with Python Function) The function given below is written to accept a string s as a parameter and return the number of vowels appearing in the string. The code has certain errors. R…
- Q27 (2 marks, Table Creation and Data Manipulation Commands) (i) (a) Write an SQL command to create the table W_STOCK with W_Code as primary key. OR (b) Can U_Price be the primary key? Justify. (ii) (a) Write an SQL comm…
- Q28 (2 marks, Computer Networks-I) (a) List one advantage and one disadvantage of Bus topology. OR (b) What is protocol in the context of computer networks? Which protocol is used to transmit hy…
- Q29 (3 marks, File Handling in Python (Text File)) (a) Write a Python function that counts and returns the number of digits appearing in the text file "Space.txt". OR (b) Write a Python function that displays t…
- Q30 (3 marks, Data Structures (Stack)) (a) A stack named FruitStack contains records represented as dictionaries. Write push_fruit(FruitStack, Fruit) to push if Price < 100, pop_fruit(FruitStack), a…
- Q31 (3 marks, Python Revision Tour II) (a) Write output: def Exam2026(given): new=[]; for ch in given[1:-1]: if ch.isupper(): new.reverse() elif ch not in new: new.append(ch) elif ch in new: new.pop…
- Q32 (4 marks, Simple Queries in SQL) STOCK table queries: (a) (i) Type and max Price for each Type. (ii) Increase Price by 0.5 where Type is 'F'. (iii) Total value (Qty * Price). (iv) Details wher…
- Q33 (4 marks, File Handling in Python (Binary & CSV file)) A csv file "States.csv" contains [State, Capital, Population, Language]. Write a Python program which reads data from this file and appends records where popul…
- Q34 (4 marks, Grouping Records, Joins in SQL) Based on CUSTOMERS and LOANS tables. Write queries for: (i) Count records where ROI > 7.0. (ii) Customer names where L_Amt > 1000000. (iii) C_ID, C_Name, Terms…
- Q35 (4 marks, Interface Python with MySQL) Help Peter write a Python program to display records of those students whose fees is less than 5000 from the 'Account' table in MySQL database 'SCHOOL'. Connec…
- Q36 (5 marks, File Handling in Python (Binary & CSV file)) Binary file 'RESOURCES.DAT' stores (R_ID, R_Name, R_Expertise, Charges). Write: (i) Append() to input data and write to file. (ii) Update() to increase Charges…
- Q37 (5 marks, Computer Networks-II) Amritsar University Campus has ADMIN (25), ACADEMIC (600), HOSTEL (120), SPORTS (50). Answer the following: (i) Suggest server location. (ii) Cable layout. (ii…
Download and study this document offline
Download PDF