IP Sample Paper Class 12 2024 with Solutions PDF Download

The CBSE Class 12 IP Sample Paper 2023-24 for the academic year 2023-24 has been provided by the Central Board of Secondary Education. IP Sample Paper Class 12 2024 may now be downloaded at cbseacademic.nic.in. The CBSE also published the Marking Scheme for the CBSE Class 12 exam 2024 along with the IP Sample Paper. Download the CBSE Class 12 Informatics Practices Sample Paper 2023-24 PDF with a Marking Scheme from the article linked below.

Check: CBSE Class 12 IP Answer Key 2024 with Solution

Class 12 IP Sample Paper 2023-24

Using Class 12 IP Sample Paper 2023-24 pdf, students can gain a complete understanding of the board exam pattern, question types, response alternatives, and other elements. Students who chose Informatics practices as one of their senior secondary studies will find this sample paper and marking scheme highly useful. They can use it to predict the types of questions that will be asked in their exams, and the answers can be utilized to know how to answer precisely for an appropriate mark.

IP Sample Paper Class 12 2024

Get the CBSE IP sample paper class 12 2024 with Solutions below:

IP Sample Paper Class 12 2024 with Solution PDF

The IP Sample paper class 12 2023 and marking scheme have been posted available by the Central Board of Secondary Education at cbseacademic.nic.in. Candidates can download them to their devices from the official website. However, we will offer the sample paper for IP class 12 sample paper 2023-24 in pdf format below for the convenience of the students.

Class 12 IP Sample Paper 2023-24: Exam pattern

It is essential to comprehend the exam structure for the Class 12 Informatics Practices Exam. The official 12th IP Question Paper and the Sample Paper for CNSE Class 12 Informatics Practices2 have the same formatting. The overall grade for the IP sample paper class 12 2024 is 70. The question paper must be completed within three hours. view the general guidelines listed below.

1. This IP Sample paper class 12 2023 question paper contains five sections, Sections A to E.
2. All questions are compulsory.
3. Section A has 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 02 questions carrying 04 marks each.
7. Informatics practices class 12 sample paper 2023-24 – Section E has 03 questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.

IP Sample Paper Class 12 2024: Section A

Here we have discussed the IP Sample paper class 12 2023 Section A questions.

SECTION A
(Each Question Carries 1 Mark)

1. 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

Answer: iii. Gateway

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.
i. Hydrogen
ii. Beryllium
iii. Chlorine
iv. Oxygen

Answer: ii. Beryllium

3. Copyright, Patent and Trademark comes under:
i. Intellectual Property Right
ii. Individual Property Right
iii. Industrial Property Right
iv. International Property Right

Answer: i. Intellectual Property Right

4. Predict the output of the following query:
SELECT MOD (9,0);
i. 0
ii. NULL
iii. NaN
iv. 9

Answer: NULL

5. Which of the following SQL functions does not belong to the Math functions category?
i. POWER()
ii. ROUND()
iii. LENGTH()
iv. MOD()

Answer: iii. LENGTH()

6. ________ is not a FOSS tool.
i. Libre Office
ii. Mozilla Firefox
iii. Google Chrome
iv. Python

Answer: iii. Google Chrome

7. CSV stands for:
i. Column Separated Value
ii. Class Separated Value
iii. Comma Separated Value
iv. Comma Segregated Value

Answer: iii. Comma Separated Value

8. Raj, a Database Administrator, needs to display the average pay of workers from those departments that 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?
i. SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;
ii. SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) > 5 GROUP BY DEPT;
iii. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT(*) > 5;
iv. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5;

Answer: iv. 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’));
i. May
ii. March
iii. may
iv. march

Answer: iv. march

10. Which of the following commands will show the last 3 rows from a Pandas Series named NP?
i. NP.Tail( )
ii. NP.tail(3)
iii. NP.TAIL(3)
iv. All of the above

Answer: ii. NP.tail(3)

11. With reference to SQL, identify the invalid data type.
i. Date
ii. Integer
iii. Varchar
iv. Month

Answer: iv. 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.
i. Null
ii. Blank
iii. NaN
iv. Zero

Answer: iii. NaN

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 to get access to the data and threatens to publish sensitive information unless a price is paid. This kind of attack is known as:
i. Phishing
ii. Identity Theft
iii. Plagiarism
iv. Ransomware

Answer: iv. Ransomware

14. In SQL, the equivalent of UCASE() is:
i. UPPERCASE ()
ii. CAPITALCASE()
iii. UPPER()
iv. TITLE ()

Answer: iii. UPPER()

15. Collection of hyper linked documents available on the internet is known as_______________.
i. Website
ii. Webpage
iii. Web Server
iv. Web Hosting

Answer: i. Website

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.
i. Creative Cost
ii. Critical Commons
iii. Creative Commons
iv. Creative Common

Answer: iii. Creative Commons

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.
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True

Answer: i. Both A and R are true and R is the correct explanation for A

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.
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True

Answer: iii. A is True but R is False

Class 12 IP Sample Paper 2023-24: Section B

The section B questions from informatics practices class 12 sample paper 2023-24 is discussed here.

SECTION B
(Each Question Carries  2 Marks)

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:
i. Returns the position of the first occurrence of the substring “the” in the given string.
ii. 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.

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

IP Class 12 Sample Paper 2023-24: Section C

SECTION C
(Each Question Carries 3 Marks)

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

i. Display fuel wise average sales in the first quarter.
ii. Display segment wise highest sales in the second quarter.
iii. 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:
i. SELECT LEFT(SEGMENT,2) FROM CAR_SALES WHERE FUEL= “PETROL”;
ii.SELECT (QT2-QT1)/2 “AVG SALE” FROM CAR_SALES WHERE SEGMENT= “SUV”;
iii. SELECT SUM(QT1) “TOT SALE” FROM CAR_SALES WHERE FUEL= “DIESEL”;

27. Create a data frame 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:

28. Write MySQL statements for the following:
i. To create a database named FOOD.
ii. To create a table named Nutrients based on the following specifications:

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 sometime, 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.

i. Identify the type of cybercrime she is a victim of.
ii. Under which act, she can lodge a complaint to the relevant authorities?
iii. 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’:
Write suitable Python statements for the following:
i. Add a column called Num_Copies with the following data: [300,290,450,760].
ii. Add a new genre of type ‘Folk Tale’ having code as “FT” and 600 number of copies.
iii. Rename the column ‘Code’ to ‘Book_Code’.

Sharing is caring!