CBSE Sample Papers for Class 12 Informatics Practices Set 10 with Solutions

Practicing the CBSE Sample Papers for Class 12 Informatics Practices Set 10 allows you to get rid of exam fear and be confident to appear for the exam.

CBSE Sample Papers for Class 12 Informatics Practices Set 10 with Solutions

Time: 3 hrs
Max. Marks: 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.

Section – A

Question 1.
As soon we get any good news from any source in social media: [1]
(a) We should forward to many people so that they can be benefited.
(b) We should never forward to anyone.
(c) We should confirm the news from any reliable source before forwarding.
(d) We should forward to our family and friends only.
Answer:
(c) We should confirm the news from any reliable source before forwarding.

Question 2.
Which of the following can be called as cyber-crime? [1]
(a) Stealing someone’s computer
(b) Harassing someone over Internet
(c) Downloading copyright free movies over Internet
(d) Sending emails to known people
Answer:
(b) Harassing someone over Internet

Question 3.
seriesl = pd.Series ({‘India’ : ‘New Delhi’, ‘UK’ : ‘London’, ‘Japan’ : ‘Tokyo’})
print(seriesl) [1]
Above code is an example of
(a) creating series from dictionary
(b) creating series from scalar values
(c) creating series from an array
(d) creating series from tuple
Answer:
(a) creating series from dictionary

Question 4.
Abhishek uses computer and mobile for his personal use. He uploaded one video on his youtube channel, where he used one background music downloaded from somewhere on Internet, he may be violating [1]
(a) copyright
(b) intellectual property right
(c) plagiarism
(d) None of these
Answer:
(a) copyright

Question 5.
Identify single-row functions of MySQL amongst the following [1]
(a) TRIM( )
(b) MAX( )
(c) ROUND ( )
(d) Both (a) and (c)
Answer:
(d) Both (a) and (c)

Question 6.
Which of the following function is used to create DataFrame? [1]
(a) DataFrame( )
(b) NewFrame( )
(c) CreateDataFrame( )
(d) None of these
Answer:
(a) DataFrame( )

Question 7.
In India, e-Waste management assumes greater significance because [1]
(a) generation of own e-Waste
(b) dumping of e-Waste from developed countries
(c) lack of awareness
(d) All of the above
Answer:
(d) All of the above

8. Method or function to add a new row in a DataFrame is [1]
(a) .loc( )
(b) .iloc( )
(c) join( )
(d) add( )
Answer:
(a) .loc( )

Question 9.
Which of the following refers to a small, single site network? [1]
(a) DSL
(b) RAM
(c) WAN
(d) PAN
Answer:
(d) PAN

Question 10.
Write the output of the following SQL command. [1]
SELECT ROUND(47.89);
(a) 47.88
(b) 47.8
(c) 48.0
(d) 50
Answer:
(c) 48.0

Question 11.
Identify the name of the network topology in which there are bi-directional links between each possible node. [1]
(a) Ring
(b) Mesh
(c) Tree
(d) None of these
Answer:
(b) Mesh

Question 12.
Which function returns the length of the string in bytes? [1]
(a) LENGTH ( )
(b) DATE ( )
(c) TIME ( )
(d) MATH ( )
Answer:
(a) LENGTH ( )

Question 13.
A software which is available for free and the code is open for all, it is called as_____ [1]
(a) Proprietary software
(b) Free and open source software
(c) Free software
(d) None of these
Answer:
(b) Free and open source software

Question 14.
Consider a table DOCTOR(ID, DocName,Department, DOJ,Gender, Salary) . Which of the following query will display the names and salaries of doctors in descending order of salaries. [1]

(a) SELECT DocName, Salary FROM DOCTOR ORDER BY Salary DESC;
(b) SELECT DocName, Salary FROM DOCTOR WHERE ORDER BY Salary ASC;
(c) SELECT DocName, Salary FROM DOCTOR ORDER BY Salary ASC;
(d) SELECT DocName, Salary FROM DOCTOR WHERE ORDER BY Salary DESC;
Answer:
(a) SELECT DocName, Salary FROM DOCTOR ORDER BY Salary DESC;

Question 15.
Which SQL clause is used to restrict the rows returned by a query? [1]
(a) SELECT
(b) ORDER BY
(c) WHERE
(d) GROUP BY
Answer:
(c) WHERE

Question 16.
Which of the following is not a Mathematical function? [1]
(a) LENGTH( )
(b) POWER( )
(c) MOD( )
(d) ROUND( )
Answer:
(a) LENGTH( )

Question 17.
Assertion (A) In this era of digital society, our daily activities like communication, social networking, banking, shopping, entertainment, education, transportation, etc., are increasingly being driven by online transactions. [1]
Reason (R) Managing our tasks digitally saves lot of time.
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true but R is not the correct explanation of A.
(c) Both A and R are false.
(d) A is false but R is true.
Answer:
(a) As our society is inclined towards using more and more digital technologies, we end up managing most of our tasks digitally as it saves our time.

Question 18.
Assertion (A) A Series is a one-dimensional array containing a sequence of values of any
data type (int, float, list, string, etc). [l]
Reason (R) Pandas Series can be imagined as a column in a spreadsheet.
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true but R is not the correct explanation of A.
(c) A is true but R is false.
(d) A is false but R is true.
Answer:
(a) A Series is a one-dimensionai array containing a sequence of values. Each value has a data label associated with it also called its index.Example of a Series containing names of students is given below:

Index	Value
0	Arnab
1	Samridhi
2	Ramit
3	Divyam
4	Kritika

Section – B

Question 19.
Write down any two points of differences between LAN, MAN and WAN. [2]
Answer:
Two major points of differences among LAN, MAN and WAN are as follows

Basics	LAN	MAN	WAN
Geographical Area	Generally within a building	Within a city	Across the continents
Distance	Upto 5 km	Upto 160 km	Unlimited

Or
Define home page. Give two advantages of home page.
Answer:
A home page is the first page of a website. Two advantages of home page are as follows
(i) It helps viewers to find out what they can find on that site.
(ii) Publicity of an individual or a community.

Question 20.
Aditi is a travel agent, she has stored the data of all passengers in a table TravelfPno, Pname,Tdate,Km, Coach). [2]
She has given the following command to count the number of passengers in each coach from Travel table.
SELECT PName, COUNT(Coach) FROM Travel ORDER BY Coach;
But she is not getting the desired result.
Help her for identifying the reason of the error and write the correct query by suggesting the possible correction (s).
Answer:
SELECT Coach, COUNT(Coach) FROM Travel GROUP BY Coach;

Question 21.
State differences between date functions NOW() and DAY() of MySQL. [2]
Answer:

NOW( )	DAY( )
This function returns the current date and time in the format ‘YYY-MM-DD HH:MM:SS’ or Y MYMMDDHHMMSS format.	This function returns the day of the month (from 1 to 31) from a date specified as an argument.
Syntax SELECT NOW( );	Syntax SELECT DAY(‘2021-09-31’);

Question 22.
Write a code to create a series object using a dictionary that stores the marks of students in Excel School. [2]
Answer:
import pandas as pd
Marks={‘0ne’ : 420, ‘Two’ : 370, ‘Three’ : 475}
sr = pd. Series (Marks)
print (sr)

Question 23.
What is digital property rights? Write the names of some digital property rights. [2]
Answer:
Digital property includes data, internet accounts and other rights in the digital world, including contractual rights and intellectual property rights. Data are the files and information stored and used by computers. Digital property right dispute arise, when some form of counterfeiting or piracy occurs between companies.
Or
What are the disadvantages of VoIP?
Answer:
The disadvantages of VoIP are as follows

• Without power, VoIP phones are useless, so in case of emergencies during power cuts it cannot be used.
• It uses Internet protocol’s packets so if packets get dropped along the way then voice quality drops.
• Even with its high quality, it cannot match the voice quality of a normal telephone line.
• It may not work for emergency service numbers like Police or Fire services.

Question 24.
Write the output of the given code. [2]
import pandas as pd
S1=pd.SeriesC[5,6,7,8,10],index=[‘v’,‘w’,‘x’,‘y’,‘z’])
1=[2,6,1,4,6]
S2=pd.Series(1,index=[‘z’,‘y’,‘a’,‘w’,‘v’])
print(S1 – S2)
Answer:

a	NaN
v	-1.0
w	2.0
x	NaN
y	2.0
z	8.0

Question 25.
Write the Python statements for the following: [2]
(i) To return both the first row and the second row in a Pandas DataFrame df?
(ii) To select first four rows and second to fourth columns from a DataFrame ‘Data’.
Answer:
(i) df. loc[[0,1]]
(ii) print( Data. iloc[0 : 4, 1 : 4])

Section – C

Question 26.
Consider the table BOOK given below. [3]
Table: BOOK

Code	Title	Author	Publication	Price
D001	Prrysics	Vikas Sharma	xxx	250
D002	Chemistry	Preeti Goyal	yyy	300
D003	Computer Science	Swati Rana	zzz	275
D004	English	Sanjeev Jain	aaa	150
D005	Mathematics	Rajiv Rastogi	bbb	400

Give the output of the following SQL commands.
(i) SELECT SUBSTR(Title,2,3) FROM BOOK WHERE Code=’D002′;
(ii) SELECT CONCAT(Author, Publication) FROM BOOK WHERE Price=250;
(iii) SELECT MAX (Price) FROM.BOOK;
Answer:

Question 27.
Mr. Ankit is working in an organisation as data analyst. He uses Python Pandas and Matplotlib for the same. He got a dataset of the passengers for the year 2010 to 2012 for January, March and December. [3]

	Year	Month	Passengers
0	2010	Jan	25
1	2010	Mar	50
2	2012	Jan	35
3	2010	Dec	55
4	2012	Dec	65

Help him to write the Python code to create the above DataFrame.
Answer:
import pandas as pd
data=|”Year”:[2010,2010,2012,2010,2012].”Month”:[“Jan”,”Mar”,“Jan”,“Dec”,“Dec”],
“Passengers”:[25,50,35,55,65])
df=pd.Data Frame(data)
print(df)

Question 28.
Sanyukta is the event incharge in a school. One of her students gave her a suggestion to use Python Pandas and Matplotlib for analysing and visualising the data, respectively. She has created a DataFrame “df ” to keep track of the number of First, Second and Third prizes won by different houses in various events. [3]

	House	First	Second	Third
0	Chenab	5	7	6
1	Gangas	10	5	4
2	Jamuna	8	13	15
3	Jhelum	12	9	12
4	Ravi	5	11	10
5	Satlui	10	5	3

Help her to write Python commands to do the following questions:
(i) Display the House names where the number of Second prize are in the range of 12 to 20.
(ii) Display all the records in the reverse order.
(iii) Display the bottom 3 records.
Answer:
(i) df [ ‘ House ’][ (df[‘Second ’ ]>=12) and (df[ ‘ Second ’ ]<=20) ]
(ii) print(df. i loc[:: -1])
(iii) df .tail (3)

Question 29.
The school offers Wi-Fi to the students of Class XII. For communication, the network security-staff of the school is having a registered URL “schoolwifi.edu”. On 17th September 2017, E-mails were received by all the students regarding expiry of their passwords. Instructions were also given renew their password within 24 hours by clicking on particular URL provided. [3]
On the bases of the above information, answer the questions:
(i) Identify the name of cyber crime which is done by given information.
(ii) Ideally, what characters should be used in a password to make it strong?
(iii) What are unsolicited E-mails called as?
Answer:
(i) Phishing is the fraudulent act of getting the confidential information of people like bank account ids, email ids, etc., by looking to be authentic phone calls , messages, SMS, etc. The given situation is also a case of phishing that is trying to acquire personal information by prompting to click on a link.

(ii) A combination of all types of characters, letters in mixed case, numbers and special characters would make it difficult for unauthentic users to guess the password.

(iii) Spam
Or
Explain the features of IT Act 2000.
Ans.
Some features of IT Act 2000 are as follows
(i) It helps to promote E-commerce.
(ii) It includes high penalty for cyber crime.
(iii) It provides filing online forms.
(iv) It enhances the corporate business.

Question 30.
Consider the following table Bookhouse. [3]
Table: Bookhouse

No	Title	Author	Subject	Publisher	Qty	Price
1	Data Structure	Lips Chute	DS	McGraw	4	217.00
2	DOS Guide	Nortron	OS	PHI	3	175.00
3	Turbo C++	Robort Lafore	Prog	Galgotia	5	270.00
4	Dbase Dummies	Palmer	DBMS	PustakM	7	130.00
5	Mastering Windows	Cowart	OS	BPB	1	225.00
6	Computer Studies	French	FND	Galgotia	2	75.00
7	COBOL	Stern	Prog	John W	4	1000.00
8	Guide Network	Freed	NET	Zpress	3	200.00
9	Basic for Beginners	Narton	Prog	BPB	3	40.00
10	Advanced Pascal	Schiidt	Prog	McGraw	4	350.00

Write the SQL statements for the following
(i) Display number of books and average Price for each type of Publisher.
(ii) Display Title, Price in descending order of Price.
(iii) Display total number of books available in stock published by BPB .
Answer:
(i) SELECT COUNT (*), AVG(Price) ,Publ isher FROM Bookhouse GROUP BY Publisher;
(ii) SELECT Title,Price FROM Bookhouse ORDER BY Price desc;
(iii) SELECT SUM(Qty) FROM Bookhouse WHERE Publisher=’BPB’;
Or
Differentiate between COUNT ( ) and COUNT (DfSTINCT) functions. Explain with the help of example.

COUNT( ) function	COUNT (DISTINCT) function
This function returns the total number of records of a specified column.	This function returns the number of distinct rows in a specified table.
COUNT( ) will count the number of records.	COUNT (DISTINCT) will count the number of records where column name is not null.
e.g. To count the total number of employees from table PAYMENTS. SELECT COUNT(*) FROM PAYMENTS;	e.g. To count distinct values of column Department from PAYMENTS table. SELECT COUNT (DISTINCT department) FROM PAYMENTS;

Section – D

Question 31.
Write the SQL functions which will perform the following operations. [5]
(i) To display the name of the day of the current date.
(ii) To remove spaces from the beginning of a string ” Python”.
(iii) To display the name of the month e.g. January or February from your date of birth(dob).
(iv) To display the starting position of word “Information” from “Information Technology”.
(v) To compute the power of two numbers a and b.
Answer:

• DAYNAME(DATE(curdate( )))
• LTRIM( “ Python ’ ’)
• MONTHNAME(date(dob))
• INSTRUInformation Technol ogy”, ‘ ‘ Information”)
• POW(a.b)

Or
Explain the following SQL functions using suitable examples.

• UCASE( )
• TRIM( )
• MID( )
• DAYNAME( )
• LEFT( )

(i) UCASE( ) It converts the string into upper case,
e.g. SELECT UCASE(‘welcome world’);
Output
WELCOME WORLD

(ii) TRIM( ) It removes the leading and trailing spaces from the given string,
e.g. SELECT TRIM(‘ Welcome world ’);
Output
Welcome world

(iii) MID( ) It extracts the specified number of characters from given string,
e.g. SELECT MID(‘Welcome world’,4,4);
Output
come

(iv) DAYNAME( ) It returns the weekday name for a given date,
e.g. SELECT DAYNAMEC‘2022-07-22’);
Output
Friday

(v) LEFT( ) This function returns a specified number of characters from the left of string.
e.g. SELECT LEFT (“Word”, 2);
Output
Wo

Question 32.
Eduminds University of India is starting its first campus in a small town Parampur of central India with its centre admission office in Delhi. The university has three major buildings comprising of Admin Building, Acad emic Building and Research Building in the 5 km area campus. As a network expert, you need to suggest the network plan as per (i) to (v) to the authorities keeping in mind the distances and other given parameters. [5]

Research Building to Admin Building	90 m
Research Building to Academic Building	80 m
Academic Building to Admin Building	15 m
Delhi Admission office to Parampur Campus	1450 km

Expected number of computers to be installed at various locations in the university are as follows:

Research Building	20
Academic Building	150
Admin Building	35
Delhi Admission Office	5

(i) Suggest the authorities, the cable layout amongst various buildings inside the university campus for connecting the building.
(ii) Suggest the most suitable place (i.e. building) to house the server of this organisation, with a suitable reason.
(iii) Suggest an efficient device to be installed in each of the buildings to connect all computers.
(iv) University is planning to provide online facility to students for clearing their doubts.Which of the following is the online textual or multimedia conversation will they use?
(a) VoIP
(b) Chatting
(c) HTML
(d) None of the above
(v) Which software will students use to connect to Internet, create websites and view sites on web?
Answer:
(i) The suggested cable layout is as follows :

(ii) The most suitable place (i.e. building) to house the server of this university is Academic Building, because there are maximum number of computers and according to 80-20 rule 80% of traffic in a network should be local.
(iii) The efficient device to be installed in each of the Building to connect all the computers is Switch.
(iv) (b) Chatting, i.e. a virtual means of communication that involves the sending and receiving of messages, share audio and video between users located in any part of the world.
(v) Web Browsers

Question 33.
Write the Python code to create a plot as given below: [5]

Answer:
import matplotlib.pyplot as plt
City=[‘Delhi’,‘Beijing’,‘Washington’,‘Tokyo’,‘Moscow’]
Gender=[‘Male’,‘Female’]
Happiness_Index_Ma1e=[60,40,70,65,85]
Happiness_Index_Female=[30,60,70,55,75]
plt.bar([0.25,1.25,2.25,3.25,4.25],Happiness_Index_Male,color=‘blue’, label=” Maie”,width=.5)
plt.bar([.75,1.75,2.75,3.75,4.75],Happiness_Index_Female,color=‘Green’, width=.5,1abel=“Female”)
pos=range(len(City))
print(pos)
plt.xticks(pos,City,fontsize=10)
plt.xlabel(‘City’, fontsize=16)
plt.ylabel(‘Happiness_Index’, fontsize=16)
plt. title( “Happiness Index across cities by gender”,fontsize=18)
plt.legend( )
plt.show( )
Or
Draw the approximate graph which display the multiline in same plot.
import matpiotlib.pypiot as plt
xl = [10,20,40]
yl = [20,50,10]
plt.plot(xl, yl, label = “line 1”)
x2 = [10,20,30]
y2 = [40,10,20]
plt.plot(x2, y2, label = “line 2”)
plt.xlabel(‘x – axis’)
plt.ylabel(‘y – axis’)
plt.title(‘Multiline’ )
plt.legend( )
plt.show( )
Answer:

Section – E

Consider the table Sports given below. Write commands in SQL for the following: [1 + 1 + 2]
Table: Sports

StudentNo	Class	Name	Game1	Grade1	Game2	Grade2
10	7	Sammer	Cricket	B	Swimming	A
11	8	Sujit	Tennis	A	Skating	C
12	7	Kamal	Swimming	B	Football	B
13	7	Venna	Tennis	C	Tennis	A
14	9	Archana	Basketball	A	Cricket	A
15	10	Arpit	Cricket	A	Athletics	C

(i) Display the names of the students who have grade A in either Gamel or Game2 or both.
(ii) Display the number of students having game ‘Cricket’.
(iii) Display the names of students who have same game for both Gamel and Game2.
Or (Option for part (iii) only)
Display the highest class of the students who has opted for swimming as Gamel or Game2.
Answer:
(i) SELECT Name FROM Sports WHERE Gradel=‘A’ OR Grade2=‘A’;
(ii) SELECT COUNT)*) FROM Sports WHERE Gamel=‘Cricket’ OR Game2=‘Cricket’ ;
(iii) SELECT Name FROM Sports WHERE Gamel=Game2;
Or
SELECT MAX(CLASS) FROM Sports WHERE GAME1=”SWI MM ING” OR GAME2=“SWIMMING”;

Question 35.
Naman has created the following DataFrame ‘‘Climate” to record the data about climatic conditions of four years: [1 + 1 + 2]

Year	MaxTemp	MinTemp	Rainfall
2017	32	20	123
2018	33	22	140
2019	35	21	135
2020	34	23	160

(a) What will be the output of the following?
(i) Climate. iloc[1:3,1:2]
(ii) print (Climate.head(2) )

(b) Write the Python code to display the temperature difference between MaxTemp and MinTemp for all the rows in the DataFrame Climate.
Or (Option for part (b) only)
The exact number of values in each column of the DataFrame?
(a) (i)

MaxTemp	Rainfall
32	123
33	140
35	135
34	160

(ii)

Year	MaxTemp	MinTemp	Rainfall
2017	32	20	123
2018	33	22	140

(b) print(Cl imate[“MaxTemp”] – Climate[“MinTemp”])
Or
print(Climate.counte( ))
print(Climate.count(0))
print(Climate.count(axis=’index’))