CBSE Class 12 Informatics Practices 2024 Main Paper (Set 1)

About this paper

This is the CBSE Class 12 Informatics Practices (065) 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

Data Handling using Pandas and Data Visualization: 25 marks · Database Query using SQL: 25 marks · Introduction to Computer Networks: 10 marks · Societal Impacts: 10 marks

Marks by chapter

Chapter	Marks
Data Handling Using Pandas – I	19
Plotting with PyPlot	5
Importing/Exporting Data (CSV & MySQL)	1
MySQL SQL Revision Tour	16
MySQL Functions	8
Querying Using SQL	1
Introduction to Computer Networks	8
Introduction to Internet and Web	2
Societal Impacts	10

Questions in this paper

1. Q1 (1 mark, Introduction to Computer Networks) In __________ topology, the devices are arranged in the form of multiple branches in hierarchical manner.
2. Q2 (1 mark, Societal Impacts) Ridhima purchased a license for a copy of a software and made additional copies without the permission of the copyright owner. This act of hers is known as ___…
3. Q3 (1 mark, Societal Impacts) What can an individual do to enhance the privacy of data stored digitally?
4. Q4 (1 mark, MySQL Functions) What will be the output of the following query? SELECT POWER(2, MOD(17, 3));
5. Q5 (1 mark, Querying Using SQL) Which of the following is not an aggregate function in MYSQL?
6. Q6 (1 mark, Societal Impacts) __________ is the gaining of unauthorized access to data in a computer system.
7. Q7 (1 mark, Importing/Exporting Data (CSV & MySQL)) Which of the following is NOT true with respect to CSV files?
8. Q8 (1 mark, MySQL SQL Revision Tour) Which MySQL command helps to add a primary key constraint to any table that has already been created?
9. Q9 (1 mark, MySQL Functions) What will be the output of the following query? SELECT SUBSTR("G20 2023 INDIA", 5, 4);
10. Q10 (1 mark, Data Handling Using Pandas – I) What will be the output of the following Python code? import pandas as pd dd = {'One': 1, 'Two': 2, 'Three': 3, 'Seven': 7} rr = pd.Series(dd) rr['Four'] = 4 p…
11. Q11 (1 mark, MySQL SQL Revision Tour) Which of the following clause cannot work with SELECT statement in MYSQL?
12. Q12 (1 mark, Data Handling Using Pandas – I) Which of the following command will not show first five rows from the Pandas series named S1?
13. Q13 (1 mark, Societal Impacts) Rama was unable to understand how the recruiters were able to know about her digital activity when she has not shared anything with them. The recruiters might…
14. Q14 (1 mark, MySQL Functions) Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length?
15. Q15 (1 mark, Societal Impacts) The software that is free for anyone, and its source code is available for access, modification, correction, and improvement is called __________.
16. Q16 (1 mark, Societal Impacts) __________ help in data protection through copyrights, patents and trademarks.
17. Q17 (1 mark, Societal Impacts) Assertion (A) : Cyber Bullying can have serious, emotional and psychological effects on victims. Reason (R) : Online Bullying is not a crime while offline bull…
18. Q18 (1 mark, Data Handling Using Pandas – I) Assertion (A) : A Series is a one dimensional array and a DataFrame is a two-dimensional array containing sequence of values of any data type. (int, float, lis…
19. Q19 (2 marks, Introduction to Internet and Web) (a) Expand URL. Identify the protocol and domain in the following URL: https://epathshala.nic.in/topics.php?len=en OR (b) Write any one advantage and one disad…
20. Q20 (2 marks, Data Handling Using Pandas – I) The Python code written below has syntactical errors. Rewrite the correct code and underline the correction(s) made. import Pandas as pd stud=['Name' : 'Ramya'…
21. Q21 (2 marks, MySQL Functions) What will be the output of the following SQL queries : (i) SELECT RIGHT("CHANDRAYAN3", 4); (ii) SELECT ROUND(76345.456, 2);
22. Q22 (2 marks, Data Handling Using Pandas – I) Find the output of the following Python code : import pandas as pd com = pd.Series([45, 12, 15, 200], index=['mouse', 'printer', 'webcam', 'keyboard']) print(c…
23. Q23 (2 marks, Introduction to Computer Networks) What is the primary function of a gateway in a computer network ? Explain briefly.
24. Q24 (2 marks, Data Handling Using Pandas – I) Consider the following Python code : import pandas as pd S1 = pd.Series(['Rubina', 'Jaya', 'Vaibhav'], index=[10, 16, 18]) S2 = pd.Series(_________, index=[10,…
25. Q25 (2 marks, MySQL SQL Revision Tour) Write any two differences between UPDATE and ALTER TABLE commands of MySQL.
26. Q26 (3 marks, MySQL Functions) (a) Consider the given table and write the following queries in MySQL: Table : Sports Sid | SName | Fees | DateofPlay | CoachID 1 | Karate | 1200 | 2024-08-24…
27. Q27 (3 marks, Data Handling Using Pandas – I) Kabir, a data analyst, has stored the voter's name and age in a dictionary. Now, Kabir wants to create a list of dictionaries to store data of multiple voters.…
28. Q28 (3 marks, MySQL SQL Revision Tour) Answer the following questions based on the table Salesman given below: Table : Salesman salesman_id | name | city | commission 5001 | Neil Bhatt | Delhi | 0.1…
29. Q29 (3 marks, Societal Impacts) (a) Police officials arrested four members of an interstate gang for allegedly duping many people from different states on the pretext of providing them with h…
30. Q30 (3 marks, Data Handling Using Pandas – I) Consider the given DataFrame 'password': CodeName Category Frequency 0 aaaaaa alpha 6.91 1 dragon animal 18.52 2 baseball sport 1.29 3 football sport 11.11 4 m…
31. Q31 (4 marks, MySQL SQL Revision Tour) Rupam created a MySQL table to store the details of Nobel prize winners. Help her to write the following MySQL queries: TABLE : NOBEL Winner_Id | YEAR | SUBJEC…
32. Q32 (4 marks, Data Handling Using Pandas – I) Ms. Ritika conducted an online assessment and stored the details in a DataFrame result as given below: Name Score Attempts Qualify a Atulya 12.5 1 yes b Disha…
33. Q33 (5 marks, MySQL SQL Revision Tour) Excellent Consultancy Pvt. Ltd. maintains two tables for all its employees. Table : Employee Employee_id | First_name | Last_name | Salary | Joining_date | Dep…
34. Q34 (5 marks, Introduction to Computer Networks) FULLMAN Tech, Bengaluru is a company that deals with software development. They have different divisions HR (H1), Sales (H2), Production (H3) and Marketing (H4…
35. Q35 (5 marks, Plotting with PyPlot) (a) The inventory management software of a grocery shop stores the price of all fruits as follows: Fruits = ['Apple', 'Guava', 'Papaya', 'Grapes', 'Mango'] Pri…