Class - XII
Informatics Practices (065)
Sample Question Paper (2020 - 21)
M.M. 70 Time: 3 hrs
1. This question paper contains two parts A and B. Each part is compulsory.
2. Both Part A and Part B have choices.
3. Part-A has 2 sections:
a. Section – I is short answer questions, to be answered in one word or one line.
b. Section – II has two case studies questions. Each case study has 4 case-based sub- parts. An examinee is to attempt any 4 out of the 5 subparts.
4. Part - B is Descriptive Paper.
5. Part- B has three sections
a. Section-I is short answer questions of 2 marks each in which two questions have internal options.
b. Section-II is long answer questions of 3 marks each in which two questions have internal options.
c. Section-III is very long answer questions of 5 marks each in which one question has question has internal option.
Part - A
Section - I
Attempt any 15 questions form questions 1 to 21
Q.1 State whether True or False:
(i) A copyright is automatically granted to authors or creators or creators of content.
(ii) In FOSS source code is usually hidden from the users.
Ans: (i) True
(ii) False
Q.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()
Ans: plt.title()
Q.3 Write the output of the following SQL command.
select round (49.88);
a. 49.88
b. 49.8
c. 49.0
d. 50
Ans: 50
Q.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))
Ans: print (Sequences. head (4))
Q.5 Given the following Series S1 and S2:
Ans: print (S1 + S2)
Q.6 Using Python Matplotlib ________ can used to count how many values fall into each interval.
(a) line plot
(b) bar graph
(c) histogram
Ans: histogram
Q.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
Q.8 In a DataFrame Axis = 1 represents the ___________ elements.
Ans: column
Q.9 Which of the following is not a network topology:
Star, Mesh, Tree, Bug, Bus
Ans: Bug
Q.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
Ans: Dynamic web page
Q.11 The avg() function in MYSQL is a example of __________.
a. Math function
b. Text function
c. Date function
d. Aggregate function
Ans: Aggregate function
Q.12The practice of taking someone else's work or ideas and passing them off as one's own is known as
Ans: Plagirism
Q.13 In Pandas the function used to check for null values in a DataFrame is ________
Ans: isnull()
Q.14 I can keep you signed in.
I can remember your site preferences.Q.18 The command can be used to makes changes in the rows of a table in SQL.
Ans: update
Q.19 Write the SQL command that will display the current time and date
Ans: select now();
Q.20 network device is known as an intelligent hub .
Ans: Switch
Q.21 Receiving irreleavnt and unwanted emails repeatedly is an example of
.
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)
a. print(df.columns())
b. print(df.column())
c. print(df.column)
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’]
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)select name from student where city=”Agra”
or city=”Mumbai”;
OR
select name from student where city IN(“Agra”, “Mumbai”);
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;
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)Select gender, avg(marks) from student group by gender
where class=”XI”;
Select gender, avg(marks) from student group by gender
having class = “XI”;
a. select name,min(DOB) from student ;
b.
select name,max(DOB) from student ;
c.
select name,min(DOB) from student group by
name ;
import pandas as pd m1=pd.Series([45,65,24,89],index=['term1','term2','t erm3','term4'])
Q. 25 State any two differences between single row functions and multiple row functions.
OR
What is the difference between the order by and group by clause when used alongwith the select statement. Explain with an example.(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
The order
by clause is used to show the contents of a table/relation in a sorted manner
with respect to the column mentioned after the order by clause. The contents of
the column can be arranged in ascending or descending order.
The group
by clause is used to group rows in a given column and then apply an aggregate
function eg max(), min() etc on the entire group.
i. round it off to a whole number
i. Write the command which will display the name of the furniture having rent>250.
ii. Write the command to name the series as Furniture.
ii. S_amt.name= 'Furniture'
Q.28 Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission.
Command1 : Select count(*) 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.
Write commands to display:
a. “occupied”
b.
“cup”
OR
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 stringa. select
substr("Preoccupied", 4); or
select substring("Preoccupied", 4); or
select mid("Preoccupied",4); or
select
right(("Preoccupied"”, 8);
b. select substr("Preoccupied" ,6,3); or
select substring("Preoccupied", 6,3); or
select mid(("Preoccupied" ,6,3);
OR
a. select instr 'Preoccupied' , ‘ 'cup'));
b.
select left 'Preoccupied',4);
Write commands to :
i.
Add a new column ‘Activity’ to the Dataframe
a. SMTP
b. POP
c. FTP
b. POP: Point to Point Protocol
c. FTP: File Transfer Protocol
d. VoIP: Voice over Internet Protocol
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
hearing: using headphones or earphones for a prolonged time and on high volume
can cause hearing problems and in severe cases hearing impairments.
iii. 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.
iv. 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.
Q.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
Q.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. will give the output as:
[20,40,90,110,20,40,90,110]
0 40
1 80
2 180
3 220
Justification:
In the first statement x represents a list so when a list is multiplied by a
number, it is replicated that many number of times.
The second
y represents a series. When a series is multiplied by a value, then each
element of the series is multiplied by that number.
Q.35 What do you mean by Identity theft? Explain with the help of an example.
OR
What do you understand by Net Ettiquetes? Explain any two such ettiquetes.
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
Net
Ettiquets refers to the proper manners and behaviour we need to exhibit while
being online.
These include :
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 behaviour like repeated posting of rumours, giving threats online, posting the victim’s personal information, or comments aimed to publicly ridicule a victim.
alternative
answer
import matplotlib.pyplot as plt
a = [1,2,3,4,5,6]
b = [2,3,4,5,6,7]
plt.plot
(a,b)
OR
import matplotlib.pyplot as plt
Classes = ['VII','VIII','IX','X']
Students = [40,45,35,44]
plt.bar(classes, students) plt.show()
Q.37 A relation Vehicles is given below:
Write SQLcommands to:
a. Display the
average price of each type of vehicle having quantity more than 20.
b. Count the type of vehicles
manufactured by each company.
b. select Company, count(distinct Type) from Vehicle group by Company;
Perform the following operations on the DataFrame :
1)Add both the scores of a
batsman and assign to column “Total”
'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']
Alternative Answer
Scheme
df['Total'] = sum(df['Score1'], df['Score2'])
print(df)
print("Maximum scores
are : " , max(df['Score1']), max(df['Score2']))
i) To display the name of the month of the
current date .
ii)
To remove spaces from the beginning and
end of a string, “ Panorama “.
iii) To display the name of the day eg, Friday
or Sunday from your date of birth, dob.
iv)
To
display the starting position of your first name(fname) from your whole name
(name).
v) To compute the remainder of division
between two numbers, n1 and n2
OR
Consider a table SALESMAN with the following data:
SNO SNAME SALARY BONUS DATE OF JOIN
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.
b)
Display the position of occurrence of the string “ta” in salesman names.
c) Display the
four characters from salesman name starting from second character.
d) Display the month name for
the date of join of salesman
ii)
trim(“ Panaroma “)
iii) dayname(date(dob))
iv)instr(name, fname)
v) mod(n1,n2)
OR
i) Select sname, round(bonus,0) from Salesman;
ii)
Select
instr(Sname, “ta”) from Salesman;
iii) Select
mid(Sname,2,4) from Salesman;
alternative
answer
iii) Select
Substring(Sname,2,4) from Salesman;
iv)
Select monthname(DateofJoin) from Salesman;
v)
Select dayname(DateofJoin) from Salesman;
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.
i. Suggest a most suitable
cable layout for the above connections.
ii. Suggest the
most appropriate topology of the connection
between the wings.
iii. The company
wants internet accessibility in all the wings.
Suggest a suitable technology.
iv. Suggest the
placement of the following devices with justification if the company wants
minimized network traffic
a)Repeater
b)Hub / switch
v. The company is planning to
link its head office situated in
excellent guide for teachers
ReplyDelete