12 Papers

CBSE Class 12 Computer Science 2024 Main Paper (Set 1)

About this paper 35 questions · 70 marks · solved answers

About this paper

This is the CBSE Class 12 Computer Science (083) board exam question paper (Set 1), 2024. 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 I2
Python Revision Tour II11
Working with Python Function9
Exception Handling1
File Handling in Python (Text File)4
File Handling in Python (Binary & CSV file)10
Data Structures (Stack)3
Computer Networks-I1
Computer Networks-II9
Simple Queries in SQL9
Table Creation and Data Manipulation Commands6
Interface Python with MySQL5

Questions in this paper

  1. Q1 (1 mark, Working with Python Function) State True or False: While defining a function in Python, the positional parameters in the function header must always be written after the default parameters.
  2. Q2 (1 mark, Simple Queries in SQL) The SELECT statement when combined with ________ clause, returns records without repetition.
  3. Q3 (1 mark, Python Revision Tour I) What will be the output of the following statement: print(16*5/4*2/5-8)
  4. Q4 (1 mark, Working with Python Function) What possible output from the given options is expected to be displayed when the following Python code is executed? import random Signal = ['RED', 'YELLOW', 'G…
  5. Q5 (1 mark, Simple Queries in SQL) In SQL, the aggregate function which will display the cardinality of the table is ________.
  6. Q6 (1 mark, Computer Networks-II) Which protocol out of the following is used to send and receive emails over a computer network?
  7. Q7 (1 mark, Python Revision Tour II) Identify the invalid Python statement from the following:
  8. Q8 (1 mark, Python Revision Tour II) Consider the statements given below and then choose the correct output from the given options: myStr="MISSISSIPPI" print(myStr[:4]+"#"+myStr[-5:])
  9. Q9 (1 mark, Python Revision Tour I) Identify the statement from the following which will raise an error:
  10. Q10 (1 mark, Python Revision Tour II) Select the correct output of the following code: event="G20 Presidency@2023" L=event.split(' ') print(L[::-2])
  11. Q11 (1 mark, Computer Networks-I) Which of the following options is the correct unit of measurement for network bandwidth?
  12. Q12 (1 mark, Working with Python Function) Observe the given Python code carefully: a=20 def convert(a): b=20 a=a+b convert(10) print(a) Select the correct output from the given options:
  13. Q13 (1 mark, Exception Handling) State whether the following statement is True or False: While handling exceptions in Python, name of the exception has to be compulsorily added with except cla…
  14. Q14 (1 mark, Table Creation and Data Manipulation Commands) Which of the following is not a DDL command in SQL?
  15. Q15 (1 mark, Computer Networks-II) Fill in the blank: ________ is a set of rules that needs to be followed by the communicating parties in order to have a successful and reliable data communicat…
  16. Q16 (1 mark, File Handling in Python (Text File)) Consider the following Python statement: F=open('CONTENT.TXT') Which of the following is an invalid statement in Python?
  17. Q17 (1 mark, File Handling in Python (Binary & CSV file)) Assertion (A): CSV file is a human readable text file where each line has a number of fields, separated by comma or some other delimiter. Reason (R): writerow(…
  18. Q18 (1 mark, Python Revision Tour II) Assertion (A): The expression "HELLO".sort() in Python will give an error. Reason (R): sort() does not exist as a method/function for strings in Python. Mark t…
  19. Q19 (2 marks, Computer Networks-II) (A) (i) Expand the following terms: XML, PPP (ii) Give one difference between circuit switching and packet switching. OR (B) (i) Define the term web hosting. (…
  20. Q20 (2 marks, Working with Python Function) The code given below accepts five numbers and displays whether they are even or odd: Observe the following code carefully and rewrite it after removing all syn…
  21. Q21 (2 marks, Working with Python Function) (A) Write a user defined function in Python named showGrades(S) which takes the dictionary S as an argument. S contains Name: [Eng, Math, Science] as key:value…
  22. Q22 (2 marks, Python Revision Tour II) Write the output displayed on execution of the following Python code: LS=["HIMALAYA", "NILGIRI", "ALASKA", "ALPS"] D={} for S in LS : if len(S)%4 == 0: D[S] =…
  23. Q23 (2 marks, Python Revision Tour II) (A) Write the Python statement for each of the following tasks using built-in functions/methods only: (i) To remove the item whose key is "NISHA" from a dictio…
  24. Q24 (2 marks, Table Creation and Data Manipulation Commands) (A) Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age and G_name. After creating the table, she realized that the at…
  25. Q25 (2 marks, Working with Python Function) Predict the output of the following code: def callon(b=20,a=10): b=b+a a=b-a print(b,"#",a) return b x=100 y=200 x=callon(x,y) print(x,"@",y) y=callon(y) print…
  26. Q26 (3 marks, Python Revision Tour II) Write the output on execution of the following Python code: S="Racecar Car Radar" L=S.split() for W in L : x=W.upper() if x==x[::-1]: for I in x: print(I,end="…
  27. Q27 (3 marks, Simple Queries in SQL) Consider the table ORDERS given below and write the output of the SQL queries that follow: Table: ORDERS [ORDNO, ITEM, QTY, RATE, ORDATE] 1001 | RICE | 23 | 12…
  28. Q28 (3 marks, File Handling in Python (Text File)) (A) Write a user defined function in Python named showInLines() which reads contents of a text file named STORY.TXT and displays every sentence in a separate l…
  29. Q29 (3 marks, Table Creation and Data Manipulation Commands) Consider the table Projects given below: Table: Projects [P_id, Pname, Language, Startdate, Enddate] P001 | School Management System | Python | 2023-01-12 | 20…
  30. Q30 (3 marks, Data Structures (Stack)) Consider a list named Nums which contains random integers. Write the following user defined functions in Python and perform the specified operations on a stack…
  31. Q31 (4 marks, Simple Queries in SQL) Consider the tables Admin and Transport given below: Table: Admin [S_id, S_name, Address, S_type] S001 | Sandhya | Rohini | Day Boarder S002 | Vedanshi | Rohta…
  32. Q32 (4 marks, File Handling in Python (Binary & CSV file)) Sangeeta is a Python programmer working in a computer hardware company. She has to maintain the records of the peripheral devices. She created a csv file named…
  33. Q33 (5 marks, Computer Networks-II) Infotainment Ltd. is an event management company with its prime office located in Bengaluru. The company is planning to open its new division at three differen…
  34. Q34 (5 marks, File Handling in Python (Binary & CSV file)) (A) (i) Differentiate between 'w' and 'a' file modes in Python. (ii) Consider a binary file, items.dat, containing records stored in the given format: {item_id…
  35. Q35 (5 marks, Interface Python with MySQL) (A) (i) Define cartesian product with respect to RDBMS. (ii) Sunil wants to write a program in Python to update the quantity to 20 of the records whose item co…

Download and study this document offline

Download PDF

Loading Preview...