VANI VIDYALAYA

GRADE:12 INFORMATICS PRACTICES

MARKS:70

SECTION-A
18X1=18

1. What does a modem do at the sender’s end?

A) It converts analog signals into digital data. B) It converts digital data into
analog signals.
C) It converts digital data into optical signals. D) It converts optical signals into
digital data.
2. Which out of the following cannot be included in digital footprint?
A) Submitting the form online B) Searching for your friend’s address
online
C) Searching your document D) online shopping
3. Which of the following are Net Etiquette?
A) Be Ethical B) Be Respectful C) Be Responsible D) All of the
above
4. Emma is a student working on her research project. She finds a well-written
paragraph on the Internet that perfectly explains the concept that she wants to
include in her project. She copies and pastes the paragraph as it is into her research
paper. Her research paper did not get selected due to plagiarism.
What is the one way out of the following that Emma could have followed to avoid
plagiarism in this case?
A) Copying the content from a book in her college library.
B) Rewriting the paragraph in her own words and citing the original source.
C) Asking her friends for information and using it in her research paper, without
mentioning her friend’s input.
D) Posting the paper on her college website.
5. Which one of the following is not an aggregate function?
A) ROUND () B) SUM() C) COUNT() D) AVG()
6. Which of the following is not feasible method of e-waste management?
A) Reuse B) Throwing in Sea C) Recycle
D) Reduce
7. In SQL, what will be output of the following query?
SELECT INSTR (‘Wednesday’, 'e');
A) 1 B) 5 C) 2 D) 4
8. For how long does a patent typically protect an invention?
A) 5 years B) 10 years C) 20 years D) 50 years
9.Which operator performs pattern matching?
A) BETWEEN operator B) LIKE operator C) EXISTS operator D)
None of these

10. _________ allows a visited website to store its own information about a user on the
user’s computer.

A) Spam B) cookies C) Malware D) Adware

11. If column “Salary” contains the data set {10000, 15000, 25000, 10000,
15000}, what will be the output after the execution of the given query?

SELECT SUM (DISTINCT SALARY) FROM EMPLOYEE;

A) 75000 B) 25000 C) 50000 D) 10000

12.Which of the following command is used to display first three rows of a DataFrame
'DF' ?

A) DF.head() B) DF.header() C) DF.head(3) D) DF.Head(3)

13. Which of the following is not a feature of Open Source Software ?

A) It can be shared with others without any licensing burden.

B) It is same as free software.

C) It can be downloaded on multiple devices.

D) Its source code is available for free distribution.

14.Which network topology typically results in less wire length usage as compared to
others?

A) Star topology B) Mesh topology C) Bus topology D) Hybrid

topology

15. __________ is a cyber-attack method that involves sending fraudulent emails or

messages to trick individuals into revealing sensitive information, such as login
credentials or financial data?

A) Malware Infection B) DDoS Attack C) Phishing D) SQL

Injection
16. Predict the output of the following query:

SELECT ROUND(15.789, 2);

A)15.79 B) 15.789 C) 16 D) 15.8

Q17 and Q18 are ASSERTION and REASONING based questions. Mark the correct choice
as

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.

17.Assertion: The internet is a collection of interconnected computer networks,
linked by transmission medium such as fiber optic cables, transmission
wires, wireless connection etc.
Reason: World Wide Web is a collection of websites or web pages stored in web
servers and connected to local computers through the internet.
18) Assertion (A): Cookies are small text files, stored locally by the client’s web browser
to remember the “name-value pair” that identifies the client.
Reason (R): Cookies are primarily used to track users' physical locations.

SECTION-B
7X2=14

19. Give two differences between Hub and Switch.

20.Nikita is using a table EMPLOYEE. It has the following columns: Admno, Name, Agg,
Stream [column Agg contains Aggregate marks]. She wants to display highest Agg
obtained in each stream. She wrote the following statement:
SELECT Stream, MAX(Agg) FROM EMPLOYEE;
But she did not get the desired result. Rewrite the above query with
necessary changes to help her get the desired output.
21.Considering the same string “Preoccupied”
Write SQL commands to display:
a) the position of the substring ‘cup’ in the string “Preoccupied”.
b) the first 4 letters of the string “INFORMATICS”.
22. What will be the output of the following
import pandas as pd
x= [20, 40,90, 110]
y=pd.Series([20, 40,90, 110])
print (x*2)
print(y*2)
23. Explain Static and Dynamic Webpage.
24. Find the output of the following Python code:
import pandas as pd
 vaccine_qty=pd. Series ([10,16,1], index=["Typhoid","Tetanus","Hepatitis"])
cost=pd. Series ([200,500,800], index=["Typhoid","Tetanus","Flu"])
print (vaccine_qty + cost)
25. What is the difference between copyright and Patent?
SECTION-C 5X3=15
26. Mr. Ram is working on MySQL table named ‘employee’ having following structure:
Empno Name Dept Salary
1 Ravi Sales 10000
2 Sunny Sales 15000
3 Vikram IT 5000
4 Nitin IT 20000
He needs to perform following task on the table. Write SQL queries for the following:
i) To display the maximum salary given to employee.
ii) To display last three character of column name.
iii) To display 4th characters from 4th place of column dept.
27. Write python statements to create a data frame for the following
data:
Name Age Designation
RAJIV 20 CLERK
SAMEER 35 MANAGER
KAPIL 45 ACCOUNTANT

28. Write MySQL statements for the following:

i) create a database “BOOKS”.
(1)
ii) create table Bookdetail using given description
(2)

Field Name Data type Constraint

Bno integer (4) Primary key
Bname varchar (20)
Author varchar (30
Price float (4,2)
29.Complete the given Python code to get the required output as "California":
import _____________ as pd
data = { 'Yosemite': 'California', 'Yellowstone': 'Wyoming', 'Glacier': 'Montana',
'Rocky Mountain': 'Colorado' }
national_parks = pd.Series(_____________)
print(national_parks_____________)
30. ABC Electronics, a popular electronics retail chain, has been a prominent player in
the market for years. However, recent concerns over environmental degradation and
e-waste have prompted the company to rethink its strategies and practices. As the
 newly appointed sustainability manager, you've been asked to answer the following
questions:

i) Considering the environmental concerns associated with e. waste. outline any one
negative impact of the electronic products on the environment.

ii) Gopal is a college student who recently bought his new smartphone from ABC
electronics. He's excited about the new features and improved performance of his new
device. However, he's now left with his old smartphone, which is still functional but
considered outdated. Suggest him any one action that he can take feeble old
smartphone.

iii) Provide any one recommendation on how ABC Electronics can responsibly manage
its e-waste while minimizing harm to the environment.

SECTION-D
2X4=8

31. Consider the given table Result and write SQL queries for (a) to (d)

Rollno Name Class City Marks

1 Nanda X Delhi 56
2 Saurabh XI Chennai 45
3 Sanal XII Delhi 66
4 Rekha X Mumbai 81
5 Neha XII Chennai 77

A) Display the minimum and maximum marks obtained by female students.

B) Display different Cities (without repetition) available in table.
C)Display the average mark obtained by students of each city.
D)Display the class wise total of marks obtained by students.
32. Rupam created a MySQL table to store the details of Nobel prize winners.
Help her to write the following MySQL queries
Table: Noble
Winner_ld YEAR SUBJECT WINNER COUNTRY CATEGORY
1001 1970 Physics Hannes Alfven Sweden Scientist
1002 1970 Physiology Bernard Katz NULL Scientist
1003 1970 Literature Aleksandr Solzhenitsyn Russia Linguist
1004 1971 Chemistry Gerhard Herzberg Germany Scientist
1005 1978 Peace Menachem Begin Israel Prime
Minister
1006 1987 Economics Robert Solow USA Economist
1007 1994 Literature Kenzaburo Oe Japan Linguist
 i) Display the names of Nobel Prize winner in 'Literature' for the year 1970.
ii) Display the subject and category of winners whose country is not known.
iii)Display the details of all Nobel Prize winners who were scientists.
iv)count total number of winners whose subject is Literature.
SECTION-E
3X5=15
33.Consider the tables Faculty and Batch given below :
Table : Faculty
F_Id FacName DoJ Qualification Salary
Emp01 Neeta 01-07-2013 MCA 85000
Khanna
Emp02 Sonia Chawla 05-05-2023 MA 35000
Emp03 Sheetal 28-06-2015 MSc 90000
Emp04 Bindu 30-03-2016 M.Com 80000
Emp05 Sunidhi 28-06-2002 BA 100000
Emp06 Ashish 01-07-1999 B.Com 120000
Table : Batch
Batchid BatchName F_Id Daysperw Subjects
eek
B01 TXAlpha Emp01 3 English
B02 TXBeta Emp05 5 Chemistry
B03 TXGama Emp02 4 Physics
B04 Super30 Emp03 3 Mathematics
B05 G-20 Emp04 2 Economics
B06 LXAlpha Emp01 4 Accountancy

Write SQL queries for the following :

i) Display name and salary of all faculties in alphabetical order of their names.

ii) Display details of faculties who joined on Monday.

iii) Display names of faculties, their salary and BatchName from both the tables.

iv) Display the details of all faculties whose salary is more than 60000 and have joined
before the year2007.

v) Display the name of faculty who is taking TXAlpha Batch.

34. Classpoint Pvt. Ltd., Pune is a company that deals with development and training of
software. They have different divisions HR (H1), Training (H2), Sales (H3) and
Marketing (H4). The layout of the Pune branch is :
 The management wants to connect all the divisions as well as all the computers of
each division (H1, H2, H3 and H4).

Distance between the divisions are as follows :

DIVISIONS Distance
(meters)
H1 to H2 90
H1 to H3 145
H1 to H4 88
H2 to H3 110
H2 to H4 80
H3 to H4 160

Number of computers in each division:

Division Number of
Computers
H1 100
H2 220
H3 160
H4 140
Based on the above specifications, answer the following questions:

i) Suggest the topology and draw the most suitable cable layout for connecting all the
divisions.

ii) Classpoint Pvt. Ltd. plans to establish a new office in Dubai. Out of LAN, MAN and
WAN, what kind of network will be created to connect Pune office with Dubai office?

iii) Suggest the division for the placement of server in Pune office. Explain the reason for
your selection.

iv) Suggest the placement of switch/hub with justification.

v) Ms. Abhilasha, working in Dubai office, is creating a software for conducting program
for the employees of Pune branch. Which protocol would help her in voice transmission
over a computer network?

35. Consider the following data :

 Year Student Strength
2019 150
2020 180
2021 240
2022 120
2023 180

Write a Python code to draw the following line chart having title and labels for x and y
axis as shown below :

Also give suitable Python statement to save this chart with name,stud.png.