MARKING SCHEME
CLASS XII
INFORMATICS PRACTICES (065)
TIME: 3 HOURS M.M.70
1. iii. Gateway 1
1 mark for correct answer
2. ii. Computer Virus 1
1 mark for correct answer
3. ii. Digital property 1
1 mark for correct answer
4. iii. SELECT * FROM PRODUCT ORDER BY PRICE DESC; 1
1 mark for correct answer
5. i. 4 1
1 mark for correct answer
6. ii. Free 1
1 mark for correct answer
7. ii. 15.8 1
1 mark for correct answer
8. i. ROUND( ) 1
1 mark for correct answer
9. ii. MIN ( ) 1
1 mark for correct answer
10. i. print(Marks.tail(2)) 1
1 mark for correct answer
11. iv. statistical 1
1 mark for correct answer
12. ii. Heterogenous 1
1 mark for correct answer
13. ii. Cookies 1
1 mark for correct answer
14. ii. DAYNAME 1
1 mark for correct answer
15. iv. Plagiarism 1
1 mark for correct answer
16. iii. A song you wrote 1
1 mark for correct answer
17. ii. Both A and R are true and R is not the correct explanation for A. 1
18. iii. A is True but R is False 1
19. Static web page: In static web pages, Pages will remain same until 2
someone changes it manually and information changes rarely.
Dynamic web page: In dynamic web pages, Content of pages are
different for different visitors and information change frequently.
2 Mark for writing correct difference.
OR
Repeater: A repeater is an electronic device that receives a signal and
retransmits it. It regenerates the signal and forwards the refreshed
signal. A repeater operates at the physical layer.
Firewall: A Firewall is a network security device that monitors and
filters incoming and outgoing network traffic based on an organization's
previously established security policies.
1 Mark each for writing correct function of respective networking
device.
20. This is because the column Fee contains a NULL value and the NULL 2
values are not taken into account in aggregate functions.
So, Command1 returns the total number of records in the table which
was 5 in this case whereas Command2 returns the total number of not
null values in the column name.
1 Mark for writing correct reason different output.
1 Mark for writing correct justification.
21. GROUP BY clause is used in a SELECT statement in combination with 2
aggregate functions to group the result based on distinct values in a
column.
For example:
To display total number of CLASS XI AND XII students from the table
STUDENT, we need to first group records based on the class then we
should count records with the help of count() function.
Considering the following table STUDENT:
RollN o Name Class Gender City Marks
1 Abhinav XI M Ajmer 40
2 Prachi XII F Mumbai 44
3 Neha XI F Chennai 43
4 Nancy XII F Mumbai 30
5 Hemant XII M Delhi 33
6 Ajay XI M Hyderabad 53
SQL query for the above-mentioned task is as follows:
select class,count(class) from student group by class;
Output:
Class Count(Class)
XI 3
XII 3
1 mark for correct purpose
1 mark for correct example
22. stu_marks= pd.Series([67,72,85,83], index=["Maths" , "English", 2
"Hindi", "IP"])
>>> print(stu_marks)
OUTPUT:
Maths 67
English 72
Hindi 85
IP 83
1 mark for each correct python statement
23. i. Give Your Electronic Waste to a Certified E-Waste Recycler 2
ii. Donating Your Outdated Technology
iii. Give Back to Your Electronic Companies and Drop Off Point
1 mark for each solution.(Write any two).
Or
The continuous use of devices like smartphones, computer desktop,
laptops, head phones etc. can cause a lot of health hazards if not
addressed. These are:
i. Impact on hearing: Using headphones or earphones for a
prolonged time and on high volume can cause hearing problems
and in severe cases hearing impairments.
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.
1 mark for each hazard (Write any two).
24. 2
0 True
1 True
2 False
3 True
½ mark for each correct output
25. 2
i. The index labels of df will include 0,1
ii. The column names of df will be: a,b,c
1 mark for each correct answer
26. i. 4 3
ii. ‘DHN’
iii. 0
1 mark for each correct output
27. 3
import pandas as pd
employee=
pd.DataFrame({‘Name’:[‘Rahul’,’Sakshi’,’Saksham’,‘Arun ’],’Salary’:
[50000,46000, 38000, 25700]},
index=[101,102,103,104]);
print(employee)
OR
import pandas as pd
Dic= {‘Name’:[‘Rahul’,’Sakshi’,’Saksham’,‘Arun ’],’Salary’:
[50000,46000, 38000, 25700]}
employee = pd.DataFrame(Dic,index=[101,102,103,104]);
print(employee)
1 mark for each correct python statement
28. i. df.Kolkata['population']=500000 3
ii. df.rename(index={"population":"pop"},inplace=True)
iii. print(df.Delhi['hospitals'])
1 mark for each correct statement
29. i. Anisha has become a victim of phishing. 3
ii. She must immediately bring it into the notice of cyber cell and must
report this cybercrime to local police.
iii.Yes.
The Information Technology Act, 2000 (also known as ITA-2000, or the
IT Act) is the primary law in India dealing with cybercrime and
electronic commerce
1 mark for each correct answer
OR
Net Etiquettes refers to the proper manners and behavior we need to
exhibit while being online. These includes:
1. 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.
2. Avoid cyber bullying: Avoid any insulting, degrading or intimidating
online behavior like repeated posting of rumors giving threats online,
posting the victim’s personal information, or comments aimed to
publicly ridicule a victim.
1 mark for correct definition.
1 mark for each correct etiquette.
30. a. Select * from Faculty where First_name like ‘%t’; 3
b. Select * from Faculty order by Hire_date desc;
c. Select max(Salary), min(Salary) from Faculty;
1 mark for each correct answer
OR
Order By clause: The ORDER BY command is used to sort the result
set in ascending or descending order.
The following SQL statement displays all the customer’s names in
alphabetical order:
SELECT Cname FROM Customers ORDER BY Cname;
1 mark for correct significance
1 mark for correct example
31. i. select mid('INDIA RISING',3,5); 5
ii. select INSTR(‘PYTHON FUNDAMENTALS’,'FUNDA');
iii. select round(453.668.78,2);
iv. select mod(120,7);
v. select trim(student_id) from student;
1 mark for each correct query
OR
1. LCASE(): It converts the string into lower case.
Example:
SELECT LCASE(‘WELCOME’);
Output:
‘welcome’
2. TRIM(): It removes the leading and trailing spaces from the given
string.
Example:
SELECT TRIM(‘ Welcome ‘ );
Output:
‘Welcome’
3. SUBSTR(): It extracts the specified number of characters from given
string.
Example:
SELECT SUBSTR(‘ Welcome world,4,3);
Output:
‘Com’
4. MONTHNAME(): It returns the month name for a given date
Example:
SELECT MONTHNAME(‘2022-07-22’);
Output:
JULY
5. TRUNCATE():The TRUNCATE() function truncates a number to
the specified number of decimal places.
Example:
SELECT TRUNCATE(23.454,2);
Output:
½ mark for each correct explanation
½ mark for each correct example
32. 5
i. Cable Layout:
ii. Bus Topology
iii. Server should be installed in Training Compound as it has
maximum number of computers.
iv. Hub/Switch
v. Optical Fibre
33. import matplotlib.pyplot as plt 5
Language=['C++','Python','Java']
Number_of_students = [20,15,18]
plt.bar(Language,Number_of_students)
plt.ylabel('Number of Students')
plt.xlabel('Language')
plt.title('Number of Students studying particular Language')
plt.show()
½ mark for each correct statement
Python statement to save the chart:
plt.savefig("ab.jpg")
1 mark for the correct statement
import matplotlib.pyplot as plt
House = ['Shivaji', 'Tagore', 'Raman', 'Ashoka']
Medal_count = [50,60,40,55]
plt.plot(House,Medal_count)
plt.show()
1 mark for each correct statement
34. a. SELECT UPPER(COMPANY) FROM VEHICLE; 1+1+2
b. SELECT MIN(PRICE) FROM VEHICLE;
1 mark for each correct query
c. select Company, count(Type) from Vehicle group by Company;
OR
select Type, sum(Price) from Vehicle group by Type;
2 mark for each correct query
35. A. Output 1+1+2
i. (4,3)
ii Sports.loc[‘SD5’]=[5, ‘RAM’, ‘M’]
1 mark for each correct answer
B. del Sports[‘GENDER’]
OR
Sports.drop(index= ‘SD3’))
2 mark for correct python statement
