CBSE Class 12 Informatics Practices (Code 065) Sample Question Papers are very helpful for students preparing for board exams. These papers give a clear idea about the latest exam pattern, types of questions, and marking scheme. By practicing the Class 12 IP 2020-21 sample paper with solutions, students can understand how to write accurate answers and manage time effectively during the exam. It also helps in identifying important topics from units like Python, Data Handling, and Database Concepts.
Solving CBSE Class 12 IP Sample Papers regularly boosts confidence and reduces exam stress. Students can analyze their mistakes using the provided solutions and improve their performance step by step. It also helps in revising the complete syllabus in a structured way before exams. Overall, practicing Class 12 IP sample papers is one of the best strategies to score good marks and perform well in the CBSE board examination.
CBSE Class 12 IP 065 Sample QP 2020-21 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 (2020-21)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATICS PRACTICES (SUBJECT CODE - 065)
Sample Question Paper (SQP) Solution for Class XII (Session 2020-2021)
Max. Time: 3 Hours
Max. Marks: 70
General Instructions:
- This question paper contains two parts A and B. Each part is compulsory.
- Both Part A and Part B have choices.
- Part - A has 2 sections:
- Section – I is short answer questions, to be answered in one word or one line.
- Section – II has two case studies questions. Each case study has 4 case-based subparts. An examinee is to attempt any 4 out of the 5 subparts.
- Part - B is Descriptive Paper.
- Part- B has three sections
- Section-I is short answer questions of 2 marks each in which two questions have internal options.
- Section-II is long answer questions of 3 marks each in which two questions have internal options.
- Section-III is very long answer questions of 5 marks each in which one question has question has internal option.
PART - A
SECTION I
SECTION I
Attempt any 15 questions from questions 1 to 21
1. State whether True or False:
i. A copyright is automatically granted to authors or creators of content.
Ans: True
ii. In FOSS source code is usually hidden from the users.
Ans: False
2. Fill in the blanks :
The command used to give a heading to a graph is _______
a) plt.show()
b) plt.plot()
c) plt.xlabel()
d) plt.title()
3. Write the output of the following SQL command.
select round(49.88);
a) 49.88
b) 49.8
c) 49.0
d) 50
4. Given a Pandas series called Sequences, the command which will display the
first 4 rows is ________.
a) print(Sequences.head(4))
b) print(Sequences.Head(4))
c) print(Sequences.heads(4)
d) print(Sequences.Heads(4))
5. Given the following Series S1 and S2:
| S1 | S2 | ||
|---|---|---|---|
| A | 10 | A | 80 |
| B | 40 | B | 20 |
| C | 34 | C | 74 |
| D | 60 | D | 90 |
Write the command to find the sum of series S1 and S2
Ans: print (S1+S2)
6. Using Python Matplotlib _________ can be used to count how many values fall into each interval.
a) line plot
b) bar graph
c) histogram
7. To prevent unauthorized access to and / or from the network, a system known as _______, can be implemented by hardware and / or software.
Ans: Firewall
8. In a DataFrame, Axis= 1 represents the _________ elements.
Ans: column
9. Which of the following is not a network topology:
Star, Mesh , Tree, Bug , Bus
Ans: Bug
10. For web pages where the information is changed frequently, for example, stock prices, weather information which out of the following options would you advise?
(a) Static web page (b) Dynamic web page
Justify your answer.
Ans: (b) Dynamic web page
Dynamic web pages are designed to display frequently changing information such as stock prices, weather updates, news feeds, etc.
11. The avg() function in MySql is an example of __________.
a) Math function
b) Text function
c) Date Function
d) Aggregate Function
12. The practice of taking someone else's work or ideas and passing them off as one's own is known as _________.
Ans: Plagiarism
13. In Pandas the function used to check for null values in a DataFrame is ________.
Ans: isnull()
14. I can keep you signed in.
I can remember your site preferences.
I can give you locally relevant content.
Who am I?
Ans: Cookies
15. Which amongst the following is not an example of browser?
a) Chrome
b) Firefox
c) Avast
d) Edge
16. A mail or message sent to a large number of people indiscriminately without their consent is called _________.
Ans: spam
17. According to a survey, one of the major asian country generates approximately about 2 million tonnes of electronic waste per year. Only 1.5 % of the total e-waste gets recycled. Suggest a method to manage e-waste.
Ans: Buy environmentally friendly electronics Donate used electronics to social programs Reuse, refurbish electronics Recycling e-waste.
18. The ________ command can be used to makes changes in the rows of a table in SQL.
Ans: update
19. Write the SQL command that will display the current time and date.
Ans: SELECT now();
20. _________ network device is known as an intelligent hub.
Ans: Switch
21. Receiving irrelevant and unwanted emails repeatedly is an example of _________.
Ans: Spam
SECTION II
Both the case study based questions (22 & 23 ) are compulsory. Attempt any four sub parts from each question. Each sub question carries 1 mark .
22. Consider the following DataFrame df and answer any four questions from (i)-(v)
| Roll No | Name | UT1 | UT2 | UT3 | UT4 |
|---|---|---|---|---|---|
| 1 | Prerna Singh | 24 | 24 | 20 | 22 |
| 2 | Manish Arora | 18 | 17 | 19 | 22 |
| 3 | Tanish Goel | 20 | 22 | 18 | 24 |
| 4 | Falguni Jain | 22 | 20 | 24 | 20 |
| 5 | Kanika Bhatnagar | 15 | 20 | 18 | 22 |
| 6 | Ramandeep Kaur | 20 | 15 | 22 | 24 |
(i) Write down the command that will give the following output.
| rollno | 6 |
| name | Tanish Goel |
| UT1 | 24 |
| UT2 | 24 |
| UT3 | 24 |
| UT4 | 24 |
| dtype: object | |
a) print(df.max)
b) print(df.max())
c) print(df.max(axis=1))
d) print(df.max, axis=1)
(ii) The teacher needs to know the marks scored by the student with roll number 4. Help her to identify the correct set of statement/s from the given options:
a) df1=df[df[‘rollno’]==4]
print(df1)
b) df1=df[rollno==4]
print(df1)
c) df1=df[df.rollno=4]
print(df1)
d) df1=df[df.rollno==4]
print(df1)
(iii) Which of the following statement/s will give the exact number of values in each column of the dataframe?
i. print(df.count())
ii. print(df.count(0))
iii. print(df.count)
iv. print(df.count(axis=’index’))
Choose the correct option:
a) both (i) and (ii)
b) only (ii)
c) (i), (ii) and (iii)
d) (i), (ii) and (iv)
(iv) Which of the following command will display the column labels of the DataFrame?
a) print(df.columns())
b) print(df.column())
c) print(df.column)
d) print(df.columns)
(v) Ms. Sharma, the class teacher wants to add a new column, the scores of Grade with the values, 'A', 'B', 'A', 'A', 'B', 'A' ,to the DataFrame. Help her choose the command to do so:
a) df.column=['A','B','A','A','B','A']
b) df ['Grade']=['A','B','A','A','B','A']
c) df.loc[‘Grade’]= ['A','B','A','A','B','A']
d) Both b) and c) are correct
23 Consider the table STUDENT given below:
| RollNo | Name | Class | DOB | Gender | City | Marks |
|---|---|---|---|---|---|---|
| 1 | Anand | XI | 6/6/97 | M | Agra | 430 |
| 2 | Chetan | XII | 7/5/94 | M | Mumbai | 460 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
| 5 | Saniyal | XII | 8/10/95 | M | Delhi | 360 |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 8 | Nishant | X | 12/6/95 | M | Moscow | 429 |
(i) State the command that will give the output as:
| Name |
|---|
|
Anand
Chetan Geet Preeti |
i. select name from student where class='XI' and class='XII';
ii. select name from student where not class='XI' and class='XII';
iii. select name from student where city='Agra' OR city='Mumbai';
iv. select name from student where city IN('Agra','Mumbai');
Choose the correct option:
a) Both (i) and (ii)
b) Both (iii) and (iv)
c) Any of the options (i), (ii) and (iv)
d) Only (iii)
(ii) What will be the output of the following command?
Select * from student where gender =”F” order by marks;
a)
| Rollno | Name | Class | DOB | Gender | City | Marks |
|---|---|---|---|---|---|---|
|
4 3 7 6 |
Preeti Geet Neha Maakhiy |
XII XI X XI |
8/8/95 6/5/97 8/12/95 12/12/94 |
F F F F |
Mumbai Agra Moscow Dubai |
492 470 324 256 |
b)
| Rollno | Name | Class | DOB | Gender | City | Marks |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
c)
| Gender | Marks |
| F | 256 |
| F | 324 |
| F | 470 |
| F | 492 |
d)
| Gender | Marks |
| F | 492 |
| F | 470 |
| F | 324 |
| F | 256 |
(iii) Prachi has given the following command to obtain the highest marks:
Select max(marks) from student where group by class;
but she is not getting the desired result. Help her by writing the correct command.
a) Select max(marks) from student where group by class;
b) Select class, max(marks) from student group by marks;
c) Select class, max(marks) group by class from student;
d) Select class, max(marks) from student group by class;
(iv) State the command to display the average marks scored by students of each gender who are in class XI?
i. Select gender, avg(marks) from student where class= 'XI' group by gender;
ii Select gender, avg(marks) from student group by gender where class='XI';
iii. Select gender, avg(marks) group by gender from student having class='XI';
iv. Select gender, avg(marks) from student group by gender having class = 'XI';
Choose the correct option:
a) Both (ii) and (iii)
b) Both (ii) and (iv)
c) Both (i) and (iii)
d) Only (iii)
(v) Help Ritesh to write the command to display the name of the youngest student?
a) select name,min(DOB) from student;
b) select name,max(DOB) from student;
c) select name,min(DOB) from student group by name;
d) select name,maximum(DOB) from student;
PART - B
SECTION I
24. Consider a given Series, M1:
index
{
| Marks | |
| Term1 | 45 |
| Term2 | 65 |
| Term3 | 24 |
| Term4 | 89 |
Write a program in Python Pandas to create the series.
Ans:
import pandas as pd
m1 = pd.Series(
[45, 65, 24, 89],
index=['term1', 'term2', 'term3', 'term4']
)
25. State any two differences between single row functions and multiple row functions.
Ans: Differences between single row functions and multiple row functions.
(i) Single row functions work on one row only whereas multiple row functions group rows
(ii) Single row functions return one output per row whereas multiple row functions return only one output for a specified group of rows.
OR
What is the difference between the order by and group by clause when used along with the SELECT statement. Explain with an example.
Ans: The ORDER BY clause is used to display the records of a table in a sorted order based on one or more columns. The sorting can be done in ascending (ASC) or descending (DESC) order.
Example: SELECT name, marks FROM student ORDER BY marks DESC;
This query displays student records sorted by marks in descending order.
The GROUP BY clause is used to group rows having the same values in a specified column. It is generally used with aggregate functions like SUM(), AVG(), MAX(), MIN(), etc.
Example: SELECT class, AVG(marks) FROM student GROUP BY class;
This query groups students by class and shows the average marks of each class.
26. Consider the decimal number x with value 8459.2654. Write commands in SQL to:
(i) round it off to a whole number
Ans: SELECT round(8459.2654);
(ii) round it to 2 places before the decimal
Ans: SELECT round(8459.2654,-2);
27. Consider the following Series object, S_amt
| Table | 350 |
| Chair | 200 |
| Sofa | 800 |
| Stool | 150 |
(i) Write the command which will display the name of the furniture having rent>250.
Ans: print(S_amt[S_amt>250])
(ii) Write the command to name the series as Furniture.
Ans: S_amt.name= 'Furniture'
28. Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission.
Command1: Select count(*) from employee;
Command2: Select count(commission) from employee;
She gets the output as 4 for the first command but gets an output 3 for the second command. Explain the output with justification.
Ans: This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.
29. Consider the following SQL string: "Preoccupied"
Write commands to display:
a. "occupied"
Ans: select substr("Preoccupied", 4);
b. "cup"
Ans: select substr("Preoccupied" ,6,3);
OR
Considering the same string "Preoccupied"
Write SQL commands to display:
a. the position of the substring ‘cup’ in the string "Preoccupied"
Ans: select instr 'Preoccupied' , ‘ 'cup'));
b. the first 4 letters of the string
Ans: select left 'Preoccupied',4);
30. Consider the following DataFrame, classframe
| Rollno | Name | Class | Section | CGPA | Stream | |
| St1 | 1 | Aman | IX | E | 8.7 | Science |
| St2 | 2 | Preeti | X | F | 8.9 | Arts |
| St3 | 3 | Kartikey | IX | D | 9.2 | Science |
| St4 | 4 | Lakshay | X | A | 9.4 | Commerce |
Write commands to:
(i) Add a new column ‘Activity’ to the Dataframe
Ans: classframe[‘Activity’]=[‘Swimming’,’Dancing’,’Cricket’, ‘Singing’]
(ii) Add a new row with values ( 5 , Mridula ,X, F , 9.8, Science)
Ans: classframe.loc[‘St5’]=[1,’Mridula’, ‘X’, ‘F’, 9.8, ‘Science’]
31. Expand the following terms related to Computer Networks:
(i) SMTP (ii) POP (iii) FTP (iv) VoIP
Ans: (i) Simple Mail Transfer Protocol
(ii) Point to Point Protocol
(iii) File Transfer Protocol
(iv) Voice over Internet Protocol
32. List any two health hazards related to excessive use of Technology.
Ans: The continuous use of devices like smartphones, computer desktop, laptops, head phones etc cause a lot of health hazards if not addressed. These are:
(i) Impact on bones and joints: wrong posture or long hours of sitting in an uncomfortable position can cause muscle or bone injury.
(ii) Impact on eyes: This is the most common form of health hazard as prolonged hours of screen time can lead to extreme strain in the eyes.
(iii) Sleep problem: Bright light from computer devices block a hormone called melatonin which helps us sleep. Thus we can experience sleep disorders leading to short sleep cycles.
33. Priyanka is using her internet connection to book a flight ticket. This is a classic example of leaving a trail of web activities carried by her. What do we call this type of activity? What is the risk involved by such kind of activity?
Ans: We call this type of activity as Digital Footprints
Risk involved: It includes websites we visit emails we send, and any information we submit online, etc., along with the computer’s IP address, location, and other device specific details. Such data could be used for targeted advertisement or could also be misused or exploited.
SECTION II
34. Consider two objects x and y. x is a list whereas y is a Series. Both have values 20, 40,90, 110.
What will be the output of the following two statements considering that the above objects have been created already
(a) print (x*2)
(b) print(y*2)
Justify your answer.
Ans: (a) Output: [20, 40, 90, 110, 20, 40, 90, 110]
In Python, multiplying a list by 2 does not multiply each element, instead it repeats the list elements.
(b) Output:
| 0 | 40 |
| 1 | 80 |
| 2 | 180 |
| 3 | 220 |
dtype: int64
In a Pandas Series, multiplication is performed element-wise, so each value is multiplied by 2.
35. What do you mean by Identity theft? Explain with the help of an example.
Ans: Identity theft is the crime of obtaining the personal or financial information of another person for the sole purpose of assuming that person's name or identity to make transactions or use it to post inappropriate remarks , comments etc. Example: Alex likes to do his homework late at night. He uses the Internet a lot and also sends useful data through email to many of his friends. One Day he forgot to sign out from his email account. In the morning, his twin brother, Flex started using the computer. He used Flex’s email account to send inappropriate messages to his contacts.
OR
What do you understand by Net Etiquettes? Explain any two such etiquettes.
Ans: Net Etiquettes refers to the proper manners and behaviour we need to exhibit while being online.
These include:
(i) No copyright violation: we should not use copyrighted materials without the permission of the creator or owner. We should give proper credit to owners/creators of open source content when using them.
(ii) Avoid cyber bullying: Avoid any insulting, degrading or intimidating online behaviour like repeated posting of rumours, giving threats online, posting the victim’s personal information, or comments aimed to publicly ridicule a victim.
36. Consider the following graph . Write the code to plot it.
Ans:
import matplotlib.pyplot as plt
plt.plot([2, 7], [1, 6])
plt.show()
OR
Draw the following bar graph representing the number of students in each class.
Ans:
import matplotlib.pyplot as plt
classes = ['VII', 'VIII', 'IX', 'X']
students = [40, 45, 35, 44]
plt.bar(classes, students)
plt.show()
37. A relation Vehicles is given below:
| V_no | Type | Company | Price | Qty |
| AW125 | Wagon | Maruti | 250000 | 25 |
| J0083 | Jeep | Mahindra | 4000000 | 15 |
| S9090 | SUV | Mitsubishi | 2500000 | 18 |
| M0892 | Mini van | Datsun | 1500000 | 26 |
| W9760 | SUV | Maruti | 2500000 | 18 |
| R2409 | Mini van | Mahindra | 350000 | 15 |
Write SQL commands to:
(a) Display the average price of each type of vehicle having quantity more than 20.
Ans: SELECT Type, avg(Price) from Vehicle group by Type having Qty>20;
(b) Count the type of vehicles manufactured by each company.
Ans: SELECT Company, count(distinct Type) from Vehicle group by Company;
(c) Display the total price of all the types of vehicles.
Ans: SELECT Type, sum(Price* Qty) from Vehicle group by Type;
SECTION III
38. Write a program in Python Pandas to create the following DataFrame batsman from a Dictionary:
| B_NO | Name | Score1 | Score2 |
| 1 | Sunil Pillai | 90 | 80 |
| 2 | Gaurav Sharma | 65 | 45 |
| 3 | Piyush Goel | 70 | 90 |
| 4 | Kartik Thakur | 80 | 76 |
Perform the following operations on the DataFrame:
> Add both the scores of a batsman and assign to column "Total"
> Display the highest score in both Score1 and Score2 of the DataFrame
> Display the DataFrame
Ans:
import pandas as pd
d1 = {
'B_NO': [1, 2, 3, 4],
'Name': ["Sunil Pillai", "Gaurav Sharma", "Piyush Goel", "Kartik Thakur"],
'Score1': [90, 65, 70, 80],
'Score2': [80, 45, 95, 76]
}
df = pd.DataFrame(d1)
print(df)
df['Total'] = df['Score1'] + df['Score2']
39. Write the SQL functions which will perform the following operations:
(a) To display the name of the month of the current date.
Ans: monthname(date(now()))
(b) To remove spaces from the beginning and end of a string, "Panorama".
Ans: trim("Panaroma")
(c) To display the name of the day eg, Friday or Sunday from your date of birth, dob.
Ans: dayname(date(dob))
(d) To display the starting position of your first name(fname) from your whole name (name).
Ans: instr(name, fname)
(e) To compute the remainder of division between two numbers, n1 and n2.
Ans: mod(n1,n2)
OR
Consider a table SALESMAN with the following data:
| SNO | SNAME | SALARY | BONUS | DATEOFJOIN |
| A01 | Beena Mehta | 30000 | 45.23 | 29-10-2019 |
| A02 | K. L. Sahay | 50000 | 25.34 | 13-03-2018 |
| B03 | Nisha Thakkar | 30000 | 35.00 | 18-03-2017 |
| B04 | Leela Yadav | 80000 | NULL | 31-12-2018 |
| C05 | Gautam Gola | 20000 | NULL | 23-01-1989 |
| C06 | Trapti Garg | 70000 | 12.37 | 15-06-1987 |
| D07 | Neena Sharma | 50000 | 27.89 | 18-03-1999 |
Write SQL queries using SQL functions to perform the following operations:
(a) Display salesman name and bonus after rounding off to zero decimal places
Ans: Select sname, round(bonus,0) from Salesman;
(b) Display the position of occurrence of the string "ta" in salesman names
Ans: Select instr(Sname, "ta") from Salesman;
(c) Display the four characters from salesman name starting from second character
Ans: Select mid(Sname,2,4) from Salesman;
(d) Display the month name for the date of join of salesman
Ans: Select monthname(DateofJoin) from Salesman;
(e) Display the name of the weekday for the date of join of salesman
Ans: Select dayname(DateofJoin) from Salesman;
40. A company in Mega Enterprises has 4 wings of buildings as shown in the diagram:
Center to center distances between various Buildings:
W3 to W1 - 50m
W1 to W2 - 60m
W2 to W4 - 25m
W4 to W3 - 170m
W3 to W2 - 125m
W1 to w4 - 90m
Number of computers in each of the wing:
W1 - 150
W2 - 15
W3 - 15
W4 - 25
Computers in each wing are networked but wings are not networked. The company has now decided to connect the wings also.
(a) Suggest a most suitable cable layout for the above connections.
Ans:
(b) Suggest the most appropriate topology of the connection between the wings.
Ans: Star Topology
(c) The company wants internet accessibility in all the wings. Suggest a suitable technology.
Ans: Broadband
(d) Suggest the placement of the following devices with justification if the company wants minimized network traffic.
(i) Repeater (ii) Hub / switch
Ans: (i) Not required. Repeaters may be skipped as per above layout (because distance is less than 100 m)
(ii) In every wing
(e) The company is planning to link its head office situated in New Delhi with the offices in hilly areas. Suggest a way to connect it economically.
Ans: Radio Waves
Download Now - Class 12 IP 065 Sample Question Paper 2020-21 with Solution
