CBSE Sample Papers Class 12 Informatics Practices 2024

Informatics Practices model papers are available on myCBSEguide. You can download these CBSE Sample Papers Class 12 Informatics Practices 2024 as PDFs with solutions from CBSE official website too.

Sample paper of Informatics Practices Class 12 – in PDF

You can download CBSE Sample Papers Class 12 Informatics Practices 2024 as PDF from the CBSE official website cbseacademic.nic.in and the same is also available on the myCBSEguide app for free download.

Informatics Practices (IP) is a very dynamic subject. It includes the application part as well. That’s why a total of 30 out of 100 marks are reserved for practical examinations. CBSE will conduct a theory exam for 70 marks.

If you deeply analyse the question paper of class 12th IP, you will find that there are a large number of questions that involve practical knowledge. So, we suggest that you give proper time to the application part of the subject.

Class 12 Informatics Practices Sample paper 2024

Download as PDF

CBSE Sample Papers Class 12 Informatics Practices 2024

myCBSEguide provides CBSE class 12 Board Sample Papers of Informatics Practices for the year 2024 with solutions in PDF format for free download. The CBSE Sample Papers for all – NCERT books and based on CBSE’s latest syllabus must be downloaded and practiced by students. Class 12 Informatics Practices New Sample Papers follow the blueprint of that year only. Students must check the latest syllabus and marking scheme. Sample papers for class 12 Informatics Practices and other subjects are available for download as PDF in-app too. myCBSEguide provides a sample paper with solutions for the year 2024.

CBSE Sample Papers Class 12 Informatics Practices 2023-24

CBSE Class 12
Informatics Practices (Code No. 065)
(Sample Paper 2023-24)

---

TIME: 3 HOURS
M.M.70

General Instructions:

1. This question paper contains five sections, Section A to E.
2.  All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c only.
8. All programming questions are to be answered using Python Language only.

Class 12 IP Sample Paper SECTION A

1. A ________ is a device that connects the organisation’s network with the
   outside world of the Internet.
   1. Hub
   2. Modem
   3. Gateway
   4. Repeater
2. When e-waste such as electronic circuit boards are burnt for disposal, the
   elements contained in them create a harmful chemical called ________ which
   causes skin diseases, allergies and an increased risk of lung cancer.
   1. Hydrogen
   2. Beryllium
   3. Chlorine
   4. Oxygen
3. Copyright, Patent and Trademark comes under:
   1. Intellectual Property Right
   2. Individual Property Right
   3. Industrial Property Right
   4. None of the above
4. Predict the output of the following query:
   SELECT MOD (9, 0);
   1. 0
   2. NULL
   3. NaN
   4. 9
5. Which of the following SQL functions does not belong to the Math functions
   category?
   1. POWER()
   2. ROUND()
   3. LENGTH()
   4. MOD()
6. ________ is not a FOSS tool.
   1. Libre Office
   2. Mozilla Firefox
   3. Google Chrome
   4. Python
7. CSV stands for:
   1. Column Separated Value
   2. Class Separated Value
   3. Comma Separated Value
   4. None of the above
8. 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 problem while running the following query:
   SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5
   GROUP BY DEPT;
   Which of the following is a correct query to perform the given task?
   1. SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5
      GROUP BY DEPT;
   2. SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) >
      5 GROUP BY DEPT;
   3. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT
      WHERE COUNT(*) > 5;
   4. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT
      HAVING COUNT(*) > 5;
9. Predict the output of the following query:
   SELECT LCASE (MONTHNAME (‘2023-03-05’));
   1. May
   2. March
   3. may
   4. march
10. Which of the following command will show the last 3 rows from a Pandas
    Series named NP?
    1. NP.Tail( )
    2. NP.tail(3)
    3. NP.TAIL(3)
    4. All of the above
11. With reference to SQL, identify the invalid data type.
    1. Date
    2. Integer
    3. Year
    4. Month
12. In Python Pandas, while performing mathematical operations on series, index
    matching is implemented and all missing values are filled in with ________ by
    default.
    1. Null
    2. Blank
    3. NaN
    4. Zero
13. By restricting the server and encrypting the data, a software company’s
    server is unethically accessed in order to obtain sensitive information. The
    attacker blackmails the company to pay money for getting access to the data,
    and threatens to publish sensitive information unless price is paid. This kind
    of attack is known as:
    1. Phishing
    2. Identity Theft
    3. Plagiarism
    4. Ransomware
14. In SQL, the equivalent of UCASE() is:
    i. UPPERCASE ()
    ii. CAPITALCASE()
    iii. UPPER()
    iv. TITLE ()
15. Collection of hyper linked documents available on the internet is known
    as ________.
    1. Website
    2. Webpage
    3. Web Server
    4. Web Hosting
16. ________ is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely.
    1. Creative Cost
    2. Critical Commons
    3. Creative Commons
    4. Creative Common
17. Assertion (A): MODEM stands for modulator-demodulator.
    Reasoning (R): It is a computer hardware device that converts data from a
    digital format to analog and vice versa.
    1. Both A and R are true and R is the correct explanation for A
    2. Both A and R are true and R is not the correct explanation for A
    3. A is True but R is False
    4. A is false but R is True
18. 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 library
    is pd.
    1. Both A and R are true and R is the correct explanation for A
    2. Both A and R are true and R is not the correct explanation for A
    3. A is True but R is False
    4. A is false but R is True

Class 12 IP Sample Paper SECTION B

19. 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. Help her by explaining it with the help of suitable example.

20. The python code written below has syntactical errors. Rewrite the correct code
    and underline the corrections made.

    Import pandas as pd
    df ={"Technology":["Programming","Robotics","3D
    Printing"],"Time(in months)":[4,4,3]}
    df= Pd.dataframe(df)
    Print(df)

21. Consider the given SQL string:
    “12#All the Best!”
    Write suitable SQL queries for the following:
    1. Returns the position of the first occurrence of the substring “the” in
       the given string.
    2. To extract last five characters from the string.
22. Predict the output of the given Python code:

    import pandas as pd
    list1=[-10,-20,-30]
    ser = pd.Series(list1*2)
    print(ser)

23. Differentiate between the active digital footprint and passive digital footprints. 2
24. Complete the given Python code to get the required output as: Rajasthan

    import ________ as pd
    di = {'Corbett': 'Uttarakhand', 'Sariska':
    'Rajasthan', 'Kanha': 'Madhya Pradesh’,
    'Gir':'Gujarat'}
    NP = ________. Series( ________ )
    print(NP[ ________ ])

25. What are aggregate functions in SQL? Name any two. 2

Class 12 IP Sample Paper SECTION C

26. Based on the SQL table CAR_SALES, write suitable queries for the following:
    

    NUMBER	SEGMENT	FUEL	QT1	QT2
    1	Compact HatchBack	Petrol	56000	70000
    2	Compact HatchBack	Diesel	34000	40000
    3	MUV	Petrol	33000	35000
    4	MUV	Diesel	14000	15000
    5	SUV	Petrol	27000	54000
    6	SUV	Diesel	18000	30000
    7	Sedan	Petrol	8000	10000
    8	Sedan	Diesel	1000	5000

    1. Display fuel wise average sales in the first quarter.
    2. Display segment wise highest sales in the second quarter.
    3. Display the records in the descending order of sales in the second
       quarter.

       OR

    Predict the output of the following queries based on the table CAR_SALES given above:

    1. SELECT LEFT(SEGMENT,2) FROM CAR_SALES WHERE FUEL= “PETROL”;
    2. SELECT (QT2-QT1)/2 “AVG SALE” FROM CAR_SALES WHERE SEGMENT= “SUV”;
    3. SELECT SUM(QT1) “TOT SALE” FROM CAR_SALES WHERE FUEL= “DIESEL”;
27. Create a DataFrame in Python from the given list:
    [[‘Divya’,’HR’,95000],[‘Mamta’,’Marketing’,97000],[‘Payal’,’IT’,980000],
    [‘Deepak’,’Sales’,79000]] Also give appropriate column headings as shown below:

    	Name	Department	Salary
    0	Divya	HR	95000
    1	Mamta	Marketing	97000
    2	Payal	IT	980000
    3	Deepak	Sales	79000

28. Write MySQL statements for the following:
    1. To create a database named FOOD.
    2. To create a table named Nutrients based on the following specification:
       

       Column Name	Data Type	Constraints
       Food_Item	Varchar(20)	Primary Key
       Calorie	Integer

29. 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, she starts getting negative comments on her posts. She also finds
    that her pictures are being shared online without her permission.
    Based on the given information, answer the questions given below.
    1. Identify the type of cybercrime she is a victim of.
    2. Under which act, she can lodge a complaint to the relevant authorities?
    3. Suggest her any two precautionary measures which she should take in future while being online to avoid any such situations.

       OR

       Mention any three health hazards associated with inappropriate and excessive use of gadgets.

30. 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:

    1. Add a column called Num_Copies with the following data:
       [300,290,450,760].
    2. Add a new genre of type ‘Folk Tale’ having code as “FT” and 600
       number of copies.
    3. Rename the column ‘Code’ to ‘Book_Code’.

Class 12 IP Sample Paper SECTION D

31. Preeti manages database in a blockchain start-up. For business purposes, she
    created a table named BLOCKCHAIN. Assist her by writing the following
    queries:

    TABLE: BLOCKCHAIN

    Id	user	value	hash	transaction_date
    1	Steve	900	ERTYU	2020-09-19
    2	Meesha	145	@345r	2021-03-23
    3	Nimisha	567	#wet5	2020-05-06
    4	Pihu	679	%rtyu	2022-07-13
    5	Kopal	768	rrt4%	2021-05-15
    6	Palakshi	534	wer@3	2022-11-29

    1. Write a query to display the year of oldest transaction.
    2. Write a query to display the month of most recent transaction.
    3. Write a query to display all the transactions done in the month of May.
    4. Write a query to count total number of transactions in the year 2022.
32. 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:

    	Store	Qtr1	Qtr2	Qtr3	Qtr4
    0	Store1	300	240	450	230
    1	Store2	350	340	403	210
    2	Store3	250	180	145	160

    Answer the following questions:

    1. Predict the output of the following python statement:
       1. print(df.size)
       2. print(df[1:3])
    2. Delete the last row from the DataFrame.
    3. Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter sales.

       OR
       (Option for part iii only)

    Write Python statement to export the DataFrame to a CSV file named data.csv stored at D: drive.

Class 12 IP Sample Paper SECTION E

33. Write suitable SQL queries for the following:
    1. To calculate the exponent for 3 raised to the power of 4.
    2. To display current date and time.
    3. To round off the value -34.4567 to 2 decimal place.
    4. To remove all the probable leading and trailing spaces from the
       column userid of the table named user.
    5. To display the length of the string ‘FIFA World Cup’.

       OR

    Kabir has created following table named exam:

    RegNo	Name	Subject	Marks
    1	Sanya	Computer Science	98
    2	Sanchay	IP	100
    3	Vinesh	CS	90
    4	Sneha	IP	99
    5	Akshita	IP	100

    Help him in writing SQL queries to the perform the following task:

    1. Insert a new record in the table having following values:
       [6,’Khushi’,’CS’,85]
    2. To change the value “IP” to “Informatics Practices” in subject
       column.
    3. To remove the records of those students whose marks are less than 30.
    4. To add a new column Grade of suitable datatype.
    5. To display records of “Informatics Practices” subject.
34. 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 of computers in each block.

    Block Z1 to Block Z2	80 metres
    Block Z1 to Block Z3	65 metres
    Block Z1 to Block Z4	90 metres
    Block Z2 to Block Z3	45 metres
    Block Z2 to Block Z4	120 metres
    Block Z3 to Block Z4	60 metres

    Block	Number of computers
    Z1	135
    Z2	290
    Z3	180
    Z4	195

    The company is planning to form a network by joining these blocks.

    1. Out of the four blocks on campus, suggest the location of the server that will provide the best connectivity. Explain your response.
    2. For very fast and efficient connections between various blocks within the campus, suggest a suitable topology and draw the same.
    3. Suggest the placement of the following devices with justification
       1. Repeater
       2. Hub/Switch
    4. VoIP technology is to be used which allows one to make voice calls
       using a broadband internet connection. Expand the term VoIP.
    5. The XYZ Media House intends to link its Mumbai and Delhi centers.
       Out of LAN, MAN, or WAN, what kind of network will be created?
       Justify your answer.
35. 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 histogram based on the given data,
    along with an appropriate chart title and both axis labels.
    Also give suitable python statement to save this chart.

    OR

    Write suitable Python code to create ‘Favourite Hobby‘ Bar Chart as
    shown below:
    
    Also give suitable python statement to save this chart.

 

---

These are questions only. To view and download the complete question paper with the solution install myCBSEguide App from the google play store or log in to our student dashboard.

Download myCBSEguide App

Class 12 Sample Papers 2024

• Physics
• Chemistry
• Mathematics
• Biology
• English Core
• Business Studies
• Economics
• Accountancy
• Computer Science
• Informatics Practices
• Hindi Core
• Hindi Elective
• History
• Political Science
• Geography
• Home Science
• Physical Education
• Other Subjects

To download sample papers for class 12 Physics, Chemistry, Biology, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies and Home Science; do check the myCBSEguide app or website. myCBSEguide provides sample papers with solutions, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Papers all are made available through the best app for CBSE students and the myCBSEguide website.