Python & MySQL: CASE STUDY BASED QUESTIONS CLASS XII - IP SAMPLE PAPER 2021

INFORMATICS PRACTICES (065)

CASE STUDY BASED QUESTIONS

Q.1 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. His manager wants certain information from him, but he is facing some problems. Help him by answering few questions given below:

Code to create the above data frame:

import pandas as ____ #Statement 1

data = {"Year":[2010,2010,2012,2010,2012],

"Month":['Jan', 'Mar', 'Jan', 'Dec','Dec'],

"Passengers":[25,50,35,55,65]}

df = pd.__________(data) #Statement 2

print(df)

(i) Choose the right code from the following for Statement 1.

(a) pd

(b) df

(d) p

Answer : (a) pd

(ii) Choose the right code from the following for the Statement 2.

(a) Dataframe

(b) DataFrame

(d) Dictionary

Answer (b) DataFrame

(iii) Choose the correct statement/method for the required output: (5, 3)

(a) df.index

(b) df.shape()

(d) df.size

Answer: (c) df.shape

(iv) He wants to print the details of "January" months along with the number of passengers, Identify the correct statement:

(a) df.loc[['Month', 'Passengers']] [df['Month'] == 'Jan']

(b) df[['Month', 'Passengers']] [df['Month'] == 'Jan']

(d) df(['Month', 'Passengers']] [df['Month'] == 'Jan')

Ans: (b) df[['Month', 'Passengers']] [df['Month'] == 'Jan']

(v) Mr. Ankit wants to change the index of the Data Frame and the output for the same is given below. Identify the correct statement to change the index.

(a) df.index[ ] = ["Air India", "Indigo", "Spicejet", "Jet", "Emirates"]

(b) df.index["Air India", "Indigo", "Spicejet", "Jet", "Emirates"]

(d) df.index() = ["Air India", "Indigo", "Spicejet", "Jet", "Emirates"]

Answer: (c) df.index = ["Air India", "Indigo", "Spicejet", "Jet", "Emirates"]

Q.2 Mr. Sharma is working in a game development industry and he was the given chart on the basis of the rating of the various games available on the play store.

He is trying to write a code to plot the graph. Help Mr. Sharma to fill in the blanks of the code and get the desired output.

import _________________ #Statement 1

Games=["Subway Surfer","Temple Run","Candy Crush","Bottle Shot","Runner Best"]

Rating=[4.2,4.8,5.0,3.8,4.1]

plt.____________(Games,Rating) #Statement 2

plt.xlabel("Games")

plt.__________("Rating") #Statement 3

plt._________ #Statement 4

(i) Choose the right code from the following for Statement 1.

(a) matplotlib as plt

(b) pyplot as plt

(d) matplotlib.plt as pyplot

Answer: (c) matplotlib.pyplot as plt

(ii) Identify the name of the function that should be used in statement 2 plot the above graph

(a) line( )

(b) bar( )

(d) barh( )

Answer: (b) bar( )

(iii) Choose the correct option for the Statement 3.

(a) title("Rating")

(b) ytitle("Rating")

(d) yaxis("Rating")

Answer: (c) ylabel("Rating")

(iv) Choose the right function/method from the following for the Statement 4.

(a) display( )

(b) print( )

(d) show( )

Answer: (d) show( )

(v) In case Mr. Sharma wants to change the above plot to any other shape, which statement, should be change.

(a) Statement 1

(b) Statement 2

(d) Statement 4

Answer: (b) Statement 2

Q.3 A School in Delhi uses database management system to store student details. The school maintains a database 'school record" under which there are two tables.

Student Table: Maintains general details about every student enrolled in school.

StuLibrary Table: To store details of issued books. BookID is the unique identification number issued to each book. Minimum issue duration of a book is one Day

(i) Identify the SQL which displays the dat of StuLibrary table in ascending order of Student ID.

(i) Select * from StuLibrary order by BookID

(ii) Select * from StuLibrary order by StuID

(iii) Select * from StuLibrary order by BookID ASC

(iv) Select * from StuLibrary order by BookID DESC

Choose the correct option:

(a) Both Query (i) and (iv) will display the desired data.

(b) Both Query (i) and (ii) will display the desired data.

(d) Both Query (ii) and (iii) will display the desired data.

Answer: (d) Both Query (ii) and (iii) will display the desired data.

(ii) The Primary Key for StuLibrary Table is/are.........

(a) BookID

(b) BookID, StuID

(d) Issued_date

Answer: (c) BookID, Issued_date

(iii) Which of the following SQL Query will fetch ID of those issued books which have not been returned?

(a) select BookID from StuLibrary where BookID is NULL;

(b) select BookID from StuLibrary where StuID is NULL;

(d) select BookID from StuLibrary where Return_date is NULL;

Answer: (d) select BookID from StuLibrary where Return_date is NULL;

(iv) The Alternate Key for Student Table will be............

(a) StuName

(b) StuContact

(d) StuClass

Answer: (c) StuAdhar

(v) Which of the following SQL Query will display dates on which number of issued books is grater than 5?

(a) SELECT Issued_date from StuLibrary GROUP BY Issued_date where COUNT(*) > 5;

(b) SELECT Issued_date from StuLibrary GROUP BY Return_date having COUNT(*) > 5;

(d) SELECT Issued_date from StuLibrary GROUP BY Return_date where COUNT(*) > 5;

Answer: (c) SELECT Issued_date from StuLibrary GROUP BY Issued_date having COUNT(*) > 5;

Q.4 Tejasvi Sethi, a car dealer has stored the details of all cars in her showroom in a table called CARMARKET. The table CARMARKET has attributes CARCODE which is a primary key, CARNAME, COMPANY, COLOR, COST (in lakh rupees) of the car and DOM which is the Date of Manufacture of the car.

Answer any four questions based on the table CARMARKET from the below mentioned questions.

Table : CARMARKET

Choose the correct SQL query to do the following (for parts 1 to 4)

(i) Display the carname along with the charges round of to 1-digit after decimal place.

(a) select carname, round(cost) from carmarket;

(b) select carname, round, cost(1) from carmarket;

(d) select carname, round, (cost, 1) from carmarket;

Answer: (d) select carname, round, (cost, 1) from carmarket;

(ii) Display the carname, color and position of the character 'E' in the color of all the cars.

(a) select carname, color from carmarket where color like "%E%" ;

(b) select carname, color, instr(color, 'E') from carmarket ;

(d) select carname, color, substr(color,1, 'E') from carmarket ;

Answer: (b) select carname, color, instr(color, 'E') from carmarket ;

(iii) Display the carname, name of the company in lower case of all cars whose year (of dom) is 2020.

(a) select carname, lcase(company) from carmarket where year(dom) = 2020;

(b) select carname, lcase(company) from carmarket where yearof(dom) like'2020%' ;

(d) select carname, lower(company) from carmarket where yearfrom(dom) = 2020;

Answer: (a) select carname, lcase(company) from carmarket where year(dom) = 2020;

(iv) Display the number of cars manufactured each year.

(a) select count(*), year(dom) from carmarket where year(dom) = distinct ;

(b) select count(*), year(dom) from carmarket group by year(dom) ;

(d) select count(distinct *), year(dom) from carmarket group by year(dom) ;

Answer: (b) select count(*), year(dom) from carmarket group by year(dom) ;

(v) What is the cardinality and degree of the table CARMARKET?

(a) Cardinality = 8 and Degree = 6

(b) Cardinality = 6 and Degree = 7

(d) Cardinality = 7 and Degree = 8

Answer: (c) Cardinality = 7 and Degree = 6

Q.5 Samarth is the hardware engineer of "Happy School". He has been given the task of installing network in the school lab which has around 40 computers.

(i) Suggest the most suitable type of network topology he should use in order to maximize speed a make each computer independent of network break downs.

(a) Bus Topology

(b) Star Topology

(d) Mesh Topology

Answer : (b) Star Topology

(ii) In order to allow data transfer from server to only the intended computers which network device is required in the lab to connect the computers?

(a) Switch

(b) Hub

(d) Gateway

Answer: (a) Switch

(iii) After setting up the lab and internet in the lab, Samarth is now required to enable videos and animations to be played on the web browser for students of multimedia class. Which tool/service can be used for the same?

(a) Plug ins

(b) Add ons

(d) Download Settings

Answer : (b) Add ons

(iv) During the international exchange programme the students need to connect to a classroom in Russia using Skype. Samarth helps the students to connect. Which type of network service is being used?

(a) Instant messaging

(b) Email messaging

(d) WWW

Answer : (c) VoIP

(v) Samarth has asked students of class 7 to identify different parts of URL. Help the students to choose the correct option label 1 and 2.

(a) 1-Domain Name, 2- Protocol

(b) 1- Protocol, 2- Domain Name

(d) 1- Protocol, 2-subdomain

Answer: (b) 1- Protocol, 2- Domain Name

Q.6 Answer the following based on the series given below:

import pandas as pd

list1 = [1,2,3,4,5,6,7,8]

list2 = ['swimming', 'tt', 'skating', 'kho kho', 'bb', 'chess', 'football', 'cricket']

school = pd.Series(list1, index = list2)

school.name = ("little")

print(school*2) #statement 1

print(school.tail(3)) #statement 2

print(school['tt']) #statement 3

print(school[2:4]) #statement 4

(i) Choose the correct name of the series object given above.

(a) list1

(b) list2

(d) little

Answer : (d) little

(ii) Choose the correct output for the statement:

print(school.tail(3)) #statement 2

(a)

swimming 1

tt 2

skating 3

(b)

chess 6

football 7

cricket 8

(d)

kho kho 4

bb 5

chess 6

football 7

cricket 8

Answer : (b)

chess 6

football 7

cricket 8

(iii) Choose the correct output for the staement:

print(school["tt"] #statement 3

(a) 2

(b) 3

(d) true

Answer: (a) 2

(iv) Identify the correct output for:

print(school[2 : 4] #statement 4

(a)

skating 3

kho kho 4

(b)

tt 2

skating 3

kho kho 4

(c)

skating 3

kho kho 4

bb 5

(d)

skating 3

kho kho 4

bb 5

chess 6

football 7

cricket 8

Answer : (a)

skating 3

kho kho 4

(v) The correct output of the statement:

print(school*2) #statement 1 will be

(a)

swimming 3

tt 4

skating 5

kho kho 6

bb 7

chess 8

football 9

cricket 10

(b)

swimming 2

tt 4

skating 6

kho kho 8

bb 10

chess 12

football 14

cricket 16

(c)

swimming False

tt False

skating True

kho kho True

bb True

chess True

football True

cricket True

(d)

swimming 1

tt 4

skating 9

kho kho 16

bb 25

chess 36

football 49

cricket 64

Answer :

(b)

swimming 2

tt 4

skating 6

kho kho 8

bb 10

chess 12

football 14

cricket 16

Q.7 Smridh has recently changed his school so he is not aware of the people, but someone is posting negative, demeaning comments on his social media profile. He is also getting repeated mails from unknown people. Everytime he goes online, he finds someone chasing him online.

(i) Smridh is a victim of .....................

(a) Eavesdropping

(b) Stolen identity

(d) Cyber stalking

Answer : (d) Cyber stalking

(ii) The action that Smridh should take:

(a) He should ONLY share with his friends.

(b) He should NOT share with anyone as it can cause serious problem.

(d) He should bring the notice of his parents and school authorities.

Answer : (d) He should bring the notice of his parents and school authorities.

(iii) ........... is a set of moral principles that governs the behaviour of a group or individual and regulates the use of computer.

(a) Copyright

(b) Computer ethics

(d) Privacy law

Answer : (b) Computer ethics

(iv) Smridh needs to protect his personal information or data from unintentional and intentional attacks and disclosure which is termed as ..........

(a) Digital right

(b) Copyright

(d) Intellectual property

Answer : (c) Privacy

(v) The act of fraudulently acquiring someone's personal and private information, such as online account names, login information and passwords is called as .....................

(a) Phishing

(b) Fraud

(d) Plagiarism

Answer : (a) Phishing

Q.8 A departmental store 'Iconic' is planning to automate its system so that they can store all the records on computer. They contacted a Software Company to make the software for the same. The company suggested that there is need of a front end and back-end software. The major challenge was to keep the record of all the items available in the store. To overcome the problem, the software company has shown the glimpses of the database and tables required to resolve their problem:

Database Name : Iconic

Table Name : Garment

Attributes of the table : Gcode - Numeric, Gname - Character 25, Size - Character 5, Colour - Character 10, Price - Numeric

Table: GARMENT

(i) Choose the command that will give the output as:

(a) select left(COLOUR,3) from GRAMENT where COLOUR like "B%" ;

(b) select COLOUR from GRAMENT where COLOUR not like "%B%" ;

(d) select COLOUR from GRAMENT where COLOUR like "B%" ;

Answer : (a) select left(COLOUR,3) from GRAMENT where COLOUR like "B%" ;

(ii) Choose the correct command for the following purpose.

To delete the record with GCode as 116

(a) Delete * from GARMENT where GCode = '116' ;
(b) Delete from GARMENT where GCode = '116' ;

(d) Delete from GARMENT where GCode is '116' ;

Answer : (b) Delete from GARMENT where GCode = '116' ;

(iii) Give the output of :

Select GName, Price from GARMENT order by Price Desc;

(a)

(b)

(c)

(d)

Answer : (c)

(iv) Choose the correct command for the following purpose.

To change the colour of GARMENT with code as 116 to "Orange".

(a) Update GARMENTS set COLOUR = "Orange" where Gcode = 116 ;

(b) Update GARMENT set COLOUR = "Orange" where Gcode = 116 ;

(d) Update GARMENTS where Gcode = 116 set COLOUR = Orange ;

Answer : (b) Update GARMENT set COLOUR = "Orange" where Gcode = 116 ;

(v) What is the degree and cardinality of 'GARMENT' table?

(a) Degree = 5 & Cardinality = 6

(b) Degree = 6 & Cardinality = 5

(d) Degree = 7& Cardinality = 5

Answer : (a) Degree = 5 & Cardinality = 6

(v) Suggest a free software for managing the dataase.

(a) Oracle

(b) MySQL

(d) Microsoft SQL Server

Answer : (b) MySQL

Q.9 Sanyukta is the event in a school. One of her students gave her a suggestion to use Python Pandas and Matplotlib for analyzing and visualizing the data, respectively. She created a Data Frame "SportsDay" to keep track of the number of First, Second and Third prizes won by different houses in various events.

Write Python commands to do the following

(i) Display the house names where the numebr of Second Prize are in the rnage 12 to 20.

(a) df['House'][(df['Second']>=12) and (df['Second']<=20)]

(b) df[House][(df['Second']>=12) & (df['Second']<=20)]

(d) df[(df['Second']>=12) & (df['Second']<=20)]

Answer : (c) df['House'][(df['Second']>=12) & (df['Second']<=20)]

(ii) Display all the records in the reverse order.

(a) print(df[::1])

(b) print(df.iloc[::-1])

(d) print(df.reverse())

Answer : (b) print(df.iloc[::-1])

(iii) Display the bottom 3 records.

(a) df.last(3)

(b) df.bottom(3)

(d) df.tail(3)

Answer : (d) df.tail(3)

(iv) Choose the correct output for the given statements:

x=df.columns[:1]

print(x)

(a) 0

(b) House

(d) Error

Answer : (b) House

(v) Which command will give the output 24:

(a) print(df.size)

(b) print(df.shape)

(d) print(df.axes)

Answer : (a) print(df.size)

Q.10 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, emails 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.

On the bases of the above case study, answer the questions given below:

(i) Specify which type of cybercrime is it.

(a) Spamming

(b) Phishing

(d) Hacking

Answer : (b) Phishing

(ii) URL stands for __________

(a) Universal Resource Loader

(b) Uniform Resource Locater

(d) Uniform Resource Loader

Answer : (b) Uniform Resource Locater

(iii) Unsolicited commercial emails is known as:

(a) Malware

(b) Virus

(d) Spyware

Answer : (c) Spam

(iv) Wi-Fi stands for ___________

(a) Wireless Internet Frequent Intercace

(b) Wireless Functioning

(d) Wire Free Internet

Answer : (c) Wireless Fidelity

(v) Ideally, what characters should be used in a password to make it strong ?

(a) Letters and numbers only

(b) Mixed Case (Upper and Lower)

(d) All of above

Answer : (d) All of above

Q.11 Pushp, a student of class-XII, has been assigned a code to create a pandaseries S1, as shown below.

a 100

b 200

c 300

d 400

e 500

dtype: int64

With reference to the above answer given questions:

(i) Choose the command that will give the following output-

b 200

c 300

dtype: int64

(a) print(S1[:3])

(b) print(S1[0:3])

(d) print(S1[2:4])

Answer : (c) print(S1[1:3])

(ii) Help him to identify the correct statement that can be used to extract t h e value with the index 'c'

(a) print(S1[c])

(b) print(S1(c))

(d) print(S1 ['c'])

Answer : (d) print(S1 ['c'])

(iii) W h i c h of the following command will give the following output-

b 200

d 400

dtype: int64

(a) print(S1.iloc[1:4])

(b) print(S1.iloc[2:4])

(d) print(S1.iloc[1:4:2])

Answer : (d) print(S1.iloc[1:4:2])

(iv) Which of the following command will display the series by adding 10 in each value.

(a) print(S1 [+10])

(b) print(S1+10)

(d) print(S1)+print(10)

Answer : (b) print(S1+10)

(v) Pushp wants to delete the value against index 'd'. Help him to choose the suitable option to do so:

(a) S1=S1.drop(d)

(b) S1=S1.drop('d')

(d) S1=S1.drop['d']

Answer : (b) S1=S1.drop('d')

Q.12 Gaurav has written a Python Code to create a bar plot as given below using the following data :

import ___________ as ________ #Statement 1

City=['Delhi','Beijing','Washington','Tokyo','Moscow']

Gender=['Male','Female']

Happiness_Index_Male=[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=" Male",width=.5)

plt.______([.75,1.75,2.75,3.75,4.75],Happiness_Index_Female,color='Green',width=.5,label="Female") #Statement 2

pos=range(len(City))

print(pos)

plt.xticks(pos, City,fontsize=10)

plt.xlabel('City', fontsize=16)

plt.ylabel('Happiness_Index', fontsize=16)

_______________ #Statement 3

_______________ #Statement 4

_______________ #Statement 5

(i) Identify the suitable code to be used in the blank space in line marked as Statement1.

(a) matplotlib as plt

(b) numpy as np

(d) matplotlib.pyplot as plt

Answer : (d) matplotlib.pyplot as plt

(ii) What is the name of the function to plot the required bar graph in the line marked as Statement 2

(a) hist()

(b) pie()

(d) scatter()

Answer : (c) bar()

(iii) Fill in the blank in statement 3 to set Chart Title as "Happiness Index across cities by gender" and font size as 18.

(a) plt.xtitle("Happiness Index across cities by gender",fontsize=18)

(b) plt.title("Happiness Index across cities by gender",fontsize=18)

(d) plt.show("Happiness Index across cities by gender",fontsize=18)

Answer : (b) plt.title("Happiness Index across cities by gender",fontsize=18)

(iv) Identify the suitable code for line marked as Statement 4 to display the legendsas shown in the plot.

(a) plt.showlegend()

(b) plt.legend()

(d) plt.show()

Answer : (b) plt.legend()

(v) Fill in the blank marked in Statement 5 to display the plot.

(a) plt.plot()

(b) plt.showplot()

(d) plt.show()

Answer : (d) plt.show()

Q.13 Refer to the following diagram and answer the questions given below.

(i) Which of the following devices acts as a server ?

(a) A

(b) B

(d) D

Answer : (d) D

(ii) The arrow from device D to pointing to A represents?

(a) HTTP request

(b) HTTP response

(d) All of the above

Answer : (b) HTTP response

(iii) Which of the following device(s) can have IP Addresses?

(a) A

(b) D

(d) All of the above

Answer : (d) All of the above

(iv) Identify the network topology of the above network :

(a) Ring

(b) Star

(d) None of the above

Answer : (b) Star

(v) _________ is a protocol (set of rules) used when transmitting files (data) over theworld wide web.

(a) FTP

(b) HTTP

(d) None of the above

Answer : (b) HTTP

Q.14 Vidya Devi, a retired school principal, was inspired by her granddaughter who uses technology for her day to day activities. Being a learner and teacher all her life, she wanted to open an email account and interact with her friends and family. Her granddaughter created an email account for her and gradually she started sending mails to her friends and family. This was a big achievement for her. Her granddaughter explained how emails are sent, how to create an email address, what protocols are used. Some of these details were too technical for her, but she never gave up. There are few doubts/misconceptions in her mind which you can help her with.

(i) Unsolicited e-mail advertising is known as

(a) newsgroup

(b) junk ads

(d) none of the above

Answer : (c) spam

(ii) Which of the following is the correct format of email address?

(a) name@website@info

(b) name@website.info

(d) name.website.com

Answer : (b) name@website.info

(iii) Mail access starts with client when user needs to download email from the

(a) mail box

(b) mail server

(d) Internet

Answer : (a) mail box

(iv) To use email service, one needs to register with

(a) Internet Service Provider

(b) Email Service Provider

(d) No need to register

Answer : (a) Internet Service Provider

(v) Bcc stands for _________ to send the copy of mail.

(a) Black carbon copy

(b) Blue carbon copy

(d) Block chain copy

Answer : (c) Blind carbon copy

Q.15 A Gift Gallery has different stores in India. Database Administrator Abhay wants to maintain database of their Salesmen in SQL to store the data, He has decided that

Name of the database: GiftGallery

Name of the table: Salesman

Attributes of the tables: Scode – Numeric, Sname – Character 25, Address - Character 25, Dojoin - Date, Sales, Numeric and Area – Character 10

Consider the following records in ‘Salesman’ table and answer the given questions:

Table: Salesman

(i) State the command that will give the output as:

(a) Select Sname from Salesman Where Not Address =”Delhi”;

(b) Select Sname from Salesman Where Address NOT IN(“Delhi”);

(d) All of the above

Answer: (d) All of the above

(ii) Which of the following commands will display the details of all sales record of North Area, regardless of case (whether North / NORTH / north):

(a) Select * from salesman where area like upper ‘north’;

(b) Select * from salesman where area = ‘North’ or ‘NORTH’ or north;

(d) Select * from salesman where area= =upper(’North”)’;

Answer: (c) Select * from salesman where upper(area)=’NORTH’;

(iii) Help Priya to display sname and sales of east and west areas

(a) Select sname, sales from Salesman where area=”East” and area=”West”;

(b) Select sname, sales from Salesman where area=”East” or area=”West”;

(d) Select sname, sales from Salesman where area=”East” , ”West”;

Answer: (b) Select sname, sales from Salesman where area=”East” or area=”West”;

(iv) The command to display the name of the salesman along with the sales amount rounded off to one decimal point will be:

(a) Select sname, round(sales,1) from salesman;

(b) Select sname, round(sales,0.1) from salesman;

(s) Select sname, trunc(sales,0.1) from salesman;

Answer: (a) Select sname, round(sales,1) from salesman;

(v) What will be the output of the following command?

Select Right(Sname,3), Round(Sales) from Salesman Where Sname Like “P%”;

(a)

(b)

(c)

(d)

Answer : (d)

Q.16 A Fashion Store MyStore is considering to maintain database of their Customers in SQL to store the data, As a Database Administrator Hina has decided that

Name of the database: MyStore

Name of the table: Customer

Attributes of the tables: Acc_No – Numeric, Cust_Name – Character 25, Cust_City - Character 25, Cust_Phone Character 11,

Open_Bal – Numeric

Consider the following records in ‘Customer’ table and answer the given questions:

Table : Customer

(i) With reference to the above given table, give query for generating following output

(a) Select Name from Customer where Open_bal<20000;

(b) Select Name from Customer where Cust_City like ‘%a’;

(d) Select Cust_name from Customer where Cust_Name like “a%;

Answer : (c) Select Cust_Name from Customer where Cust_City like ‘%a’;

(ii) Give the output of :

Select Cust_Name, Open_Bal from Customer order by Open_bal;

(a)

(b)

(c)

(d)

Answer : (a)

(iii) Pranay has given the following command to obtain Highest Opening Balance of each City

Select max(Open_Bal) from Customer where group by Cust_City;

but he is not getting the desired result. Help him by writing the correct command.

(a) Select Max(Open_Bal) group by Cust_City;

(b) Select Max(Open_Bal) from Customer where group by Cust_City;

(d) Select max(Open_Bal) from Customer group by Cust_name;

Answer: (c) Select Cust_City, Max(Open_Bal) from Customer group by Cust_City;

(iv) Help Pranay find the total no. of records having open_bal between 15000 to 20000 by selecting the right command:

(a) Select total from customer having open_bal between 15000 and 20000;;

(b) Select count(*) from customer where open_bal between 15000 to 20000;;

(d)Select count(*) from customer order by open_bal;

Answer: (c) Select count(*) from customer where open_bal between 15000 and 20000;

(v) Choose the correct command to display the first two letters of each customer’s name.

(a) select right(cust_name,2) from customer;

(b) select left(cust_name,2) from customer;

(d) select left(cust_name,2) from customer;

Answer: (b) select left(cust_name,2) from customer;

Q.17 Ramanpreet has to work on his science project which deals with electromagnetic waves. A lot of research work is required by him for the same. He uses Google Chrome to search for the relevant matter.

(i) Google chromeis an example of a

(a)Website

(b) Web browser

(d) Web Page

Answer: (b) Web browser

(ii) He finally locates some useful information and clicks on the link provided to access the website. The link is actually known as a __________.

(a) Domain name

(b) Web Page

(d) IP address

Answer: (c) URL

(iii) As Ramanpreet works on his project, he collects and curates information. Whenever he clicks on the link the same piece of information is shown and the content is not clickable. Ramanpreet is accessing a/an _________ website.

(a) Dynamic

(b) Textual

(d) Static

Answer: (d) Static

(iv) A web cookie is a small piece of data that is:

(a) sent from a website and stored in user’s web browser while a user is browsing a website

(b) sent from user and stored in the server while a user is browsing a website

(d) sent from the root server to other root servers

Answer: (a)

(v) HTML stands for

(a) Hyper Text Markup Link

(b) Hyper Text Markup Language

(d) Hyper Text Manipulation Language

Answer: (b) Hyper Text Markup Language

Q.18 Zeenat has created the following data frame dataframe1 to keep track of data Rollno, Name, Marks1 and Marks2 for various students of her class where row indexes are taken as the default values:

(i) Which among the following option will give 90, 95 as output

(a) print(max(dataframe1['Marks1','Marks2'])

(b) print((dataframe1.Marks1.max(),(dataframe1.Marks2.max())))

(c)print(max(dataframe1['Marks1'])

(d) print(max(dataframe1['Marks2'])

Answer: (b)

(ii) She needs to know the marks scored by Rollno 2. Help her to identify the correct set of statement/s from the given options:

(a) print(dataframe1[dataframe1['Rollno']= =2])

(b) print(dataframe1['Rollno']= =2)

(d) print(dataframe1[dataframe1['Rollno']])

Answer: (c) print(dataframe1[dataframe1. Rollno = =2])

(iii) Which of the following statement/s will delete the 3rd column?

(a) del dataframe1['Marks1']

(b) dataframe1.pop('Marks1')

(d) pop dataframe1['Marks1']

Choose the correct option:

(a) both (a) and (b)

(b) only (b)

(d) (a), (b) and (d)

Answer: (a) both (a) and (b)

(iv) Which of the following command will display the total number of elements in the dataframe?

(a) print(dataframe1.shape)

(b) print(dataframe1.num)

(d) print(dataframe1.elements)

Answer: (c) print(dataframe1.size)

(v) Now she wants to add a new column Marks3 with relevant data. Help her choose the command to perform this task.

(a) dataframe1.column=[ 45,52,90,95]

(b) dataframe1 ['Marks3']= [ 45,52,90,95]

(d) Both (b) and (c) are correct

Answer: (b) dataframe1 ['Marks3']= [ 45,52,90,95]

Q.19 Naman has created the following dataframe “Climate” to record the data about climatic conditions of four years.

(i) Which of the following code snippets will return the MaxTemp and Rainfall for year 2018 and 2019?

(a)Climate[['MaxTemp','Rainfall']][1:3]

(b) Climate['MaxTemp', 'Rainfall'][1:3]

(d) Climate.iloc[1:3,1:2]

Answer: (c) Climate.iloc[1:3]

(ii) Display the temperature difference between MaxTemp and MinTemp for all the rows in the dataframe Climate.

(a) Climate=Climate["MaxTemp"]-Climate["MinTemp"]

(b) print(Climate["maxt"]-Climate["mint"])

(d) print(Climate.Climate["MaxTemp"]-Climate["MinTemp"])

Answer: (c)

(iii) To display 2 rows from the top in the dataframe, which of the following statement is correct:

(a) print (Climate.head()=2 )

(b) print (Climate.head(n==2) )

(d) print (Climate.head(2) )

Answer: (d) print (Climate.head(2) )

(iv) Which of the following statement/s will give the exact number of values in each column of the dataframe?

(a) print(Climate.count())

(b) print(Climate.count(0))

(d) print(Climate.count(axis='index'))

Choose the correct option:

(a) both (a) and (b)

(b) only (b)

(d) a), (b) and (d)

Answer: (d) a), (b) and (d)

(v) To display 2 rows from the bottom in the dataframe, which of the following statement is correct:

(a) print (Climate.tail()=2 )

(b) print (Climate.tail(n==2) )

(d) print (Climate.tail(2) )

Answere: (d) print (Climate.tail(2) )

Q.20 Sumit has to prepare a project on “Swachh Bharat Shreshth Bharat”.

He decides to get information from the Internet. He downloads three web pages (webpage1, webpage 2, webpage 3) containing information on the given topic.

1. He read a paragraph on from webpage 1 and rephrased it in his own words. He finally pasted the rephrased paragraph in his project.

2. He downloaded three images of from webpage 2. He made a collage for his project using these images.

3. He also downloaded an icon from web page 3 and pasted it on the front page of his project report.

(i) Step1 An Example of __________

(a) Plagiarism

(b) Paraphrasing

(d) Intellectual Property right

Answer: (b) Paraphrasing

(ii) Step 2 An act of _______.

(a) plagiarism

(b) copyright infringement

(d) Digital Footprints

Answer: (a) plagiarism

(iii) Step 3 An act of ________.

(a) Plagiarism

(b) Paraphrasing

(d) Intellectual Property right

Answer: (c) copyright infringement

(iv) A website is a collection of __________.

(a) Web Servers

(b) Web pages

(d) Hyperlinks

Answer: (b) Web pages

(v) The process of getting web pages, images and files from a web server to local computer is called

(a) FTP

(b) Uploading

(d) Remote access

Answer: (c) Downloading

Q. 21 HR Department of ABCTech has created following dataframe to store data about salaries and bonus paid to their employees:

import pandas as pd

import numpy as np

d1={'EName':[ 'Kavita', 'Sudha', 'Garima’]'],

'Sal':[50000,60000,55000],

'Bonus':[3000,4000,5000]}

Df1=pd.DataFrame(d1)

Choose the python statement using suitable functions for the following tasks:

(i) Display the columns Sal and Bonus

(a) df1 [:Sal :Bonus]

(b) df1.loc(['Sal','Bonus'])

(d) df1[['Sal','Bonus']]

Answer: (b) df1.loc(['Sal','Bonus'])

(ii) Display the details of employee Kavita.

(a) df1[df1.EName='Kavita']

(b) df1.loc[df1.EName=='Kavita']

(d) df1[EName='Kavita']

Answer: (b) df1.loc[df1.EName=='Kavita']

(iii) Display the details of the last employee.

(a) Df1.tail(1)

(b) Df1.tail (-1)

(d) Df1.head()

Answer: (a) Df1.tail(1)

(iv) Add a new column named ‘Email’ with the value “abc@gmail.com”.

(a) Df1[‘Email’]= ‘abc@gmail.com’

(b) Df1[Email]=’abc@gmail.com’

(d) Df1(‘Email’)=’abc@gmail.com’

Answer: (a) Df1[‘Email’]= ‘abc@gmail.com’

(v) Write a python statement to print the details of employees having Sal more than 50000

(a) df1.Sal>=5000

(b) df1[df1.Sal>=5000]

(d) df1.iloc[df1.Sal>=5000]

Answer: (b) df1[df1.Sal>=5000]

=================FINISH===============

Python & MySQL

Tuesday, August 10, 2021

CASE STUDY BASED QUESTIONS CLASS XII - IP SAMPLE PAPER 2021 - CBSE

No comments:

Post a Comment

CLASS XI HALF YEARLY QP WTH MS 2024

Contact Form

Pages