Preparing for the CBSE board exams becomes much easier when students practice with the latest sample papers. CBSE Class 12 Informatics Practices (065) Sample Question Paper 2023-24 with Solution is designed according to the latest CBSE exam pattern and marking scheme. By solving this paper, students can understand important concepts such as Python Pandas, Data Visualization, SQL queries, and database management. It also helps in improving time management skills and identifying commonly asked questions in the examination.
This CBSE Class 12 IP 065 SQP 2023-24 with Solutions is highly beneficial for both pre-board and final board exam preparation. Students can evaluate their performance, learn the correct answering techniques, and boost their confidence before the exam. Regular practice of CBSE Class 12 IP sample papers ensures better accuracy and helps in scoring high marks in the board exams. Download and practice this paper to strengthen your preparation and achieve excellent results.
CBSE Class 12 IP 065 Sample QP 2023-24 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 12 Informatics Practices (065) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 12 IP 065 Sample Question Paper Session (2023-24)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATICS PRACTICES (SUBJECT CODE - 065)
Sample Question Paper (SQP) Solution for Class XII (Session 2023-2024)
Max. Time: 3 Hours
Max. Marks: 70
General Instructions:
- This question paper contains five sections, Section A to E.
- All questions are compulsory.
- Section A have 18 questions carrying 01 mark each.
- Section B has 07 Very Short Answer type questions carrying 02 marks each.
- Section C has 05 Short Answer type questions carrying 03 marks each.
- Section D has 02 questions carrying 04 marks each.
- Section E has 03 questions carrying 05 marks each.
- All programming questions are to be answered using Python Language only.
SECTION A
1. A ____________is a device that connects the organisation’s network with the outside world of the Internet.
a) Hub
b) Modem
c) Gateway
d) 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.
a) Hydrogen
b) Beryllium
c) Chlorine
d) Oxygen
3. Copyright, Patent and Trademark comes under:
a) Intellectual Property Rights
b) Individual Property Rights
c) Industrial Property Rights
d) International Property Rights
4. Predict the output of the following query:
SELECT MOD (9,0);
a) 0
b) NULL
c) NaN
d) 9
5. Which of the following SQL functions does not belong to the Math functions category?
a) POWER()
b) ROUND()
c) LENGTH()
d) MOD()
6. ________ is not a FOSS tool.
a) Libre Office
b) Mozilla Firefox
c) Google Chrome
d) Python
(FOSS - Free and Open Source Softwares)
7. CSV stands for:
a) Column Separated Value
b) Class Separated Value
c) Comma Separated Value
d) Comma Segregated Value
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?
a) SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;
b) SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) > 5 GROUP BY DEPT;
c) SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT(*) > 5;
d) 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'));
a) May
b) March
c) may
d) march
10. Which of the following command will show the last 3 rows from a Pandas Series named NP?
a) NP.Tail( )
b) NP.tail(3)
c) NP.TAIL(3)
d) All of the above
11. With reference to SQL, identify the invalid data type.
a) Date
b) Integer
c) Varchar
d) 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.
a) Null
b) Blank
c) NaN
d) 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:
a) Phishing
b) Identity Theft
c) Plagiarism
d) Ransomware
14. In SQL, the equivalent of UCASE() is:
a) UPPERCASE ()
b) CAPITALCASE ()
c) UPPER ()
d) TITLE ()
15. Collection of hyper linked documents available on the internet is known as ________.
a) Website
b) Webpage
c) Web Server
d) 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.
a) Creative Cost
b) Critical Commons
c) Creative Commons
d) 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.
a) Both A and R are true and R is the correct explanation for A
b) Both A and R are true and R is not the correct explanation for A
c) A is True but R is False
d) 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.
a) Both A and R are true and R is the correct explanation for A
b) Both A and R are true and R is not the correct explanation for A
c) A is True but R is False
d) A is false but R is True
SECTION B
19. Briefly explain the basic concepts of a web server and web hosting.
Ans: Web server: A web server is used to store and deliver the contents of a website to clients such as a browser that request it. A web server can be software or hardware.
Web hosting: It is a service that allows to put a website or a web page onto the Internet, and make it a part of the World Wide Web.
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.
Ans: URL: It stands for Uniform Resource Locator. It provides the location and mechanism (protocol) to access the resources over the internet.
URL is sometimes also called a web address. It not only contains the domain name, but other information as well that completes a web address.
Examples: https://www.cbse.nic.in, https://www.mhrd.gov.in, http://www.ncert.nic.in, http://www.airindia.in, etc.
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)
Ans:
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.
Ans: SELECT INSTR("12#All the Best!","the");
ii. To extract last five characters from the string.
Ans: SELECT RIGHT("12#All the Best!",5);
22. Predict the output of the given Python code:
import pandas as pd
list1=[-10,-20,-30]
ser = pd.Series(list1*2)
print(ser)
Ans:
0 -10
1 -20
2 -30
3 -10
4 -20
5 -30
23. Differentiate between the active digital footprint and passive digital footprints.
Ans: Active Digital Footprints: Active digital footprints include data that we intentionally submit online. This would include emails we write, or responses or posts we make on different websites or mobile Apps, etc.
Passive Digital Footprints: The digital data trail we leave online unintentionally is called passive digital footprints. This includes the data generated when we visit a website, use a mobile App, browse Internet, etc.
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[ ___________ ])
Ans:
import pandas as pd
di = {'Corbett': 'Uttarakhand', 'Sariska':'Rajasthan', 'Kanha': 'Madhya Pradesh','Gir':'Gujarat'}
NP = pd.Series(di)
print(NP['Sariska'])
25. What are aggregate functions in SQL? Name any two.
Ans: Aggregate functions: These are also called multiple row functions. These functions work on a set of records as a whole, and return a single value for each column of the records on which the function is applied.
Max(), Min(), Avg(), Sum(), Count() and Count(*) are few examples of multiple row functions.
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 |
i. Display fuel wise average sales in the first quarter.
Ans: SELECT FUEL, AVG(QT1) FROM CAR_SALES GROUP BY FUEL;
ii. Display segment wise highest sales in the second quarter.
Ans: SELECT SEGMENT, MAX(QT2) FROM CAR_SALES GROUP BY SEGMENT;
iii. Display the records in the descending order of sales in the second quarter.
Ans: SELECT * FROM CAR_SALES ORDER BY QT2 DESC;
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";
Ans:
| LEFT(SEGMENT,2) |
|---|
| Co |
| MU |
| SU |
| Se |
ii.SELECT (QT2-QT1)/2 "AVG SALE" FROM CAR_SALES WHERE SEGMENT= "SUV";
Ans:
| AVG SALE |
|---|
| 13500.0000 |
| 6000.0000 |
iii. SELECT SUM(QT1) "TOT SALE" FROM CAR_SALES WHERE FUEL= "DIESEL";
Ans:
| TOT SALE |
|---|
| 67000 |
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 |
Ans:
import pandas as pd #Statement 1
df=[["Divya","HR",95000],["Mamta","Marketing",97000],["Payal","IT",980000], ["Deepak","Sales",79000]] #Statement 2
df=pd.DataFrame(df,columns=["Name","Department", "Salary"]) #Statement 3
print(df) #Statement 4
28. Write MySQL statements for the following:
i. To create a database named FOOD.
Ans: CREATE DATABASE FOOD;
ii. To create a table named Nutrients based on the following specification:
| Column Name | Data Type | Constraints |
|---|---|---|
| Food_Item | Varchar(20) | Primary Key |
| Calorie | Integer |
Ans: CREATE TABLE NUTRIENTS(NAME VARCHAR(20) PRIMARY KEY,CALORIES 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.
i. Identify the type of cybercrime she is a victim of.
Ans: She is a victim of Cyber Bullying.
ii. Under which act, she can lodge a complaint to the relevant authorities?
Ans: Information Technology Act, 2000 (also known as IT Act).
iii. Suggest her any two precautionary measures which she should take in future while being online to avoid any such situations.
Ans: (i) Need to be careful while befriending unknown people on the internet.
(ii) Never share personal credentials like username and password with others.
OR
Mention any three health hazards associated with inappropriate and excessive use of gadgets.
Ans: Simran needs to be made aware of the following consequences:
i) Eye strain ii) Painful muscles and joints iii) Poor memory iv) Lack of sleep v) Back pain and neck pain
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:
i. Add a column called Num_Copies with the following data: [300,290,450,760].
Ans: Genre["Num_Copies"]=[300,290,450,760]
ii. Add a new genre of type ‘Folk Tale' having code as “FT” and 600 number of copies.
Ans: Genre.loc[4]=["Folk Tale","FT",600]
iii. Rename the column ‘Code’ to ‘Book_Code’.
Ans: Genre=Genre.rename({"Code":"Book_Code"}, axis=1)
OR
Genre=Genre.rename({"Code":"Book_Code"}, axis="columns")
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 | #wert5 | 2020-05-06 |
| 4 | Pihu | 678 | %rtyu | 2022-07-13 |
| 5 | Kopal | 768 | rtt4% | 2021-05-15 |
| 7 | Palakshi | 534 | wer03 | 2022-11-29 |
i. Write a query to display the year of oldest transaction.
Ans: SELECT YEAR(MIN(TRANSACTION_DATE)) FROM BLOCKCHAIN;
ii. Write a query to display the month of most recent transaction.
Ans: SELECT MONTH(MAX(TRANSACTION_DATE)) FROM BLOCKCHAIN;
iii. Write a query to display all the transactions done in the month of May.
Ans: SELECT * FROM BLOCKCHAIN WHERE MONTHNAME (TRANSACTION_DATE)='MAY';
iv. Write a query to count total number of transactions in the year 2022.
Ans: SELECT COUNT(ID) FROM BLOCKCHAIN WHERE YEAR(TRANSACTION_DATE)=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:
i. Predict the output of the following python statement:
a. print(df.size)
Ans: 15
b. print(df[1:3])
Ans:
| Store | Qtr1 | Qtr2 | Qtr3 | Qtr4 | |
|---|---|---|---|---|---|
| 1 | Store2 | 350 | 340 | 403 | 210 |
| 2 | Store3 | 250 | 180 | 145 | 160 |
ii. Delete the last row from the DataFrame.
Ans: df=df.drop(2)
OR
df.drop(2,axis=0)
iii. Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter sales.
Ans: df["total"]=df["Qtr1"]+df["Qtr2"]+df["Qtr3"]+df["Qtr4"]
OR (Option for part iii only)
Write Python statement to export the DataFrame to a CSV file named data.csv stored at D: drive.
Ans: df.to_csv(“D:\data.csv”)
SECTION E
33. Write suitable SQL queries for the following:
i. To calculate the exponent for 3 raised to the power of 4.
Ans: SELECT POWER(3,4);
ii. To display current date and time.
Ans: SELECT NOW();
iii. To round off the value -34.4567 to 2 decimal place.
Ans: SELECT ROUND(-34.4567,2);
iv. To remove all the probable leading and trailing spaces from the column userid of the table named user.
Ans: SELECT TRIM(USERID) FROM USER;
v. To display the length of the string ‘FIFA World Cup’.
Ans: SELECT LENGTH("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:
i. Insert a new record in the table having following values:
[6,'Khushi','CS',85]
Ans: INSERT INTO EXAM VALUES(6,'Khushi','CS',85);
ii. To change the value “IP” to “Informatics Practices” in subject column.
Ans: UPDATE EXAM SET subject= "Informatics Practices" where subject = "IP";
iii. To remove the records of those students whose marks are less than 30.
Ans: DELETE FROM EXAM WHERE marks<30;
iv. To add a new column Grade of suitable datatype.
Ans: ALTER TABLE EXAM ADD COLUMN grade varchar(2);
v. To display records of “Informatics Practices” subject.
Ans: SELECT * FROM EXAM WHERE subject="Informatics Practices";
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 m
Block Z1 to Block Z3 - 65 m
Block Z1 to Block Z4 - 90 m
Block Z2 to Block Z3 - 45 m
Block Z2 to Block Z4 - 120 m
Block Z3 to Block Z4 - 60 m
| Block | Number of computers |
|---|---|
| Z1 | 135 |
| Z2 | 290 |
| Z3 | 180 |
| Z4 | 195 |
The company is planning to form a network by joining these blocks.
i. Out of the four blocks on campus, suggest the location of the server that will provide the best connectivity. Explain your response.
Ans: Z2 as it has maximum number of computers.
ii. For very fast and efficient connections between various blocks within the campus, suggest a suitable topology and draw the same.
Ans: For very fast and efficient connections between various blocks within the campus suitable topology: Star Topology
iii. Suggest the placement of the following devices with justification
(a) Repeater (b) Hub/Switch
Ans: Repeater: To be placed between Block Z2 to Z4 as distance between them is more than 100 metres.
Hub/Switch: To be placed in each block as each block has many computers that needs to be included to form a network.
iv. VoIP technology is to be used which allows one to make voice calls using a broadband internet connection. Expand the term VoIP.
Ans: Voice Over Internet Protocol
v. 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.
Ans: WAN as distance between Delhi and Mumbai is more than 40kms.
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.
Ans:
import matplotlib.pyplot as plt #Statement 1
Height_cms = [145, 141, 142, 142, 143, 143, 141, 140, 143, 144] #Statement 2
plt.hist(Height_cms) #Statement 3
plt.title("Height Chart") #Statement 4
plt.xlabel("Height in cms") #Statement 5
plt.ylabel("Number of people") #Statement 6
plt.savefig("heights.jpg")
plt.show() #Statement 7
OR
Write suitable Python code to create 'Favourite Hobby' Bar Chart as shown below:
Also give suitable python statement to save this chart.
Ans:
import matplotlib.pyplot as plt #Statement 1
hobby = ('Dance', 'Music', 'Painting', 'Playing Sports') #Statement 2
users = [300, 400, 100, 500] #Statement 3
plt.bar(hobby, users) #Statement 4
plt.title("Favourite Hobby") #Statement 5
plt.ylabel("Number of people") #Statement 6
plt.xlabel("Hobbies") #Statement 7
plt.savefig("hobbies.jpg")
plt.show() #Statement 8
Download Now - Class 12 IP 065 Sample Question Paper 2023-24 with Solution
