Class 12 IP Half Yearly Sample Paper 2022-23

Section – A

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=pd1.____________________(data)                                #Statement 2

print(df)

i. pd                            ii. pd1                       iii. data                           iv. p

i. Dataframe             ii. DataFrame         iii. Series                       iv. Dictionary

i. df.index                  ii. df.shape()           iii. df.shape                  iv. df.size

i.                     df.loc[[‘Month’,’Passengers’]][df[‘Month’]==’Jan’]

ii.                   df[[‘Month’,’Passengers’]][df[‘Month’]==’Jan’]

iii.                 df.iloc[[‘Month’,’Passengers’]][df[‘Month’]==’Jan’]

iv.                 df([‘Month’,’Passengers’]][df[‘Month’]==’Jan’)

i.                     df.index[]=[“Air India”,”Indigo”,”Spicejet”,”Jet”,”Emirates”]

ii.                   df.index[“Air India”,”Indigo”,”Spicejet”,”Jet”,”Emirates”]

iii.                 df.index=[“Air India”,”Indigo”,”Spicejet”,”Jet”,”Emirates”]

iv.                 df.index()=[“Air India”,”Indigo”,”Spicejet”,”Jet”,”Emirates”]

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. matplotlib as plt                                          ii. pyplot as plt

iii. matplotlib.pyplot as plt                          iv. matplotlib.plt as pyplot

i. line()                    ii. bar()                            iii. hist()                        iv. barh()

i. title(“Rating”)    ii. ytitle(“Rating”)        iii. ylabel(“Rating”)   iv. yaxis(“Rating”)

i. display()              ii. print()                        iii. bar()                         iv. show()

i. Statement 1        ii. Statement 2               iii. Statement 3           iv. Statement 4

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)                   Select * from StuLibrary Order By BookID

ii)                 Select * from StuLibrary Order By StuID

iii)               Select * from StuLibrary Order By StuID ASC

iv)               Select * from StuLibrary Order By StuID 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.

c. Both Query iii) and iv) will display the desired data.

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

a.BookID                 b.BookID,StuID                 c.BookID,Issued_date              d.Issued_date

a.       SELECT BookID from StuLibrary where BookID is NULL;

b.      SELECT BookID from StuLibrary where StuID is NULL;

c.       SELECT BookID from StuLibrary where Issued_date is NULL;

d.      SELECT BookID from StuLibrary where Return_date is NULL;

a. StuName               b. StuContact                      c. StuAadhar                               d. StuClass

a.SELECT Issued_date from StuLibrary GROUP BY Issued_datewhere COUNT(*)>5; b.SELECT Issued_date from StuLibrary GROUP BY Return_datehaving count(*)>5 c.SELECT Issued_date from StuLibrary GROUP BY Issued_datehaving count(*)>5

d. SELECT Issued_date from StuLibrary GROUP BY Return_datewhere COUNT(*)>5

Answer any three 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)

 a. Select carname,round(cost) from carmarket;

b. Select carname,round.cost(1) from carmarket;

c. Select carname,round.cost() from carmarket;

d. Select carname, round(cost,1) from carmarket;

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

c. select carname,color from carmarket where color = “%E%”;

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

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

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

c. select carname,lower(company) from carmarket where dom from’2020-01-01′ to ‘2020- 12-31’;

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

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

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

c. select count(carmarket),year(dom) from carmarket group by year(dom);

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

a. Cardinality = 8 and Degree = 6                  b. Cardinality = 6 and Degree = 7

c. Cardinality = 7 and Degree = 6                  d. Cardinality = 7 and Degree = 8

a. Bus Topology                                                   b. Star Topology          

c. Ring Topology                                                 d. Mesh Topology

a. Switch                                                                 b. Hub

c. Router                                                                 d. Gateway

a. Plug ins                                                               b. Add ons

c. Control Panel                                                    d. Download Settings

Section – B

a. Intelligent Property Right                           b. Intellectual Property Reserve

c. Intellectual Property Right                         d. Intellectual Product Right

a. Yes                                                                      b. No

c. May be                                                               d. Not sure

a. Cyber bullying                                                 b. Phishing

c. Digital Footprint                                             d. Digital Activity

a. star                                                                      b. hybrid

c. mesh                                                                   d. tree

a. Client                                                                   b. Server

c. Hub                                                                      d. Switch

a. HTML Document                                             b. graphics file

c. audio & video files                                           d. All of these

a. Where                                                                  b. from

c. having                                                                  c. like

SELECT INSTR(“INDIA”,”DI”);

a. 2                                                                             b. 3

c. -2                                                                            d. -3

a. MAX                                                                       b. COUNT

c. SUM                                                                       d. All of these

a. AVG                                                                        b. SUM

c. WITH                                                                     d. MIN

import pandas as pd

Name=[‘Manpreet’,’Kavil’,’Manu’,’Ria’]

Phy=[70,60,76,89]

Chem=[30,70,50,65]

a. df=pd.DataFrame({“Name”:Name, “Phy”:Phy, “Chem”:Chem})

b. d=(“Name”:Name, “Phy”:Phy, “Chem”:Chem)

     dfpd.DataFrame(d)

c. df=pd.DataFrame([Name, Phy, Chem], columns=[“Name”,”Phy”,”Chem”,”Total”])

d. df=pd.DataFrame({Name:”Name”, Phy:”Phy”, Chem:”Chem”})

import pandas as pa

pa.Series([1,2,3,4], index=[‘a’, ‘b’, ‘c’])

a. Value Error                                                             b. Syntax Error

c. Name Error                                                            d. Logical Error

a. lists                                                                            b. dictionaries

c. series                                                                         d. All of these

import pandas as pd

s=pd.Series(data=[31,54,34,89,12,23])

df=pd.DataFrame(s)

Which statement will be used to get the output as 2?

a. print(df.index)                                                         b. print(df.shape())

c. print(df.ndim)                                                          d. print(df.values)

Section – C

Very Short answer type questions

i) if the series is empty

ii) Indexes of the series

S1=pd.Series(range(1,15,3) , index=list(‘abcd’))

S1= pd.Series(range(1,15,3),index=list(‘ababa’))

print(S1[‘ab’])

df.tail( )

but last 5 rows are being displayed. Identify the error and rewrite the correct code so that last 4 rows get displayed.

mysql> SELECT LCASE(‘INFORMATICS PRACTICES CLASS 12’);

mysql>SELECT CONCAT(LOWER(‘CLASS’), UPPER(‘XII’));

i) Each node is connected with the help of single cable

ii) Each node is connected with central switching through independent cables

Static Web page or Dynamic Web page

Section – D

Short answer type questions

What will be the output of the following two statement considering that the above object have been created already?

i) print ( x*2)                       ii) print (y*2)

justify your answer.

import pandas as pd

Stationery=[‘pencil’, ‘notebook’, ‘scales’, erasers’]

S1=pd.Series([20,33,52,10], index=Stationery)

S2=pd.Series([17,13,31,32], index=Stationery)

print(S1+S2)

S1=S1+S2

print(S1+S2)

Select Power(5,3);

Select MOD(5,3);

Powe( ) and mod( )

i) Select round(8.72,3);

ii) Select round (9.8);

Section – E

Long answer type questions

Perform the following operation on the DataFrame:

i) Display the Dataframe.

ii) Add both the scores of a batsman and assign to column “Total”

iii) Display the highest score in both Score1 and Score2 of the DataFrame.

Write SQL queries for the following :

i) Create the table product with appropriate data types and constraints

ii) identify the primary key in product

iii) list  the product code, product name. if PName is the same then display the data in ascending order of Price

iv) Add new column discount to the table product

v) Calculate the value of the discount in the table product as 10 percent of the UPrice for all those product where the UPrice is more than 100, otherwise the discount will be 0.

Table : Student

He has written following queries:

a) Select sum(MARKS) from student where Optional=’IP’and Stream=’Commerce’;

b) Select max(MARKS) + min(MARKS) from student where OPTIONAL= ‘CS’;

c) Select avg(MARKS) from student where OPTIONAL = ‘IP’;

d) Select length (SNAME) from student where MARKS is NULL;

help him in predicting the output of the above given queries.

i) Copyright and Patent

ii) Plagiarism and Copyright infringement

iii) Non-Ethical hacking and Ethical Hacking

iv) Active and Passive footprint

v) free software and free and open source software

*** BEST OF LUCK ***