CBSE Informatics Practices Sample Paper 2024 Class 12: Download PDF

CBSE Informatics Practices Sample Paper 2024 for Class 12: The Central Board of Secondary Education (CBSE) is the national-level Indian education Board coverIing hundreds of school all across the nation. Many private and public schools are affiliated with this board. The Indian Union Government regulates and operates all its processes. CBSE Board follows only the NCERT curriculum. The curriculum of CBSE for class 12 is divided into electives and skill-based subjects along with language subjects. Informatics Practices is one of the academic electives for class 12. This article elaborates on the latest sample paper 2024 released by CBSE for Class 12 Informatics Practices students to help them prepare for final exams.

CBSE Class 12 Informatics Practices General Guidelines:

1. This question paper contains five sections, Section 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. Section E has 03 questions carrying 05 marks each. 
8. All programming questions are to be answered using Python Language only.
9. Time duration: 3 hours
10. Maximum marks: 70

SAMPLE QUESTION PAPER 

CLASS XII (2023-24) 

INFORMATICS PRACTICES (065)

SECTION A

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

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

Q3. Copyright, Patent and Trademark comes under: 

1. Intellectual Property Right 
2. Individual Property Right 
3. Industrial Property Right 
4. None of the above

Q4. Predict the output of the following query: 

SELECT MOD (9,0); 

1. 0 
2. NULL 
3. NaN 
4. 9

Q5. Which of the following SQL functions does not belong to the Math functions category?

1. POWER() 
2. ROUND() 
3. LENGTH() 
4. MOD() 

Q6. ________ is not a FOSS tool. 

1. Libre Office 
2. Mozilla Firefox 
3. Google Chrome 
4. Python 

Q7. CSV stands for: 

1. Column Separated Value 
2. Class Separated Value 
3. Comma Separated Value 
4. None of the above

Q8. 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; 

Q9. Predict the output of the following query: SELECT LCASE (MONTHNAME ('2023-03-05')); 

1. May 
2. March 
3. may 
4. March

Q10. Which of the following command will show the last 3 rows from a Pandas Series named NP? i. NP.Tail( ) 

1. NP.tail(3) 
2. NP.TAIL(3) 
3. All of the above
4. With reference to SQL, identify the invalid data type. 
5. Date 
6. Integer 
7. Year 
8. Month

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

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

Q14. In SQL, the equivalent of UCASE() is: 

1. UPPERCASE () 
2. CAPITALCASE() 
3. UPPER() 
4. TITLE ()

Q15. Collection of hyperlinked documents available on the internet is known as_______________. 

1. Website 
2. Webpage 
3. Web Server 
4. Web Hosting
5. _______________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. 
6. Creative Cost 
7. Critical Commons 
8. Creative Commons 
9. Creative Common

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

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

Get the complete sample from the link below:

Also read:

CBSE Class 12 Syllabus 2023-2024 PDFs

CBSE Class 12 Sample Paper 2023-24