12 Papers

CBSE Class 12 Computer Science 2024 Sample Question Paper

About this paper 35 questions · 70 marks · solved answers

About this paper

This is the CBSE Class 12 Computer Science (083) sample question paper (SQP) for the 2024 board exam. It carries 70 marks across 35 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 I3
Python Revision Tour II11
Working with Python Function9
Exception Handling1
File Handling in Python (Text File)4
File Handling in Python (Binary & CSV file)9
Data Structures (Stack)3
Computer Networks-I2
Computer Networks-II8
Relational Databases1
Simple Queries in SQL4
Table Creation and Data Manipulation Commands5
Grouping Records, Joins in SQL5
Interface Python with MySQL5

Questions in this paper

  1. Q1 (1 mark, Python Revision Tour I) State True or False: “In a Python program, if a break statement is given in a nested loop, it terminates the execution of all loops in one go.”
  2. Q2 (1 mark, Simple Queries in SQL) In a table in MYSQL database, an attribute A of datatype varchar(20) has the value “Keshav”. The attribute B of datatype char(20) has value “Meenakshi”. How ma…
  3. Q3 (1 mark, Python Revision Tour I) What will be the output of the following statement: print(3-2 2 3+99/11)
  4. Q4 (1 mark, Python Revision Tour II) Select the correct output of the code: s = "Python is fun" l = s.split() s_new = "-".join([l[0].upper(), l[1], l[2].capitalize()]) print(s_new)
  5. Q5 (1 mark, Grouping Records, Joins in SQL) In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardin…
  6. Q6 (1 mark, Computer Networks-I) Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth Technology to connect two devices. Which type of network will be formed…
  7. Q7 (1 mark, Python Revision Tour II) Which of the following will delete key-value pair for key = “Red” from a dictionary D1?
  8. Q8 (1 mark, Python Revision Tour II) Consider the statements given below and then choose the correct output from the given options: pride="#G20 Presidency" print(pride[-2:2:-2])
  9. Q9 (1 mark, Python Revision Tour II) Which of the following statement(s) would give an error during execution of the following code? tup = (20,30,40,50,80,79) print(tup) #Statement 1 print(tup[3]+…
  10. Q10 (1 mark, Working with Python Function) What possible outputs(s) will be obtained when the following code is executed? import random myNumber=random.randint(0,3) COLOR=["YELLOW","WHITE","BLACK","RED"…
  11. Q11 (1 mark, Computer Networks-II) Fill in the blank: The modem at the sender’s computer end acts as a ____________.
  12. Q12 (1 mark, Working with Python Function) Consider the code given below: b=100 def test(a): # missing statement b=b+a print(a,b) test(10) print(b) Which of the following statements should be given in t…
  13. Q13 (1 mark, Exception Handling) State whether the following statement is True or False: An exception may be raised even if the program is syntactically correct.
  14. Q14 (1 mark, Relational Databases) Which of the following statements is FALSE about keys in a relational database?
  15. Q15 (1 mark, Computer Networks-I) Fill in the blank: In case of _____________ switching, before a communication starts, a dedicated path is identified between the sender and the receiver.
  16. Q16 (1 mark, File Handling in Python (Text File)) Which of the following functions changes the position of file pointer and returns its new position?
  17. Q17 (1 mark, Python Revision Tour I) Assertion(A): List is an immutable data type Reasoning(R): When an attempt is made to update the value of an immutable variable, the old variable is destroyed…
  18. Q18 (1 mark, Working with Python Function) Assertion(A): Python Standard Library consists of various modules. Reasoning(R): A function in a module is used to simplify the code and avoids repetition. (a)…
  19. Q19 (2 marks, Computer Networks-II) (i) Expand the following terms: POP3 , URL (ii) Give one difference between XML and HTML. OR (i) Define the term bandwidth with respect to networks. (ii) How i…
  20. Q20 (2 marks, Working with Python Function) The code given below accepts a number as an argument and returns the reverse number. Observe the following code carefully and rewrite it after removing all syn…
  21. Q21 (2 marks, Working with Python Function) Write a function countNow(PLACES) in Python, that takes the dictionary, PLACES as an argument and displays the names (in uppercase)of the places whose names ar…
  22. Q22 (2 marks, Python Revision Tour II) Predict the output of the following code: S = "LOST" L = [10,21,33,4] D={} for I in range(len(S)): if I%2==0: D[L.pop()] = S[I] else: D[L.pop()] = I+3 for K,V…
  23. Q23 (2 marks, Python Revision Tour II) Write the Python statement for each of the following tasks using BUILT-IN functions/methods only: (i) To insert an element 200 at the third position, in the li…
  24. Q24 (2 marks, Table Creation and Data Manipulation Commands) Ms. Shalini has just created a table named “Employee” containing columns Ename, Department and Salary. After creating the table, she realized that she has forg…
  25. Q25 (2 marks, Working with Python Function) Predict the output of the following code: def Changer(P,Q=10): P=P/Q Q=P%Q return P A=200 B=20 A=Changer(A,B) print(A,B,sep='$') B=Changer(B) print(A,B,sep='$'…
  26. Q26 (3 marks, Python Revision Tour II) Predict the output of the Python code given below: Text1="IND-23" Text2="" I=0 while I="0" and Text1[I]="A" and Text1[I]
  27. Q27 (3 marks, Simple Queries in SQL) Consider the table CLUB given below and write the output of the SQL queries that follow. Table: CLUB CID | CNAME | AGE | GENDER | SPORTS | PAY | DOAPP 5246 | A…
  28. Q28 (3 marks, File Handling in Python (Text File)) Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’. OR Write a function, vowelCount() in Python…
  29. Q29 (3 marks, Table Creation and Data Manipulation Commands) Consider the table Personal given below: Table: Personal P_ID | Name | Desig | Salary | Allowance P01 | Rohit | Manager | 89000 | 4800 P02 | Kashish | Clerk |…
  30. Q30 (3 marks, Data Structures (Stack)) A list, NList contains following record as list elements: [City, Country, distance from Delhi] Each of these records are nested together to form a nested list.…
  31. Q31 (4 marks, Grouping Records, Joins in SQL) Consider the tables PRODUCT and BRAND given below: Table: PRODUCT PCode | PName | UPrice | Rating | BID P01 | Shampoo | 120 | 6 | M03 P02 | Toothpaste | 54 | 8…
  32. Q32 (4 marks, File Handling in Python (Binary & CSV file)) Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the results of students i…
  33. Q33 (5 marks, Computer Networks-II) Meticulous EduServe is an educational organization. It is planning to setup its India campus at Chennai with its head office at Delhi. The Chennai campus has 4…
  34. Q34 (5 marks, File Handling in Python (Binary & CSV file)) (i) Differentiate between r+ and w+ file modes in Python. (ii) Consider a file, SPORT.DAT, containing records of the following structure: [SportName, TeamName,…
  35. Q35 (5 marks, Interface Python with MySQL) (i) Define the term Domain with respect to RDBMS. Give one example to support your answer. (ii) Kabir wants to write a program in Python to insert the followin…

Download and study this document offline

Download PDF

Loading Preview...