REVIEW OF PYTHON

Multiple Choice Questions

1. Which of the following is not a keyword?
a) Eval b) assert c) nonlocal d) pass
2. What is the order of precedence in python?
(i) Parentheses ii) Exponential iii) Multiplication iv) Division v) Addition vi)
Subtraction
a) i,ii,iii,iv,v,vi
b) ii,i,iii,iv,v,vi
c) ii,i,iv,iii,v,vi
d) i,ii,iii,iv,vi,v

3. What error occurs when you execute the following Python code snippet?
apple = mango
a) SyntaxError
b) NameError
c) ValueError
d) TypeError

4. Find the output.

def example(a):
a = a+2
a=a*2
return a
>>>example("hello")
a. indentation Error
b. cannot perform mathematical operation on strings
c. hello2
d. hello2hello2

5. What will be the value of X in the following Python expression?

X = 2+9*((3*12)-8)/10

a) 30.0
b) 30.8
c) 28.4
d) 27.2

6. Select all options that print. hello-how-are-you

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 1
 a. print(‘hello’, ‘how’, ‘are’, ‘you’)
b. print(‘hello’, ‘how’, ‘are’, ‘you’ + ‘-‘ * 4)
c. print(‘hello-‘ + ‘how-are-you’)
d. print(‘hello’ + ‘-‘ + ‘how’ + ‘-‘ + ‘are’ + ‘you’)

7. Which of the following can be used as valid variable identifier(s) in Python?

a. total
b. 7Salute
c. Que$tion
d. global

8. Which of the following statement is correct for an AND operator?

a) Python only evaluates the second argument if the first one is False
b) Python only evaluates the second argument if the first one is True
c) Python only evaluates True if any one argument is True
d) Python only evaluates False if any one argument is False

9. Which of the following forces an expression to be converted into specific type?

a) Implicit type casting b) Mutable type casting
c) Immutable type casting d) Explicit type casting
10. Which point can be considered as difference between string and list?
a. Length c. Indexing and Slicing
b. Mutability d. Accessing individual elements

11. Which of the following statement is true for extend () list method?
a) adds element at last c) adds multiple elements at last
b) adds element at specified index d) adds elements at random index

12. The statement del l[1:3] do which of the following task?

a) delete elements 2 to 4 elements from the list
b) delete 2nd and 3rd element from the list
c) deletes 1st and 3rd element from the list
d) deletes 1st, 2nd and 3rd element from the list

13. If l=[11,22,33,44], then output of print(len(l)) will be

a) 4 b)3 c) 8 d) 6

14. Which of the following method is used to delete element from the list?
a)del()
b) delete()
c)pop()
d)All of these
15. The step argument in range() function .
a. indicates the beginning of the sequence

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 32
 b. indicates the end of the sequence
c. indicates the difference between every two consecutive numbers in the sequence
d. generates numbers up to a specified value

Answers of MCQ:
1) A 2)A 3)B 4)A 5)D 6)C 7)A 8)B 9) D 10)B 11)B 12)B 13)A 14)C
15)C

Very Short Answer Type Questions

1. Give the output of the following

Sum = 0
for k in range(5):
Sum = Sum+k
print(Sum)

2. Give the output of the following

Sum = 0
for k in range(10 , 1, -2):
Sum = Sum+k
print(Sum)

3. Give the output of the following

for k in range(4):
for j in range(k):
print(‘*’, end = ‘ ‘)
print()

4. Give the output of the following

for k in range(5,0, -1):

for j in range(k):
print(‘*’, end=’ ‘)
print()

5. How many times the following loop will execute? Justify your answer
A=0
while True:
print(A)
A =A+1
6. Give the output of the following. Also find how many times the loop will execute.

A=0
while A<10:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 33
 print(A, ‘ , ‘)
A =A+1

7. Give the output of the following. Also find how many times the loop will execute.
A=0
while A<10:
print(A, ‘ , ‘)
A =A+1
print(‘\n’, A)

8. Give the output of the following

T = (5)
T = T*2
print(T)

9. Give the output of the following

T = (5, )
T = T*2
print(T)

10. What kind of error message will be generated if the following code is executed
A=5
B = ‘hi’
d = A+B
print(D)

11. Give the output of the following

L = [1,2,3,4,5,6,7,8,9]
print(L[:])

12. Give the output of the following

L = [1,2,3,4,5,6,7,8,9]
print(L[: -1])

13. Find the output of the following

S = ‘abcdefgh’
L = list(S)
print(L[1:4])

14. Give the output of the following

L = [1,2,3,4,5,6,7,8,9]
print(L.count(2))
print(L.index(2)

15. Write python code to sort the list, L, in descending order.

16. Give the output of the following

x=[4,5,66,9]
y=tuple(x)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 34
 print( y)

Answers for VSA Questions

1)10
2)30
3)
*
* *
* * *

4) * * * * *
****
** *
**
*
5) infinite loop. Condition / test expression is always Ture.

6) 0,1,2,3,4,5,6,7,8,9

7) 0,1,2,3,4,5,6,7,8,9
10

8) 10 Note: here T is an integer

9) (5, 5), Note: here T is tuple

10)TypeError

11) [1,2,3,4,5,6,7,8,9]

12) [1,2,3,4,5,6,7,8]

13) ['b', 'c', 'd']

14) 1
1

15) L.sort(reverse= True)

16) (4, 5, 66, 9)

Short Answer Type Questions

1. Consider the following dictionary ‘D’. Display all the items of the dictionary as
individual tuple
D = ,‘A’: 20, ‘B’: 30, ‘C’:40. ‘D’: 50}

2. Write Python code to remove an element as entered by the user form the list, L

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 35
 3. Create a list k, by selecting all the od numbers within the given range, m and n. User
will input the values of m , n at run time

4. Write Python code to create and add items to a dictionary. Ask the user to input key
value pairs. Continue as long as the user wishes.

5. Write Python code to find whether the given item is present in the given list using for
loop.
6. Create a list, L, with the squares of numbers from 0 to 10

7. Mr. Rahul wants created a dictionary to store the details of his students and to
manipulate thedata.
He wrote a code in Python, help him to complete the code:

studentDict = ______# stmt 1

n = int(input("How Many Students you Want To Input?"))
for i in range( ): # stmt 2 - to enter n number of students data
rollno = input("Enter Roll No:")
name = input("Enter Name:")
physicsMarks = int(input("Enter Physics Marks:"))
chemistryMarks = int(input("Enter Chemistry Marks:"))
mathMarks = int(input("Enter Maths Marks:"))
studentDict[rollno]= __________ # stmt 3

Answers /Hints: Short answer Type Questions.

1) for k in D.items():
print(k)

2) a =int(‘input the item to be deleted’)

l.remove(a)

3) m = int(input(‘lower limit’))
n = int(input(‘upper limit’))
n = n+1
L = [x for x in range(m, n) if x%2!=0]
4)
D={}
while Ture:
K = input(‘type a key’)
V = int(input(‘type the value’)
D[K] = V
C = input(‘type ‘y’ to add more’)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 36
 if C!=’y’:
break
5) flag = 0
L = eval(input(‘input a list on numbers’))
E = int(input(‘item to be searched’)
K =len(L)
for p in range(K):
if E ==L(p):
flag = 1
print(‘found and index is ‘,p)
if flag==0:
print(‘not found’)
6)
list1=[]
for x in range(10):
list1.append(x**2)
list1
Output:
[0, 1, 4, 9, 16, 25, 36, 49, 64, 81]
OR
list1=list(map(lambda x:x**2, range(10)))
7)
Statement 1 : StudentDict = dict( )
Statement 2 = for i in range( n ):
Statement 3: studentDict[rollno]=[name, physicsMarks, chemistryMarks, mathMarks]

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 37
 FUNCTIONS
Practice Questions
1 Which of the following is a valid function name?
a) Start_game() b) start game() c) start-game() d) All of the above
2 If the return statement is not used in the function then which type of value will be
returned by the function?
a)int b) str c) float d) None
3 Richa is working with a program where she gave some values to the function. She
doesn’t know the term to relate these values. Help her by selecting the correct option.
a) function value b) arguments or parameters
c) return values d) function call
4 What is the minimum and maximum value of c in the following code snippet?
import random
a=random.randint(3,5)
b = random.randint(2,3)
c=a+b
print(c)

a) 3 , 5 b) 5, 8 c) 2, 3 d) 3, 3
5 In python function, the function calling another function is known as
and the function being called is
known _ _

a) main, keyword b) caller, called

c) called, caller d) executer, execute
6 What will be the output of the following code?

print(“100+200”)

a) 300 b) 100200 c) 100+200 d) 200

7 pow( ) function belongs to which library ?

a) math b) string c) random d) maths

8 What data type is the object below?

L = (1, 23, ‘hello’,1)

a) list b) dictionary c) array d) tuple

9 What is returned by int(math.pow(3, 2))?

a) 6 b) 9 c) error, third argument required d) error, too many arguments

10 Which of the following is not a type conversion functions?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 38
 a) int() b) str() c) input() d) float()

11 Write the output of the following:

print(float())

12 Identify the module to which the following function load () belong to?

a) math b) random c) pickle d) sys

13 How many argument(s) a function can receive

a) Only one b) 0 or many c) Only more than one d) At least one

14 Give the output

def fun():
global a
a=10
print(a)
a=5
fun()
print(a)
a) 10 b) 5 c) 5 d) 10
10 10 5 5
15 Value returning functions should be generally called from inside of an expression

a) True b) False

16 The variable declared inside the function is called a variable

a) global b) local c) external d) none of the above

17 These are predefined functions that are always available for use. For using them we
don’t need to import any module

a) built in function b) pre-defined function

c) user defined function d) none of the above
18 The of a variable is the area of the program where it may be referenced

a) external b) global c) scope d) local

19 If you want to communicate between functions i.e. calling and called statement,
then you should use
a) values b) return c) arguments d) none of the above

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 50
 20 Which of the following function header is correct?
a) def mul(a=2, b=5,c) b) def mul(a=2, b, c=5)
c) def mul(a, b=2, c=5) d) def mul(a=2, b, c=5)
21 Find the flow of execution of the following code:
1. def calculate (a, b):
2. res=a**b
3. return res
4.
5. def study(a):
6. ans=calculate(a,b)
7. return ans
8.
9. n=2
10. a=study(n)
11. print(a)
a) 1 > 5 > 9 > 10 >6 > 2 > 3 > 7 > 11 b) 5 > 9 > 10 > 6 > 2 > 3 > 7 > 11
c) 9 > 10 > 5 > 1 > 6 > 2 > 3 > 7 > 11 d) None of the above

22. Python resolves the scope of a name using the LEGB rule
a) True b) False

23 A void function internally returns legal empty value

a) None b) Close() c) Return d) all

24 When you use multiple type argument in function, then default argument take place

a) at beginning b) at end c) anywhere d) none of the above

25 A can be skipped in the function call statements

a) named parameter b) default parameter
c) keyword parameters d) all of the above

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 51
 ANSWERS
1 a)Start_game()

2 d) None
3 b) arguments or parameters
4 b) 5, 8
5 b) caller, called

6 c) 100+200
7 a) math
8 d) tuple
9 b) 9

10 c) input()

11 b) 0.0
12 c)pickle
13 b) 0 or many

a) 10
14
10

15 a) True

16 b) local
17 a) built in function

18 c) scope

19 c) arguments

20 c) def mul(a, b=2, c=5)

21 a) 1 > 5 > 9 > 10 >6 > 2 > 3 > 7 > 11

22 a) True

23 a) None

24 b) at end

25 b) default parameter

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 52
 QUESTIONS

1. What is the output of the following code?

def cube(x):
return x * x * x
x = cube(3)
print( x)
a) 9 b)3 c)27 d) 30
Ans. C)
27
2 Which of the following items are present in the function header?
a) function name
b) parameter list
c) return value
d) Both A and B
Ans.d
Both A and B
3 Choose correct answer
def fun1(num):
return num+5
print(fun1(5))
print(num)
a) Print value 10 b) Print value 5 c) Name Error d) 25
Ans c)Name Error
4. Predict the output of the following code
def func1(list1):
for x in list1:
print(x.lower(),end="#")
func1(["New","Dehli"])
A. [New,Dehli]
B. new#dehli#
C. newdehli#
D. New#Dehli#
Ans. B)new#dehli#
5. What will be the output of the following python code?
def mul (num1, num2):
x = num1 * num2
x = mul(20,30)
A. 600 B. None C. No Output D. 0
Ans. C)No Output

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 53
 6 Which of the following function header is Correct:
A. def fun(x=1,y)
B. def fun(x=1,y,z=2)
C. def fun(x=1,y=1,z=2)
D. def fun(x=1,y=1,z=2,w)
Ans.c) def fun(x=1,y=1,z=2)
7 What is the output of the program given below?
x = 50
def func (x) :
x=2
func (x)
print ('x is now', x)
A) x is now 50 B) x is now 2 C) x is now 100 D) Error
Ans. A)
A) x is now 50
8 Choose the correct output from the options given below.
print(‘Welcome!’)
print(‘Iam’, name ) # is double underscore
a) Welcome! b) Error
Iam main
c) Welcome! d)None of these
Iam name
Ans. a)Welcome!
Iam main
9 Predict the output of the following code fragment
def update(x=10):
x+=15
print("x=",x)
x=20
update()
print("x=",x)
a) x=20 b) x=25
x=25 x=25
c) x=20 d) x=25
x=25 x=20
Ans. d)
x=25
x=20

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 54
 10 Predict the output of the following code fragment
def display(x=2,y=3):
x=x+y
y+=2
print(x,y)
display( )
display(5,1)
display(9)
a) 5 5 b)12 5
63 63
12 5 55

c) 5 6 d) 5 5
12 5 7 7
63 6 6
Ans. a)
55
63
12 5
11 Find the output print(pow(5,4,9))
a) 7 b)0 c)4 d) error
Ans. C) 4
Hint: pow(x, y, z) is equal to xy % z
Give the output of the following program
12 def check(a):
for i in range(len(a)):
a[i]=a[i]+5
return a
b=[1,2,3,4]
c=check(b)
print(c)
a) [6, 8, 8, 9] b) [6,7,8,9]
c) [7, 7, 8, 9] d) [6,7,9,9]
Ans. b) [6, 7, 8, 9]
13 Give the output
def abc(x,y=60):
return x+y
a=20

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 55
 b=30
a=abc(a,b)
print(a,b)
b=abc(a)
print(a,b)
a=abc(b)
print(a,b)

a) 50 30 50 110 170 b) 30 50 110 170 110

c) 50 30 d) 50 30 50 110 170 110
50 110
170 110
Ans.C)
c) 50 30
50 110
170 110
14
Predict the output of the following code snippet:
def Execute(M):
if M%3==0:
return M*3
else:
return M+10;
def Output(B=2):
for T in range (0,B):
print(Execute(T),"*",end="")
print()
Output(4)
Output()
Output(3)

Ans.
0 *11 *12 *9 *
0 *11 *
0 *11 *12 *

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 56
 15. Find the output of the following program:

def ChangeIt(Text,C):

T=""
for K in range(len(Text)):

if Text[K]>='F' and Text[K]<='L':

T=T+Text[K].lower();

elif Text[K]=='E' or Text[K]=='e':

T=T+C;

elif K%2==0:

T=T+Text[K].upper()

else:

T=T+T[K-1]

print(T)

OldText="pOwERALone"

ChangeIt(OldText,"%")

(a) PPW%RRLLN% (b) PPWCRRllNC

(c) PPW%RRllN% (d) PpW%RrllN%

Ans: c)

PPW%RRllN%
16 What possible outputs are expected to be displayed on screen at the time of execution
of the program from the following code? Also specify the maximum value that can be
assigned to each of the variables L and U.
import random
Arr=[10,30,40,50,70,90,100]
L=random.randrange(1,3)
U=random.randrange(3,6)
for i in range(L,U+1):
print(Arr[i],"@",end="")

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 57
 i) 40 @50 @ ii) 10 @50 @70 @90 @
iii) 40 @50 @70 @90 @ iv) 40 @100 @
Ans. Options i and iii
i)40 @50 @

iii) 40 @50 @70 @90 @

Maximum value of L and U

L=2 ,U=5
17 Find the output of the following code

def disp(str):
m=' '
for i in range(0,len(str)):
if(str[i].isupper()):
m=m+str[i].lower()
elif str[i].islower():
m=m+str[i].upper()
else:
if i%2==0:
m=m+str[i-1]
else:
m=m+"@"
print(m.swapcase())
disp('StudyBag$2021')
a) StudyBagG@2@2 b) sTUDYbAGg@2@2 c) StudyBagG$2$2 d) None
Ans : a)
StudyBagG@2@2
Note: The swapcase() method returns a string where all the upper case letters are
lower case and vice versa. Syntax. string.swapcase().
18 What will be the output of the following code

total=0
def add(a,b):
global total
total=a+b
print(total)
add(6,6)
print(total)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 58
 a) 12 b) 12 c) 0 d) None of these
12 0 12
Ans : a)
12
12
19 Find and write the output of the following Python code:

def makenew(mystr):
newstr = " "
count = 0
for i in mystr:
if count%2 ==0:
newstr = newstr+i.lower()
else:
if i.islower():
newstr = newstr+i.upper()
else:
newstr = newstr+i
count +=1
newstr = newstr+mystr[:3]
print ("The new string is :", newstr)
makenew("cbseEXAMs@2022")

Ans. The new string is :

cBsEeXaMs@2022cbs
20 What possible output(s) are expected to be displayed on screen at the time of
execution of the following code? Also specify the maximum and minimum value that
can be assigned to variable X.

import random
L=[10,7,21]
X=random.randint(1,2)
for i in range(X):
Y=random.randint(1,X)
print(L[Y],"$",end=" ")

(i)10 $ 7 $ (ii) 21 $ 7 $ (iii) 21 $ 10 $ (iv) 7 $

Ans. iv) 7 $
Maximum value of x is 2

Minimum value of x is 1

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 59
 21 Choose the correct option:

Statement1: Local Variables are accessible only within a function or block in which it
is declared.

Statement2: Global variables are accessible in the whole program.

a. Statement1 is correct but Statement2 is incorrect

b. Statement2 is correct but Statement1 is incorrect
c. Both Statements are Correct
d. Both Statements are incorrect
Ans.c) Both Statements are Correct
22 Consider the following code and choose correct answer:
def nameage(name, age):
return [age,name]
t=nameage('kishan',20)
print(type(t))

a) tuple b) list c) (kishan,20) d) None of all

Ans : b)
23 Write the output of the following:

a=(10, 12, 13, 12, 13, 14, 15)

print(max(a) + min(a) + a.count(2))

a) 13 b) 25 c) 26 d) Error
Ans : b) 25

24 Consider the code given below and Identify how many times the message “Hello
All” will be printed.

def prog(name):
for x in name:
if x.isalpha():
print('Alphabet')
elif x.isdigit():
print('Digit')
elif x.isupper():
print('Capital Letter')
else:
print('Hello All')
prog('[email protected]')

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 60
 a) 0 b) 2 c) 1 d) 3
Ans: b) 2

25 Find and write the output of the following Python code:

def changer(p,q=10):
p=p/q
q=p%q
print(p,"#",q)
return p
a=200
b=20
a=changer(a,b)
print(a,"$",b)
a=changer(a)
print(a,"$",b)
Ans.
10.0 # 10.0
10.0 $ 20
1.0 # 1.0
1.0 $ 20
26 What will be the output for the below code snippet?

def div(lst,n):
for i in range(0,n):
if lst[i]%5==0:
lst[i]+=5
else:
lst[i]=lst[i]//2
lt=[45,20,23,54,5]
div(lt, len(lt))
for i in lt:
print(i,end='#')
a) 50#25#11.5#27.0#10# b) 50#25#11#27#10#
c) 50#25#1#0#10# d) 225#100#1#0#25#
Ans: b) 50#25#11#27#10#

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 61
 DATA FILE HANDLING
SAMPLE PROGRAMS
1. Write a program to write roll no and name to xiib.txt

2. Write read contents from story.txt and count no: of independent words
“to” in the file

3. is the return type of readline()

Ans: string

PRACTICE QUESTIONS
1. Write a program to read contents from the text file story.txt and count no:of
vowels in it
2. Write a program to read contents from the text file myfile.txt and find average
word count
3. Write a program to read contents from the text file library.txt and count “is” as
independent word
4. Write a program to read contents from the text file diary.txt and count number of
lines with Starting letter “T” or “M”
5. Write a program to read contents from the text file mydiary.txt and count number
of lines with ending letter “r”

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 62
8
 MULTIPLE CHOICE QUESTIONS
1. If a text file is opened in w+ mode, then what is the initial position of file
pointer/cursor?
a. Beginning of file
b. End of the file
c. Beginning of the last line of text file
d. Undetermined

2. Which of the following statements are true?

a. When you open a file for reading, if the file does not exist, an error occurs
b. When you open a file for writing, if the file does not exist, a new file is created
c. When you open a file for writing, if the file exists, the existing file is overwritten
with the new file
d. All of the mentioned

3. To read the entire remaining contents of the file as a string from a file object
myfile, we use
a. myfile.read(2)
b. myfile.read()
c. myfile.readline()
d. myfile.readlines()

4. A text file is opened using the statement f = open(‘story.txt’). The file has a total
of 10 lines. Which of the following options will be true if statement 1 and statement 2
are executed in order.
Statement 1: L1 = f.readline( )
Statement 2: L2 = f.readlines( )
a. L1 will be a list with one element and L2 will be list with 9 elements.
b. L1 will be a string and L2 will be a list with 10 elements.
c. L1 will be a string and L2 will be a list with 9 elements.
d. L1 will be a list with 10 elements and L2 will be an empty list.

5. Which function of a file object can be used to fetch the current cursor position in
terms of number of bytes from beginning of file?
a. seek( )
b. bytes( )
c. tell( )
d. fetch( )

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 69
 6. What will be the output of the following code?
f = open(‘test.txt’, ‘w+’)
L = *‘First Line\n’, ‘Second Line\n’, ‘Third Line’+
f.writelines(L)
f.flush()
f.seek(0)
O = f.readlines()
print(len(O))

a. 33
b. 31
c. 28
a.3

7. The contents of a text file named ‘quote.txt’ is as shown below:

What will be the output of the following code?

fin = open('fracture.txt’)
data = fin.read(10)
print(data*0:3+, end= ‘’)
data = fin.readline(5)
print(data[0:3] , end= ‘’)
fin.seek(0)
data = fin.read(4)
print(data[0:3] , end= ‘’)

a. AllngsAll
b. AllcanAll
c. Allcancan
d. Allngscan

8. What will be the most correct option for possible output of the following code,
given that the code executes without any error.
f = open(‘cricket.txt’)
data = f.read(150)
print(len(data))

a. It will always be 150

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 70
 b. 151
c. More than or equal to 150
d. Less than or equal to 150

9. For the following python code, what will be the datatype of variables x, y, z given
that the code runs without any error?
f = open(‘story.txt’)
x = f.read(1)
y = f.readline()
z = f.readlines()
a. string, list, list
b. None, list, list
c. string, string, list
d. string, string, string

10. The contents of a text file named ‘fracture.txt’ is as shown below:

What will be the output of the following code?

fin = open('fracture.txt’)
x=0
for line in fin:
words = line.split( )
for w in words:
if len(w)>x:
x = len(w)
print(x)

a. 12
b. 11
c. 13
d. 10

Answers:
1. a. Beginning of file
2. d. All of the mentioned
3. b. myfile.read()
4. c. L1 will be a string and L2 will be a list with 9 elements.
5. c. tell( )

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 71
 6. d. 3
7. a. AllngsAll
8. d. Less than or equal to 150
9. c. string, string, list
10. a. 12

VERY SHORT ANSWER TYPE QUESTIONS

1. Differentiate between file modes r+ and w+ with respect to python?
Ans: r+ opens a text file for reading and writing.
w+ opens a text file for reading and writing. It overwrites the file if it exists, create a file
if it doesn’t.
2. Write a statement in Python to open a text file “ABC.TXT” in reading mode.
Ans: F=open("ABC.TXT","r")
3. In files each line terminates with EOL or ‘\n’ or carriage return, or
‘\r\n’.
Ans: Text File
4. Observe the following code and answer the questions that follow.
File=open(“MyData”,”a”)
#Blank1
File.close()
a) What type (text/binary) of file is MyData ?
b) Fill the Blank1 with statement to write “ABC” in the file “Mydata”
Ans: a) Text File

b) File.write(“ABC”)

5. What are files?

Ans: A named entity, usually stored on a hard drive that contains a stream of
characters are called files.

2 SHORT ANSWER TYPE QUESTIONS

1. Explain seek() method in python.
In Python, seek() function is used to change the position of the File Handle to a given
specific position.
Syntax: fi.seek(offset, from_where), where fi is the file pointer

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 72
 Offset: This is used for defining the number of positions to move forward.
from_where: This is used for defining the point of reference. It can take
0: beginning of the file. 1: current position of the file. 2: end of the file.

2. Write a function in Python that counts the number of “the” or “this” words
present in a text file “myfile.txt”.
Example: If the “myfile.txt” contents are as follows:
This is my first class on Computer Science. File handling is the easiest topic for me
and Computer Networking is the most interesting one.
The output of the function should be: Count of the/this in file: 3

Answer:
def displayTheThis():
num=0
f=open("myfile.txt","r")
N=f.read()
M=N.split()
for x in M:
if x=="the" or x== "this":
print(x)
num=num+1
f.close()
print("Count of the/this in file:",num)

3. Write a function countVowels() in Python, which should read each character of

a text file “myfile.txt”, count the number of vowels and display the count.
Example: If the “myfile.txt” contents are as follows:
This is my first class on Computer Science.
The output of the function should be: Count of vowels in file: 10
Answer:
def countVowels():
fobj = open(“myfile.txt”)
data = fobj.read()
count = 0
vowels=*‘a’,’e’,’I’,’o’,’u’+
for ch in data:
if ch in vowels:
count +=1
print(“Count of vowels in file:”, count)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 73
 4. Write a Python program to count all the line having 'a' as last character.
Answer:

count =0
f=open('fracture.txt',"r")
data=f.readlines()
for line in data:
if line[-2] == 'a':
count=count+1
print("Number of lines having 'a' as last character is/are : " ,count)

f.close()

5. Assume that a text file named TEXT1.TXT already contains some text written into
it, write a program with a function named vowelwords(),that reads the file TEXT1.TXT
and create a new file named TEXT2.TXT ,which shall contain only those words from the
file TEXT1.TXT which don’t start with an uppercase vowel(i.e. with ‘A’,’E’,’I’,’O’,’U’) ,
for example if the file TEXT1.TXT contains
Carry Umbrella and Overcoat When it Rains
then the file TEXT2.TXT shall contain
Carry and when it Rains.

Answer:

def vowelwords ():

file1=open('TEXT1.txt','r')
file2=open('TEXT2.txt','w')
text = file1.read()
text=text.split()
vowels=['A','E','I','O','U']
for i in text:
if i[0] not in vowels:
file2.write(i)
file2.write(" ")
file1.close()
file2.close()
vowelwords()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 74
 BINARY FILES
Operations on binary file
 Writing data into binary file
 Searching of data
 Modifying data
 Deleting data
 Appending data

try and except block

pickle.load() can generate runtime exceptions like EOFError. try and except
block will handle runtime errors raised due to EOF (end of file) .In try block write all the
statements that can generate an exception and in except block write code to handle the
exception.

Writing data into binary file

Write a program to write contents to a binary file stud.dat with record format
[rollno,name,marks]

Searching of data from binary file

Write a program to read contents from the file stud.dat and display those
records whose marks >90. Assume stud.dat existing in the system with the record
format [rollno,name,marks]

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 75
6
 Deleting data from a binary file

Write a program to read contents from the file stud.dat and delete those records whose
marks <90. Assume stud.dat existing in the system with the record format
[rollno,name,marks]
Below program is implemented using function and module os is used to use functions
like rename() and remove()

Updating /Modifying data in a binary file

Write a program to update records in the file stud.dat with records in the format
[rollno,name,marks].Increase 10 marks to the student whose rollnumber entered by
the user

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 77
 Appending data in to a binary file
Write a program to append records into the file stud.dat with records in the format
[rollno,name,marks]

Opening a file using with statement

In Python, we can also open a file using with statement.

The syntax of with statement is:

with open (file_name, access_mode) as file_object:

The with statement is a compact statement which combines the opening of file ,
processing of file along with inbuilt exception handling.The with statement will also close
the file automatically after with block is over.

with open(“myfile.txt”,”r+”) as myObject:

content = myObject.read()

Here, we don’t have to close the file explicitly using close() statement. Python
will automatically close the file.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 78
 SAMPLE QUESTIONS

1. A binary file “employees.dat” has structure [empid, empname, age, department]

a. Write a user defined function CreateEmployee() to input the data to a

record and add to employee.dat
b. Write a function CountRec(department) in Python which accepts the
Department of the employee as the parameter and count and return the
number of employees in that department.

PRACTICE QUESTIONS

1. A binary file “STUDENT.DAT” has structure *admission_number, Name, Percentage+.

Write a function countrec() in Python that would read contents of the file
“STUDENT.DAT” and display the details of those students whose percentage is above 75.
Also display number of students scoring above 75%.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 79
 2. A binary file “students.dat” has structure (admission_number, Name, Percentage,
subject). Write a function countrec() in Python that would read contents of the file and
display the details of those students whose subject is “Biology” and percentage is below
45%. Also display the number of such students

3. A binary file “STOCK.DAT” has structure [ITEMID, ITEMNAME, QUANTITY, PRICE].

(i) Write a user defined function MakeFile( ) to input data for a record and add to
Book.dat.
(ii) Write a function GetPrice(ITEMID) in Python which accepts the ITEMID as
parameter and return PRICE of the Item stored in Binary file STOCK.DAT
4. A binary file “EMPLOYEE.DAT” has structure (EMPID, EMPNAME, SALARY). Write a
function CountRec( ) in Python that would read contents of the file “EMPLOYEE.DAT”
and display the details of those Employees whose Salary is above 20000. Also display
number of employees having Salary more than 20000.
5. A binary file “Computers.dat” has structure [CNo, Make, Model, Price].
The description is given below:

CNo : Computer Number e.g. 278548

Make : Make of PC e.g. HP
Model : Model Number e.g. VXPC126
Price : Price of computer e.g.40258.99

i) Write a user defined function CreatePC() to input data for a record and append in
Computers.dat .
ii. Write a function FindPCs(Price) in Python which accepts the Price as parameter and
display only those computer records from Computers.dat which are having less than or
equal to given price.

Multiple Choice Questions

1. Which of the following statements is true?

a. load method of pickle module gives error if EOF is reached
b. load method of pickle module returns an empty string is EOF is reached
c. load method of pickle module returns -1 if EOF is reached
d. None of the above

2. Shylesh is writing python code to append a new record to a binary file ‘salary.dat’
that is storing list objects containing [empid, empname, salary]. Consider the
following code written by him.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 80
 import pickle
f = open(‘salary.dat’, ‘ab’)
id = input(“Enter employee id : ”)
name = input(“Enter name of employee: ”)
sal = float(input(“Enter salary :”))
record = _ #Blank 1
pickle.dump(record,f)
f.close()

Identify the missing part of Blank 1.

a. [id,name,sal]
b. id, name, sal
c. [empid, empname, salary]
d. empid, empname, salary

3. Which is the valid syntax to write an object onto a binary file opened in the write
mode?
a. pickle.dump(<object to be written>, <file handle of open file>)
b. pickle.dump(<file handle of open file>, <object to be written>)
c. dump.pickle(<object>, <file handle>)
d. None of the above

4. What is the binary file mode associated with “ file must exist, otherwise error will
be raised and reading and writing can take place”.
a. wb+
b. w+
c. rb
d. rb+

5. Rahul is trying to write a tuple t = (10,20,30,40,50) on a binary file

notebook.bin. Consider the following code written by him.
import pickle #statement 1
t = (10,20,30,40,50) #statement 2
myfile = open("notebook.bin",'w') #statement 3
pickle.dump(t, myfile) #statement 4

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 81
 myfile.close()

Which of the following statement contains an error?

a. Statement 1
b. Statement 2
c. Statement 3
d. Statement 4

6. A binary file “salary.dat” has structure [employee id, employee name, salary].
What the following code will display:
def records():
num=0
fobj=open("data.dat","rb")
try:
print("Emp id\tEmp Name\tEmp Sal")
while True:
rec=pickle.load(fobj)
if rec[2]< 20000:
print(rec[0],"\t\t",rec[1],"\t\t",rec[2])
except:
fobj.close()
records()

a. Display the details of those employee whose salary is above 20000.

b. Display the details of all the employees.
c. Display the salaries of all the employees.
d. Display the details of those employees whose salary is less than 20000.

7. In which file, no delimiters are used for line and no translations occur?
(a) Text file
(b) Binary file
(c) csv file
(d) None of the above

8. Choose the file mode used to write data into binary file.

(a) rb
(b) wb
(c) r+
(d) w+

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 82
 9. Which of the following function is used to read data from a binary file?

(a) write
(b) load
(c) dump
(d) scan

10. Dima is trying to read a list l1 from a binary file ‘num’. Consider the following
code written by her.

import pickle

f1 = open("num",'rb')

l1= _________________ #Statement 1

print(l1)

f1.close()

Identify the missing code in Statement 1.

(a) pickle.load(f1)

(b) pickle.load(l1,f1)

(c) pickle.read(f1)

(d) pickle.dump(l1,f1)

Answers:

a.load method of pickle module gives error if EOF is reached

a.[id,name,sal]

a. pickle.dump(<object to be written>, <file handle of open file>)

d. rb+

c. Statement 3

d.Display the details of those employees whose salary is less than 20000.

(b) Binary file

(b) wb

(b) load

(a) pickle.load(f1)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 83
 CASE STUDY QUESTIONS
Amit Kumar of class 12 is writing a program to store roman numbers and find their
equivalents using a dictionary. He has written the following code. As a programmer,
help him to successfully execute the given task.

import ________________________________ #Line 1

numericals = {1: ‘I’, 4 : ‘IV’, 5: ‘V’ , 9: ‘IX’, 10:’X’, 40:’XL’,50:’L’, 90:’XC’,
100:’C’,400:’CD’,500:’D’,900:’CM’,1000:’M’-

file1 = open(“roman.log”,” ”) #Line 2

pickle.dump(numerals,file1)
file1.close()
file2 = open(“roman.log”,’ ”) #Line 3
num = pickle.load(file2)
file2. #Line 4
n=0
while n!=-1:
print(“Enter 1,4,5,9,10,40,50,90,100,400,500,900,1000:”)
print(“or enter -1 to exit”)
n = int(input(“Enter numbers”))
if n!= -1:
print(“Equivalent roman number of this numeral is:”,num*n+)
else:
print(“Thank You”)

(a) Name the module he should import in Line 1.

(b) In which mode, Amit should open the file to add data into the file in Line #2
(c) Fill in the blank in Line 3 to read the data from a binary file.
(d) Fill in the blank in Line 4 to close the file.
(e) Write the output he will obtain while input is 100.

Answers:

(a) pickle
(b) wb
(c) rb
(d) file2.close()
(e) C

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 84
 LONG ANSWER QUESTIONS

1. A binary file “emp.dat” has structure [EID, Ename, designation, salary].

I. Write a user defined function CreateEmp() to input data for a record and add to emp.dat.
II. Write a function display() in Python to display the detail of all employees.
Answer:

I.

import pickle
def CreateEmp():
f1=open("emp.dat",'wb')
eid=input("Enter E. Id")
ename=input("Enter Name")
designation=input("Enter Designation")
salary=int(input("Enter Salary"))
l=[eid,ename,designation,salary]
pickle.dump(l,f1)
f1.close()
II.

import pickle
def display():
f2=open("emp.dat","rb")
while True:
try:
rec=pickle.load(f2)
print(rec['eid'],rec['ename'],rec['designation'],rec['salary'])
except EOFError:
break
f2.close()
2. A binary file “emp.DAT” has structure [EID, Ename, designation,salary].

I. Write a function to write more items in emp.dat.

II. Write a function Show() in Python that would read detail of employee from file “emp.dat” and

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 85
 display the details of those employee whose designation is “Manager”.

I)

import pickle
def createemp():
f1=open("emp.dat",'ab')
eid=input("Enter E. Id")
ename=input("Enter Name")
designation=input("Enter Designation")
salary=int(input("Enter Salary"))
l=[eid,ename,designation,salary]
pickle.dump(l,f1)
f1.close()
II) def Show():

f2=open("emp.dat","rb")
while True:
try:
rec=pickle.load(f2)
if (rec['designation']=='Manager'):
print(rec['eid'],rec['ename'],
rec['designation'],rec['salary'])
except EOFError:
break
f2.close()
3. A binary file “employee.dat” has structure [ empId, empName , Dept, Salary].
(i) Write a user defined function addData() to input data for a record and add tp
employee.dat
(ii) Write a function checkSalary(empName) in Python which accepts the empName as
parameter and return the salary of particular employee by the given employee name stored
in the file employee.dat
(i)
import pickle
def addData():

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 86
 fobj=open("employee.dat","ab")
empID=int(input("Enter Emp ID : "))
empName=input("Employee Name :")
Dept = input(“Department: “)
Salary = int(input("Monthly Salary : "))
rec=[ empId, empName , Dept, Salary]
pickle.dump(rec,fobj)
fobj.close()
(ii)
import pickle
def checkSalary(empName):
fobj=open("employee.dat","rb")
num = 0
try:
while True:
rec=pickle.load(fobj)
if Author==rec[3]:
num = num + 1
except:
fobj.close()
return num

4. A binary file “discovery.dat” has a structure

[scien_name,discovery,yearofDiscovery,yearofbirth]
Write a function display(scien_name) in python that accepts the name of a scientist as
scien_name and returns the discovery with the year of discovery.

import pickle
def display(scien_name):
fobj=open("Discovery.DAT","rb")
num = 0
try:
while True:
rec=pickle.load(fobj)
if rec[1] == scien_name:
print(rec[0],rec[1],rec[2],sep="\t")
num = num + 1
except:
fobj.close()
return num

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 87
 CSV FILE
• A Comma Separated Values (CSV) file is a plain text file that contains the comma-
separated data.
• These files are often used for exchanging data between different applications.
• CSV files are usually created by programs that handle huge amounts of data. They
are used to export data from spreadsheets (ex:- excel file) and databases (Ex:- Oracle,
MySQL). It can be used to import data into a spreadsheet or a database.

CSV File Structure

## sample.csv file structure

Name, DOB, City

Ram, 12-Jul-2001, Delhi
Mohan, 23-Jan-2005, Delhi

Python CSV Module

 CSV Module is available in Python Standard Library.
 The CSV module contains classes that are used to read and write tabular form of
data into CSV format.
 To work with CSV Files, programmer have to import CSV Module.
import csv

Methods of CSV Module :

 writer( )
 reader( )

Both the methods return an Object of writer or reader class. Writer Object again have two
methods – writerow( ) , writerows( ).

writer( ) Methods
This function returns a writer object which is used for converting the data given by the
user into delimited strings on the file object.

writer( ) Object Methods –

 w_obj . writerow( <Sequence> ) : Write a Single Line
 w_obj . writerows ( <Nested Sequence> ) : Write Multiple Lines

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 88
 Example:-

## writerow()
import csv
row=['Nikhil', 'CEO', '2', '9.0']
f=open("myfile.csv", 'w')
w_obj = csv.writer(f)
w_obj.writerow(row)
f.close()
## writerows()

import csv
rows = [['Nikhil','CEO','2','9.0'],
['Sanchit','CEO','2','9.1']]
f=open("myfile.csv",'w')
w_obj = csv.writer(f)
w_obj.writerows(rows)
f.close()

reader( ) Methods
This function returns a reader object which will be used to iterate over lines of a given
CSV file.
r_obj = csv.reader(csvfile_obj)

To access each row, we have to iterate over this Object.

for i in r_obj:
print(i)
import csv
f=open("myfile.csv",'r')
r_obj = csv.reader(f)
for data in r_obj:
print(data)
f.close()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 89
 SAMPLE QUESTIONS:

1. Write a program to read entire data from file data.csv

import csv f=open("data.csv", 'r')
d=csv.reader(f)
for row in d:
print(row)
OUTPUT:
['Admno', 'Name', 'Class', 'Sec', 'Marks']
['1231', 'Amit', 'XII', 'A', '45']
['1224', 'Anil', 'XII', 'B', '49']
['1765', 'Suman', 'XI', 'A', '42']
['2132', 'Naman', 'XII', 'C', '38']

2. Write a program to add/insert records in file “data.csv”. Structure of a record is roll

number, name and class.
import csv
field = ["Roll no" , "Name" , "Class"]
f = open("data.csv" , 'w')
d=csv.writer(f)
d.writerow(field)
rn=int(input("Enter Roll number: "))
nm = input("Enter name: ")
cls = input("Enter Class: ")
rec=[rn,nm,cls]
d.writerow(rec)
f.close()

Multiple Choice Questions:

1. CSV stands for :
a. Comma Separated Values
b. Comma Separated Variables
c. Comma Stored Values
d. Comma Stored Variables

2. The separator character of CSV Files is called a

a. EOL
b. Delimiter
c. EOF
d. Default

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 90
 3. The default delimiter for a CSV file is :
a. Semi colon
b. Colon
c. Comma
d. Hyphen

4. _ module of Python provides the functionality to read and write tabular data
in CSV file.
a. pickle
b. csv
c. file
d. ccv

5. Which function is used to open a csv file ?

a. Open()
b. csv.open()
c. writer()
d. csv.writer()

6. Name the function to read from CSV file.

a. read()
b. csv.reader()
c. csv.read()
d. readline()

7. Which among the following is not a function of csv module?

a. reader()
b. read()
c. writer()
d. writerows()

8. In Python, default newline character is :

a. \f
b. \t
c. \n
d. \v

9. CSV module allows to write multiple rows using function.

a. writerows( )

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 91
 b. writerow( )
c. writer( )
d. None of the above

10. The opening function of a csv file is similar to the opening of:
a. Binary file
b. Text File
c. Both of them
d. None of them

11. The argument of open function is to specify how Python handle the
newline characters in csv file
a. newline
b. line
c. mode
d. char

12. Which among the following is an iterable object ?

a. writer
b. file
c. reader
d. All of the above

13. To specify a different delimiter while writing into a csv file, argument is used
with writer object :
a. newline
b. separator
c. character
d. delimiter

14. Which mode opens the file for exclusive creation, which fails in the case where file
already exists
a. a
b. w
c.x
d. r

15. The file mode to open a CSV file for reading as well as writing is .
a. a+
b. w+

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 92
 c. r+
d. All the above.
16. Identify the line number which may cause an error:
import csv #Line1
line=[[1,2,3],[4,5,6]]#Line 2
with open("sample.csv","w",newline="") as csvfile: #Line3
writer=csv.writer(csvfile,delimiter="|") #Line4
for line in writer: #Line5
writer.writerow(line)
a. Line1
b. Line2
c. Line 4
d. Line

17. The CSV files are files.

a. Plain text file
b. Binary
c. Data
d. Python

18. The writer() function has how many mandatory parameters?

a. 1
b. 2
c. 3
d. 4

19. Which of the following parameter needs to be added with open function to avoid
blank row followed by each record in the CSV file?
a. quotechar
b. quoting
c. newline
d. skiprow

20. Ajaikrishna wants to separate the values by a $ sign. Suggests him a pair of function
and parameter to use it.
a. open, quotechar
b. writer, quotechar
c. open, delimiter
d. writer, delimiter

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 93
 21. Tejalakshmi of Class 12 have written the below code . Observe and fill in the given
blanks so that it opens the file “data.csv” and read and print all the records.

I. What must be filled in line 1?

a. Open(“data.csv”,”r”)
b. open(“data.csv”)
c. “data.csv”
d. File

II. What must be filled in Line 2?

a. csv.reader()
b. csv.read()
c. csv.write()
d. csv.writer()

III. What must be filled in line 3?

a. data.csv
b. f
c. r
d. None

IV. What must be filled in line 4?

a. data
b. f
c. “File”
d. row

V. What is the default data type of data read from this file?
a. List
b. String
c. Tuple
d. Integer

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 94
 22. Sudev, a student of class 12th, is learning CSV File Module in Python. During
examination, he has been assigned an incomplete python code to create a CSV file
‘customer.csv’ .Help him in completing the code which creates the desired CSV file.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 95
 I. Identify suitable code for the blank space in line marked as Statement-1.
a) include
b) add
c) Import
d) import

II. Identify the missing code for the blank space in line marked as Statement-2.
a) Customer
b) reader
c) csvwriter
d) writer

III. Identify the argument name for the blank space in line marked as Statement-3?
a) Row
b) Rec
c) row
d) rec

IV. Identify the missing file name for the blank space in line marked as Statement-4?
a) customer
b) customer.csv
c) customer.txt
d) customer.dat

V .Identify the object name for the blank space in line marked as Statement-5?

a) i
b) Rec
c) row
d) rec

23. Daya of class 12 is writing a program to create a CSV file “empdata.csv” with empid,
name & mobile number. Also to search a particular empid and display its record details.
He has written the following code. As a programmer, help him to successfully execute the
given task.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 96
 Choose the module he should import in Line 1.
a) math
b) pickle
c) csv
d) random

II. Choose a code to write the column heading from fields list in Line2.
a) writerows(fields)
b) writerow(field)
c) writerow(fields)
d) writerows(fields)

III. Choose a code to write the row from rows list in Line3.
a) writerows(row)
b) writerow(row)
c) writerow(rows)
d) write_row(row)

IV. Choose a code for line 4 to read the data from a csv file.
a) csv.reader(f)
b) csv.read(f) d) pickle.load(f) e) f.read()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 97
 V. Choose the correct variable (list value) to check “emplid” in Line5

a) Row[0]
b) Rec[0]
c) row[0]
d) rec[0]

24. Viraj is making a software on “Countries and their Capitals” in which various records
are to be stored/retrieved in “CAPITAL.CSV” data file. It consists of few records of
Countries and their Capitals. He has written the following code in python. As a
programmer, you have to help him to successfully execute the program.

I. Choose the Name of the function in Statement-1.

a) AddNewRec
b) Addnew
c) Addrec
d) AddNewRec()

II. Choose the file mode to be passed to add new records in Statement-2.
a) w
b) r
c) w+
d) a
III. Identify the correct variables in Statement-3 to store data to the file.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 98
 a) country,capital
b) Country,Capital
c) Coun,Cap
d) [Country,Capital]

IV. Choose the correct option for Statement-4 to read the data from a csv file.
a) Reader()
b) reader()
c) read
d) reader

V. Choose the output which will come after executing Statement-5.

a) ‘INDIA NEW DELHI’ ‘CHINA BEIJING’
b) ‘CHINA’ ‘BEIJING’
c) INDIA NEW DELHI
d) None of the above

25. Rinsha of class 12 is writing a program to create a CSV file “user.csv” which will
contain user name and password for some entries. She has written the following code.
As a programmer, help her to successfully execute the given task.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 99
 I. Name the module she should import in Line 1.
a. CSV
b. csv
c. math
d. File

II. In which mode, Rinsha should open the file to add data into the file.
a. r
b. a
c. w
d. w+

III. Fill in the blank in Line 3 to read the data from a csv file.
a. writer()
b. reader()
c. write()
d. read()

IV. Fill in the blank in Line 4 to close the file.

a. End()
b. Close()
c. close()
d. end()

26. Consider the following csv file and the code fragment associated with the following
csv file :

I. What will be the output printed by the above code?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 100
 a. SLNO12345
b. SLNO
c. The entire content
d. Error

II. What will be the output printed by the above code if the break is replaced with
continue?
a. SLNO12345
b. SLNO
c. The entire content
d. Error

III. What will occur if the file stud.csv is not existing in the mentioned path?
a. It will create a new one
b. It will create an error
c. None of the above
d. It will cause a system reboot

IV. Which statement in the above code will help to move to the next record?
a. fobj.next()
b. next(fobj)
c. fobj.move()
d. fobj.forward()

27. Sai Krishna has created the following csv file named item.csv:

He has written the following program for managing the file. Help him to find the
answers for the following questions.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 101
 I. What will be printed by Line1?
a. All the records
b. ITEMNO, NAME, PRICE c.item.csv
d. None of the above

II. What will be printed by Line2?

a. 101,PENCIL,5
b. ITEMNO, NAME, PRICE c.102,PEN,10
d. 103,NOTEBOOK,156

III. What will be printed by Line3?

a. 103,NOTEBOOK,15
b. Line 3 will not be executed
c. Line 3 will be executed , but nothing will be printed
d. 102,PEN,10

IV. What will be printed by Line4?

a. 101,PENCIL,5
b. ITEMNO, NAME, PRICE
c. 102,PEN,10
d. 103,NOTEBOOK,15

V. What must be written in Line 5?

a. F.close()
b. f.close()
c. fobj.close()
d. csvfile.close()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 102
 ANSWERS

QNO OPT QNO OPT QNO OPT QNO OPT

1 A 6 b 11 a 16 d
2 B 7 b 12 c 17 a
3 C 8 c 13 d 18 a
4 B 9 a 14 c 19 c
5 B 10 b 15 d 20 d

QNO OPT QNO OPT QNO OPT

I b I d I c
II a II c II c
21 III c 22 III b 23 III b
IV d IV b IV a
V b V d V c

QNO OPT QNO OPT QNO OPT

I d I b I b
II d II b II c
24 III b 25 III b 26 III b
IV D IV c IV b
V b

QNO OPT
I b
II a
27 III b
IV c
V b

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 103
 DATA STRUCTURE
Implementation of stack – menu oriented program

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 104
7
 SAMPLE QUESTIONS:

MCQ/Very Short Answer Type Questions(1-mark)

1. Choose the correct output for the following stack operation(* top position)

(a) 8 5 2 5 1*
(b) 8 5 5 2 1*
(c) 2 5 5 1*
(d) 5 2 1*

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 108
 (e) Which list method can be used to perform Push operation in a stack implemented
by list?
(f) append()
(g) extend()
(h) push()
(i) insert()

2. Which list method can be used to perform Pop operation in a stack implemented
by list?
(a) pop()
(b) pop(1)
(c) remove()
(d) pop(0)
4. Consider the following operation performed on a stack of size 3, What will be the
output? (* top position)

(a) overflow
(b) underflow
(c) 10 20 30 40 50*
(d) 10 20 40 50*
5. Based on the below given code, Write answer to the following questions i to v

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 109
 (i) Identify the suitable code for statement 1?

a) colour.insert(len(colour),n)
b) colour.append(len(colour),n)
c) colour.append()
d) colour.extend()

(ii) Identify the suitable code for statement 2?

a) push(colour,c[i])
b) push(colour)
c) push(c[i])
d) push(colour,i)

(iii) Identify the suitable code for statement 3?

a) colour==[]:
b) colour.isEmpty():
c) len(colour)=0:
d) None of the above

(iv) Fill in the statement to delete an element from the stack?

a) colour.pop(1)
b) colour.pop()
c) del colour[1]
d) colour.delete(1)

(v) Fill the statement 5,to call pop function

a) pop(c)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 110
 b) pop(colour)
c) call pop(colour)
d) def pop(colour)

6. What do you mean by Data Structure?

7. LIFO data structure is?
8. Can we have nested list?
9. Name one linear data structure.
10. Name one non-linear data structure.
11. Name the operation for insertion in a stack.
12. Name the operation for deletion from a stack.
13. Name the function to find length of a list.
14. Indexing in list starts from?

Short Answer Type Questions(2-marks)

1. How is Data Structure different from Data Type?

2. Define Stack and Queue
3. Name some operations commonly performed on data structures?
4. What is a list?
5. What is traversing? Write python code to traverse a list.
6. Name the methods used for inserting and deleting elements from a list.
7. Write some applications of stack.

Application based Short Answer Type Questions(2-marks)

8. Predict the output with respect to the list L=[40,20,30,10,50]

(a) print(L)
(b) print(len(L))
(c) L.pop() ; print(L)
(d) L.append(70); print(L)
(e) L.sort(); print(L)

9. Find the output:

(a) secondlist=[1,2,3,[4,5,[6,7,8],9],10,11]
print(len(secondlist) )
L=[1, 2, 3, [4, 5, [ 6, 7, 8 ], 9 ] ,10, 11]
(b) L[1]
(c) L[3]
(d) L[3][1]

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 111
 (e) L[3][2][0]
(f) L[3][2]
(g) L[3][2][1]
(h) L[3][3]

10. Predict the output:

(a) b=[[9,6],[4,5],[7,7]] X=b[:2]
X.append(10)
print(X)

(b)
b=[[9,6],[4,5],[7,7]] X=b[:2]
X[1].append(10)
print(X)
11. Consider STACK=*‘a’,’b’,’c’,’d’+. Write the STACK content after each operations:
a) STACK.pop( )
b) STACK.append(‘e’)
c) STACK.append(‘f’)
d) STACK.pop( )

12. Write a program to implement a stack for the students(studentno, name). Just
implement Push.

13. Write a program to implement a stack for the students(studentno, name). Just
implement Pop and display.

14. If
L=["Python", "is", "a", ["modern", "programming"], "language", "that", "we", "use"] ,
then find the output:
a) L[0][0]
b) L[3][0][2]
c) L[3:4][0]
d) L[3:4][0][1]
e) L[3:4][0][1][3]
f) L[0:9][0]
g) L[0:9][0][3]
h) L[3:4][1]

15. What is the difference between pop() and pop(0)?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 112
 Long Answer Type Questions (3-marks)
1. Write a program for linear search in a list.

2. Write a program for bubble sort.

3. Write PushOn(Book) and Pop(Book) methods/functions in Python to add a new

Book and delete a Book from a list of Book titles, considering them to act as push and
pop operations of the Stack data structure.

4. Write functions in python for performing stack operations implemented by using

list and also write a function for the menu driven operations to implement all the stack
operations? (Hint: Use global variables)

5. Write a function in python to perform Push Operation in a stack implemented by

using list. Maximum size of the stack can be input by the user along with original stack and
also display the top position and stack elements after push operation.
>>> li=[3,4,5]
>>> push(li,5)
enter the element:20
Top position after Push operation: 3 stack after Push operation: [20, 5, 4, 3]

6. Write a function in python to perform Pop Operation in a stack implemented by

using list. Print the element deleted, top position and also display the stack elements
before and after the pop operation?
>>> li=[20,5,4,3]
>>> pop(li)
Original stack [3, 4, 5, 20]
Top position: 3
Deleted element 3
stack after Pop Operation: [4, 5, 20]
7. Write a function in python to display elements of a stack implemented by using list.
Use both traditional and python methods. Print stack empty message, if elements are not
there.
>>> li=[20,5,4,3]
>>> display(li)
Stack elements: [3, 4, 5, 20]
>>> displaytraditional(li) Stack elements:
3 4 5 20
>>> l2=[]
>>> display(l2) Stack empty

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 113
 8. Write a function in Python PUSH(Arr),where Arr is a list of numbers, from this list
push all even numbers into a stack implemented by using a list. Display the stack if it has
at least one element, otherwise display “stack empty” message.
>>> li=[1,6,89,100,25,29]
>>> push(li)
The item 1 can't be inserted because it is not an even number The item 89 can't be inserted
because it is not an even number The item 25 can't be inserted because it is not an even
number The item 29 can't be inserted because it is not an even number
Stack elements after push operation : [100, 6]

9. Write a function in Python PUSH(mydict,maxsize=5),where mydict is a dictionary

of phone book(name and mobile numbers), from this dictionary push all phone numbers
to a stack implemented by using list and also the display the numbers that Display the
stack if it has at least one element, otherwise display “stack empty” message
>>>mydict={1234567890:"Shyam",94567892:"Ram",8657456789012:
"Karun",9674123789:"Tharun"}
>>> push(mydict)
Stack elements after push operation :
[[1234567890, 94567892, 8657456789012, 9674123789]]

10. Write a function in Python PUSH(mydict),where mydict is a dictionary of phone

book(name and mobile numbers), from this dictionary push only phone numbers having
last digit is greater than 5 to a stack implemented by using list and also display the stack if
it has at least one element, otherwise display “stack empty” message.
>>> mydict={9446789123:"Ram",8889912345:"Sam",7789012367:"Sree"}
>>> push(mydict)
Phone number: 9446789123 last digit is less than five which can't be pushed Stack
elements after push operation : [7789012367, 8889912345]
11. Write a function in Python PUSH(mydict),where mydict is a dictionary of phone
book(name and mobile numbers), from this dictionary push only phone numbers having
10 digits into a stack implemented by using list . Display the stack if it has at least one
element, otherwise display “stack empty” message.
>>>mydict={1234567890:"Shyam",94567892:"Ram",8657456789012:"Karun",
9674123789:"Tharun"}
>>> push(mydict)
Digit of phone number 8
Phone number: 94567892 doesn't have 10 digits,which can't be pushed Digit of phone
number 13
Phone number: 8657456789012 doesn't have 10 digits,which can't be pushed Stack
elements after push operation : [9674123789, 1234567890]

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 114
 12. Write a function in Python PUSH(Arr),where Arr is a list of numbers, From this list
push all numbers divisible by 5 in to a stack implemented by using a list. Display the stack
if it has at least one element, otherwise display appropriate error message.
>>> li=[10,2,5,6,15,30]
>>> push(li)
The item 2 can't be inserted because it is not divisible by 5 The item 6 can't be inserted
because it is not divisible by 5 Stack elements: [30, 15, 5, 10]

13. Write a function in Python POP(Arr),where Arr is a stack implemented by a list of

numbers. The function returns the value deleted from the stack and stack status after pop
operation.
>>> li=[10,20,30,40,50]
>>> dele,st=pop(li)
Original stack [50, 40, 30, 20, 10]
>>> print("Element deleted=",dele,"Stack after deletion",st[::-1])
Element deleted= 50
Stack after deletion [40, 30, 20, 10]
Or
>>> pop(li)
Original stack [40, 30, 20, 10]
(40, [10, 20, 30])

ANSWER KEY
I. MCQ/ Very Short Answer Type Questions(1-mark)
1. (d) 5 2 1*
2. (a) append()
3. (a) pop()
4. (a) overflow
5.
(i). a colour.insert(len(colour),n)
(ii). a push(colour,c[i]) (iii).a colour==[]
(iv). b colour.pop()
(v). b pop(colour)
6. Data Structure means organization of data. A data structure has well defined
operations or behaviour.
7. STACK
8. Yes
9. Lists
10. Graphs
11 PUSH

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 115
 12 pop
13. len()
14. 0

Short Answer Type Questions(2-marks)

1. Data Structure provides information regarding organization of data whereas Data
Type provides information regarding the domain of values and operations that can be
performed on data.
2. Stack – A stack is a linear list also known as LIFO list with the special property that
items can be added or removed from only one end called the top.
Queue – A queue is a linear list also known as FIFO list with the special property that items
can be added at one end and removed from the other.
3. Traversal, Insertion, Deletion, Searching, Sorting, Merging etc.
4. A list is a mutable sequence of data elements indexed by their position. A list is
represented using [ ] . e.g L=[10,20,30]
5. Traversing means accessing or visiting or processing each element of any data
structure.
L=[10,20,30,40,50]
for x in L:
print(x)
6. Various methods for inserting elements in a list are - insert(), append(), extend()
and methods used for deleting items from a list are – pop() , remove(), clear()
7. Reversing a string, compilers use stack to store previous state of program, undo
mechanism in text editors and backtracking.

Application based Short Answer Type Questions(2-marks)

8. (a) Ans: [40, 20, 30, 10, 50]
(b) Ans: 5
(c) Ans:50
[40, 20, 30, 10]
(d) Ans: [40, 20, 30, 10, 70]
(e) Ans: [10, 20, 30, 40, 70]
9. (a) Ans:6
(b) Ans: 2
(c) Ans:[4, 5, [6, 7, 8], 9]
(d) Ans:5
(e) Ans:6
(f) Ans: [6, 7, 8]
(g) Ans:7
(h) Ans:9

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 116
 10. (a) Ans: [[9, 6], [4, 5], 10]
(b) Ans: [[9, 6], [4, 5, 10]]

11. Ans: ['a', 'b', 'c']

Ans: ['a', 'b', 'c',’e’+
Ans: ['a', 'b', 'c',’e’,’f’+
Ans: ['a', 'b', 'c',’e’+
12.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 117
 14. (a) Ans: ‘P’
(b) Ans: ‘d’
(c) Ans: ['modern', 'programming']
(d) Ans: 'programming'
(e) Ans: 'g'
(f) Ans: 'Python'
(g) Ans: 'h'
(h) Ans: IndexError: list index out of range
15. Ans: pop() will delete the last element of a list whereas pop(0) will delete element at
index zero of a list

Long Answer Type Questions (3-marks)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 118
MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 119
 5. #Stack operation-Push

6. #stack operation-Pop

7. Ans: Program for pop and display operation in a stack

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 120
 8.

9.

10.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 121
 11.

12

13

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 122
 COMPUTER NETWORKS
Model Questions

I. Multiple Choice Questions

1. Which one of the following devices will you suggest for connecting all the computers
within each block of a building?
a. Switch/Hub b. Modem
c. Telephone d. Repeateri
2. XYZ company is planning to link its head office situated in New Delhi with the offices in
hilly areas. Suggest a way to connect it economically:
a. Micro waves b. Coaxial cable
c. Fibre optic d. Radio waves
3. Which of the following is/are not communication media?
a. Microwaves b. Optical Fiber cable
c. Node d. Radio waves
4. The _ is over which the messages are sent.
a. Signal b. Channel c. Protocol d. Sender
5. Which of the following is not a unit of data transfer rate?
a. Abps b. Bps c. Kbps d. Gbps
6. The number of bits transmitted per second is called .
a. Bit rate b. Baud rate c. Data rate d. Transfer rate
7. The messages sent over a network is divided into small pieces called .
a. Units b. Chunks c. Packets d. Bits

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 123
 8. A _ is established in circuit switching before actual communication.
a. Switch b. Link c. Protocol d. Hub
9. The is the difference between upper and lower frequencies of a
communication medium.
a. Bandwidth b. Data rate c. Latency d. communication speed
10. The unit of Bandwidth is?
a. Khz b. Hz c. Watt d. KW
11. For every device connected to a network, there will be a unique _ _.
a. Name b. ID c. IP Address d. IC
12. Raw data is processed to get .
a. File b. Information c. Communication d. Message
13. Which of the following is/are true regarding packet switching?
1. The packets of data are sent simultaneously through different paths.
2. The free communication channel is utilized properly.
3. Protocols are used for the reliable receipt of data at the receiver end.
4. Sequence numbers are assigned to the data packets.

a. Only 1 b. Both 1 & 4 c. Both 2 & 4 d. All of the above.

14. is applicable in the case of long voice data communication.
a. Protocols b. Circuit Switching c. Packet Switching d. None of these.
15. Which of the following is/are true in the case of IP address?
1. IP address can be used to trace the actual physical location of adevice in the network.
2. A printer connected to a network will also have an IP Address.
3. Two devices can have same IP Address.
4. The IP Address can be formed of any number.
a. Only 1 is true b. Only 1 & 2 are true c. Options 1, 2 and 4 are true. d.
All the options are true.
16. Selecting a communication path among multiple available paths is termed as:
a. Transmission b. Reception c. Switching d. multiplexing
17. The other name for communication medium is:
a. Channel b. Source c. Hub d. Switch

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 150
 18. Establishing a Terminating
Communication
Connection Connection

The above procedure occurs in the case of .

a. Packet Switching b. Circuit Switching
c. Both a and b d. None of these.
19. What are the three common types of computer networks?
a. ROM, MAN, LAN b. RAM, WAN, LAN
c. MAN, LAN, WAN d. None of the above
20. What is the acronym for LAN?
a. Local Area Network b. Local Access Network
c. Line And Networking d. Line-less Networking
21. Define what a LAN is?
a. Connected devices share the resources of a single processor or server within a
small geographic area
b. Normally find within a business and school
c. These are computers that share resources over a large area
d. None of the above
22. Mr. John is a small businessman who runs Hardware. He has been experiencing
problems with his small accounting department, which he depends on to provide sales
reports. Mr. John wants to share information between his 7 computer stations and
have one central printing area. What type of network would you recommend to Mr.
John?
a. MAN b. LAN
c. WAN d. SAN
23. WAN covers a larger geographical area than MAN?
a. True b. False
24. A network that consists of both LANs and MANs is called a Wide area network?
a. True b. False
25. Arrange the Following Types of Networks according to their size, from largest to
smallest?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 151
 a. LAN, WAN, MAN b. WAN, LAN, MAN
c. MAN, LAN, WAN d. WAN, MAN, LAN
26. You are a member of a club that deals with computer networks. The club has to take
a project to build a MAN. Where would this project likely take place?
a. A small building/organization b. University or college
c. Home d. None of the above
27. What is the acronym MAN stand for?
a. Magnetic Access Network b. Metropolitan Area Network
c. Multi-Area Network d.. Multi-Access net
28. In your school there is a library, and you can use the internet to do research, this
library will most likely be a WAN network?
a. True b. False
29. Types of Networks are Categories by their Geographical Area cover?
a. True b. False
30. Metropolitan Area Network Normally Require an Internet connection?
a. True b. False
31. What’s a web browser?
a) A kind of spider
b) A computer that store www files
c) A person who likes to look at websites
d) A software program that allows you to access sites on the World Wide Web
32. A is a document commonly written and is accessible through the internet or
other network using a browser?
a) Accounts b) Data
c) Web page d) Search engine
33. Which of the following is used to read HTML code and to render Webpage?
a) Web Server b) Web Browser
c) Web Matrix d) Weboni
34. Which of these tech company owns Firefox web browser?
a) Lenovo b) IBM
c) Apple d) Mozilla

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 152
 35. Which of the following browsers were/are available for the Macintosh?
a) Opera b) Safari
c) Netscape d) All of these
36. What is the name of the browser developed and released by Google?
a) Chrome b) Googly
c) Heetson d) Titanium

37. Which of the following is a Web Browser?

a) MS-office b) Notepad c) Firefox d) Word 2007
38. Which of the following is not a web browser?
a) Chrome b) Microsoft Edge c) Safari d) Ubuntu
39. URL stands for
(a) Uniform Research Limited (b) Uniform Resource Locator
(c) Uniform Resource Labs (d) Uniform Research Locator
40. LinkedIn is an example for website.
(a) E-learning (b) E-commerce
(c) Video conferencing (d) Social networking
41. Which of the following is not a web service?
(a) Distance Learning (b) E-mailing
(c) Video conferencing (d) Social networking
42. Web browsers are also called as _
(a) Web Servers (b) Web Clients (c) Web Hosting (d) Web Designing
43. Working of WWW based on _ architecture.
(a) Peer-To-Peer architecture (b) Client-Client architecture
(c) Client-Server architecture (d) Server-Server architecture
44. is a computer software capable of requesting, receiving &
displaying information in the form of webpages.
(a) Web Servers (b) Web Browsers
(c) Web Designers (d) Web Camera
45. A _ is a program or automated script which browses the World Wide
Web in a methodical, automated manner.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 153
 (a) Web Servers (b) Web Browsers
(c) Web Designers (d) Web Crawler
46_ is a mark-up language that helps in developing web pages.
(a) HTTP (b) HTML (c) XML (d) C++
47 is a language used to transport data over internet.
(a) HTTP (b) HTML (c) XML (d) C++
48. is a set of rules for communication between two computers over a
network.
(a) Modem (b) Protocol
(c) Switch (d) IP address
49. In web services, the communication takes place between
(a) Two electronic devices (b) Two human beings
(c) Two spiders (d) None of the above
50. Web services means services provided by

(a) Microsoft (b) Google

(c) BSNL (d) World Wide Web

II. Very Short Answer Type Questions(1-mark)

1. Give examples for Wired media and Wireless media.
2. Name the device which connects multiple nodes to form a network. It redirects the
received information only to the intended node(s).
3. Identify odd one out of the following:
Optical Fiber/Coaxial Cable/ Bluetooth/Twisted Pair Cable. Give reason for your answer.
4. Ms. Emily is planning to connect 20 computers in her computer lab to form a local area
network. Suggest an intelligent network device to connect all the computers.
5. Which communication channel is/are suitable in each of the following situations?
(i) Transfer of data from one mobile to another.
(ii) Communication in a hilly area.
6. Tagore Consultancy is planning to link its head office at Kolkata with the offices at
Ernakulam. Suggest an economic way to set up a connection between these offices. The
company is ready to compromise on the speed of the connectivity.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 154
 7. Mr. Roy, General Manager of Infopark Solutions discovered that the communication
between his company’s main office and HR office is extremely slow and signals drop quite
frequently. These offices are 150 meters away from each other and connected by an
Ethernet cable. Suggest him a device which can be installed between the offices for
smooth communication.
8. Name The transmission media best suitable for connecting to hilly areas.
9. How many pair of wires are there in twisted pair cable (Ethernet)?
10. Name a device that forwards data packets along networks.
11. What is the full form of WWW?
12. What is the full form of Internet?
13. Who invented the WWW in 1989?
14. Special software’s that is used to view webpages are
15. are used to store webpages, so whenever a request, it will serve the request.
16. are programs /computers used to store information’s in the form of
webpages.
17. Web pages that are linked to each other via _
18. _ protocol is used to transfer web pages over internet.
19. Full form of HTTP?
20. is a massive collection of digital pages to access information over the
Internet
21. Write any 2 differences between HTML & XML?
22. is a real-time communication between two or more users via computer.
23. helps us to learn anywhere using Internet.
24. allows customers to conduct financial transactions on a secure Website.
25. Internet can be used to get reservation of trains and air planes through

service.
26. helps to create and maintain social relationship over web.
27. Expand the following abbreviations:
a. HTTP
b. XML
c. HTTPS

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 155
 d. HTML
e. VoIP
28. Name any two common web browsers.
29. Full form of Email is
30. What out of the following, you will use to have an audio visual chat with an expert
sitting in a faraway place to fix-up technical issues?
(i) E-mail (ii) VoIP (iii) FTP
31. Match the following

Web Services Description

A Video conferencing P Without ever having to go booking office
Self-paced learning modules allow students to
B E-Shopping Q
work at their own speed
Each of the end user has a camera as well as
C E-mail R microphone to capture video and audio in real
time and it will be transmitted over internet
Purchasing products through computers/mobile
D E-reservation S
devices
Messages normally reaches a recipients account
E E-learning T
within seconds

32. Match the following

Web Services Applications

A Video conferencing P IRCTC
B E-Shopping Q Diksha App
C E-mail R GEM
D E-reservation S Gmail
E E-learning T Instagram
F Social Networking U VConSol

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 156
 III. Short Answer Type (Theory with Answers)
1. Your friend wishes to install a wireless network in his office. Explain him the difference
between guided and unguided media.
Guided media uses cables to connect computers, whereas unguided media uses
waves

2. What are Protocols? Name the protocol used to transfer a file from one device to the
other.
Protocols are set of rules that are followed while transmitting data through a
computer network. Protocols determines how to data can be moved securely from a
source device to a destination device. The protocol used for transferring a file from one
device to another is the File Transfer Protocol (FTP)

3. Define communication channel.

A communication channel is the medium through which data is moved from the
source to destination. The communication channel can be either wired or wireless. Wired
communication channel is also called guided medium while wireless communication
channel is also called unguided medium.

4. What do you mean by an IP Address? Give an example for IP Address.

An IP Address is a numerical address that uniquely identifies every device connected
to a network or internet. The user’s physical location can be tracked by using an IP
Address. IP V4 (IP Version 4) is a popular version of IP Address. IP Address (in IP V4) consists
of four set of numbers separated by a dot. These numbers can range from 0 to 255.
An example IP Address format is given below:
192.158.12.38
5. Differentiate between Circuit Switching and Packet Switching.
In Circuit Switching a physical connection between the sender and the receiver is
set up first. Then, through that physical link, the complete message is communicated
continuously. After completion of the transmission, the physical connection is terminated.
In Packet Switching, the message is split into small units called packets. Then these
packets are passed from source to destination simultaneously through different routes in
the network. As the flow of packets are asynchronous, sequence numbers are assigned to
each packet to facilitate re-ordering of packets at the destination.

6. Define the following: a. Bandwidth b. Data rate

Bandwidth: It is the range of frequencies that can be carried through a communication
channel. The bandwidth of a channel determines its capacity. It is the difference between
the highest and lowest frequencies that can be carried through the channel. The unit of
Bandwidth is Hertz (Hz).

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 157
 Data transfer rate: It is the amount of data moved through a communication channel per
unit time. The units of Data transfer rate are Bits per second (Bps), Kilobits per second
(Kbps) , Megabits per second (Mbps) or Gigabits per second (Gbps).

7. Explain the components of data communication.

The components of data communication are: Sender, Receiver, Message, Communication
Medium and Protocols.
Sender: The device which sends data through a network is called sender or source.
Receiver: The device which receives data through a network is called receiver or
destination.
Message: The data that is communicated between the source and the destination is
called message.
Communication channel: The medium through which the data is carried from the
source to destination is called a communication medium.
Protocols: The set of rules followed while communicating data over a network are
called Protocols.

8. What are the advantages of Packet switching over Circuit switching.

In Packet Switching the communication channel is utilized completely whenever it is free.
Where as in Circuit Switching, once the connection is assigned for a particular
communication, the entire channel cannot be used for other data transmissions even if
the channel is free.
Data packets moves simultaneously through different paths in a Packet Switched network,
making the transmission quick and easy. But in the case of Circuit Switched network, there
is a delay in setting up a physical connection between the source and destination before
communicating the actual message.
Packet Switching is cost effective compared to Circuit Switching as there is no need to set
up a connection between the communicating parties every time before the actual
communication.

9. Explain why Circuit Switching is not cost effective compared to Packet Switching?
The Circuit Switching is not cost effective like Packet Switching because, in Circuit
Switching, every time there is a need to set up a connection between the sender and the
receiver before communicating the message.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 158
 10. Explain how an IP Address become helpful in investigating cyber-crimes.
IP address can be used to trace the physical location of a user connected to a network. By
this many cyber crime can be investigated and traced out efficiently tracking the exact
location from where the cybercrime is carried out.

11. Why Protocols are needed in the case of Data Communication?

The communicating devices may be in different geographical areas. The speed of these
devices may be different. Also, the data transfer rates of different networks may be
different. These complexities make it necessary to have a common set of rules i.e.,
Protocols to ensure the secure communication of data

12. What is the difference between World Wide Web & Internet?
Internet means interconnected networks that spread all over the world (i.e. the
physical infrastructure), while WWW means the information’s (available in the form of
webpages) that can be accessed through internet.

13. What is a protocol, give some examples?

Protocols are set of rules that are followed while transmitting data through a
computer network. Protocols determines how to data can be moved securely from a
source device to a destination device. The protocol used for transferring a file from one
device to another is the File Transfer Protocol (FTP)

14. What is the difference between E-mail and chat?

In order to chat, you need to have an account on the same service as the person
you are chatting with. e.g. on the other hand, in case of E-mail, it is not necessary, i.e. you
can have an account from any provider and you can establish your own.

15. What are cookies?

Cookies are files stored temporarily on www browser’s computer, which allow the
www server to store persistent information associated with browsing user on user’s
system.

16. What is the difference between domain name and IP address?

IP addresses look like this: 192.168.12.134.
Domain names look like this: “www.google.com”
Domain names are easier for us to remember and use, while computers are quite handy
with numbers. Thus, we use DNS (Domain Naming System) to translate domain names
into the IP addresses.
IP address is a unique identifier for a computer or device on internet. A domain name
(website name) is a name that identifies one or more IP addresses (when hosted at
different servers for load balancing).

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 159
 17. Give one suitable example of each URL and domain name?
URL: https://kvsangathan.nic.in/hq-gyan-kosh
Domain name: kvsangathan.nic.in

18. Differentiate between XML and HTML.

XML was designed to describe data and to focus on what data is.
HTML was designed to display data and to focus on how data looks.
HTML is about displaying information while XML is about describing information.

19. Distinguish between website and web browser.

Website:- It is a collection of inter-linked web pages stored in a server.
Web Browser:- It is a software application for retrieving, presenting and traversing
through information resources in the form of web pages available on the World
Wide Web.

20. Differentiate between the terms Domain Name and URL in context of web services.
Also write one example of each to illustrate the difference.
Domain Name URL
A domain name or website name URL is a string that represents the complete web
is a human-friendly text form of address of any web page. It’s used to locate a
the IP address. webpage.
It is the part of the URL that is It is the string that represents a complete web
more human friendly. address that contains the domain name.
Example: kvsangathan.nic.in Example: https://kvsangathan.nic.in/contact-us

22.Differentiate between communication using Optical Fiber and Ethernet Cable in

context of wired medium of communication technologies.
Optical Fibre - Very Fast - Expensive - Immune to electromagnetic interference
Ethernet Cable - - Slower as compared to Optical Fiber - Less Expensive as
compared to Optical Fiber - prone to electromagnetic interference

IV. Previous CBSE Board Questions

1) Ravi was trying to log-in to his internet-banking account. He noticed that the URL
of the net banking starts with 'https'. The 's' in 'https' stands for _
(i) Simple 0(ii) Smart (iii) Secure (iv) Strength

2) What is mean by the homepage of a website?

3) What is the significance of the URL?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 160
 4) Which of the following is not a network protocol?
(i) HTML (ii) HTTP (iii) SMTP (iv) FTP

5) Which of the following internet protocols provides secure data transmission

between server and browser with the help of encryption.
a) HTTP b) HTTPS c) TELNET d) ARPANET

6) Devanand, a student of Class XII, is not able to understand the difference between
web client and web-server. Help him in understanding the same by explaining their
role and giving suitable example of each.

7) Write the full form of Cc and Bcc (used in email communication). Explain the
difference between them.

8) Define Internet and write its two uses in our daily life. How is it different from the
World Wide Web (WWW).

9) Web _ is a software used to view web pages.

10) In a network, _ is a computer that provides data and resources to

other computers.

11) How is a website and a webpage related?

12) Microsoft Edge, Apple Safari are examples for

13) What is the use of a server in a computer network?

14) Among the following service available on the World Wide Web are?
i) Email ii) HTML iii) XML iv) Video conferencing
(a) (i) and (ii) (b) (i) and (iv)
(c) (ii) and (iii) (d) None of the above
15) HTML and XML are _
(a) Programming Languages (b) Scripting Languages
(c) Mark-up Languages (d) None of the above
16) XML uses
(a) User defined tags (b) Predefined Tags
(c) Both user defined and predefined tags (d) None of the above

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 161
 17) XML was not designed to _
(a) store the data (b) present the data
(c) carry the data (d) both a & c
18) Which of the following will you suggest to establish the online face to face
communication between the people in the Regional Office Ernakulum and Delhi
Headquarter?
(a) Cable TV (b) Email
(c) Text chat (d) Video Conferencing
19) What kind of data gets stored in cookies and how is it useful?

20) What do the following top level domains signify?

(a) .com
(b) .org

21) “With XML you invent your own tags”, Explain this statement with the help of
example.
22) Define Domain Name Resolution?

23) tags are case sensitive and tags are not case
sensitive.
(a) HTML, XML (b) HTTP, XML
(c) XML, HTTP (d) XML,HTML

24) Which of the following is not a web browser ?

(a) Google Chrome (b) Internet Explorer (c) Mozilla Firefox (d) Photoshop

25) Which protocol helps us to browse through web pages using internet browsers?

26) Name any one internet browser.

27) XML stands for

(A) Xtra Markup Language
(B) Extensible Markup Language
(C) Extensible Marking Language
(D) Extensive Marked Language
28) We can upload a file to a web server using a protocol called _ .
(A) FPT (B) IP (C) TCP (D) FTP

29) delivers the requested web page to web browser.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 162
 30) . MyPace University is setting up its academic blocks at Naya Raipurand is planning
to set up a network. The University has 3 academicblocks and one Human Resource
Center as shown in the diagram below: Study the following structure and answer
questions (a) to (e)

Center to Center distances between various blocks/center is as follows:

Law Block to business Block 40m
Law block to Technology Block 80m
Law Block to HR center 105m
Business Block to technology Block 30m
Business Block to HR Center 35m
Technology block to HR center 15m

Number of computers in each of the blocks/Center is as follows:

Law Block 15
Technology Block 40
HR center 115
Business Block 25

a) Suggest the most suitable place (i.e., Block/Center) to install the server of this
University with a suitable reason.
b) Suggest an ideal layout for connecting these blocks/centers for a wired
connectivity.
c) Which device will you suggest to be placed/installed in each of these
blocks/centers to efficiently connect all the computers within these blocks/centers?
d) Suggest the placement of a Repeater in the network with justification.
e) The university is planning to connect its admission office in Delhi, which is more
than 1250km from university. Which type of network out of LAN, MAN, or WAN will
be formed? Justify your answer.

Test Your Self : PART I

1 Write any 1 advantage and 1 disadvantage of Bus topology.

2. What happens to the Network with Star topology if the following happens:
(i) One of the computers on the network fails?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 163
 (ii) The central hub or switch to which all computers are connected, fails?

3. Two doctors have connected their mobile phones to transfer a picture file of a person
suffering from a skin disease. What type of network is formed?

4. SunRise Pvt. Ltd. is setting up the network in the Ahmadabad. There are four
departments named as MrktDept, FunDept, LegalDept, SalesDept.

Distance between various buildings is given as follows:

MrktDept to FunDept 80 m
MrktDept to LegalDept 180 m
MrktDept to SalesDept 100 m
LegalDept to SalesDept 150 m
LegalDept to FunDept 100 m
FunDept to SalesDept 50 m

Number of Computers in the buildings

MrktDept 20
LegalDept 10
FunDept 8
SalesDept 42

i) Suggest a cable layout of connections between the Departments and specify

topology.
ii) Suggest the most suitable building to place the server with a suitable reason.
iii) Suggest the placement of i) modem ii) Hub /Switch in the network.
iv) The organization is planning to link its sale counter situated in various part of the
same city/ which type of network out of LAN, WAN, MAN will be formed? Justify.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 164
 5. Name the protocol Used to transfer voice using packet switched network.
6. What is HTTP?
7. Write the purpose of the following devices:
(i). Network Interface Card
(ii). Repeater

Test Your Self : PART II

1. The ‘Grand Plaza ’ Mall has a computer network. The network is in one building. Name
this type of network( out of LAN/MAN/WAN).

2. Identify the type of topology on the basis of the following:

a. Since every node is directly connected to the server, a large amount of cable is needed
which increases the installation cost of the network.
b. It has a single common data path connecting all the nodes

3. The following is a 32 bit binary number usually represented as 4 decimal values, each
representing 8 bits, in the range 0 to 255 (known as octets) separated by decimal points.
192.158.1.38
What is it? What is its importance?

4. Dinsey has to share the data among various computers of his two offices branches
situated in the same city. Name the network (out of LAN, WAN, PAN and MAN) which is
being formed in this process.

5. . Global Pvt. Ltd. is setting up the network in the Bangalore . There are four
departments
Distances between various buildings are as follows:
Accounts to Research Lab 55 m
Accounts to Store 150 m
Store to Packaging Unit 160 m
Packaging Unit to Research Lab 60 m
Accounts to Packaging Unit 125 m
Store to Research Lab 180 m

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 165
 Number of Computers
Accounts 25
Research Lab 100
Store 15
Packaging Unit 60

i) Suggest a cable layout of connections between the buildings.

ii) Suggest the most suitable place (i.e. buildings) to house the server of this
organization.
iii) Suggest the placement of the following device with justification:
a) Repeater b) Hub/Switch

6. Write one example each of URL and IP address.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 166
 ANSWER KEY
I. Multiple Choice Questions(MCQ)

1. a 2. d 3. c 4. b 5. a

6. a 7. c 8. b 9. a 10. b

11. c 12. b 13. d 14. b 15. c

16. c 17. a 18. b 19. c 20. a

21. a 22. b 23. a 24. a 25. d

26. d 27. b 28. a 29. a 30. a

31. d 32. c 33. b 34. d 35. b

36. a 37. c 38. d 39. b 40. d

41. a 42. b 43. c 44. b 45. d

46. b 47. c 48. b 49. a 50. d

II. Very Short Answer Type Questions(1-mark)

1. Wired media: Optical Fiber cable

Wireless media: Microwaves, Radio waves
2. Switch
3. Odd one: Bluetooth(Reason: Bluetooth is a wireless/unguided communication
media while others are wired/guided communication media)
4. Switch
5. (i) Bluetooth (ii). Radio waves
6. Satellite
7. Repeater

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 167
 8. Microwave / Radio wave
9. Two insulated copper wires
10. Router
11. World Wide Web
12. Interconnected Networks
13. Tim Berners-Lee
14. Web browsers
15. Web servers
16. Web servers
17. hyperlinks
18. HTTP- HyperText Transfer Protocol
19. HyperText Transfer Protocol
20. World Wide Web(WWW) or Web
21. Refer comparison table
22. Chat
23. E-learning
24. Internet banking
25. E-reservation
26. Social networking websites
27.
a. HTTP- HyperText Transfer Protocol
b. XML – eXtensible Mark-up Language
c. HTTPS - HyperText Transfer Protocol Secure
d. HTML - HyperText Mark-up Language
e. VoIP-Voice over Internet Protocol
28. Google Chrome, Mozilla Firefox
29. Electronic mail
30. Ii.VoIP
31.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 168
 A Video conferencing P Each of the end user has a camera as well as
microphone to capture video and audio in real time
and it will be transmitted over internet
B E-Shopping Q Purchasing products through computers/mobile
devices
C E-mail R Messages normally reaches a recipients account
within seconds
D E-reservation S Without ever having to go booking office
E E-learning T Self-paced learning modules allow students to work at
their own speed
32.
Web Services Applications
A Video conferencing P VConSol
B E-Shopping Q GEM
C E-mail R Gmail
D E-reservation S IRCTC
E E-learning T Diksha App
F Social Networking U Instagram

IV.Previous CBSE Board Questions - Answers

1. (iii) Secure
2. The default (first) page of a website is called a Homepage.
3. URL specifies unique address of each document on the internet.
4. (i) HTML
Internet Protocols for communication over the Internet, the communicating devices must
follow certain rules. These rules are called Internet protocols.
For email communication, we use SMTP and POP.
For communication between browser and server HTTP and HTTPS protocols are used.
We can use TELNET to access services available on a remote computer.
5. b) HTTPS
6. Web-Client: An application that requests for services from a webserver. Example:
Web Browsers, Chatting Applications
Web-Server: Web-server is a software (or any dedicated computer running this software)
that serves the request made by web-clients. Example: Apache Server.
7. Cc : Carbon Copy: every recipient can check who else has received the mail.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 169
 Bcc : Blind Carbon Copy: no recipient can check who else has received the mail.
8. The Internet is a worldwide network that links many smaller computer-networks.
Uses of the Internet 1. E-learning 2. E-commerce
The difference between the internet and www:
Internet means interconnected networks that spread all over the world (i.e. the physical
infrastructure), while WWW means the information’s (available in the form of webpages)
that can be accessed through internet.
9. Web Browser
10. Server
11. A website is a collection of interlinked webpages.
12. Web Browsers
13. Role of server is to serve various clients (sharing data or resources among multiple
clients)
14. (b) (i) and (iv)
15. (c) Mark-up Languages
16. (a) User defined tags
17. (b) present the data
18. (d) Video Conferencing
19. Cookies can store a wide range of information, including personally identifiable
information (such as your name, home address, email address, or telephone number).
Cookies often store your settings for a website, such as your preferred language or
location. When you return to the site, browser sends back the cookies that belong to the
site. This allows the site to present you with information customized to fit your needs.
20. (a) .com - commercial
(b) .org - organization
21. XML tags are created by the user as there are no standard tags.
Ex : <name>Nayana<name>
22. The process of converting domain names (website names) into corresponding IP
address with the help of DNS servers is called domain name resolution.
23. (d) XML,HTML
24. (d) Photoshop

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 170
 25. HTTP - Hyper Text Transfer Protocol
26. Google Chrome or any other valid browser name
27. (B) Extensible Markup Language
28. (D) FTP
29. Web Server
30 a. Most suitable place to install the server is HR center, as this center has maximum
number of computers.
b.

c. Switch
d. Repeater may be placed when the distance between 2 buildings is more than 70 meter.
e. WAN, as the given distance is more than the range of LAN and MAN.

Test Yourself: PART I

1. Advantage: Since there is a single common data path connecting all the nodes, the
bus topology uses a very short cable length which considerably reduces the installation
cost.
Disadvantage: Fault detection and isolation is difficult. This is because control of the
network is not centralized in any particular node. If a node is faulty on the bus, detection
of fault may have to be performed at many points on the network. The faulty node has
then to be rectified at that connection point.

2. (i). failure in one cable will not affect the entire network
(ii). If the central hub or switch goes down, then all the connected nodes will not be able
to communicate with each other.

3. PAN

4. i. Star Topology should be used.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 171
 ii) As per 80 – 20 rule, SalesDept because it has maximum no. of computers.
iii) Each building should have hub/switch and Modem in case Internet connection is
required.
iv) MAN (Metropolitan Area Network)

5. VoIP

6. HTTP is a protocol that is used for transferring hypertext(i.e. text, graphic, image,
sound, video, etc,) between 2 computers and is particularly used on the World Wide
Web (WWW)
7.
(i) Network Interface Card (NIC) is a network adapter used to set up a wired network. It
acts as an interface between computer and the network.
(ii) A repeater is a device that amplifies a signal being transmitted on the network.

Test Yourself: PART II

1. LAN
2.
a. Star Topology
b. Bus Topology
3. It is an IP Address. It is used to identify the computers on a network
4. MAN
5. (i)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 172
 (ii) The most suitable place/ building to house the server of this organization would be

building Research Lab, as this building contains the maximum number of computers
(iii). a)Repeater : distance between Store to Research Lab is quite large, so a repeater
would ideally be placed.
b) Hub/Switch : Each would be needed in all the buildings to interconnect the group
of cables from the different computers in each building.

6. IP address 192.168.1.1
URL : https://www.apple.com/

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 173
 Interface Python with SQL database
# TO CREATE A TABLE IN MYSQL USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="s
ystem",database="student")
mycursor=mydb.cursor()
mycursor.execute("CREATE TABLE FEES (ROLLNO INT,NAME
VARCHAR(20),AMOUNT INT);")

# TO SHOW THE TABLES IN MYSQL USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student")
mycursor=mydb.cursor()
mycursor.execute("SHOW TABLES")
for x in mycursor:
print(x)
#TO DESCRIBE TABLE STRUCTURE USING PYTHON INTERFACE

mydb=mysql.connector.connect(host="localhost",user="root",passwd="system"
,database="student")
mycursor=mydb.cursor()
mycursor.execute("DESC STUDENT")
for x in mycursor:
print(x)
# TO EXECUTE SELECT QUERY USING A PYTHON INTERFACE

import mysql.connector
conn=mysql.connector.connect(host="localhost",user="root",passwd="12345
",database="student")
c=conn.cursor()
c.execute("select * from student")
r=c.fetchone()
while r is not None:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 197
 print(r)
r=c.fetchone()

# TO EXECUTE SELECT QUERY WITH WHERE CLAUSE USING A PYTHON INTERFACE

import mysql.connector
conn=mysql.connector.connect(host="localhost",user="root",passwd="12345",
database="student")
if conn.is_connected()==False:
print("Error connecting to MYSQL DATABASE")
c=conn.cursor()
c.execute("select * from student where marks>90")
r=c.fetchall()
count=c.rowcount
print("total no of rows:",count)
for row in r:
print(row)
#TO INSERT A RECORD (ROLLNO,NAME,AND MARKS) IN MYSQL TABLE student USING
#PYTHON INTERFACE
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student") mycursor=mydb.cursor()
r=int(input("enter the rollno"))
n=input("enter name")
m=int(input("enter marks"))
mycursor.execute("INSERT INTO student(rollno,name,marks)
VALUES({},'{}',{})".format(r,n,m))
mydb.commit()
print(mycursor.rowcount,"RECORD INSERTED")

# TO UPDATE A DATA IN A TABLE USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="syste
m",database="student") mycursor=mydb.cursor()
mycursor.execute("UPDATE STUDENT SET MARKS=100 WHERE MARKS=40")
mydb.commit()
print(mycursor.rowcount,"RECORD UPDATED")

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 201
 # TO DELETE A RECORD FROM THE TABLE USING PYTHON INTERFACE
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student")
mycursor=mydb.cursor()
mycursor.execute("DELETE FROM STUDENT WHERE MARKS<50")
mydb.commit()
print(mycursor.rowcount,"RECORD DELETED")

# TO DROP AN ENTIRE TABLE FROM MYSQL DATABASE USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student")
mycursor=mydb.cursor()
mycursor.execute("DROP TABLE STUDENT")

# TO ADD A COLUMN IN THE EXISTING TABLE USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student")
mycursor=mydb.cursor()
mycursor.execute("ALTER TABLE STUDENT ADD AGE INT”)
mydb.commit()

#TO DROP A COLUMN FROM THE TABLE USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="student")
mycursor=mydb.cursor()
mycursor.execute("ALTER TABLE DROP AGE ”)
mydb.commit()

# TO ALTER THE DATATYPE OF A COLUMN IN A TABLE USING PYTHON INTERFACE

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="syste
m",database="student")
mycursor=mydb.cursor()
mycursor.execute("ALTER TABLE STUDENT MODIFY GRADE CHAR(3)")

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 202
  commit( ): After executing insert or update query we must commit our
transaction using commit method of connection object.
Eg: mycon.commit()
 rollback( ): mysqlConnection.rollback() reverts the changes made by the
current transaction.
 rowcount: This attribute returns the number of rows that were affected
by an execute()

Closing cursor and connection

Since the database can keep limited number of connections at a time ,
we must close the connection using
cursorobject.close()
Eg: mycursor.close()
con.close()
Model Questions
I. Multiple choice Questions(MCQ):
1. DBMS stands for
a) Data Base Management Software
b) Data Base Maintenance System
c) Data Basic Management System
d) Data Base management system

2. In RDBMS, R stands for

a) Relational b)Rotational c)Rational d)None of the above

3. A Database contains one or more_ _

a) Data b)Tables c)Files d)Links

4. What is not true in respect of DBMS?

a) Database enforces standards
b) Database increases redundancy
c) Database facilitates sharing of data
d) Database helps to maintain integrity

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 203
 5. Cardinality is total _
a) number of rows in a table
b) number of columns in a table
c) number of data items in a table
d) none of the above

6. Degree refers to total

a) number of rows in a table
b) number of columns in a table
c) number of data items in a table
d) none of the above

7. Referential Integrity is a rule that ensures between records in

related tables are valid.
a) Links b)difference c)relationship d)similarity

8. Data about data is

a) Data redundancy
b) Meta Data
c) Database schema
d) None of the above

9. Repetition of data is called ..............

a) Data redundancy
b) Data Description
c) Data inconsistency
d) None of the above

10. Mismatched redundant copies of data is known as data ............

a) Dependence b)Inconsistency c)Isolation d)Redundancy

11. A ............. is an organized collection of structured data.

a) Database
b) File
c) DBMS
d) Information

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 204
 12. A data ................. is a set of rules that define valid data.
a) Query b)Constraint c)Dictionary d)All of the above

13. A relational database consists of a collection of ..............

a) Fields b)Records c)Keys d)Tables

14. A row in a database.

a) Field b)Record c)Key d)Table

15. The term is used to refer to a field in a table.

a) Attribute b)Row c)Tuple d)Instance

16. Which of the following statements is not true about relational database?
a) Relational data model is the most widely used data model.
b) The data is arranged as a collection of tables in relational database.
c) Relational database increases data redundancy and inconsistency.
d) None of the above.

17. Which of the following is a disadvantage of file processing system?

a) Data redundancy
b) Data isolation
c) Data inconsistency
d) All of the above

18. A _ is a property of the entire relation, rather than of the individual tuples in
which each tuple is unique.
a) Rows b)Key c)Attribute d)Fields

19. Which one of the following attribute can be taken as a primary key?
a) Name b)Street c)Id d)Department

20. A _ integrity constraint requires that the values appearing in specified

attributes of any tuple in the referencing relation also appear in specified
attributes of at least one tuple in the referenced relation.
a) Referencing b)Referential c)Primary d)Specific

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 205
 21. Answer the questions based on the table Employee.
Table: Employee

EMPID ENAME SALARY DEPTNO Email

1001 George 30000 10 [email protected]
1002 Mary 32000 12 [email protected]

1003 Alwin 25000 12 [email protected]

1004 Sumit 20000 11 [email protected]

a) The cardinality of the table Employee is ……

i) 5 ii)4 iii)3 iv)6

b) The degree of the table Employee is …….

i) 3 ii)4 iii)5 iv)6

c) Which column can be made as the primary key in the table Employee?
i) EMPID
ii) EMAIL
iii) Both i and ii
iv) None of the above

d) If two columns are added to the table Employee, then the cardinality and
degree of the table is …… and …… respectively.
i) 4,7
ii) 7, 4
iii) 6,5
iv) 5,6

e) State True/False:
Both EMPID and EMAIL can be defined as primary key in the table
Employee.

i) True ii)False

22. An attribute in a relation is a foreign key if it is the _ key in any other

relation.
a) Candidate b)Primary c)Super d)Sub

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 206
 23. A(n) in a table represents a logical relationship among a set of values.
a) Column b)Key c)Row d)Attribute

24. Which of the following attributes can be considered as a choice for the primary
key?
a) Name b)Street c)RollNo d)Subject

Fill in the blanks:

1) _ helps in efficient retrieval, inserting and deleting of data.

2) _ is a software for creating and managing databases.
3) means that data is accurate and consistent in the database.
4) - ensure that the database properly changes states upon a
successfully committed transaction.
5) RDBMS stands for .
6) In RDBMS a database is considered as a collection of
7) Collection of rows and columns are called as
8) Record is also called as a
9) The group of one or more columns used to uniquely identify each row of a relation
is called
10) is data about data.
11) A is a request to a database for obtaining information in a desired way.
12) _ is collection of values from which the value is derived for a column.
13) are the columns of a table that points to the primary key of another table.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 207
 Worksheet 1:
1. There is a column HOBBY in a Table CONTACTS. The following two statements are

giving different outputs. What may be the possible reason ?

a. SELECT COUNT(*) FROM CONTACTS;
b. SELECT COUNT(HOBBY)FROM CONTACTS;
2. Given the following employee table:-

a. What values will the following statements return ?

b. SELECT COUNT(*) FROM Employee;

c. SELECT COUNT(Commission) FROM Employee;
3. .What will be the output of the following queries on the basis of Employee table:

a. Select avg(Salary) from Employee;

b. Select Salary+100 from Employee where EmpId='A002';

4. Kunal has entered the following SQL command on Table ‘STUDENT’ that has
TotalMarks as one of the columns.
SELECT COUNT (*) FROM STUDENT;
The output displayed is 20. Then, Kunal enters the following command :
SELECT COUNT (*) FROM STUDENT WHERE TotalMarks <100;
The output displayed is 15. Then, Kunal enters the following command :
SELECT COUNT (*) FROM STUDENT WHERE TotalMarks >= 100;
He predicts the output of the above query as 5. Do you agree with Kunal ? Give reason
for your answer.
5. Consider the table given below :

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 208
 Write command for (i) and output for (ii)

i) To display Area along with number of Salespersons working in that area.

(ii) SELECT Area, COUNT (*) FROM Salesperson GROUP BY Area HAVING COUNT (*) > 1;

6. Consider the table ‘PERSONS’ given below. Write commands in SQL for (i) to (iv) and
write output for (i) to (iii)

(i) SELECT SUM(BasicSalary) FROM Persons Where Gender=’F’;

(ii) SELECT Gender,MIN(BasicSalary) FROM Persons GROUP BY gender;
(iii) SELECT Gender,Count(*) FROM Persons GROUP BY Gender;
7. In a database there are two tables 'Customer' and 'Bill' as shown below:

(i) How many rows and how many columns will be there in the Cartesian product of
these two tables?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 209
 (ii) Which column in the 'Bill' table is the foreign key?
8. Consider the tables HANDSETS and CUSTOMER given below:

With reference to these tables, Write commands in SQL for (i) and (ii) and output for (iii)
below:

(i) Display the CustNo, CustAddress and corresponding SetName for each customer.

(ii) Display the Customer Details for each customer who uses a Nokia handset.
(iii) select SetNo, SetName from Handsets, customer where SetNo = SetCode and
CustAddress = 'Delhi';
9. Consider the tables DOCTORS and PATIENTS given below:

With reference to these tables, write commands m SQL for (I) and (II) and output for (iii)
below:

(i) Display the PatNo, PatName and corresponding DocName for each patient
(ii) Display the list of all patients whose OPD_Days are MWF.
(iii) select OPD_Days, Count(*) from Doctors, Patients where Patients.Department
= Doctors.Department Group by OPD_Days;

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 210
 Worksheet 2
1. The following table represents information on sales representatives of ABC company
with the following data.
Sales man name
Code
Address
commission
salary.
Write Python code to create the above table.

2. Write Python mysql connectivity program to retrieve all the data from a table student.

3. Write a python code to delete all the records from employee table whose age >60
and the table has the following fields. Empid, empname, deptid, age, payscale

4. Consider the information stored in the table : EMP

EMPNO ENAME DEPT SALARY

1 ALEX MUSIC 60000
2 PETER ART 67000
3 JOHNY WE 55000
4 RAMBO P&HE 48000

A pythoncode is writtentoaccess therecordsoftable: EMP, What willbe theoutput of

following code:
# Assume Allbasicsetuprelated toconnection andcursorcreation is alreadydone
query="select * from emp"
mycursor.execute(query)
results = mycursor.fetchone()
results = mycursor.fetchone()
results = mycursor.fetchone()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 211
 d = int (results[3])
print (d*3)

5. Considerthe following Pythoncode is writtentoaccess thedetails of employee, whose

employee number is passed to function:
Complete the missing statements:

def Search(eno):

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="sy
stem",database="DB")
mycursor=mydb.cursor()
query="select * from emp where empno= ".format(eno)
mycursor.execute(query)
results = mycursor.
print(results)

6. Consider the following python code for updating the records.

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="
system",database="student")
mycursor=mydb.cursor()
mycursor.execute("UPDATE STUDENT SET MARKS=95 WHERE MARKS=50")
print(mycursor.rowcount,"RECORD UPDATED")
Code is running but the record in actualdatabase is not updating, what could be the
possible reason?

7. Whichfunction of connection is usedtocheck whether connection tomysql is

successfully done or not?
import mysql.connector as msq

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 212
 con=msq.connect(#ConnectionString) # Assumingallparameterrequiredas
passed
if _:
print(“Connected!”)
else:
print(“ Error! Not Connected”)

8. What is the difference in fetchall() and fetchone()?

9. Write a python connectivity program to retrieve data, one record at a time from EMP
table for employees with id<10.

10. Write python connectivity program to delete the employee record whose name is
read from the keyboard at execution time.

11. SD School is managing the student data in student table in school database. Write a
python code that connects to database school and display the record of students and
total number of students.

12. Which record will get inserted in the table by the following code:
Import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="s
ystem",database="db")
mycursor=mydb.cursor()
a=1011
b=”Euphoria”
c=599.00
mycursor.execute("INSERT INTO BOOKS(bookid,bname,price) VALUES
({},'{}',{})" .format(a,b,c))
mydb.commit()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 213
 WORKSHEET 3 - Fill in the blanks

1.A ------------------- is a special control structure that facilitates the row by row processing
of records in the resultset.
2.After importing mysqlconnector, first of all --------------- is established by using connect()
3----------------- method executes a database query from within Python.
4. Running of sql query through database cursor returns the table records in the form
of
5. A connectivity package--------------- must be imported before running db connection
program.

WORKSHEET 4 -(Multiple Choice questions:)

1. Which of the following is not a legal method for fetching records from database.
a)fetchone() b)fetchtwo() c)fetchall() d)fetchmany()
2. To fetch one record from resultset you may use<curor> ............ method.
a) fetch() b)fetchone() c)fetchtuple d)none of these.
3. To reflect the changes made in the database permanently you need to run……..
a) done() b)reflect() c)commit() d)final
4. To run an sql query from within python you may use cursor -------------- method.

a) query() b)execute() c)commit() d)final()

5. A database ............. controls the connection to an actual database , established in

program.
a) database object b)connection object c)fetch object d)query object

Very Short Answer Questions:

1. What is meant by a database?
A database is an organized collection of structured information, or inter-related data,
typically stored in a computer system.

2. What is primary key?

A primary key is a column or set of columns that contain values that uniquely identify each
row in a table.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 214
 3. What do you mean by candidate key?
It is an attribute or a set of attributes or keys participating for Primary Key, to uniquely
identify each record in that table.

4. What is meant by degree and cardinality of a table?

Degree refers to the number of attributes/columns in a relation. Cardinality refers to the
number of tuples/rows in a relation
5. What is meant by RDBMS?
RDBMS (relational database management system) is the software used to store, manage,
query, and retrieve data stored in a relational database. The RDBMS provides an interface
between users and applications and the database, as well as administrative functions for
managing data storage, access and performance.
6. What is meant by database schema?
Database schema is also called the visual or logical architecture as it tells us how the data
are organized in a database.

7. What is meant by data constraint?

Restrictions or limitations are put on the type of data that can be inserted in one or more
columns of a table to ensure accuracy and reliability of data in the database.
8. What is meant by relation?
A relation is a named, two dimensional table storing logically related data.

MODEL PRACTICE QUESTIONS:

1. Which command is used to add new column in existing table?

2. Which clause is used to search for NULL values in any column?
3. Which command is used to see information like name of columns, data type, size
4. Which clause is used for pattern matching? What are the 2 main characters used
for matching the pattern?
5. Which clause is used to see the output of query in ascending or descending order?
6. Which clause is used to eliminate the duplicate rows from output?
7. Which command is used to remove the table from database?
8. Which option of ORDER BY clause is used to arrange the output in descending
order?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 215
 9. Meetali is a database programmer, She has to write the query from EMPLOYEE
table to search for the employee who are getting any commission, for this she
has written the query as:
SELECT * FROM EMPLOYEE WHERE commission=null;
But the query is not producing the correct output, help Raj and correct the query
so that he gets the desired output.

10. Raj is a database programmer, He has to write the query from EMPLOYEE table to
search for the employee who are not getting any commission, for this he has
written the query as: SELECT * FROM EMPLOYEE WHERE commission=null;
But the query is not producing the correct output, help Raj and correct the query
so that he gets the desired output.

11. Deepika wants to remove all rows from the table BANK. But he needs to maintain
the structure of the table. Which command is used to implement the same?
12. While creating table ‘customer’, Rahul forgot to add column ‘price’. Which
command is used to add new column in the table. Write the command to
implement the same.

13. Observe the given Table TEACHER and give the output of question (i) and (ii)

TEACHER_CODE TEACHER_NAME DOJ

T001 ANAND 2001-01-30

T002 AMIT 2007-09-05

T003 ANKIT 2007-09-20

T004 BALBIR 2010-02-15

T005 JASBIR 2011-01-20

T006 KULBIR 2008-07-11

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 216
 (i) SELECT TEACHER_NAME,DOJ FROM TEACHER WHERE TEACHER_NAME LIKE
“%I%”;
(ii) SELECT * FROM TEACHER WHERE DOJ LIKE “%-09-%”;

14. Write SQL QUERIES for q no 1 to 4

1. To display NO, NAME, TDATE from the table TRIP in descending order of NO.

2. To display the NAME of the drivers from the table TRIP who are traveling by transport
vehicle with code 101 or 103.

3. To display the NO and NAME of those drivers from the table TRIP who travelled
between ‘2015-02-10’ and ‘2015-04-01’.

4. To display all the details from table TRIP in which the distance travelled is more than
100 KM in ascending order of NOP

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 217
 ANSWERS: 1. Multiple Choice Questions (MCQ )

1 D 2 A 3 B 4 B
5 A 6 B 7 C 8 B

9 A 10 B 11 A 12 B
13 D 14 B 15 A 16 C
17 D 18 B 19 C 20 B

21a) (ii) 21b) (iii) 21c) (iii) 21d) (ii)

21e) (ii) 22 B 23 C 24 C

Answers Fill in the blanks:

1 Database 2 DBMS 3 Data integrity

4 Consistency 5 Relational Database 6 Interrelated data
Management
System

7 Table 8 Tuple 9 Primary key

10 Meta – data 11 Query 1 Domain
2

13 Foreign key

ANSWER KEY WORKSHEET1 :

1. The column hobby may have NULL values, when we give count(colname) it
ignores null values while count(*) will count all duplicate and NULL values.
therefore two statements may give different values.
2. 3
1
3. I) 5300
II) NULL
4. Yes , as no of records =20 , students scoring <100 = 15. ; hence the students
scoring greater than equal to 100 will be 20-15 =5. As all the three statements
mentioned use count(*) as the count function.
5. i) select area,count(*) from salespersons group by area;
ii) North 2

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 218
 South 2
6. I) 132000
II) F 42000
M 33000
III) F 3
M 4
7. i) 15 rows and 6 columns
ii) custID
8. i) select Custno,CustAddress,setName from customer c,handset h where
c.setNo=h.setName;
ii) select Custno,CustAddress,setName from customer c,handset h where
c.setNo=h.setName and h.setName like ‘Nokia%’;
iii) N2 Nokia 3G
B1 Blackberry
9. I) select patNo,PatName,DocName from Patient p,doctor d where
p.docID=d.docID;
II) select patNo,PatName,DocName from Patient p,doctor d where
p.docID=d.docID and OPD_Days=”MWF”;

ANSWER KEY FOR WORKSHEET2 :

1.

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="syste
m",database="sales") mycursor=mydb.cursor()
mycursor.execute("CREATE TABLE SALESMAN (NAME VARCHAR(20),CODE INT
,ADDRESS VARCHAR(20), COMMISSION DEC,SALARY FLOAT);")
2.
import mysql.connector
conn=mysql.connector.connect(host="localhost",user="root",passwd="syste
m",database="DB") c=conn.cursor()
c.execute("select * from student")
r=c.fetchone()
while r is not None:
print(r)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 219
 r=c.fetchone()
conn.close()

3.
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="DB") mycursor=mydb.cursor()
mycursor.execute("DELETE FROM EMP WHERE AGE>60
") mydb.commit()
print(mycursor.rowcount,"RECORD DELETED")
mydb.close()

4. 165000

5. .{ } and fetchone()

6. con.commit() function is missing in the python code

7. con.is_connected()

8. fetchall() function is used to fetch all the records from the cursor in the form of tuple.
fetchone() isusedtofetchonerecordatatime. Subsequentfetchone() willfetch
nextrecords. If no more records to fetch, it returns None.
9. import mysql.connector

conn=mysql.connector.connect(host="localhost",user="root",passwd="system",datab
ase="com")
c=conn.cursor()
c.execute("select * from emp where id>10")
r=c.fetchone()
while r is not None:
print(r)
r=c.fetchone()
conn.close()
10.
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="DB") mycursor=mydb.cursor()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 220
 s= input(“enter the name”)
mycursor.execute("delete from emp where name =’,-’)”.format(s)
mydb.commit()

11.
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="system
",database="school") mycursor=mydb.cursor()
sql=”select * from student”
mycursor.execute(sql)
recs=mycursor.fetchall()
count=0
for r in recs:
count+=1
print(r)
print(“total no of records”,count)

12. 1011 ,”Euphoria” 599.00

ANSWER KEY FOR WORKSHEET3 (Fill in the blanks)

1. database cursor

2. database connection.
3. execute()
4.resultset
5.mysql.connector

ANSWER KEY FOR WORKSHEET4 (MCQ)

1. b)fetchtwo()
2. b)fetchone()
3. c)commit()
4. b)execute()
5. b)connection object

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 221
 Answers-MODEL PRACTICE QUESTIONS
1. ALTER TABLE
2. IS NULL
3. DESC
4. LIKE
% (percent) and _ (underscore)
5. ORDER BY

6. DISTINCT
7. DROP TABLE
8. DESC
9. SELECT * FROM EMPLOYEE WHERE commission IS NOT null;
10. SELECT * FROM EMPLOYEE WHERE commission IS null;
11. DELETE FROM BANK.

12. ALTER TABLE CUSTOMER ADD PRICE FLOAT;

13.
(i) TEACHER_NAME DOJ
-------------------------------------------------------
AMIT 2007-09-05
ANKIT 2007-09-20
BALBIR 2010-02-15
JASBIR 2011-01-20
KULBIR 2008-07-11

(ii)
TEACHER_CODE TEACHER_NAME DOJ
----------------------------------------------------------------------
T002 AMIT 2007-09-05
T003 ANKIT 2007-09-20

14.

1. SELECT NO,NAME,TDATE FROM TRIP ORDER BY NO DESC;

2. SELECT NAME FROM TRIP WHERE TCODE=101 OR TCODE=103;
3. SELECT NO,NAME FROM TRIP WHERE TDATE BETWEEN ‘2015-02-10’ AND
‘2015-04-01’;
4. SELECT * FROM TRIP WHERE KM >100 ORDER BY NOP;

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 222
 KENDRIYA VIDYALAYA SANGHATHAN – ERNAKULAM REGION
SAMPLE PAPER-1(SOLVED) – COMPUTER SCIENCE (083)

MAX MARKS: 70 TOTAL TIME : 3 hrs

General Instructions:
1. This question paper contains five sections, Section A to E.

2. All questions are compulsory.

3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34 against part
c only.
8. All programming questions are to be answered using Python Language only.
Part A
Section 1 [18 marks] (1x18)( attempt any 18)

1. Which of the following symbols are used for comments in Python? 1

(A) // (B) & (C) /**/ (D) #

2. Suppose str=”computer science with python” .What will be the output of 1
print(type(str))
(a)int (b) bool (c) string (d)str
3. The RDBMS terminology for a row is 1
(a) Tuple (b) relation (c) attribute (d) degree

4. Spans over less than a Kilometer 1

a)MAN b)LAN c)WAN d)All of the above

5. The act which governs the cyber transactions in India is 1

a) IT act 2000 b)IT act 2008 c)IT act 2003 d)None of these

6. A network device used to divide a single computer network into various sub- 1
networks . i)router ii)switch ii)hub iv)R

7. With SQL, how do you select all the records from a table named “Persons” 1
where the value of the column “FirstName” ends with an “a”?
a) SELECT * FROM Persons WHERE FirstName=’a’
b) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
d) SELECT * FROM Persons WHERE FirstName=’%a%’.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 223
 8. Which of the following is not a DDL command? 1
a) UPDATE b) TRUNCATE c) ALTER d) None of the Mentioned

9. To include the use of functions which are present in the random library, we 1
must use the option:
a) import random
b) random.h
c) import.random
d) random.random

10. How many values can be returned by a function in python? 1

a) 0 b) 1 c) more than one d) 2

11. print (id(x)) will print . 1

1. Value of x 2. Datatype of x 3. Size of x 4. Memory address of x

12. Which of the following command is used to change the VALUES OF rows that 1
already exist in a table?
1. Insert. 2. Union. 3. Update. 4. Select

13. Give the output: my_data = (1, 2, "Kevin", 8.9) print (my_data[-3]) 1
1. 8.9 2. “Kevin”. 3. 1 4. 2

14. Suppose list1 is [1, 3, 2], What is list1 * 2 ? 1

a) [2, 6, 4]. b) [1, 3, 2, 1, 3]. c) [1, 3, 2, 1, 3, 2] . d) [1, 3, 2, 3, 2, 1]

15. The readlines() method returns 1

a) str b) a list of lines c) a list of single characters d) a list of
integers

16 To write data into CSV from python console, which of the following function is 1
correct?
a) csv.write(file) b) csv.writer(file)
c) csv.Write(file) d) csv.writerow()

Statement (A) : A function can perform certain functionality 1

17 Statement (B) : A function must return a result value
a) Statement A is correct
b) Statement B is correct
c) Statement A is correct but Statement B is not correct
d) Both are incorrect

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 224
 18 Ms. Suman is working on a binary file and wants to write data from a list to a 1
binary file. Consider list object as l1, binary file suman_list.dat, and file object as
f. Which of the following can be the correct statement for her?
a) f = open(‘sum_list’,’wb’); pickle.dump(l1,f)
b) f = open(‘sum_list’,’rb’); l1=pickle.dump(f)
c) f = open(‘sum_list’,’wb’); pickle.load(l1,f)
d) f = open(‘sum_list’,’rb’); l1=pickle.load(f)

Section B [14 marks] [2x7=14]

Answer All questions

19 Evaluate the following expressions: 2

a) 6+7*4+2**3//5-8
b) 8<5 or no 19<=20 and 11<4

20 Write down the fullform of : 2

POP b) TCP/IP c) WWW d) HTTPS

21 Differentiate between Candidate Key and Primary Key in the context Relational 2
Database Mode

22 What will be the output of the following code? 2

a=[1,2,3,4]
s=0
for a[-1] in a:
print(a[-1])
s+=a[-1]
print(‘sum=’,s)

23 Difference between ALTER & UPDATE commands. 2

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

i. Smridh is a victim of …………

ii. The act of fraudulently acquiring someone’s personal and private information,
such as online account names, login information and passwords is called as
……………

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 225
 25 In the table Loan below 2
(a) Identify the candidate key(s) from the table Garment.
(b) What is the cardinality and degree of the table?

Section C [15 Marks] [3x5]

Answer All questions

26 Vedika has created a dictionary containing names and marks as key-value pairs 3
of 5 students. Write a program, with separate user-defined functions to perform
the following operations:

Push the keys (name of the student) of the dictionary into a stack, where the
corresponding value (marks) is greater than 70.
Pop and display the content of the stack.
The dictionary should be as follows:

d=,“Ramesh”:58, “Umesh”:78, “Vishal”:90, “Khushi”:60, “Ishika”:95-

Then the output will be: Umesh Vishal Ishika

27. A department is considering to maintain their worker data using SQL to store the 3
data. As a database administer, Karan has decided that :

Name of the database - Department

Name of the table - WORKER

The attributes of WORKER are as follows:

WORKER_ID - character of size 3
FIRST_NAME – character of size 10
LAST_NAME– character of size 10
SALARY - numeric
JOINING_DATE – Date
DEPARTMENT – character of size 10

I) Identify the attribute best suitable to be declared as a primary key

II) Karan wants to increase the size of the FIRST_NAME column from 10 to 20

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 226
 characters. Write an appropriate query to change the size.
III) Karan wants to remove all the data from table WORKER from the database
Department.
Which command will he use from the following:

i) DELETE FROM WORKER;

ii) DROP TABLE WORKER;
iii) DROP DATABASE Department;
iv) DELETE * FROM WORKER

28. Ashok Kumar of class 12 is writing a program to create a CSV file “cust.csv” with 3
custid, custname and mobile no and search custname and delete the record. He
has written the following code. As a programmer, help him to successfully
execute the given task.
import _________ # LINE1
record = list()
custname= input("Please enter a customer name to delete:")
with open('cust.csv', 'r') as f:
data = csv. (f) # LINE2
for row in data:
record.append(row)
for field in row:
if field == custname:
record. (row) #LINE3
with open('cust.csv', 'w') as f:
writer = csv.writer(f)
writer.writerows(record

A) Name the module he should import in Line 1.

b) Write a code to read the fields (column heading) once from fields list in
Line2.
(c) Write a code to delete the row from row list in Line3.

29. Write SQL commands for(a) to (b) and write the outputs for (C) on the basis of 2+1
table GRADUATE

a) List the names of those students who obtained DIV 1 sorted by NAME .

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 227
 b )Display a report, listing NAME , STIPEND , SUBJCT and amount of stipend
received in a year assuming that the STIPEND is paid every month.
C.) Give the output of the following SQL statements based on table GRADUATE :
(i) Select MIN(AVERAGE ) from GRADUATE where SUBJECT=”PHYSICS”;
(ii) Select SUM(STIPEND) from GRADUATE where DIV=1;

30 A) Write a function countmy() in Python to read the text file "DATA.TXT" and 3
count the number of times "my" occurs in the file.
For example, if the file "DATA.TXT" contains "This is my website. I have displayed
my preferences in the CHOICE section." - the countmy() function should display
the output as: "my occurs 2 times"Or
Write a method/function DISPLAYWORDS() in python to read lines from a text
file STORY.TXT, and display those words, which are less than 4 characters.

Or

A) Write a method/function DISPLAYWORDS() in python to read lines

from a text file STORY.TXT,and display those words, which are less than 4
characters

Section D [15 Marks]

[5x3]

31. Indian School, in Mumbai is starting up the network between its different wings. 5
There are four Buildings named as SENIOR, JUNIOR, ADMIN and HOSTEL as
shown below:

The distance between various buildings is as follows

1. Suggest the cable layout of connections between the buildings. (1)

2. Suggest the most suitable place (i.e., building) to house the server of this
school, provide a suitable reason. (1)
3. Suggest the placement of the following devices with justification. (2)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 228
 a. Repeater b.Hub/Switch

4. The organisation also has inquiry office in another city about 50-60 km
away in hilly region. Suggest the suitable transmission media to interconnect
to school and inquiry office out of the following : (1)

a) Fiber optic cable

b) Microwave
c) Radiowave

32. Give Output of : 5

(2+3)

def Change (P, Q = 30) :

P=P+Q
Q=P-Q
print (P,"@",Q)
return P
R =150
S= 100
R=Change(R, S)
print(R,"@",S)
S=Change (S)

1. The books table of test database contains the records shown below:-

Title ISBN
Die to Live 78127873915
Again? 23686286243
Ushakaal 12678987036
Ushakiran 42568987036
What will be the output produced by following code:

import mysql.connector as sqltor.

conn = sqltor.connect (host = "localhost", user = "learner", passwd = "fast",
database = "test")
cursor = conn.cursor()
cursor.execute("SELECT * FROM books")
row = cursor.fetchone()
while row is not None:
print (row)
row = cursor.fetchone()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 229
 33 A. Considering the following definition of dictionary MULTIPLEX, write a method 5
in python to search and display all the content in a pickled file CINEMA.DAT,
where MTYPE key of the dictionary is matching with the value "Comedy".

MULTIPLEX = {'MNO': , 'MNAME": _ , 'MTYPE': }

Or
Following is the structure of each record in a data file named "phonebook.DAT".
,“name”: value, "phone": value}
Write a program to edit the phone number of “Arvind” infile “phonebook.dat”. If
there is no record for “Arvind”, report error.

34 Write SQL commands for the queries (i) to (iii) and output for (iv) & (vii) based 4
on a

table COMPANY and CUSTOMER

I) Identify the most appropriate Primary key for Tables Company and Customer.

Ii) To display those company name which are having prcze less than 30000.

iii a.To increase the price by 1000 for those customer whose name starts with S?

b) What is the cardinality and degree of table customer?

Or

Iii)a) Delete the records from table customer whose name has KUMAR.

B. Insert a new record in table COmpany where CID : 777, Name : APPLE City
KOCHI and PRODUCTNAME is LAPTOP

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 230
 35 Aradhana is creating a binary file student.dat that has structure 4
(rollno,name,class,percentage). She wrote a program to updating a record in
the file requires roll number to be fetched from the user whose name is to be
updated. She has few doubts in the code. Help her to complete the task. She
uses intermediate file for working temp.dat
Import ______ #STATEMENT 1
import os
f1 = open(‘student.dat','rb')
f2=open(“temp.dat”,” ”) #Statement2
r=int(input(“enter rollno which you want to search”))
try:
while True:
e = pickle.load(f1)
if e[0]==r:
e*1+=input(“enter name”)
pickle.dump( ) #Statement3
else:
pickle.dump(e,f2)
except:
f1.close()
f2.close()
os.remove(“student.dat”)
os. (“temp.dat”,”student,dat”) #Statement4

(i) Which module should be imported in the program? (Statement 1)

(ii) Write the correct statement required to open a temporary file named
temp.dat. (Statement 2)
(iii) ) Which statement should Aradhana fill in Statement 3 to write the data
to the binary filedat
(iv) Statement 4 to write the rename temp.dat to student.dat?

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 231
 KENDRIYA VIDYALAYA SANGHATHAN – ERNAKULAM REGION
SAMPLE PAPER-1(SOLUTION) – COMPUTER SCIENCE (083)
Part A
Section 1 [18 marks] (1x18)
1. (a) // 1
2. (d)str 1
3. (a) Tuple 1
4. b)LAN 1
5. a)IT act 2000 1
6. ii)switch 1
7. c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’ 1
8. a) UPDATE 1
9. a) import random 1
10. c) more than one 1
11. 4. Memory address of x 1
12 3. Update. 1
13. 4. 2 1
14. c) [1, 3, 2, 1, 3, 2] . 1
15. b) a list of lines 1
16. b) csv.writer(file) 1
17 c) Statement A is correct but Statement B is not correct 1
18 a) f = open(‘sum_list’,’wb’); pickle.dump(l1,f) 1

Section B [2x7=14]
Answer All questions

19 a) 27 b) False 2
20 a) Post Office Protocol b)Transmission Control Protocol/Internet 2
Protocol c) World Wide Web
d) Hypertext Transfer Protocol Secure
21 Candidate Key: The columns which can serve as primary key of a table 2
is known as candidate keys. There can be multiple candidate for a
relation.
Primary Key: Primary key is a field name which identifies rows
uniquely. There can be only one primary key for a relation.
22 1 2
2
3
3
Sum=9
23 ALTER Command is used to add, delete, modify the attributes of the 2
relations (tables) in the database. UPDATE Command is used to update
existing records in a database.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 232
 24 i)Cyber stalking ii)Phishing 2
25 a) GCODE, GNAME, b) Degree=5 & Cardinality=6 2
26 def push(stk,item): 3
stk.append(item)
def Pop(stk):
if stk==[]:
return None
else:
return stk.pop()
stk=[]
d={"Ramesh":58, "Umesh":78, "Vishal":90, "Khushi":60, "Ishika":95}
for i in d:
if d[i]>70:
push(stk,i)
while True:
if stk!=[]:
print(Pop(stk),end=" ")
else:
break
27 I) WORKER_ID 3
II) alter table worker modify FIRST_NAME varchar(20);
lll)DELETE FROM WORKER;
28. a) csv 3
.b) reader
.c) remove
29 A. List the names of those students who obtained DIV 1 sorted by 2+1
NAME .
Ans.: SELECT name FROM graduate WHERE div=1 ORDER BY name;
(b )Display a report, listing NAME , STIPEND , SUBJCT and amount of
stipend received in a year
assuming that the STIPEND is paid every month.
Ans.: SELECT name, stipend, subject, stipend *12 FROM graduate;
(C) Give the output of the following SQL statements based on table
GRADUATE :
(i) Select MIN(AVERAGE ) from GRADUATE where SUBJECT=”PHYSICS”;
Ans. MIN(AVERAGE)

63
(ii) Select SUM(STIPEND) from GRADUATE where DIV=1;
Ans.: SUM(STIPEND)

1000
30 A) 3
def countmy ():
f = open("DATA.txt", "r")
count = 0

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 233
 x = f.read()
word = x.split()
for i in word :
if (i == "my") :
count = count + 1
print ("my occurs", count, "times")

A. close()
Or

ii) )
def DISPLAYWORDS() :
file = open("story.txt", "r")
lst = file.readlines()
for i in lst :
word = i.split()
for j in word :
if len( j ) < 4 :
print( j )
file.close()
print("Word with length smaller than 3 :- \n")
DISPLAYWORDS()

SectionD [15 Marks]

[5x3]
31. 5

1.

2. Server can be placed in the ADMIN building as it has the maxium

number of computer.
3. (a) Repeater can be placed between ADMIN and SENIOR and
ADMIN and JUNIOR building as the distance is more than 80 m.
(b) Hub/Switch : can be placed in all building in order to connect the
computer within
4. Radiowaves can be used in hilly regions as they can travel through
obstacles
32 b) 2+3

250 @ 150

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 234
 250 @ 100

130 @ 100

c)
(Die to Live 78127873915)
(Again? 23686286243)
(Ushakaal 12678987036)
(ushakiran 42568987036)

33. A.) def Search(): 5

file = open('CINEMA.DAT', "rb")
try:
while True:
MULTIPLEX = pickle.load(file)
if MULTIPLEX ["MTYPE"] == "Comedy":
print (MULTIPLEX)
except EOFError:
file.close()

Or

B.) Try = 0
f = open("phonebook.det","r")
data = f.readlines()
f.close()
f = open("phonebook.det","w")
name = input("Enter name which you want search :-")
for i in range(len(data)) :
line = data[ i ] . split()
if line[0] == name :
phone = input("Enter new Phone :-")
data[ i ] = name + " " + phone
Try = 1

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 235
 if Try != 1 :
print("Try again !!!!! ")

for i in range(len(data)) :
line = data[ i ] . split()
for j in line :
f.write( j + "\t")
f.write("\n")

f.close()
print("Thankyou")

Section E [8 Marks]
[4x2]
34 1)CID for Company and CUSTID for CUtomer 4

II) Select company.Name from company , Customer where

company.cid=customer.cid and price <30000
III) a. update customer set price=price+1000 where name like ‘S%’
b) cardinality : 7 degree : 5
Or
III a. delete from Customer where name like “ %Kumar%’
B) Insert into COMPANY values( 777,’APPLE’, ‘OCI’,”LAPTOP’)
35 (v) pickle 4
(vi) Wb
(vii) pickle.dump(e,f2)
(viii) .rename()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 236
 KENDRIYA VIDYALAYA SANGATHAN ERNAKULAM REGION
CLASS XII SAMPLE PAPER-2 2022-23 (SOLVED)

Subject: COMPUTER SCIENCE (083)

Time Allotted: 3 HRS Max Marks: 70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered using Python Language only.
QNo. Section-A Marks
1 Find the invalid identifier from the following 1
a) sub%marks b)age c)_subname_ d)subject1
2 Given the list L=*“A”, “E”, “I”, “O”, “U”+ , write the output of print(L[2:5]) 1
3 Which module is required to work with CSV files in Python? 1
4 Identify the invalid logical operator in Python from the following. 1
a) and b) or c) by d) not
5 Suppose a tuple K is declared as K = (100, 102, 143, 309), which of the 1
following is incorrect?
a) print(K[-1])
b) K[3] =405
c) print(min(K))
d) print(max(K))
6 Write a statement in Python to declare a dictionary whose keys are 1
Sub1, Sub2, Sub3 and values are Physics, Chemistry, Math
respectively.
7 A List is declared as 1

List1=[2,3,5,7,9,11,13]
What will be the value of len(List1)
8 Name the built-in mathematical function / method that is used to 1
return the smallest integer less than or equal to N.
9 Name the protocol that is used to transfer files. 1

10 Ms. Priya is an IT expert. She recently used her skills to access the Admin 1

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 237
 password for the network server of Happiest Minds Technology Ltd.
and provided confidential data of the organization to its CEO, informing
him about the vulnerability of their network security. Out of the
following options which one most appropriately defines Ms. Priya?
a) Cracker b) Operator c) Hacker d) Network Admin
11 In SQL, name the clause that is used to sort the records in 1
ascending/descending order of an attribute.
12 In SQL, what is the use of IS NOT NULL operator? 1
13 Name the aggregate function to find the average value in SQL. 1
14 Which of the following is not a DDL command? 1
a) UPDATE b)ALTER TABLE c)CREATE TABLE d)DROP TABLE
15 Name the transmission media best suitable for difficult terrain like hilly 1
areas.
16 Identify the data type of INFO: 1
INFO = ['hello',203,'9',[5,6]]
a. Dictionary b. String c. Tuple d. List
17 Assertion (A):- If the arguments in function call statement match 1
the number and order of arguments as defined in the function
definition, such arguments are called positional arguments.

Reasoning (R):- During a function call, the argument list first contains
default argument(s) followed by positional argument(s).
Mark the correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True
18 Assertion (A):- If the arguments in function call statement match the 1
number and order of arguments as defined in the function definition,
such arguments are called positional arguments.

Reasoning (R):- During a function call, the argument list first contains
default argument(s) followed by positional argument(s).
Mark the correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 238
 SECTION-B
19 Evaluate the following expressions: 2
a) 16 // 3 + 3 ** 3 + 15 / 4 - 9
b) x>y or y<z and not x!=z If x, y, z=25, 16, 9
20 Differentiate between WiFi and WiMax in context of wireless 2
communication technologies.
OR
Differentiate between Domain name and URL. Illustrate with the help of
suitable example.
21 Expand the following terms: 2
a. GPRS b. GSM c. WLL d. PPP

22 Differentiate between positional parameters and default parameters 2

with suitable example program for each.
OR
How can a function return multiple values? Illustrate with an
example program.
23 Rewrite the following code in Python after removing all syntax error(s). 2
Underline each correction done in the code.

for Name in [Aakash, Sathya, Tarushi]

IF Name[0]= 'S':
print(Name)

24 What are the incorrect output(s) from the given options when the following 2
code is executed? Also specify the minimum and maximum values that can
be assigned to the variable VALUE.

import random
VALUE = random.randint (0,3)
SUBJECT=*“PHY”,”CHEM”,”MATHS”,”COMP”+;
for I in SUBJECT:
for J in range(1, VALUE):
print(I, end=””)

print()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 239
 Options:

i) PHYPHY ii) PHY

CHEMCHEM PHYCHEM
MATHSMATHS PHYCHEMMATHS
COMPCOMP
iii) PHY iv) PHY
CHEMCHEM CHEM
COMPCOMPCOMP MATHS
COMP

25 What do you understand by Alternate Keys in a table? Give a suitable 2

example of Alternate Keys from a table containing some meaningful data.

Section- C
26 Write a function Interchange (num) in Python, which accepts a list num of 3
integers, and interchange the adjacent elements of the list and print the
modified list as shown below: (Number of elements in the list is assumed as
even)

Original List:
num = [5,7,9,11,13,15]
After Rearrangement
num = [7,5,11,9,15,13]
27 Write a function in Python that displays the words, starting with uppercase 3
letter in a file ‘legend.txt’.
Example: If the “legend.txt” contents are as follows:
Diego Maradona, Argentinian soccer legend and celebrated Hand of God
scorer dies at 60.
The output of the function should be:
Diego
Maradona,
Argentinian
Hand
God
OR
Write a function countdigits() in Python, which should read each character
of a text file “marks.txt”, count the number of digits and display the file
content and the number of digits.
Example: If the “marks.txt” contents are as follows:
Harikaran:40,Atheeswaran:35,Dahrshini:30,Jahnavi:48

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 240
 The output of the function should be:
Harikaran:40,Atheeswaran:35,Dahrshini:30,Jahnavi:48
('Total number of digits in the file:', 8)
28 Write the outputs of the SQL queries (i) to (iii) based on the relations Car 3
and Customer given below:
Car
Ccode Cname Make Colour Capacity Charges
201 Triber Renault Yellow 7 1000
203 Altroz Tata Black 5 1500
208 Innova Toyota Silver 8 3000
209 Harrier Tata White 6 2000
212 Duster Renault Red 6 2500
217 Ertiga Suzuki Grey 7 2300

Customer
Custcode Custname Ccode
101 Gopinath 201
102 Ashok 203
103 Harshini 209
104 Vishnu 212

i. Select make, count(*) from Car group by make having count(*)<2;

ii. Select Cname, Make from Car order by charges desc;
iii. Select Custname, Cname from Car R, Customer C where
R.Ccode=C.Ccode:
29 Write a function in Python Push (nums), where nums is a list of numbers. 3
From this list push all odd numbers into a stack implemented by using a list.
Display the stack if it has at least one element, otherwise display
appropriate error message.
OR
Write a function in Python Popstack (names), where names is a stack
implemented by a list of names. The function returns the name deleted
from the stack.
30 Find and write the output of the following Python code: 3

def Shuffle(str1):

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 241
 str2=""
for i in range(0,len(str1)-1):
if(str1[i].islower()):
str2=str2+str1[i].upper()
elif str1[i].isupper():
str2=str2+str1[i].lower()
elif str1[i].isdigit():
str2=str2+'d'
else:
str2=str2+(str1[1-i])
print(str2)

Shuffle('Pre-Board Exam@2023')
Section-D
31 Young Minds Ltd. is an educational organization. It is planning to setup its 5
India campus at Chennai with its head office at Delhi. The Chennai campus
has 4
main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA.
You as a network expert have to suggest the best network related
solutions for
their problems raised in (i) to (v), keeping in mind the distances between
the
buildings and other given parameters.

Shortest distances between various buildings :

ADMIN to ENGINEERING 55 m
ADMIN to BUSINESS 90 m
ADMIN to MEDIA 50 m
ENGINEERING to BUSINESS 55 m
ENGINEERING to MEDIA 50 m
BUSINESS to MEDIA 45 m
DELHI Head Office to CHENNAI 2175 km
Campus

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 242
 Number of Computers installed at various buildings are as follows :
ADMIN 110
ENGINEERING 75
BUSINESS 40
MEDIA 12
DELHI Head Office 20

(i) Suggest the most appropriate location of the server inside the CHENNAI
campus (out of the 4 buildings), to get the best connectivity for maximum
no. of computers. Justify your answer.
(ii) Suggest the topology and draw the cable layout to efficiently connect
various buildings within the CHENNAI campus.
(iii) Which hardware device will you suggest to be procured by the company
to minimize the transmission loss?
(iv) Which will be the most suitable wireless communication medium to
connect Chennai campus with its Delhi head office?
(v) Which of the following will you suggest to establish the online face-to-
face
communication between the people in the Admin Office of CHENNAI
Campus and DELHI Head Office?
(a) Cable TV
(b) Email
(c) Video Conferencing
(d) Text Chat
32 Write the SQL commands for the following questions (i) to (v) based on the 5
relations Car and Customer given below:

Car
Ccode Cname Make Colour Capacity Charges
201 Triber Renault Yellow 7 1000
203 Altroz Tata Black 5 1500
208 Innova Toyota Silver 8 3000

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 243
 209 Harrier Tata White 6 2000
212 Duster Renault Red 6 2500
217 Ertiga Suzuki Grey 7 2300

Customer

Custcode Custname Ccode

101 Gopinath 201
102 Ashok 203
103 Harshini 201
104 Vishnu 212
(i) To display the Names and Charges of all the Silver coloured cars.
(ii) To display the non duplicate car codes in the customer table.
(iii) To display the Minimum and Maximum car charges.
(iv) To give a discount of 10% in the car charges for existing customers (who
are in the customer table).
(v) To display Name and Make of cars whose charges is in the range 2000
to 3000 (both inclusive).
33 A binary file “vehicle.dat” has structure [RegNo, Type, Make, Year]. 5
a. Write a user defined function AddVahan() to input data for a vehicle
and add to “vehicle.dat” file.
b. Write a function CountVahan(Type) in Python which accepts the
Type of the vehicle as the parameter and count and return the
number of vehicles of the given Type.

OR

A binary file “player.dat” has structure (PlayerId, Name, Team, StrikeRate).

Write a function ShowPlayer() in Python that would read contents of the file
and display the details of those players whose Team is “India” and
StrikeRate is above 50. Also display the total number of such players.

SECTION E
34 A Book store Current Books is planning to store their book details in a 4
database using SQL. As a database administrator, Poorvekka has decided
that:
(a) Name of the database - CB

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 244
 (b) Name of the table - Collections
(c) The attributes of Collections are as
follows:

BookNo - Numeric
BookName – Character of size 25
Price – Numeric
Quantity – Numeric
Table : Collections
BookNo BookName Price Quantity
1647 The Lowland 399 75
5241 The Inheritance Of Loss 555 44
3546 The Guide 641 60
4541 Untouchable 529 53
5025 Train to Pakistan 643 73
6783 Godan 341 97
7614 The God Of Small Things 555 48

(d) Identify the attribute best suitable to be declared as a primary key,

(e) Write the degree and cardinality of the table Collections.
(f) Write SQL command to increment the quantity by 20 wherever
quantity is below 50.
(d) Poorvekka wants to remove the entire data from table
Collections. Which command will she use from the following:
a. DELETE FROM Collections;
b. DELETE Collections;
c. DROP DATABASE CB;
d. DELETE * FROM Collections;
35 Atul Prakash of Class 12 is writing a program to create a CSV file 4
“students.csv” which will contain student name and admission number
for some entries. He has written the following code. As a programmer,
help him to successfully execute the given task.
import _________________________________________ # Line 1

def Addstudents(Name, Admno): # to write / add data into the CSV

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 245
 f=open('students.csv',' ') # Line2
writerObj = csv.writer(f)
writerObj.writerow([Name,Admno])
f.close()
#csv file reading code
def Retrievestudents():# to read data from CSV

with open(' students.csv','r') as fobj:

readerObj=csv. (fobj) # Line
3 for row in readerObj:
print (row[0],row[1])
fobj.close() # Line4

AddStudents(“Raghava”, “2541”)
AddStudents (“Pooja”,”3411”)
AddStudents(“Krutika”,”2218”)
Retrievestudents () #Line 5

(a) Name the module to be imported in Line 1.

(b) Which mode Atul should open the file to add data.
(c) Fill in the blank in Line 3 to read data from a csv file.
(d) Is Line 4 mandatory? Justify your answer.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 246
 KENDRIYA VIDYALAYA SANGATHAN: ERNAKULAM REGION
CLASS XII SAMPLE PAPER -2 2022-23(SOLUTION)

Subject: COMPUTER SCIENCE (083)

MARKING SCHEME
Section - A
1 a) sub%marks 1
2 *“I”, “O”, “U”+ 1
3 Module “csv” 1
4 c) by 1
5 b) K[3] =405 (as tuple is immutable) 1
6 ,“Sub1” : “Physics” , “Sub2” : “Chemistry” , “Sub3”: “Math”- 1
7 7
1
8 floor() from math module 1
9 FTP (File Transfer Protocol) 1
10 c) Hacker 1
11 ORDER BY 1
12 To check for values which are not defined as NULL 1
13 AVG 1
14 a) UPDATE 1
15 Microwave / Radio wave 1
16 d. List 1
17 Ans: (c) A is True but R is False 1
18 Ans: (a) Both A and R are true and R is the correct explanation for A 1
SECTION B
19 a) 26.75 1
1
b) True
20 Wi-Fi is the name of a wireless networking technology that uses radio waves to 2
provide wireless high-speed Internet and network connections.

WiMax (World wide Interoperability for Microwave Access) is a wireless industry

coalition dedicated to the advancement of IEEE 802.16 standards for broadband
wireless access (BWA) networks.
OR

Domain Name: A domain name is a unique name that identifies a particular

website and represents the name of the server where the web pages reside.

URL: The Uniform Resource Locator is a means to locate resources such as web
pages on the Internet. URL is also a method to address the web pages on the
Internet.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 247
 Example: http://cbseacademic.nic.in/web_material/CurriculumMain22/CS2022-
23.pdf
is an URL where cbseacademic.nic.in is the domain name.
21 a. GPRS – General Packet Radio Services 2
b. GSM – Global System for Mobile communications
c. WLL – Wireless Local Loop/Wireless in Local Loop
d. PPP – Point to Point Protocol
22 Positional Parameter - When function calls are made, there is a one to one 2
correspondence between the argument and the parameter based on the
order/position in which the argument appears in the function.
Ex:
def fun1(x,y,z):
m= x/y-z
print(m)
a,b,c = 5,2,3
fun1(a,b,c)
fun1(4,b,b)
#fun1(a,b) #Error as the third argument is missing

Default parameters - Usually when a function is called, the number of arguments

must match exactly the number of parameters, otherwise python gives an error.
But there is an exception, if a function is defined with a default parameter, then
the function call can have less number of arguments than the number of
parameters in the function header.
Ex:
def fun1(x,y,z=2): # z is default parameter
m= x/y-z
print(m)
#def fun2(m=2,n,p): # error default arguments must be rightmost
# return m+n+p
a,b,c= 1,2,3
fun1(a,b,c)
fun1(a,b)
#fun1(b) #error as at least two parameters must be passed
OR
A function can return multiple values which is written after the return statement
and the values are separated by commas. The multiple return values are returned
as a tuple object to the statement that made the function call.
Ex:
def fun1(x,y,z):
return x+y,y+z,z+x
a,b,c= 3,5,9

#multiple returned values accepted as a tuple

m = fun1(a,b,c)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 248
 print(m)

#multiple returned values accepted in multiple variables

p,q,r=fun1(10,11,12)
print(p,q,r)
23 CORRECTED CODE: 2

for Name in ['Aakash', 'Satya', 'Tarushi']:

if Name[0]=='S':
print(Name)
24 Minimum VALUE = 0 2
Maximum VALUE = 3
Options (ii) & (iii)
are incorrect.
25 Alternate Keys are candidate keys which are not selected as Primary Key. 2
Table: STUD
AdmNo RollNo Name
1236 101 Amarnath

1457 102 Piyush

1836 103 Swetha

In the above table STUD, AdmNo and RollNo are candidate keys, If RollNo
is selected as Primary Key then AdmNo will be the alternate key.
SECTION C

26 def Interchange(num): 3
for i in range(0,n,2):
num[i], num[i+1] = num[i+1], num[i]
print(num)

num=[5,7,9,11,13,15]
n=len(num)
if n%2==0:
Interchange(num)
Note : Any correct code giving the same result is also accepted
27 def Disp_upper_first(): 3
word=""
f=open("legend.txt","r")
line=f.read()
word=line.split()
for i in word:
if i[0].isupper():

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 249
 print(i)
f.close()
Disp_upper_first()
Note : Any correct code giving the same result is also accepted

OR
def countdigits():
c=0
f=open("marks.txt","r")
line=f.read()
print(line)
for i in line:
if i.isdigit():
c+=1
print("Total number of digits in the file:",c)
f.close()
countdigits()
Note : Any correct code giving the same result is also accepted
i.
28 3
Make Count(*)
Toyota 1
Suzuki 1
ii.
Cname Make
Innova Toyota
Duster Renault
Ertiga Suzuki
Harrier Tata
Altroz Tata
Triber Renault
iii.
Custname Cname
Gopinath Triber
Ashok Altroz
Harshini Harrier
Vishnu Duster
29 def Push(nums):
li =[] 3
for i in range(0,len(nums)):
if nums[i]%2!=0:
li.append(nums[i])
if len(li) == 0:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 250
 print('Stack is empty!!')
else:
print(li)
Push([10,15,20,25,30,35])
Note : Any correct code giving the same result is also accepted

OR
def popStack(names) :
L = len(names)
if L==0:
print("Stack Underflow")
else:
val = names[L-1]
names.pop(L-1)
return val
res=popStack(['Harikaran','Balaji','Nikhil','Cathrine'])
print('Value returned:',res)
Note : Any correct code giving the same result is also accepted
30 OUTPUT : 3
pRE2bOARDxeXAMaddd
SECTION -D
31 (i) Most suitable place to install the server is ADMIN, as this building has 5
maximum number of computers.
(ii) Topology: STAR
Cable layout:

(iii) Repeater
(iv) Satellite Link
(v) (c) Video Conferencing
32 (i) Select Cname, Charges from Car where Colour=’silver’; 5
(ii) Select distinct Ccode from customer;
(iii) Select min(Charges), max(Charges) from Car;
(iv) Update Car set Charges=Charges - Charges*0.1 from Car R, Customer C
where R.Ccode=C.Ccode;
(v) Select Cname, Make from Car where Charges between 2000 and 3000;
33 import pickle 5
def AddVahan():
f1= open(“vehicle.dat”, “ab”)
RegNo = input(“Enter the vehicle registration number: “)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 251
 Type = input(“Enter the vehicle type: “)
Make = input(“Enter the manufacturer name: “)
Year = int(input(“Enter the year of manufacturing: "))
rec = [RegNo, Type, Make, Year]
pickle.dump(rec, f1)
f1.close()
def CountVahan(Type):
f1 = open(“vehicle.dat”, “rb”)
count = 0
try:
while True:
rec = pickle.load(f1)
if Type == rec[1]:
count = count + 1
except:
f1.close()
return count
OR
import pickle
def ShowPlayer():
f1 = open(“player.dat”, “rb”)
count = 0
try:
while True:
rec= pickle.load(f1)
if rec[3] >50 and rec[2] == “India”:
print(rec [0], rec [1], rec [2], rec *3+,sep=”\t”)
count +=1
except:
f1.close()
print(“Number of Indian players with strike rate more than 50=”, count)
SECTION E
34 (a) BookNo 4
(b) Degree=4 Cardinality =7
(c) UPDATE collections SET quantity = quantity + 20 WHERE quantity < 50;
(d) DELETE FROM Collections;
35 (a) Line 1 :import csv 4
(b) Line 2 :f=open('students.csv','a')
(c) Line 3 :readerObj=csv.reader(fobj)
(d) Line 4: Not mandatory, as we have opened the file using “with” operator, it
closes automatically.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 252
 KENDRIYA VIDYALAYA SANGATHAN, ERNAKULAM REGION
SAMPLE QUESTION PAPER-3(SOLVED)
COMPUTER SCIENCE
CLASS: XII
Max.Marks:70 Time Allowed:3 hours
General Instructions:
1.
This question paper contains five sections, Section A to E.
2.
All questions are compulsory.
3.
Section A have 18 questions carrying 01 mark each.
4.
Section B has 07 Very Short Answer type questions carrying 02 marks each.
5.
Section C has 05 Short Answer type questions carrying 03 marks each.
6.
Section D has 03 Long Answer type questions carrying 05 marks each.
7.
Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34
against part c only.
8. All programming questions are to be answered using Python Language only.
Q.NO PART A Marks
SECTION 1
Attempt any 15 questions from question no 1 to 21.
Which of the following is not a relational operator
1 1
a) > b)<= c)!= d)=
Identify the data type of result of expression 10<5
2 1
a)bool b)int c)float d)None
Which is not a type of tokens from the following.
3 1
a)keyword b) literals c)Operators d)Class
Identify valid declaration of tuple
a)T=,‘a’,’b’,’c’,’d’- b) T=‘a’,’b’,’c’,’d’
4 1
c)D=(‘a’,’b’,’c’,’d’) d) both b and c

Write the module that need to be imported to execute the function dump():
5 1
a)random b)csv c)mysql.connector d)pickle
Given the list L=[-1,4,6,-5] ,write the output of print(L[-1:-3])
6
a)[4,6,-5] b)[] c)[6,-5] d)error
What will be the output of following:
x,y=10,5
7 x,y=y,x 1
print(x,y)
a) 10,5 b)5 10 c) 5,10 d)10 5
A function can return ------ number of values
8 1
a)0 b)None c)Many d)2
The default file open mode is ----------- mode
9 1
a)r b)r+ c)w d)a
Which of the following is/are mutable data type?
10 1
a)int b)string c)list d)tuple
Which operator in SQL is used to compare a value to a specified list of
11 values 1
a)BETWEEN b)= c)IN d)ALL

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 253
 Which of the following is not an aggregate function?
12 1
a)MIN() b)SUM() c)UPPER() d)COUNT()
Which keyword is used to eliminate duplicate values in an SQL select query?
13 1
a)unique b)distinct c)key d)all
Which of the following network device is a broadcasting device
14 1
a)switch b)hub c)gateway d)router
What is the degree of the following relation?
slno dateofadmn class
15 1 2022-06-05 V 1
2 2022-08-23 VIII
a)3 b)5 c)2 d)1
If all devices are connected to a central hub, then topology is called
16 1
a)tree topology b)bus topology c)star topology d)mesh topology
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the
correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True

Assertion(A):The resultset refers to a logical set of records that are fetched

from the database by executing an SQL query.
17 1
Reason(R):Resultset stored in a cursor object can be extracted by using
fetch(…) functions.
Assertion(A):Python overwrites an existing file or creates a non-existing file
18 when we open a file with ‘w’ mode . 1
Reason(R):a+ mode is used only for write operations
SECTION B
Sona has written the following code to check whether number is divisible by
3 .She could not run the code successfully. Rewrite the code and underline
each correction done in the code.
x=10
for I range in (a)
19 2
If i%3=0:
print(I)
else
pass

Write disadvantage of bus topology and star topology(1 each).

20 or 2
What are Routers? How is it differs from gateway?.
Write output
a)a=5
21 2
a+=27
print(a)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 254
 b) a=5
print(a+4<10)
22 What is scope? What is the scope resolving rule in python? 2
(a)Expand the following terms:
23 i)MAN ii)HTML 2
b)What is URL ?
Write output for the following code.
def encrypt(str):
str1=""
for i in str:
if i.isupper():
str1+=i.lower()
else:
str1+="*"
return str1
s=encrypt("HeLLo")
print(s)
24 2
or

Go through the python code shown below and find out the possible
output(s) from the suggested options i to iv. Also specify maximum and
minimum value that can be assigned to the variable j.
import random
i=random.random()
j=random.randint(0,6)
print(int(i),”:”,j+int(i))
(i)0:0 (ii)0:6 (iii)1:7 (iv)1:6

Differentiate ORDER BY and GROUP BY with an example.

OR
25 2
Classify the following statements into DDL and DML
a)delete b)drop table c)update d)create table
SECTION C
Consider the following tables CABHUB and CUSTOMER
CABHUB

Vcode VehicleName Make Color Capacity Charges

100 Innova Toyota WHITE 7 15
26 3
102 SX4 Suzuki BLUE 4 14
104 C Class Mercedes RED 4 35
105 A-Star Suzuki WHITE 3 14
108 Indigo Tata SILVER 3 12

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 255
 CUSTOMER
CCode CName VCode
Hemant
1 Sahu 101
2 Raj Lal 108
Feroza
3 Shah 105
4 Ketan Dhal 104
a) What will be the output of following statement?
select VehicleName,Capacity from Cabhub c, Customer s where
c.Vcode=s.Vcode and c.capacity<4;
b) Write the output of the queries (i) to (iv) based on the table CABHUB
i) select count(VCode),Color from CABHUB group by Color;
ii) select distinct capacity from Cabhub;
iii) select min(Charges),max(charges) from CABHUB;
iv) select VehicleName,Make from CABHUB order by VehicleName

Write a function in python to count number of words ending with ‘n’

present in a text file “ABC.txt”
If ABC.txt contains “A story of a rich man And his son”, the output of the
function should be
27 3
Count of words ending with ‘n’ is 2
Or
A text file contains alphanumeric text (say an.txt).Write a program that
reads this text file and prints only the numbers or digits from the file.
a)Write the output of the SQL commands for (i) to (iv) on the basis of tables
BOOKS and ISSUES.
Table: BOOKS
Book_ID BookName AuthorName Publisher Price Qty
L01 Maths Raman ABC 70 20
L02 Science Agarkar DEF 90 15
L03 Social Suresh XYZ 85 30

28 L04 Computer Sumita ABC 75 7 3

L05 Telugu Nannayya DEF 60 25
L06 English Wordsworth DEF 55 12
Table: ISSUES
Book_ID Qty_Issued
L02 13
L04 5

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 256
 L05 21

(i) select sum(price) as TOTAL_PRICE from BOOKS;

(ii) select * from BOOKS where publisher=”DEF”;
(iii) select BookName,AuthorName from BOOKS,ISSUES where
BOOKS.Book_ID=ISSUES.Book_ID and Qty_Issued>10;
(iv) select BOOKS.Book_ID,BookName,Publisher,Price,Qty,Qty_Issued from
BOOKS,ISSUES where BOOKS.Book_ID=ISSUES.Book_ID;
b)Write SQL command to display structure of the table BOOKS.

Write a function SUMNOS() that accept a list L of numbers and find sum of
all even numbers and sum of all odd numbers.
If L=[1,2,3,4],
29 3
Output :
sum of even nos:6
Sum of odd numbers:4
A stack S contains Name of countries.Write a function POP(A), to remove
Name from stack. Function should handle underflow condition and should
return removed element.
30 OR 3
Write a function PUSH(STACK,Name) to add new name to the STACK data
structure . Also display all the names having at least 4 characters from the
stack.
SECTION D
“Learn Together” is an educational NGO. It is setting up its new campus at
Jabalpur for its web based activities. The campus has 4 compounds as shown
in the diagram below:

Y Z

Building

W
X
Building Building
31 5

Center to center distances between various buildings is as follows:

X Building to Y Building 25 m
Y Building to Z Building 100m

X Building to W Building 110 m

W Building to Y Building 135 m
X Building to Z Building 115 m

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 257
 Z Building to W Building 35 m

Number of Computers in each of the buildings is follows:

X Building 150

Y Building 15

Z Building 5

W Bulding 20

a) Suggest the most suitable place (i.e. building) to house the server of
this organisation with a suitable reason.

b) Suggest a cable layout of connections between the buildings.

c) The organisation is planning to link its admin counter situated in
various parts of the same city, which type of network out of LAN, MAN or
WAN will be formed? Justify your answer.

d) Suggest the placement of the following devices with justification:

(i) Repeater
(ii) Hub/Switch

e) In each of the buildings,the management wants that each LAN segment

gets a dedicated a bandwidth ie.bandwidth must not be shared. How can this
be achieved?

a) Write the output of the code given below

def f():
global s
s += ' Is Great'
print(s)
s = "Python is funny"
s = "Python"
f()
32 print(s) 5
b) The code given below inserts the following record in the table Student:

RollNo – integer
Name – string
Marks – integer
Address –String
Phone-integer
Note the following to establish connectivity between Python and MYSQL:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 258
  Username is root
 Password is root
 The table exists in a MYSQL database named school.
 The details (RollNo, Name, Marks,Address,Phoneno) are to be
accepted from the user.
Write the following missing statements to complete the code:
Statement 1 – to establish connection to the database
Statement 2 – to execute the command that inserts the record in the table
Student. Statement 3- to add the record permanently in the database

OR
a) Predict the output of the following
def student(firstname, lastname ='Mark', standard ='Fifth'):
print(firstname, lastname, 'studies in', standard, 'Standard')

student("John")
student('George','Jose','Seventh')
b) The code given below reads the following record from the table named
student and displays only those records whose address is ‘Delhi’ RollNo –
integer Name – string , Marks – integer ,Address-string,Phone-integer

Note the following to establish connectivity between Python and MYSQL:

Username is root
Password is root
The table exists in a MYSQL database named school.

Write the following missing statements to complete the code: Statement 1

– to form the cursor object
Statement 2 – to execute the query that extracts records of those students
whose address is ‘Delhi’.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 259
 Statement 3- to read the complete result of the query (records who are from
“Delhi”) into the object named r, from the table student in the database

What are the characteristics of csv file ? Write a Program in Python that
defines and calls the following user defined functions:

(i) ADD_PROD() – To accept and add information about a product

into a csv file named ‘product.csv’. Each record consists of
prodname and price to store product name and price of the
product
(ii) DISPLAY_PROD() – To display details of products having price
more than 100 present in the CSV file named ‘product.csv’.
33 5
OR

When do we use csv file?. Write a Program in Python that defines and calls
the following user defined functions:

(i) insert_ROLL()– To accept and add data of a student to a CSV file

‘marks.csv’. Each record consists of a list with field elements as rollno, mark
to store roll number and mark of students respectively.
(ii) read_ROLL()- To display and count the records of the students.

SECTION E
Advaith,a manager has stored the details of departments in a table called
DEPARTMENT.
DEPTNO DNAME LOC
----- -------------- --------
34 10 ACCOUNTING NEW YORK 1+1+2
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 260
 He wants to add one more record to this table and has written the following
code and unable to insert that record.
INSERT INTO DEPARTMENT VALUES(43,”HRD”);
i. Help him to correct the code for adding the record
ii. How can he restrict Null values in the table
iii. Write a commands to :
a. show the names of department starting with “R”.
b.update LOC as “New York” for DEPTNO 30.
OR(Option for part iii only)

iii. Write a commands to :

a. insert the following record into the table:DEPTNO-47,DNAME-
Accounting,LOC-Paris
b. delete the records of location(LOC) “Boston”
Manju has created a program using two functions for storing his friends’
exam roll numbers and marks in a binary file “STUDENT.DAT” and to display
total mark.But he forgot some lines of code. As a programmer, help him to
complete the task and to run the program successfully.
#Line 1
def create_File():
f=open(“STUDENT.DAT”,”ab”)
rollno=int(input(“Enter roll number”))
m1=int(input(“Enter Mark1”))
m2=int(input(“Enter Mark2”))
m3=int(input(“Enter Mark3”))
d=,“rollno”:rollno,”M1”:m1,”M2”:m2,”M3”:m3-
pickle. (d,f) #Line2
f.close()
35 s={} 4
def read_File():
with open(“STUDENT.DAT”,”rb”) as f:
try:
while True:
s= ____________________________________ #Line3
t=s*“M1”++s*“M2”++s*“M3”+
print(“RollNo:”,s*rollno+,”Total Mark:”,t)
except:
#Line 4

a) Fill in the blank in Line 1 to import required module.

b) Fill in the blank in Line 2 to write the record
c) Complete Line 3 for reading the record
d) Write the code in the line marked Line4

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 261
 KENDRIYA VIDYALAYA SANGATHAN, ERNAKULAM REGION
Sample Paper-3(SOLUTION)
SUB: COMPUTER SCIENCE
CLASS XII
Q.NO PART A Marks
Section -A
1 d)= 1
2 a)bool 1
3 d)class 1
4 d)both b and c 1
5 d)pickle 1
6 b)[] 1
7 b)5 10 1
8 c)Many 1
9 a)read 1
10 c)list 1
11 c)IN 1
12 c)UPPER() 1
13 DISTINCT 1
14 b)hub 1
15 a)3 1
16 c)star topology 1
17 b 1
18 c 1
Section-B
19 x=10 2
for I in range(a):
if I%3==0:
print(I)
else:
pass

20 Disadvantages of bus topology 2

1. Identification of problems becomes difficult if the whole network goes
down
2. Need terminators are required at both ends of the main cable
Disadvantages of star topology
1. If hub goes down everything goes down, none of the devices can work
without hub.
2. More expensive than linear bus topology due to the value of the
connecting devices (network switches)

or
What are routers?.
A router is a network device that can receive the data , analyse it and
transmit it to other networks . It is used to connect a Local Area Network to

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 262
 the internet. Using a routing table, it ensures that data packets are travelling
through the best suitable paths to their destinations.
In simple words, a gateway is a device that we use for communicating among
various networks possessing different protocol sets. It is responsible for
converting a given protocol to another one.Gateway connects dissimilar
network

21 a) 32 1+1
b) True

22 What is scope? What is the scope resolving rule in python? 2

The scope of a variable is the region of a program in which the variable is
visible, i.e., in which it is accessible by its name and can be used.
Scope resolution is required when a variable is used to determine where
should its value be come from. Scope resolution in Python follows the LEGB
rule.

23 a) MAN –Metropolitan Area Network b)HTML –Hyper Text Mark up Language 1+1
URL stands for Uniform Resource Locator. A URL is nothing more than the
address of a given unique resource on the Web.
24 h*ll* 2
OR
minimum-0
maximum -1
options(i) and (ii)

25 1. Order By : 2
Order by keyword sort the result-set either in ascending or in descending
order. This clause sorts the result-set in ascending order by default. In
order to sort the result-set in descending order DESC keyword is used.
Order By Syntax –
SELECT column_1, column_2, column_3...........
FROM Table_Name
ORDER BY column_1, column_2, column_3 ......... ASC|DESC;
2. Group By :
Group by statement is used to group the rows that have the same value. It
is often used with aggregate functions for example:AVG(), MAX(), COUNT(),
MIN() etc. One thing to remember about the group by clause is that the
tuples are grouped based on the similarity between the attribute values of
tuples.
Group By Syntax –
SELECT function_Name(column_1), column_2
FROM Table_Name

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 263
 WHERE condition
GROUP BY column_1, column_2
ORDER BY column_1, column_2;
OR

a)delete -DML b)drop table -DDL c)update -DML d)create table-DDL

26 a) 1+2
Vehicle Capacity
A-Star 3
Indigo 3

b)
I)
count(vcode) color
2 WHITE
1 BLUE
1 RED
1 SILVER
II)
distinct capacity
7
4
3
III)
min(charge) max(charge)
12 35
iv)
Vehicle Name Make
A-Star Suzuki
C Class Mercedes
Indigo Tata
Innova Toyota
SX4 Suzuki
27 def countA(): 3
file=open("ABC.txt",'r')
r=file.read()
s=r.split()
count=0
for i in s:
if i[-1]=='n':
count+=1
file.close()
print("Count of words ending with “n” is", count)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 264
 OR
def printnum():
file=open("an.txt",'r')
r=file.read()
for i in r:
if i.isdigt():
print(i)
file.close()

28 a) i) 2+1
TOTAL_PRICE
435
ii)

Book_ID BookName AuthorName Publisher Price Qty

L02 Science Agarkar DEF 90 15
L05 Telugu Nannayya DEF 60 25
L06 English Wordsworth DEF 55 12
iii)

BookName AuthorName
Science Agarkar
Telugu Nannayya
iv)

Book_ID BookName Publisher Price Qty Qty_Issued

L02 Science DEF 90 15 13
L04 Computer ABC 75 7 5
L05 Telugu DEF 60 25 21

b) DESC BOOKS

29 def SUMNOS(L): 3
SE=0
SO=0
for i in L:
if i%2==0:
SE+=i
else:
SO+=i
print(“Sum of Even no:s=”,SE)
print(“Sum of Odd no:s=”,SO)
30 def POP(A): 3
if len(A)==0:
print(“UNDERFLOW”)
else:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 265
 val=A.pop()
return val

OR
Write a function PUSH(STACK,Name) to add new name to the STACK data
structure . Also display all the names having atleast 4 characters from the
stack.
def PUSH(STACK,Name):
STACK.append(Name)
#code for displaying
if len(STACK)==0:
print(“Empty stack”)
else:
top=len(STACK)-1
for i in range(top,-1,-1):
if len(STACK[i])>=4:
print(STACK[i] )

31 a) The most suitable place / block to house the server of this organisation 5(1
would be X Building, as this block contains the maximum number of each)
computers, thus decreasing the cabling cost for most of the computers as well
as increasing the efficiency of the maximum computers in the network.

b)
Answer:
Layout 1

Y Z

W
X

Layout 2:

Y Z

W
X

c)
Answer:
The type of network that shall be formed to link the sale counters situated in
various parts of the same city would be a MAN, because MAN (Metropolitan
Area Networks) are the networks that link computer facilities within a city.
d)

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 266
 Answer:
(i) In layout1 between X&Z,X&W.In layout2 between Y and Z.Because
distance is more than 90m.
(ii) In both the layouts, a hub/switch each would be needed in all the
buildings, to interconnect the group of cables from the different
computers in each block

e)switch

32 a) Python Is Great 2+3

Python is funny
b) statement 1-connect
statement2-execute
statement3-commit
OR
a)John Mark studies in Fifth Standard
George Jose studies in Seventh Standard
b) Statement1-mycon.cursor()
statement2-select * from student where address=”Delhi”
statement3-fetchall()

33  One line for each record 5

 Comma separated fields
 Space-characters adjacent to commas are ignored
 Fields with in-built commas are separated by double quote
characters.
import csv
def ADD_PROD():
fout=open("product.csv","a",newline="\n")
wr=csv.writer(fout)
prodname=input("Enter Product name :: ")
price=float(input("Enter Price:: "))
lst=[prodname,price]
wr.writerow(lst)
fout.close()

def DISPLAY_PROD():
found=False
fin=open("record.csv","r",newline="\n")
data=csv.reader(fin)
for i in data:
if int(i[1])>100:
found=True
print(i[0],i[1])
if found==False:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 267
 print("Record not found")
fin.close()
ADD_PROD()
print(“Displaying product having price more than 100\n”)
DISPLAY_PROD()

OR
CSV file are useful when we need to import data into many other software
applications.

import csv
def inser_ROLL():
fout=open("marks.csv","a",newline="\n")
wr=csv.writer(fout)
rollno=int(input("Enter Roll number "))
mark=float(input("Enter mark :: "))
lst=[rollno,mark]
wr.writerow(lst)
fout.close()

def read_ROLL():
fin=open("marks.csv","r",newline="\n")
data=csv.reader(fin)
d=list(data)
print(“No.of records=”:,len(d))
for i in data:
print(i)
fin.close()

34 iv. INSERT INTO DEPARTMENT(deptno,dname) VALUES(43,”HRD”); 1+1+2

v. by adding constraint NOT NULL
vi. a. select DName from DEPARTMENT where Dname like “R%”;
b.update DEPARTMENT set LOC=”NEW YORK” where DEPTNO=30;
OR
iii. a. insert into DEPARTMENT values(47,”Accounting”,”Paris”);
b.delete from DEPARTMENT where LOC=”Boston”;

35 a) Fill in the blank in Line 1 to import required module. 1+1+1+1

a) import pickle
b) Fill in the blank in Line 2
b)dump
c) Complete line3
c)pickle.load(f)
d) Write the code in
Line4 f.close()
KENDRIYA VIDYALAYA SANGHATHAN – ERNAKULAM REGION

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 268
 SAMPLE PAPER (UNSOLVED) – COMPUTER SCIENCE (083)
MAX MARKS: 70 TOTAL TIME : 3 hrs
Part A
Section 1 [18 marks] (1x18)
1 Which of the following is an invalid identifier? 1
a. CS_class_XII
b. csclass12
c. _csclass12
d. 12CS
2 Which of the is a correct statement? 1
a. xyz = 10 100 1000
b. x y z = 10 100 1000
c. x, y, z = 10, 100, 1000
d. x y z= 10, 100, 1000
3 Aman wants to write a function in python. But he doesn’t know how to 1
start with it! Select the keyword used to start a function out of the
following:
a) function
b) start
c) def
d) fun
4 Which of the following is not a part of the python function? 1
a) function header
b) return statement
c) parameter list
d) function keyword
5 Which of the following is the correct statement for checking the presence 1
of a key in the dictionary?
a) <key> in <dictionary_object>
a) <key> not in <dictionary_object>
c) <key> found in <dictionary_object>
d) a) <key> exists in <dictionary_object>
6 What will be the output of : 1
t=(4,5,6)
del t[1]
print(t)

a) (4,6) b) ([4,6])
c) [4,6] d) Error
7 Which of the following statement is correct? 1
a) Tuples are mutable.
b) Tuples are immutable.
c) Tuples and lists are same.
d) All of these are correct.
8 What will be the output of following code: 1
txt="Term 1"

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 269
 print(txt*2)
a) Term 1 Term 2
b) Term 1Term 1
c) Term 1 2
d) TTeerrmm 11
9 The append() method adds an element at 1
a. first
b. last
c. specified index
d. at any location
10 Which point can be considered as difference between string and list? 1
a. Length
b. Indexing and Slicing
c. Mutability
d. Accessing individual elements
11 If n=”Hello” and user wants to assign n*0+=’F’ what will be the result? 1
a. It will replace the first character
b. It’s not allowed in Python to assign a value to an individual character
using index
c. It will replace the entire word Hello into F
d. It will remove H and keep rest of the characters
12 In list slicing, the start and stop can be given beyond limits. If it is then 1
a. raise exception IndexError
b. raise exception ValueError
c. return elements falling between specified start and stop values
d. return the entire list
13 Ms. Hetvee is working on a string program. She wants to display last four 1
characters of a string object named s. Which of the following is statement
is true?
a. s[4:]
b. s[:4]
c. s[-4:]
d. s[:-4]
14 Which of the following statement is true for extend() list method? 1
a. adds element at last
b. adds multiple elements at last
c. adds element at specified index
d. adds elements at random index
15 The statement del l[1:3] do which of the following task? 1
a. deletes elements 2 to 4 elements from the list
b. deletes 2nd and 3rd element from the list
c. deletes 1st and 3rd element from the list
d. deletes 1st, 2nd and 3rd element from the list
16 If l=[11,22,33,44], then output of print(len(l)) will be 1
a. 4
b. 3

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 270
 c. 8
d. 6
17 Assertion(A) The personal area Network (PAN) is established within a very 1
small area(20 to 30 sq ft) to share the information.
Reason (R ): The campus are network is used to interconnect the
computers located within a campus such as university campus, corporate
campus, hospital campus etc.
Based on the above discussion, choose an appropriate state form the
options given below:

(a) Both assertion and reason are true and the reason is the correct
explanation of assertion.
(b) Both assertion and reason are true but the reason is not the correct
explanation of assertion.
(c) Assertion is true but reason is false.
(d) Assertion is false but reason is true.
(e) Assertion and reason both are wrong.
18 Assertion ( A) : In SQL, the aggregate function Avg() calculates the average 1
value on a set of values and produce a single result.
Reason ( R) : The aggregate functions are used to perform some
fundamental arithmetic tasks such as Min(),Max(), Sum() etc
(a) Both assertion and reason are true and the reason is the correct
explanation of assertion.
(b) Both assertion and reason are true but the reason is not the correct
explanation of assertion.
(c) Assertion is true but reason is false.
(d) Assertion is false but reason is true.
(e) Assertion and reason both are wrong.

Section B [14 marks] [2x7=14]

19 Evaluate the following expressions: 2
a) 7*3+4**2//5-8
b) 7>5 and 8>20 or not 12>4
20 Write down the fullform of : 2
A. FTP b) HTML c) SMTP d) VoIP
21 What are actual and formal parameters in Functions? Differentiate using 2
example.
22 Write the queries for the following questions using the table Product with 2
the following fields. (P_ Code, P_Name, Qty, Price)
(i) Display the price of product having code as P06.
(ii) Display the name of all products with quantity greater than 50 and price
less than 500
23 Give two characteristics of Stacks 2
24 In the table Loan below 2
(a) Identify the candidate key(s) from the table Loan.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 271
 (b) Which field will be considered as the foreign key if the tables Customers
and Loan are related in a database?

25 Rewrite the following code in Python after removing all syntax error(s). 2
Underline each correction done in the code.

Value=30
for VAL in range(0,Value)
If val%4==0:
print (VAL*4)
Elseif val%5==0:
print (VAL+3)
else
print(VAL+10)
Section C [15 Marks] [3x5]
Answer All questions
26 Coach Abhishek stores the races and participants in a dictionary. Write a 3
program, with separate user defined functions to perform the following
operations:

a. Push() Push the names of the participants of the dictionary onto a

stack, where the distance is more than 100.
b. PoP() Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as follows: Races ={100:'Varnika',
200 :'Jugal', 400:'Kushal', 800:'Minisha'}}
The output from the program should be: Minisha Kushal Jugal

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 272
 27 a) Write the outputs of the SQL queries (i) to (iv) based on the 3
relations Teacher and Placement given below:
Table : Teacher

(i) SELECT Department, sum(Salary) FROM Teacher WHERE Salary>12000

GROUP BY Department;

ii) SELECT MAX(Date_of_Join),MIN(Date_of_Join) FROM Teacher WHERE

Gender=’M’;

iii) SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P

WHERE T.Department = P.Department AND T.Department Like ‘%o%;

iv) SELECT Name, Place FROM Teacher T, Placement P WHERE Gender =’M’
AND T.Department=P.Department;

(b) Write the command to remove all the tuples of a table

28 Write a program to count a total number of lines and count the total number 3
of lines starting with ‘A’, ‘B’, and ‘C’. (Consider the merge.txt file)

Or

Write a method/function DISPLAYWORDS() in python to read lines from a

text file STORY.TXT, and display those words, which are less than 4
characters.

29 You are a student in CBSE school. 1 Teacher has given a task to write a 3
python code to perform the following binary file operations with the help of
two user defined functions/modules:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 273
 a) Addrecord() to create a binary file called school.dat containing
student information (in list datatype) - student number, name, marks(out of
100) of each student.
Or
b) Search() to display name and marks of the student by asking the
student number from the user.
30 Give the output of the following Queries from the given table: 3

a) SELECT COUNT(age) FROM employee WHERE age>33;

b) Select COUT(distinct department) from EMPLOYEE;
c) Select MAX(Age) from EMPLOYEE where SEX =”F”;
Section D [15 Marks]
[5x3]
31 China Middleton Fashion is planning to expand their network in India, 5
starting with two cities to provide infrastructure for distribution of their
products. The company has planned to setup their main office in Chennai at
three different locations and have named their offices as Production Unit,
Finance Unit and Media Unit. The company’s rough layout of the same is as
follows: its Corporate Unit in Delhi. A rough layout of the same is as follows:

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 274
 (i) Suggest the kind of network required (out of LAN, MAN, WAN) for each of
the following units. (2)
(a) Production Unit and Media Unit
(b) Production Unit and Finance Unit
(ii) Which of the following devices will you suggest for connecting all
computers with each of their office units? (1)
(a) Switch/Hub (b) Modem (c) Telephone
(iii) Suggest a cable/wiring layout for connecting the company’s local office
units located in Chennai. Also, suggest an effective method/technology for
connecting the company’s office unit located in Delhi (2)
32 A. Find an output of the following code 5
def func(b): (2+3)
global x
print(‘Global x=’, x)
y=x+b
x=7
z=x–b
print(‘Local x = ‘,x)
print(‘y = ‘,y)
print(‘z = ‘,z)
x=3
func(5)

B.) ABC Infotech Pvt. Ltd. needs to store, retrieve and delete the records of
its employees. Develop an interface that provides front-end interaction
through Python, and stores and updates records using MySQL.

The operations on MySQL table "emp" involve reading, searching, updating

and deleting the records of employees.

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 275
 Give statements for 1,2 , 3or4

import __________ #statement1

db1 = mysql.connector.connect (host = "localhost", user = "root", password =
"pathwalla", database = "company")
cursor = db1.cursor()

sql = "SELECT FROM EMP WHERE SALARY> 70000;"

try:
cursor ______ (sql) #statement2

resultset = cursor ______ () #statement3

for _ in resultset: #statement4
empno = row [0]
ename = row [1]
salary = row [2]
print (("empno-3d, ename=%s, salary-8f") % (empno, ename, salary))
except:
print ("Error: unable to fetch data")
db1close()
33 What is the advantage of using a csv file for permanent storage?’ 5

Write a Program in Python that defines and calls the following user defined
functions:
(i) ADD() – To accept and add data of a student to a CSV file ‘Stud.csv’. Each
record consists of a list with field elements as studid,s name and Smark to
store student id, student name and student percent marks respectively.
(ii) Count() – To count the number of records present in the CSV file where
Smark is greater then 75% from stud.csv.
OR
Give any one point of difference between a binary file and a csv file.
Write a Program in Python that defines and calls the following user defined
functions:
(i) add() – To accept and add data of a client to a CSV file ‘Client.csv’. Each
record consists of a list with field elements as Cid, Cname and CCity
(ii) search()- To display the records of the Clients whose city is KOCHI
SECTION E ( 4x2= 8 marks)
34 Consider the table ‘PERSONS’ given below 4

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 276
 (i) Display the SurNames, FirstNames and Cities of people residing in
Udhamwara city.
(ii) Display the Person Ids (PID), cities and Pincodes of persons in descending
order of Pincodes.
(iii) Display the First Names and cities of all the females getting Basic salaries
above 40000.
(iv) Display First Names and Basic Salaries of all the persons whose
firstnames starts with “G”
35 Consider an employee data, Empcode, empname and salary. Sneha Wrote 4
python function to create binary file emp.dat and store their records. And
function to read and display all the records Help her complete the code
import _______ #STATEMENT 1
def add_record():
f = open(“emp.dat”,”ab”)
empcode =int(input(“employee code:”))
empname = int(input(“empName:”))
salary = int(input(“salary:”))
d = [empcode, empname, salary]
pickle.dump( ) #STATEMENT 2
f. close()

def search():
f=open(“ ______ ”,”rb”) #STATEMENT 3
while True:
try:
d=pickle.load( __ ) #STATEMENT 4
print(d)
except EOFError:
break
f.close()

MD - STUDENT SUPPORT MATERIAL - COMPUTER SCIENCE-083 FOR THE ACADEMIC YEAR 2025-26 277
 CBSE 2022 TERM-2 QP WITH MARKING SCHEME
Maximum Marks: 35 Time: 2 hours
General Instructions :
i. This question paper is divided into 3 Sections – A, B and C
ii. Section A, consists of 7 questions (1-7). Each question carries 2 marks.
iii. Section B, consists of 3 questions (8-10). Each question carries 3 marks.
iv. Section C, consists of 3 questions (11-13). Each question carries 4 marks.
v. Internal choices have been given for question numbers 7, 8 and 12.

Section -A
(Each question carries 2 marks)

1. “Stack is a linear data structure which follows a particular order in which 2

the operations are performed.”

What is the order in which the operations are performed in a Stack ?

Name the List method/function available in Python which is used to
remove the last element from a list implemented stack.

Also write an example using Python statements for removing the last
element of the list.
Ans Order of operations performed in a Stack is
LIFO (Last In First Out)

The List method in Python to remove the last element

from a list implemented stack is

pop()
OR
pop(-1)
OR
pop

Example:
L=[10,20,30,40]
L.pop() OR L.pop(-1)

OR

Any other appropriate example

(1 mark for writing correct order)

(½ mark for writing pop or any other correct method/function)
(½ mark for writing correct Python code of an example)

OR
(1 mark for writing correct order)
(1 mark for correct Python statement to demonstrate the pop() function)

(Note: FILO - First In Last Out, may also be considered)

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #3/15]
STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 292
 2. (i) Expand the following : 1
VoIP, PPP
Ans VoIP : Voice over Internet Protocol
PPP : Point to Point Protocol
(½ mark each for writing correct expansion)

(ii) Riya wants to transfer pictures from her mobile phone to her laptop. She 1
uses Bluetooth technology to connect two devices. Which type of network
(PAN/LAN/MAN/WAN) will be formed in this case?
Ans PAN/ Personal Area Network
(1 mark for correct type of network)

3. Differentiate between the terms Attribute and Domain in the context of 2

Relational Data Model.
Ans

(1 mark each for writing any correct explanation of Attribute and Domain)

4. Consider the following SQL table MEMBER in a SQL Database CLUB: 2

Table: MEMBER

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #4/15]
STUDENTS SUPPORT MATERIAL COMPUTER SCIENCE(083) 293
 Assume that the required library for establishing the connection between
Python and MYSQL is already imported in the given Python code. Also
assume that DB is the name of the database connection for table MEMBER
stored in the database CLUB.

Predict the output of the following code:

MYCUR = DB.cursor()
MYCUR.execute("USE CLUB")
MYCUR.execute("SELECT * FROM MEMBER WHERE ACTIVITY='GYM'")
R=MYCUR.fetchone()
for i in range(2):
R=MYCUR.fetchone()
print(R[0], R[1], sep ="#")

Ans M1002#Pratik
M1004#Rakesh

(1 mark for writing each correct line of output)

(Note: Deduct ½ mark for missing # or writing the output in a single line OR
writing any additional line along with the correct output)

5. Write the output of the SQL queries (a) to (d) based on the table 2
VACCINATION_DATA given below:

TABLE: VACCINATION_DATA
VID Name Age Dose1 Dose2 City
101 Jenny 27 2021-12-25 2022-01-31 Delhi
102 Harjot 55 2021-07-14 2021-10-14 Mumbai
103 Srikanth 43 2021-04-18 2021-07–20 Delhi
104 Gazala 75 2021-07-31 NULL Kolkata
105 Shiksha 32 2022-01-01 NULL Mumbai

(a) SELECT Name, Age FROM VACCINATION_DATA

WHERE Dose2 IS NOT NULL AND Age > 40;

Ans
Name Age
Harjot 55
Srikanth 43

(½ mark for the correct output )

(Note: Ignore column heading of the output and order of the output rows)

(b) SELECT City, COUNT(*) FROM VACCINATION_DATA

GROUP BY City;

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #5/15]
STUDENTS SUPPORT MATERIAL COMPUTER SCIENCE(083) 294
 Ans
City COUNT(*)
Delhi 2
Mumbai 2
Kolkata 1

(½ mark for the correct output )

(Note: Ignore column heading of the output and order of the output rows)

(c) SELECT DISTINCT City FROM VACCINATION_DATA;

Ans
City
Delhi
Mumbai
Kolkata

(½ mark for the correct output )

(Note: Ignore column heading of the output and order of the output rows)

(d) SELECT MAX(Dose1),MIN(Dose2)FROM VACCINATION_DATA;

Ans
MAX(Dose1) MIN(Dose2)
2022-01-01 2021-07-20

(½ mark for the correct output )

(Note: Ignore column heading of the output and order of the output rows)

6 Write the output of SQL queries (a) and (b) based on the following two 2
tables DOCTOR and PATIENT belonging to the same database :
Table: DOCTOR
DNO DNAME FEES
D1 AMITABH 1500
D2 ANIKET 1000
D3 NIKHIL 1500
D4 ANJANA 1500

Table: PATIENT
PNO PNAME ADMDATE DNO
P1 NOOR 2021-12-25 D1
P2 ANNIE 2021-11-20 D2
P3 PRAKASH 2020-12-10 NULL
P4 HARMEET 2019-12-20 D1

(a) SELECT DNAME, PNAME FROM DOCTOR

NATURAL JOIN PATIENT ;

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #6/15]

STUDENTS SUPPORT MATERIAL COMPUTER SCIENCE(083) 295

 Ans

(1 mark for writing correct output)

Note:
Deduct ½ mark for any additional row along with the correct rows
Ignore column heading of the output and order of the output rows

(b) SELECT PNAME, ADMDATE, FEES

FROM PATIENT P, DOCTOR D
WHERE D.DNO = P.DNO AND FEES > 1000;

Ans
2021-12-25
2019-12-20

(1 mark for writing correct output)

Note:
Deduct ½ mark for any additional row along with the correct rows
Ignore column heading of the output and order of the output rows
7. Differentiate between Candidate Key and Primary Key in the context of 2
Relational Database Model.
Ans A table may have more than one or a combination of
attribute(s)that identifies a tuple uniquely. All such
attribute(s) are known as Candidate Keys.

Out of all the Candidate keys, the most appropriate one,

which is used for unique identification of the Tuples,
is called the Primary Key.

Example:
Table: BANK
ACNO NAME PHONE
10001 RISHABH 9810876677
10031 ARNAV 9810876123
10064 ARNAV 9810875577
10076 GURSHARAN 9810871144
Candidate Keys: ACNO, PHONE
Primary Key: ACNO

(2 marks for correct explanation OR example given to differentiate the keys)

OR
(1 mark for writing only the correct explanation/example of candidate key)
(1 mark for writing only the correct explanation/example of primary key)

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #7/15]
STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 296
 OR
Consider the following table PLAYER : 2
Table: PLAYER
PNO NAME SCORE
P1 RISHABH 52
P2 HUSSAIN 45
P3 ARNOLD 23
P4 ARNAV 18
P5 GURSHARAN 42

(a) Identify and write the name of the most appropriate column from the
given table PLAYER that can be used as a Primary key.
Ans PNO

(1 mark for mentioning PNO)

(Note: Don’t deduct marks, if any additional column name is also mentioned
along with PNO)

(b) Define the term Degree in relational data model. What is the Degree of
the given table PLAYER ?
Ans Total number of columns/attributes in a table/relation
is known as its Degree.

The Degree of the given table is 3.

(½ mark for writing/explaining with example the correct meaning of Degree)

(½ mark writing correct Degree of the given table)

Section -B
(Each question carries 3 marks)
8. ● Write the definition of a user defined function PushNV(N) which 3
accepts a list of strings in the parameter N and pushes all strings
which have no vowels present in it, into a list named NoVowel.
● Write a program in Python to input 5 Words and push them one by one
into a list named All.
The program should then use the function PushNV() to create a stack
of words in the list NoVowel so that it stores only those words which
do not have any vowel present in it, from the list All.
Thereafter, pop each word from the list NoVowel and display the
popped word. When the stack is empty, display the message
"EmptyStack".
For example:

If the Words accepted and pushed into the list All are
['DRY', 'LIKE', 'RHYTHM', 'WORK', 'GYM']

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #8/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 297

 Then the stack NoVowel should store
['DRY', 'RHYTHM', 'GYM']

And the output should be displayed as

GYM RHYTHM DRY EmptyStack

Ans def PushNV(N):

for W in N :
for C in W :
if C.upper() in 'AEIOU':
break
else:
NoVowel.append(W)
All=[]
NoVowel=[]

for i in range(5) :
All.append(input('Enter a Word: '))

PushNV(All)

while NoVowel :
print(NoVowel.pop(), end=' ')
else :
print('EmptyStack')

OR

Any other correct equivalent code

(½ mark for checking vowels correctly, ignore case sensitivity)

(½ mark for pushing strings into the stack NoVowel)
(½ mark for reading 5 words from the users)
(½ mark for assigning 5 words into All)
(½ mark for writing correct code to pop and display the words from NoVowel)
(½ mark for writing correct code to check empty stack and display the message
'EmptyStack')
OR
● Write the definition of a user defined function Push3_5(N) which
accepts a list of integers in a parameter N and pushes all those
integers which are divisible by 3 or divisible by 5 from the list N into
a list named Only3_5.
● Write a program in Python to input 5 integers into a list named NUM.
The program should then use the function Push3_5() to create the
stack of the list Only3_5. Thereafter pop each integer from the list
Only3_5 and display the popped value. When the list is empty, display
the message "StackEmpty".

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #9/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 298

 For example:
If the integers input into the list NUM are :

[10,6,14,18,30]

Then the stack Only3_5 should store

[10,6,18,30]

And the output should be displayed as

30 18 6 10 StackEmpty
Ans def Push3_5(N):
for i in N :
if i%3==0 or i%5==0 :
Only3_5.append(i)

NUM=[]
Only3_5=[]

for i in range(5):
NUM.append(int(input('Enter an Integer: ')))

Push3_5(NUM)

while Only3_5 :
print(Only3_5.pop(), end=' ')
else :
print('StackEmpty')

OR
Any other correct equivalent code
(½ mark for checking divisibility correctly)
(½ mark for pushing integers into the stack Only3_5)
(½ mark for reading 5 integers from the users)
(½ mark for assigning those 5 integers into NUM)
(½ mark for writing correct code to pop and display the integers from Only3_5)
(½ mark for writing correct code to check empty stack and display the message
'StackEmpty')

9. (i) A SQL table ITEMS contains the following columns: 1

INO, INAME, QUANTITY, PRICE, DISCOUNT
Write the SQL command to remove the column DISCOUNT from the table.

Ans ALTER TABLE ITEMS

DROP COLUMN DISCOUNT;
OR
ALTER TABLE ITEMS
DROP DISCOUNT;

(½ mark for writing ALTER TABLE ITEMS)

(½ mark for writing DROP COLUMN DISCOUNT OR DROP DISCOUNT)

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #10/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 299

 (ii) Categorize the following SQL commands into DDL and DML : 2
CREATE, UPDATE, INSERT, DROP

Ans DDL Commands : CREATE, DROP

DML Commands : INSERT, UPDATE

(½ Mark each for writing the correct DDL/DML commands)

10. Rohan is learning to work upon Relational Database Management System 3

(RDBMS) application. Help him to perform following tasks:

(a) To open the database named "LIBRARY".

Ans USE LIBRARY ;

(1 Mark for writing correct SQL command)

(b) To display the names of all the tables stored in the opened database.

Ans SHOW TABLES;

OR
SHOW TABLES FROM LIBRARY;

(1 Mark for writing correct SQL command)

(c) To display the structure of the table "BOOKS" existing in the already
opened database "LIBRARY".

Ans DESCRIBE BOOKS ;

OR
DESC BOOKS ;

(1 Mark for writing correct SQL command)

Section - C
(Each question carries 4 marks)

11. Write SQL queries for (a) to (d) based on the tables PASSENGER and 4
FLIGHT given below:
Table : PASSENGER

Table: FLIGHT

2021-12-25
2021-11-20
2021-12-10
2021-12-20
2021-01-15

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #11/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 300

 (a) Write a query to change the fare to 6000 of the flight whose FNO is F104.

Ans UPDATE FLIGHT

SET FARE=6000 WHERE FNO="F104";

(½ Mark for writing UPDATE FLIGHT)

(½ Mark for writing SET FARE=6000 WHERE FNO="F104")

(b) Write a query to display the total number of MALE and FEMALE
PASSENGERS.

Ans SELECT GENDER, COUNT(*) FROM PASSENGER

GROUP BY GENDER;
OR
SELECT COUNT(*) FROM PASSENGER
GROUP BY GENDER;

(½ mark for writing SELECT part correctly)

(½ mark for writing GROUP BY GENDER; )
OR
(any alternate correct uses of COUNT() is acceptable)

(c) Write a query to display the NAME, corresponding FARE and F_DATE of
all PASSENGERS who have a flight to START from DELHI.

Ans SELECT NAME, FARE, F_DATE FROM PASSENGER P, FLIGHT F

WHERE F.FNO= P.FNO AND START = 'DELHI';
OR
SELECT NAME, FARE, F_DATE FROM PASSENGER, FLIGHT
WHERE PASSENGER.FNO= FLIGHT.FNO AND START = 'DELHI';
OR
SELECT NAME, FARE, F_DATE FROM PASSENGER, FLIGHT
WHERE PASSENGER.FNO= FLIGHT.FNO AND START LIKE 'DELHI';
OR
SELECT NAME,FARE,F_DATE FROM PASSENGER NATURAL JOIN FLIGHT
WHERE START = 'DELHI';
OR
Any other correct and equivalent query

(½ mark for writing SELECT - FROM part correctly)

(½ mark for writing WHERE part correctly)

(d) Write a query to delete the records of flights which end at Mumbai.

Ans DELETE FROM FLIGHT

WHERE END = "MUMBAI";
OR
DELETE FROM FLIGHT
WHERE END LIKE "MUMBAI";

(½ mark for writing DELETE FROM FLIGHT)

(½ mark for writing WHERE part correctly)

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #12/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 301

12. (i) Differentiate between Bus Topology and Tree Topology. Also, write one 2
advantage of each of them.

Ans

topologies.
OR
Any other correct difference/definition/advantages

(1 Mark for mentioning any one correct difference between the topologies)
(½ mark each for writing any one advantage of Bus and Tree Topologies)

OR
(½ mark each for conveying correct understanding of Bus and Tree Topology
using/not using diagram)
(½ mark each for writing any one advantage of Bus and Tree Topologies)

OR

Differentiate between HTML and XML.

Ans
HTML XML

It stands for HyperText Markup It stands for eXtensible Markup

Language. Language.

It contains predefined tags It contains user defined tags to

which are used to design describe and store the data.
webpages.

OR
Any other valid difference/characteristic

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #13/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 302

 (Full 2 Marks for writing any one correct difference between HTML and XML)

OR

(1 Mark for writing correct explanation of HTML)

OR
(½ Mark for writing full form of HTML)

(1 Mark for writing correct explanation of XML)

OR
(½ Mark for writing full form of XML)

(ii) What is a web browser ? Write the names of any two commonly used web 2
browsers.

Ans A Web browser is a software/tool, which allows us to

view/access the content of WebPages.
OR
It is a Client software program that is used to access
various kinds of Internet resources using HTTP.
Examples :
Google Chrome, Microsoft Edge, Mozilla Firefox, Apple
Safari, Opera, Chromium, etc. (ANY TWO)

(1 Mark for writing correct explanation of Web-Browser)

(½ Mark for writing each correct name of two Web-Browsers)

13. Galaxy Provider Ltd. is planning to connect its office in Texas, USA with its 4
branch at Mumbai. The Mumbai branch has 3 Offices in three blocks
located at some distance from each other for different operations –
ADMIN, SALES and ACCOUNTS.
As a network consultant, you have to suggest the best network related
solutions for the issues/problems raised in (a) to (d), keeping in mind the
distances between various locations and other given parameters.
Layout of the Offices in the Mumbai branch:

Shortest distances between various locations:

[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #14/15]

STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 303

 Number of Computers installed at various locations are as follows:

ACCOUNTS Block

(a) It is observed that there is a huge data loss during the process of data
transfer from one block to another. Suggest the most appropriate
networking device out of the following, which needs to be placed along
the path of the wire connecting one block office with another to refresh
the signal and forward it ahead.
(i) MODEM (ii) ETHERNET CARD
(iii) REPEATER (iv) HUB
Ans (iii) REPEATER
(1 Mark for correct identification of the Networking Device)

(b) Which hardware networking device out of the following, will you suggest
to connect all the computers within each block ?

(i) SWITCH (ii) MODEM

(iii) REPEATER (iv) ROUTER
Ans (i) SWITCH
(1 Mark for correct identification of the Networking Device)

(c) Which service/protocol out of the following will be most helpful to

conduct live interactions of employees from Mumbai Branch and
their counterparts in Texas ?
(i) FTP (ii) PPP
(iii) SMTP (iv) VoIP
Ans (iv) VoIP
(1 Mark for correct identification of the service/protocol)

(d) Draw the cable layout (block to block) to efficiently connect the three
offices of the Mumbai branch.
Ans

OR any alternate cable layout

(1 Mark for drawing correct cable layout)