12 Papers

CBSE Class 12 Informatics Practices 2024 Sample Question Paper

About this paper 35 questions · 70 marks · solved answers

About this paper

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

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

ChapterMarks
Data Handling Using Pandas – I19
Plotting with PyPlot5
Importing/Exporting Data (CSV & MySQL)1
MySQL SQL Revision Tour4
MySQL Functions15
Querying Using SQL6
Introduction to Computer Networks7
Introduction to Internet and Web3
Societal Impacts10

Questions in this paper

  1. Q1 (1 mark, Introduction to Computer Networks) A ____________is a device that connects the organisation’s network with the outside world of the Internet. i. Hub ii. Modem iii. Gateway iv. Repeater
  2. Q2 (1 mark, Societal Impacts) When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in them create a harmful chemical called ________which causes ski…
  3. Q3 (1 mark, Societal Impacts) Copyright, Patent and Trademark comes under: i. Intellectual Property Right ii. Individual Property Right iii. Industrial Property Right iv. International Prop…
  4. Q4 (1 mark, MySQL Functions) Predict the output of the following query: SELECT MOD (9,0);
  5. Q5 (1 mark, MySQL Functions) Which of the following SQL functions does not belong to the Math functions category? i. POWER() ii. ROUND() iii. LENGTH() iv. MOD()
  6. Q6 (1 mark, Societal Impacts) ________ is not a FOSS tool. i. Libre Office ii. Mozilla Firefox iii. Google Chrome iv. Python
  7. Q7 (1 mark, Importing/Exporting Data (CSV & MySQL)) CSV stands for: i. Column Separated Value ii. Class Separated Value iii. Comma Separated Value iv. Comma Segregated Value
  8. Q8 (1 mark, Querying Using SQL) Raj, a Database Administrator, needs to display the average pay of workers from those departments which have more than five employees. He is experiencing a pro…
  9. Q9 (1 mark, MySQL Functions) Predict the output of the following query: SELECT LCASE (MONTHNAME ('2023-03-05'));
  10. Q10 (1 mark, Data Handling Using Pandas – I) Which of the following command will show the last 3 rows from a Pandas Series named NP?
  11. Q11 (1 mark, MySQL SQL Revision Tour) With reference to SQL, identify the invalid data type.
  12. Q12 (1 mark, Data Handling Using Pandas – I) In Python Pandas, while performing mathematical operations on series, index matching is implemented and all missing values are filled in with _____by default.
  13. Q13 (1 mark, Societal Impacts) By restricting the server and encrypting the data, a software company's server is unethically accessed in order to obtain sensitive information. The attacker b…
  14. Q14 (1 mark, MySQL Functions) In SQL, the equivalent of UCASE() is:
  15. Q15 (1 mark, Introduction to Internet and Web) Collection of hyper linked documents available on the internet is known as_______________.
  16. Q16 (1 mark, Societal Impacts) _______________is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared free…
  17. Q17 (1 mark, Introduction to Computer Networks) Assertion (A):- MODEM stands for modulator-demodulator. Reasoning (R): - It is a computer hardware device that converts data from a digital format to analog an…
  18. Q18 (1 mark, Data Handling Using Pandas – I) Assertion (A):- To use the Pandas library in a Python program, one must import it. Reasoning (R): - The only alias name that can be used with the Pandas librar…
  19. Q19 (2 marks, Introduction to Internet and Web) Briefly explain the basic concepts of a web server and web hosting. OR Rati is doing a course in networking. She is unable to understand the concept of URL. He…
  20. Q20 (2 marks, Data Handling Using Pandas – I) The python code written below has syntactical errors. Rewrite the correct code and underline the corrections made. Import pandas as pd df ={"Technology":["Prog…
  21. Q21 (2 marks, MySQL Functions) Consider the given SQL string: “12#All the Best!” Write suitable SQL queries for the following: i. Returns the position of the first occurrence of the substrin…
  22. Q22 (2 marks, Data Handling Using Pandas – I) Predict the output of the given Python code: import pandas as pd list1=[-10,-20,-30] ser = pd.Series(list1*2) print(ser)
  23. Q23 (2 marks, Societal Impacts) Differentiate between the active digital footprint and passive digital footprints.
  24. Q24 (2 marks, Data Handling Using Pandas – I) Complete the given Python code to get the required output as: Rajasthan import _________ as pd di = {'Corbett': 'Uttarakhand', 'Sariska': 'Rajasthan', 'Kanha':…
  25. Q25 (2 marks, Querying Using SQL) What are aggregate functions in SQL? Name any two.
  26. Q26 (3 marks, Querying Using SQL) Based on the SQL table CAR_SALES, write suitable queries for the following: +--------+-------------------+--------+-------+-------+ | NUMBER | SEGMENT | FUEL |…
  27. Q27 (3 marks, Data Handling Using Pandas – I) Create a DataFrame in Python from the given list: [[‘Divya’,’HR’,95000],[‘Mamta’,’Marketing’,97000],[‘Payal’,’IT’,980000], [‘Deepak’,’Sales’,79000]] Also give…
  28. Q28 (3 marks, MySQL SQL Revision Tour) Write MySQL statements for the following: i. To create a database named FOOD. ii. To create a table named Nutrients based on the following specification: Colum…
  29. Q29 (3 marks, Societal Impacts) Richa, recently started using her social media account. Within a few days, she befriends many people she knows and some that she does not know. After some time…
  30. Q30 (3 marks, Data Handling Using Pandas – I) Consider the given DataFrame ‘Genre’: Type Code 0 Fiction F 1 Non Fiction NF 2 Drama D 3 Poetry P Write suitable Python statements for the following: i. Add a…
  31. Q31 (4 marks, MySQL Functions) Preeti manages database in a blockchain start-up. For business purposes, she created a table named BLOCKCHAIN. Assist her by writing the following queries: TAB…
  32. Q32 (4 marks, Data Handling Using Pandas – I) Ekam, a Data Analyst with a multinational brand has designed the DataFrame df that contains the four quarter’s sales data of different stores as shown below: S…
  33. Q33 (5 marks, MySQL Functions) Write suitable SQL queries for the following: i. To calculate the exponent for 3 raised to the power of 4. ii. To display current date and time. iii. To round…
  34. Q34 (5 marks, Introduction to Computer Networks) XYZ Media house campus is in Delhi and has 4 blocks named Z1, Z2, Z3 and Z4. The tables given below show the distance between different blocks and the number o…
  35. Q35 (5 marks, Plotting with PyPlot) The heights of 10 students of eighth grade are given below: Height_cms=[145,141,142,142,143,144,141,140,143,144] Write suitable Python code to generate a histo…

Download and study this document offline

Download PDF

Loading Preview...