KVS PGT Mock Test | SET B | Computer Science

1. For given dataframe df

What will be output of following code?
Temp = df.drop(‘jan’)
Print(temp)

To create chart as given below, complete the given code

X=[2,4,6,8]
Y= [20,40,10,10]
____________________________
Plt.show()

For given dataframe ‘sale’

You have been asked to add new column ‘total’ to show total sale of all months. Which of the following code you will suggest?

Predict the output of given code
S1 = pd.Series([10,20])
S2 = pd.Series(S1*2)
Print(S2)

Predict the output of given code
d={‘san’:{10:20,20:30}}
s=pd.Series(d)
print(s)

For given dataframe ‘river’ find the total no of places covered by Ganga in different locations.

predict the output of given code
import pandas as pd
s = pd.Series([10,20,30,40,50],[1,2,3,4,5])
print(s.iloc[1:3])

Select the correct statement
(i) while creating chart legend is displayed at bottom right corner of it.
(ii) values being taken in category axis should be arranged.

Look at the given code and predict the output. (assume that you have entered 6 as input)
def factorial(x):
for i in range(1,x+1):
r = r*i
r = 1
n = int(input(“Enter a Number”))
factorial(n)
print(r)

In the previous code what code should be written to execute it successfully?
r = 1
def factorial(x):
for i in range(1,x+1):
r = r*i
n = int(input(“Enter a Number”))
factorial(n)
print(r)

Define flow of execution of given program
1. def add(x,y):
2. return x+y
3. def cube(x):
4. return x*x*x
5. a = int(input(“enter a number”))
6. b= int(input(“enter a number”))
7. R = add(a,b)
8. Print(R)

For given function
Def equation(a,b,c=10):
Identify the legal call statements
(i) equation(5000, c=30, b=20)
(ii) equation(c=30, a=50, b = 20)
(iii) equation(50, a=50, b = 20)

Predict the output of
print(len(str(232/2)))

Write appropriate code to get the following output:

for given table ‘Books’

Write SQL command to produce following output.

i. Select title from library where type = ‘DS’ or type = ‘DBMS’;
ii. Select title from library where type in (‘DS’,’DBMS’);
iii. Select title from library where type = ‘DS’ or ‘DBMS’;
iv. Select title from library where type = ‘DS’ and ‘DBMS’;

For given table ‘books’ in previous question write SQL command to delete all records
i. Delete from club
ii. Delete all from club
iii. Truncate from club
iv. Truncate club

For given table ‘books’ in Q15,

calculate total and average of price of books publication wise. Also make sure the name of calculated field should be displayed as ‘Total Price’ and ‘Average Price’ respectively.

Select the correct SQL command

Select incorrect pair

Satellite uses

VoLTE stands for

CSV Files are

Which of the following does not come under GNU GPL?

Predict the result of given code
x=12
i=1
sum = 0
while i < x: if i%2==0: sum = sum + 1 i = i + 1 print sum

Bittu is a tech savvy student and has also an Instagram account where he keeps sharing some informative posts from time to time. This time Bittu downloaded the complete NCERT 12th computer science book and shared it on his Instagram under his name. Is this illegal according to you? If yes, what kind of violation?