KVS PGT Computer Science Question paper with answers

Question 1: Which of the following is not hardware of a computer system?

• (A) Keyboard
• (B) Printer
• (C) Operating System
• (D) Mouse

Question 2: Which out of the following is the least capacity of memory unit compared to other options?

• (A) MB
• (B) KB
• (C) GB
• (D) TB

Question 3: A collection of 4 bits is known as:

• (A) BYTE
• (B) WORD
• (C) NIBBLE
• (D) K.BYTE

Question 4: While working on a computer, if we open a document in MS Word, which of the following is used?

• (A) RAM
• (B) ROM
• (C) BIOS
• (D) I/O BUS

Question 5: Which of the following is not an operating system?

• (A) UNIX
• (B) WINDOWS
• (C) ANDROID
• (D) MS OFFICE

Question 6: What will be the result of the following Boolean expression?

NOT True OR False AND True

• (A) False
• (B) True
• (C) Error in Expression
• (D) No result

Question 7: Which Boolean expression is the correct interpretation of the following logic circuit?

• (A) A + B.C
• (B) (A + B).C
• (C) A.B + C
• (D) A + B + C

Question 8: Which of the following represents Absorption law correctly?

• (A) X + Y.Z = (X + Y).(X + Z)
• (B) X + X.Y = X
• (C) (X + Y)’ = X’ Y’
• (D) (X . X)’ = X’

Question 9: Which of the following represents the exact equivalent of the given binary number in Octal number? (101110001011)

• (A) (232023)
• (B) (A8A)
• (C) (5613)
• (D) (3165)

Question 10: What is the full form of the ISCII encoding scheme?

• (A) Indian Standard Code for Interchange of Information
• (B) Indian Standard Code for Information Interchange
• (C) Indian Standard Coding for Information in Interchange
• (D) Indian Scheme of Coding for Information Interchange

Question 11: Which of the following cannot be registered under cybercrime?

• (A) Sending pornographic material online
• (B) Stealing of brand-new internet routers from a showroom
• (C) Accessing CCTV camera of a private company without their knowledge
• (D) Sending threats on social media accounts

Question 12: Which of the following is an example of a very strong password?

• (A) STRONG
• (B) Abc1234
• (C) admin
• (D) Ap9#2@cQ

Question 13: Which protocol is used to upload and download files from remote servers?

• (A) SMTP
• (B) VoIP
• (C) HTTP
• (D) FTP

Question 14: What type of network is created when buildings are connected using CAT6 cables?

• (A) PAN
• (B) MAN
• (C) LAN
• (D) WAN

Question 15: Which of the following is not a network device?

• (A) Switch
• (B) Router
• (C) Hub
• (D) RAM

Question 16: Which of the following is an example of a DBMS?

• (A) Windows
• (B) Linux
• (C) MySQL
• (D) MS Paint

Question 17: What does CPU stand for?

• (A) Central Processing Unit
• (B) Central Printed Unit
• (C) Core Processing Unit
• (D) Computer Processing Unit

Question 18: Which of the following is not an operating system?

• (A) Windows
• (B) Linux
• (C) Python
• (D) macOS

Question 19: Which memory is volatile?

• (A) ROM
• (B) Hard Drive
• (C) RAM
• (D) SSD

Question 20: What is the full form of URL?

• (A) Uniform Resource Locator
• (B) Unified Resource Link
• (C) Universal Remote Link
• (D) Uniform Record Locator

Question 21: Which of the following is an invalid identifier in Python programming language?

• (A) none
• (B) False
• (C) true
• (D) For

Question 22: Which of the following is not a valid operator in Python?

• (A) ==
• (B) =>
• (C) //
• (D) **

Question 23: Identify the correct output of the following Python arithmetic expression:
1 + (2 – 3) * 4 ** 5 // 6

• (A) -171
• (B) 172
• (C) -170
• (D) 170

Question 24: Evaluate the following expression:
not True or not False and False

• (A) True
• (B) False
• (C) None
• (D) will generate an Error.

Question 25: Identify the correct output of the following Python command:
print(10 or 40)

• (A) 10
• (B) 40
• (C) 50
• (D) 400

Question 26: Identify the correct output of the following Python program segment?

Pi=3.141592
print(‘%d4f’ %Pi)

• (A) 3.14
• (B) 3.1415
• (C) 3.1416
• (D) 3.0000

Question 27: Which of the following is an immutable data type in Python?

• (A) Set
• (B) List
• (C) Tuple
• (D) Dictionary

Question 28: If we have 2 Python lists as follows:

List1=[10,20,30]
List2=[40,50,60]

If we want to generate a list List3 as
List3= [10,20,30,40,50,60]

Then the best Python command out of the following is:

• (A) List3 = List1 + List2
• (B) List3 = List1.append(List2)
• (C) List3 = List1.update(List2)
• (D) List3 = List1.extend(List2)

Question 29: Identify the correct output of the following Python code:

L=[3,3,2,2,1,1]
L.append(L.pop(L.pop()))
print(L)

• (A) [3,2,2,1,3]
• (B) [3,3,2,2,3]
• (C) [1,3,2,2,1]
• (D) [1,1,2,2,3,3]

Question 30: Identify the output of the Python command:

print(22.0/5)

• (A) 4.4
• (B) 4
• (C) 4.0
• (D) 2

Question 31: Find the output of the following Python code:

L1 = [1,4,3,2]
L2 = L1
L1.sort()
print(L2)

• (A) [1,4,3,2]
• (B) [1,2,3,4]
• (C) 1 4 3 2
• (D) 1 2 3 4

Question 32: If PL is a Python list as follows:
PL = [‘Basic’, ‘C’, ‘C++’]
Then what will be the status of the list PL after PL.sort(reverse=True)?

• (A) [‘Basic’,’C’,’C++’]
• (B) [‘C++’,’C’,’Basic’]
• (C) [‘C’,’C++’,’Basic’]
• (D) [‘Basic’,’C++’,’C’]

Question 33: Identify the correct output of the following Python program.

CHARR = [[‘A’,’B’],[‘C’,’D’],[‘E’,’F’]]
print(CHARR [1][1])

• (A) ‘A’
• (B) ‘B’
• (C) ‘C’
• (D) ‘D’

Question 34: The following Python list S is implemented as a stack.
S=[10, 12, 0, 4, 6]
If 10 is the element added (pushed) last into the stack S, which command from the following options is best to remove (pop) an element from the Stack S, if not empty?

• (A) S.pop(0)
• (B) S.pop()
• (C) S.remove()
• (D) S.remove(0)

Question 35: Traditionally, the end of a stack from where PUSH (addition) and POP (deletion) take place is popularly known as:

• (A) FRONT
• (B) TOP
• (C) LIFO
• (D) FIFO

Question 36: Identify the correct output of the Python code:

L1 = [1,2,3]
L2 = [4,5]
L3 = [6,7]
L1.extend(L2)
L1.append(L3)
print(L1)

• (A) [1,2,3,4,5,6,7]
• (B) [1,2,3,[4,5],6,7]
• (C) [1,2,3,4,5,[6,7]]
• (D) [1,2,3,[4,5],[6,7]]

Question 37: Identify the correct output of the Python code:

TUP = ([1, 2], [3, 4], [5, 6])
TUP[2][1] = 8
print(TUP)

• (A) ([1, 2], [8, 4], [5, 6])
• (B) ([1, 2], [3, 4], [8, 6])
• (C) ([1, 2], [3, 4], [5, 8])
• (D) will generate an error as a Tuple is immutable

Question 38: Identify the output of the following Python program segment:

S = “Python Programming”
L = S.split()
S = “,”.join(L)
print(S)

• (A) Python Programming
• (B) Python, Programming
• (C) ,Python Programming,
• (D) ,Python, Programming,

Question 39: If S = “python language” is a Python string, which of the following commands will display “Python language”?

• (A) print(S.upper())
• (B) print(S.title())
• (C) print(S.capitalize())
• (D) print(S.sentence())

Question 40: Identify the correct output of the following Python Code:

Str = “Hello World! Hello India!”
Pos = Str.index(“Hello”)
print(Pos)

• (A) 0
• (B) 13
• (C) [0, 13]
• (D) (0, 13)

Question 41: If a List L=[‘Hello’, ‘World!’] Identify the correct output of the following Python command:
print(*L)

• (A) Hello World!
• (B) Hello, World!
• (C) ‘Hello’, ‘World!’
• (D) ‘Hello’ ‘ ‘World!’

Question 42: If Str is a Python string as
Str= “Hello World!”
What will be the output of the following Python Command?
print(Str.find(‘1’))

• (A) 2
• (B) 3
• (C) [2, 3, 7]
• (D) (2, 3, 7)

Question 43: Suppose a Python tuple TUP is declared as
TUP = (‘A’,’B’,’C’)
Which of the following command is invalid?

• (A) TUP = (‘D’)
• (B) TUP = (‘D’,)
• (C) TUP += (‘D’)
• (D) TUP += (‘D’,)

Question 44: Identify the correct output of the following Python code:
TUP = (3, 1, 2, 4)
sorted(TUP)
print(TUP)

• (A) (3, 1, 2, 4)
• (B) (1, 2, 3, 4)
• (C) [3, 1, 2, 4]
• (D) [1, 2, 3, 4]

Question 45: Find the correct output of the following Python program segment:
T=(‘1’)
print(T*3)

• (A) 3
• (B) (‘1′,’1′,’1’)
• (C) 111
• (D) (‘3’)

Question 46: Select the correct output of the given Python code from the following options:

S = ‘INDIAN’
L=S.partition(‘N’)
NS = L[0]+’-‘+L[1]+’-‘+L[2]
print(NS)

• (A) I – N – DIA – N –
• (B) I – DIA –
• (C) I – DIAN
• (D) I – N – DIAN

Question 47: To execute the following code in Python, which module needs to be imported?

print(mean([1, 2, 3]))

• (A) math
• (B) random
• (C) statistics
• (D) probability

Question 48: If D is a Python dictionary as

D= {‘A’ : 1, ‘B’ : 2, ‘C’ : 3}

Then, which of the following command will remove the entire dictionary from memory?

• (A) del(D)
• (B) D.del()
• (C) D.clear()
• (D) D.remove()

Question 49: What will be the output of the following Python code?

D1 = {‘A’ : 5,’B’ : 7, ‘C’ : 9}
D2 = {‘B’ : 5, ‘D’ : 10}
D1.update(D2)
print(D1)

• (A) {‘A’ : 5, ‘B’ : 5, ‘C’ : 9, ‘D’ : 10}
• (B) {‘A’ : 5, ‘B’ : 5, ‘C’ : 9, ‘B’ : 5, ‘D’ : 10}
• (C) {‘A’ : 5, ‘C’ : 9, ‘D’ : 10}
• (D) {‘B’ : 7, ‘D’ : 10, ‘A’ : 5, ‘C’ : 9}

Question 50: Select the output for the given Python code from the following options:

D1 = { 1 : 2, 2 : 3, 3 : 4 }
D2 = D1.get(1,2)
print(D2)

• (A) 2
• (B) 3
• (C) [2,3]
• (D) {1 : 2, 2 : 3 }

Question 51:

Which of the following functions cannot be used with string (str) data type?

• (A) islower()
• (B) isupper()
• (C) isalpha()
• (D) isnum()

Question 52:

Examine the given Python program and select the purpose of the program from the following options:

N = int(input("Enter the number"))
for i in range(2, N):
    if (N % i == 0):
        print(i)

• (A) to display the proper factors (excluding 1 and the number N itself)
• (B) to check whether N is a prime or Not
• (C) to calculate sum of factors of N
• (D) to display all prime factors of the number N

Question 53:

If A = random.randint(B, C) assigns a random value between 1 and 6 (both inclusive) to the identifier A, what should be the values of B and C, if all required modules have already been imported?

• (A) B = 0, C = 6
• (B) B = 0, C = 7
• (C) B = 1, C = 7
• (D) B = 1, C = 6

Question 54:

Identify the correct output of the following Python code:

from math import *
A = 5.6
print(floor(A), ceil(A))

• (A) 5 6
• (B) 6 5
• (C) -5 -6
• (D) -6 -5

Question 55:

Identify the correct output of the following Python program segment:

import math
print(math.fabs(-10))

• (A) 1
• (B) -10
• (C) -10.0
• (D) 10

Question 56:

Consider the given Python program and identify one possible output from the following options:

from random import *
Low = randint(2, 3)
High = randrange(5, 7)
for N in range(Low, High):
    print(N, end=' ')

• (A) 3 4 5
• (B) 2 3
• (C) 4 5
• (D) 3 4 5 6

Question 57:

Assuming all required modules have already been imported, identify the correct output of the following Python program segment:

Data = [4, 4, 1, 2, 4]
print(mean(Data), mode(Data))

• (A) 1 4
• (B) 2 1
• (C) 3 4
• (D) 4 3

Question 58:

Observe the Python code carefully and answer the following question:

def FUN(A):
    L = []
    for i in range(2, A):
        if (A % i == 0):
            L.append(i)
    print(L)

N = 10
FUN(N)

Identify the global identifier in the above code:

• (A) A
• (B) L
• (C) i
• (D) N

Question 59:

Observe the following Python program carefully.

import random

def DICE(Low=1, High=6):
    RND = random.randint(Low, High)
    print(RND, end=' ')

DICE()
DICE(2)
DICE(2,4)

Which of the following options cannot be an output of the above code?

• (A) 4 3 3
• (B) 4 1 3
• (C) 3 5 4
• (D) 6 4 3

Question 60:

Identify the output of the following Python code:

def EXP(N2):
    global N1
    N1, N2 = N1 + 5, N2 + 10
    print(N1, N2, end=' ')

N1 = 10
EXP(N1)
print(N1)

• (A) 10 20 15
• (B) 15 20 10
• (C) 15 20 15
• (D) 10 20 10

—

Question 61:

Which of the following modes, when used in the file opening statement in Python, generates an error if the file does not exist?

• (A) a+
• (B) r+
• (C) w+
• (D) a

Question 61:

Which of the following modes, when used in the file opening statement in Python, generates an error if the file does not exist?

• (A) a+
• (B) r+
• (C) w+
• (D) a

—

Question 62:

Consider the following Python command:

File = open('Myfile', 'a')

Which of the following option cannot be true?

• (A) ‘Myfile’ can be a text file
• (B) ‘Myfile’ can be a csv file
• (C) ‘Myfile’ can be a binary file
• (D) ‘Myfile’ will be created if not exist

—

Question 63:

Which of the following is not true for the Python command:

File = open('story.txt', 'a+')

• (A) More text can be written into ‘story.txt’
• (B) Content of the file ‘story.txt’ can be read.
• (C) Content of the file ‘story.txt’ can be modified.
• (D) Command generates an error, if the file ‘story.txt’ does not exist.

Question 64:

Consider the following Python program segment:

File = open('Poem.txt', 'r')
T = File.readline()

Identify the data type of T:

• (A) String (str)
• (B) List
• (C) Tuple
• (D) Dictionary

—

Question 65:

Name the Python module that needs to be imported to invoke the function?

• (A) csv
• (B) pickle
• (C) sql
• (D) binary

Question 66:

Examine the given Python program and select the purpose of the program from the following options:

F = open('story.txt', 'r+')
S = F.read()
S = S.upper()
F.seek(0)
F.write(S)
F.close()

What is the purpose of this program?

• (A) To count the uppercase alphabets present in the file
• (B) To convert all alphabets into uppercase in the file
• (C) To copy only the uppercase alphabets from the file
• (D) To remove all lowercase alphabets from the file

—

Question 67:

The seek() method is a method of which object/module?

• (A) csv module
• (B) pickle module
• (C) text module
• (D) file object

Question 68:

The csv module needs to be imported in a program to invoke or use which function?

• (A) write()
• (B) writerow()
• (C) writeline()
• (D) writelines()

—

Question 69:

Examine the given Python program and select the best purpose of the program from the given options:

File = open("Poem.txt", "r")
print(len(File.readline().split()))
File.close()

• (A) To count the number of words present in the file
• (B) To count the number of lines present in the file
• (C) To count the number of characters present in the file
• (D) To count the number of words present in the first line of the file

—

Question 70:

CSV files are comma-separated values saved as a ________.

• (A) text file
• (B) binary file
• (C) MySQL table
• (D) random file

Question 71:

The creator of the open-source Pandas package for data analysis in the Python programming language was ________.

• (A) Wes McKinney
• (B) Mc Pandas
• (C) John D. Hunter
• (D) Travis Oliphant

—

Question 72:

Which of the following is not a bundled package with Pandas?

• (A) Six
• (B) NumPy
• (C) Pytz
• (D) Statistics

—

Question 73:

Which of the following is equivalent to the and operator while using Boolean indexing on DataFrames?

• (A) &&
• (B) @
• (C) &
• (D) N

Question 74:

Find the output of the following Python code:

import Pandas as pd
M = pd.series({‘P’ : 10, ‘Q’ : 90})
print(M)

• (A) P Q
  10 90
• (B) P 10
  Q 90
• (C) 0 P 10
  1 Q 90
• (D) 10 P
  90 Q

P    10
Q    90
dtype: int64
  

76. Fill in the blanks with an appropriate command from the given options to produce the output shown on the right side of the following code:

1. D = pd.DataFrame(D, columns = A, index = B)
2. D = pd.DataFrame(D, rows = B, columns = A)
3. D = pd.DataFrame(D, B, i = A)
4. D = pd.DataFrame(A, B, D )

77. What will be the output of the following Python code?
import numpy as np
B= np.array([20, 50, 80, 30])
print(B, B.size, B.shape)

1. (20, 50, 80, 30) 4, (4,)
2. [20, 50, 80, 30] 4, (4,)
3. (20, 50, 80, 30) (4,) 4
4. [20, 50, 80, 30] (4,) 4

78. Which of the following will help us to read the content of a CSV file ITEMS.CSV as pandas DataFrame ?

1. IT-pandas.read(“ITEMS.CSV”)
2. IT pandas.readcsv(“ITEMS.CSV”)
3. IT-pandas.csv_read(“ITEMS.CSV”)
4. IT-pandas.read_csv(“ITEMS.CSV”)

79. Consider the following import command:
import matplotlib.pyplot as PLT
Which of the following command will help us to draw a line chart for given values?

1. PLT.line plot([100, 400, 200, 300])
2. PLT.plotline([100, 400, 200, 300])
3. PLT line([100, 400, 200, 300])
4. PLT.plot([100, 400, 200, 300])

80. Which of the following is DDL command ?

1. UPDATE SET
2. DELETE
3. DROP TABLE
4. INSERT INTO

81. Which of the following is DML command ?

1. INSERT INTO
2. DROP TABLE
3. CREATE TABLE
4. ALTER TABLE

82. An attribute or a set of attribute which are used to identify a tuple uniquely is known as :

1. Primary Key
2. Foreign Key
3. Alternate Key
4. Candidate Key

83. Which of the following is not a valid relational operator used in SQL ?

1. <=
2. <>
3. =>
4. =

84. Which of the following is using wrong syntax for a SELECT query in SQL?

1. SELECT * WHERE RNO>100 FROM STUDENT;
2. SELECT * FROM STUDENT WHERE RNO>100;
3. SELECT * FROM STUDENT WHERE RNO BETWEEN 100 AND 200;
4. SELECT * FROM STUDENT WHERE RNO IN (100,101,105,104);

85. Which of the following will be the correct SQL command to add a new column FEES in a table TEACHER ?

1. ALTER TABLE TEACHER
   ADD COLUMN FEES FLOAT;
2. ADD COLUMN FEES FLOAT
   INTO TEACHER;
3. UPDATE TEACHER
   ADD COLUMN FEES FLOAT;
4. INSERT INTO TEACHER
   ADD COLUMN FESS FLOAT;

86. Which of the following will display a list of tables in a database ?

1. DISPLAY TABLES;
2. SHOW TALES;
3. SELECT TABLES;
4. VIEW TABLES;

87. Which of the following will display information about all the employees from employee table, whose names contains second letter as “A” ?

1. SELECT * FROM EMPLOYEE WHERE NAME LIKE “_A%”;
2. SELECT * FROM EMPLOYEE WHERE NAME LIKE “%A_”;
3. SELECT * FROM EMPLOYEE WHERE NAME LIKE “_ _ A%”;
4. SELECT * FROM EMPLOYEE WHERE NAME = “_A%”;

88. Which of the following SQL command will help in incrementing values of FEES column in STUDENT table by 10% ?

1. UPDATE STUDENT ASSIGN FEES = FEES * 1.1;
2. UPDATE STUDENT SET FEES = FEES * 1.1;
3. UPDATE STUDENT SET FEES = FEES * 10%;
4. UPDATE STUDENT SET FEES 10%;

89. Which of the following is correct sequence in a SELECT query ?

1. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
2. SELECT, WHERE, FROM, GROUP BY, HAVING, ORDER BY
3. SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY
4. SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING

90. Consider the following tables and their respective degrees and cardinalities in a database called SCHOOL :

Select the degree and cardinality of the cartesian product of the tables STUDENT x TEACHER from the following options :

1. 30 7500
2. 200 325
3. 30 325
4. 200 7500

91. Which of the following set of functions is a valid set of aggregate functions in MySQL ?

1. AVG(), ROUND(), COUNT()
2. MIN(), UPPER(), AVG()
3. COUNT(), MAX(), SUM()
4. DATE(), COUNT(), LTRIM()

92. Find the output of the MySQL query based on the given Table-COACH (ignore the output header)

Query :
SELECT COUNT(GAME), AVG(SALARY) FROM COACH;

1. 3 70000
2. 4 35000
3. 4 70000
4. 3 35000

93. Find the output of the MySQL query based on the given Table – STUDENT (ignore the output header)

Query :
SELECT SEC, AVG (MARKS) FROM STUDENT GROUP BY SEC HAVING MIN (MARKS) > 80;

1. B 83
2. A 84
3. A 84
   B 83
4. A 83
   B 80

94. Consider the following tables in a database called SPORTS.
Database : SPORTS

Which is the best command from the following options to display the name of the player (PNAME) and their respective games (GNAME)

1. SELECT PNAME, GID FROM PLAYERS ;
2. SELECT PNAME, GAME FROM GAMES, PLAYERS
   WHERE GAMES.GID = PLAYERS.G1D ;
3. SELECT PNAME, GNAME FROM GAMES, PLAYERS;
4. SELECT PNAME, GNAME FROM GAMES, PLAYERS
   WHERE P.GID = G.GID;

95. Following are the two tables in a MySQL database.
Database : COMPARTMENT

Select the command from the following option to display subjects (SUBNAME) and number of students registered in that subject in table RESULT.

1. SELECT SUBNAME, COUNT(*)
   FROM SUBJECTS, RESULT GROUP BY SUBNAME ;
2. SELECT SUBNAME, COUNT(*)
   FROM SUBJECTS, RESULT ORDER B SUBNAME;
3. SELECT SUBNAME, COUNT(*)
   FROM SUBJECTS NATURAL JOIN RESULT ORDER BY SUBNAME;
4. SELECT SUBNAME, COUNT(*)
   FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;

96. To establish the Python-MySQL connection, connect() methods is used with certain parameters or arguments. Which of the following is not a parameter / argument used with connect() method ?

1. user
2. password
3. database
4. table

97. commit( ) is required to be used after the execution of certain queries in Python-MySQL connectivity applications. Identify one such MySQL command out of the following options :

1. CREATE
2. INSERT
3. SELECT
4. DROP

98. While working on Python-MySQL connectivity, fetchall( ) method is used to get data from table. The method fetchall( ) returns –

1. a list
2. a tuple
3. tuple of lists
4. list of tuples

99. The method cursor( ) is used in Python-MySQL connectivity applications. This method is a member of :

1. sql module
2. pickle module
3. database-connectivity module
4. csv module

100. Which of the following clause is used with SELECT command in MySQL to avoid duplication of output rows.

1. NO DUPLICATE
2. UNIQUE
3. DISTINCT
4. NO REPEAT