SET-5
INFORMATICSPRACTICES (065)
Class XII
Max Marks: 70 Time: 3 hrs.
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have18 questions carrying01 mark each.
4. Section B has 07 Very Short Answer type questions carrying02 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 04marks each. One internal choice is
given in Q35 against part C only.
8. All programming questions are to be answered using Python Language only.
PARTA
1. The device used to connect two networks using different protocols is: 1
i. Router
ii. Repeater
iii. Gateway
iv. Hub
2. A _______________is some lines of malicious code that can copy itself and can 1
have detrimental effect on the computers, by destroying data or corrupting the
system.
i. Cybercrime
ii. Computervirus
iii. Program
iv. Software
3. Any work / information that exist in digital form idea on internet or on an 1
electronic device, is known as ___________property.
i. License property
ii. Digital property
iii. Source code property
iv. Software property
4. Which SQL statement is used to display all the data from product table in the 1
decreasing order of price?
i. SELECT * FROM PRODUCT;
ii. SELECT * FROM PRODUCT ORDER BY PRICE;
iii. SELECT * FROM PRODUCT ORDER BY PRICE DESC;
iv. SELECT * FROM PRODUCT ORDER BY DESC;
5. If column “City” contains the data set (DELHI, HYDERABAD, KOLKATA, 1
CHENNAI, KOLKATA), what will be the output after the execution of the
given query?
SELECT COUNT(DISTINCT City) FROM Customer;
i. 4
ii. 5
iii. 3
iv. 2
6. ‘F’ in FOSS stands for: 1
i. IForce
ii. Free
iii. Fibre
iv. First
7. Write the output of the following SQL command: select truncate(15.88,1); 1
i. 15.88
ii. 15.8
iii. 15.9
iv. 16
8. Which one of the following is not an aggregate function? 1
i. MAX()
ii. SUMUP()
iii. COUNT()
iv. MIN()
9. Which one of the following functions is used to find the smallest value from 1
the given data in MySQL?
i. MINIMUM()
ii. MIN()
iii. SMALL()
iv. TINY()
10. Given a Pandas series called Marks, the command which will display the last 2 1
rows is :
i. print([Link](2))
ii. print([Link](2))
iii. print([Link](3)
iv. print([Link]())
11. Which of the following is not a valid char type? 1
i. Lineplot
ii. bargraph
iii. histogram
iv. statistical
12. A DataFrame object is a collection of _________ type of data. 1
i. Homogenous
ii. Heterogenous
iii. Hybrid
iv. None of the above
13. Website stores the browsing activity through: 1
i. web page
ii. Cookies
iii. passwords
iv. server
14. In SQL, which function returns the weekday name for a given date. 1
i. DAY
ii. DAYNAME
iii. NAME
iv. DNAME
15. Stealing someone’s intellectual work and representing it as your own work 1
without citing the source of informationis:
i. Copyright
ii. Licensing
iii. GPL
iv. Plagiarism
16. Which of the following would be a creative work protected by copyright? 1
i. A list of all Indian Prime minister names
ii. A Portrait of your friend
iii. A song you wrote
iv. The name of your pet dog.
Q17and18 are ASSERTION AND REASONING based questions. Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17. Assertion (A):-The Internet is a collection of interconnected computer networks 1
linked by transmission medium such as copper wires, fiber-optic cables,
wireless connections etc.
Reasoning (R): - World wide web is a collection of interconnected documents.
18. Assertion (A):-A series object can be created by calling the Series() method. 1
Reasoning (R): - A Series is a two-dimensional labelled data structure.
PARTB
19. Distinguish between Static webpage and Dynamic webpage. 2
OR
Explain the function of the following network devices:
a. Repeater
b. Firewall
20. Rohini writes the following commands with respect to a table Student having 2
fields, SNo, Name, Age, Fee.
Command1: Select count (*) from student;
Command2: Select count (Fee) from student;
she gets the output as 5 for the first command but gets an output 4 for the
second command.
Explain the reason for different output with justification.
21. What is the purpose of Group By clause in SQL? Explain with the help of 2
suitable example.
22. Write a program in Python Pandas to create a series named as “stu_marks” 2
which stores marks of 4 subjects of a student in class XII B of your school.
Assume that student is studying class XII and have 67,72,85,83 marks in Maths,
English, Hindi, IP respectively and PANDASlibrary has been imported aspd.
23. Give any two solutions to manage the E-Waste in locality/society. 2
OR
List any two health hazards related to excessive use of technology.
24. What will be the output of the followingcode? 2
>>>import pandas as pd
>>>A=[Link](data=[19,20,5,42])
>>>print(A>15)
25. Carefully observe the following code: 2
import pandas as pd
data = [{'a': 10, 'b': 20},{'a': 6, 'b': 32, 'c': 22}]
df1 = [Link](data)
print(df1)
Answer the following:
i. List the index of the DataFrame df1
ii. List the column names of DataFrame df1.
SECTIONC
26. Write outputs for SQL queries (i) to (iii) which are based on the given table 3
COURSE:
[Link] LENGTH(CNAME) FROM COURSE WHERE
FEES<10000;
ii. SELECT CNAME FROM COURSE WHERE
MONTH (STARTDATE
STARTDATE)=8;
iii. SELECT MOD (FEES FEES, DAY(STARTDATE)) FROM Course
WHERET ID=1044;
27. Write python code to create the DataFrame employee using dictionary: 3
NAME SALARY
101 RAHUL 50000
102 SAKSHI 46000
103 SAKSHAM 38000
104 ARUN 25700
28. Consider the following Data Framed f and answer questions 3
Delhi Mumbai Kolkata Chennai
hennai
hospitals 200 230 300 320
population 150000 230000 450000 340000
schools 280 300 315 278
Write suitable Python statements for the following:
i. Change the population in Kolkata as 500000
ii. Rename the column population as “pop”
iii. Display hospitals in Delhi
29. Anisha received an email from the bank stating that there is a problem with her 3
account. The email provides instructions and a link, by click
clicking
ing on which she
can login her account and fix the problem.
i. What is this happening to Anisha?
ii. What immediate action should she take to handle it?
Is there any law in India to handle such issues? Discuss briefly.
OR
What do you understand by NetEtiquettes? Explain any two such [Link].
30. Considerthegiven tableFaculty, write suitable SQL queries for the following: 3
Faculty_Id First_name Last_name Hire_date Salary
101 Sarika Mishra 12-10-1997 25000
102 Naveen Vyas 23-12-1994 18000
103 Rakesh Sharma 25-08-2003 32000
104 Rashmi Malhotra 18-09-2004 21000
105 Amit Srivastava 05-06-2007 28000
WriteSQLcommandsto:
a. To display details of those faculty members whose First_name ends
with‘t’.
b. Display all records in descending order of Hire_date.
c. Find the maximum and minimum salary.
OR
Discuss the significance of Order by clause in detail with the help of suitable
example.
SECTIOND
31. Write suitable SQL query for the following: 5
i. Display 5 characters extracted from 3th left character onwards from the
string ‘INDIA RISING’.
ii. Display the position of occurrence of string ‘FUNDA’ in the string
‘PYTHON FUNDAMENTALS.
iii. Round off the value 453.668 to two decimal place.
iv. Display the remainder of 120 divided by7.
v. Remove all the expected leading and trailing spaces from a column
student_id of the table ‘student’.
OR
Explain the following SQL functions using suitable examples.
i. LCASE()
ii. TRIM()
iii. SUBSTR()
iv. MONTHNAME()
v. TRUNCATE()
32. “StudyTogether” is an educational NGO. It is setting up its new campus at 5
Mumbai for its Web-Based activities. The campus has 4 compounds as shown
in the diagram below:
RESOURCE TRAINING
COMPOUND COMPOUND
FINANCE
MAIN COMPOUND
COMPOUND
Center to center distances between various Compounds as per architectural
Drawings (in Meter) is as follows:
Main Compound to Resource Compound 50m
Main Compound to Training Compound 40m
Main Compound to Finance Compound 90m
Resource Compound to Training Compound 25m
Resource Compound to Finance Compound 45m
Training Compound to Finance Compound 200m
Expected Number of Computers in each Compound is as follows:
MainCompound 5
ResourceCompound 15
TrainingCompound 150
AccountsCompound 20
1. Suggest a cable layout of connections between the compounds.
2. Suggest the most suitable topology of the connection between the
wings.
3. Suggest the most suitable place ([Link]) to house the server for
/ this NGO. Also, provide a suitable reason for your suggestion.
4. Which networking device will you suggest to be procured by the
company to interconnect all the computers of various Compounds of
MUMBAI campus?
5. The NGO is planning to connect its International office situated in
Delhi, which out of the following wired communication link, you will
suggest for very high speed connectivity?
a. Telephone Analog Line
b. Optical Fiber
c. Ethernet Cable
33. Write Python code to plot a bar chart for Number of students studying 5
particular language as shown below:
Alsogivesuitablepythonstatementtosavethischart.
OR
Write a python program to plot a line chart based on the given data to depict the
medal tally between four Houses in school.
House=['Shivaji', 'Tagore', 'Raman', 'Ashoka']
Medal_count=[50,60,40,55]
SECTION E
34. Sahil, a database administrator has designed a database for Vehicles in a Service 1+1+2
Centre. Help him by writing answers of the following questions based on the
given table:
Vehicle:
Write SQL command to:
a. Display the company name in upper case.
b. Display the lowest price of the Vehicle.
c. Count the type of vehicles manufactured by each company.
OR (Option for part iii only)
Display the sum of price of each type of vehicles.
35. Consider the following Data Frame sports: 1+1+2
ID NAME GENDER
SD1 1 ARUNA F
SD2 2 RAHUL M
SD3 3 SAKSHI F
SD4 4 RAMAN M
(A)
i. Predict the output of the following python statement: sports. shape
ii. Write command to Add a new row with values(5, SAM, M):
(B) Write python statement to delete column Gender.
OR (Option for part iii only)
Write python statement to delete the row with index SD3.