Page 1 Sample Paper 1 Computer Science Class 12

Sample Paper 1
Computer Science (083)
CLASS XII 2023-24
Time: 3 Hours Max. Marks: 70
General Instructions:
1. Please check this question paper contains 35 questions.
2. The paper is divided into 4 Sections- A, B, C, D and E.
3. Section A, consists of 18 questions (1 to 18). Each question carries 1 Mark
4. Section B, consists of 7 questions (19 to 25). Each question carries 2 Marks.
5. Section C, consists of 5 questions (26 to 30). Each question carries 3 Marks.
6. Section D, consists of 2 questions (31 to 32). Each question carries 4 Marks.
7. Section E, consists of 3 questions (33 to 35). Each question carries 5 Marks.
8. All programming questions are to be answered using Python Language only.

Section A
1. The output of the code will be :
s=“Wonders of World”
print(s.count(‘O’) + s.index(‘o’))
(a) 3 (b) 4
(c) 2 (d) 1

2. The constraint that is used to provide a condition on a field to take specific values only is :
(a) NULL (b) PRIMARY KEY
(c) CHECK (d) NOT NULL

3. Which of the following are random number generators ?

(a) randint() (b) randrange()
(c) random() (d) All of these

4. Which of the following are sequence of character data?

(a) Lists (b) Tuples
(c) Strings (d) Dictionaries

5. A device that connects two dissimilar networks is

(a) modem (b) repeater
(c) bridge (d) gateway

6. 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 these

7. State True or False

“Multiple elements can be added at the end of list by the append method”.

8. These operators are used to make a decision on two conditions.

(a) Logical (b) Arithmetic
(c) Relational (d) Assignment
Install NODIA App to See the Solutions.
Click Here To Install
Page 2 Sample Paper 1 Computer Science Class 12

9. In files, there is a key associated with each record which is used to differentiate among different records. For every
file, there is atleast one set of keys that is unique. Such a key is called
(a) unique key (b) prime attribute
(c) index key (d) primary key

10. a = 1.0
b = 1.0
a is b # Line 1
Output of Line 1 will be
(a) False (b) True
(c) 1.0 (d) 0.0

11. Which of the following is a correct syntax to add a column in SQL command?
(a) ALTER TABLE table_name ADD column_name data_type;
(b) ALTER TABLE ADD column_name data_type;
(c) ALTER table_name ADD column_name data_type;
(d) None of the above

12. In complex number a + ib, a represents as

(a) real part (b) imaginary part
(c) special part (d) None of these

13. a = 6
b = 5.5
sum = a+b
print(sum)
print(type (sum))
(a) 11.5 (b) 10.5
<class ‘float’> <class ‘float’>
(c) None (d) None of these
<class ‘int’>

14. A column storing Name of a department in a table Emp will be of type

(a) int (b) date
(c) float (d) varchar

15. The........keyword sorts the records in ascending order by default.

(a) LIKE (b) UPDATE
(c) ORDER (d) ORDER BY

16. .........method takes a string and writes it in the file.

(a) writelines() (b) write()
(c) writerow() (d) writer()

Install NODIA App to See the Solutions.

Click Here To Install
Page 3 Sample Paper 1 Computer Science Class 12

Directions : (Q.Nos.-17 and 18) are Assertion and Reason based Questions.

17. Assertion (A) Built-in functions are predefined in the system and can be directly used in any program.
Reason (R) id( ) and type( ) are built-in functions in Python.
(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true but 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) The CSV files are like TEXT files and are comma separated value files.
Reason (R) The data stored in CSV files are separated by comma by default. Although the delimiter can be changed.
(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true but R is not the correct explanation for A.
(c) A is true but R is false.
(d) A is false but R is true.

Section - B
19. Riya was asked to accept a list of even numbers ,but she did not put the relevant condition while accepting the list
of numbers. She wrote a user defined function odd to even (L) that accepts the list L as an argument and converts
all the odd numbers into even by multiplying them by 2.
def oddtoeven (L)
for i in range (size(L)):
if (L[i]%2! == 0)
L[i]= L[1] ** 2
print (L)
There are some errors in the code . Rewrite the correct code.

20. How are E-mail and chat applications different?

o
How are LAN and MAN different?

21. Observe the code and write the output

(a) ‘arihant publication’.
count(‘hant’, 0, 10)
(b) dic = {}
dic [(1, 2, 4)] = 8
dic [(4, 2, 1)] = 10
dic [1, 2)] = 24
sum = 0
for i in dic :
sum = sum + dic[i]
print (sum)

Install NODIA App to See the Solutions.

Click Here To Install
Page 4 Sample Paper 1 Computer Science Class 12

22. Write about the terms degree and cardinality of a table.

23. (a) Write the full forms of

(i) URL
(ii) VoIP
(b) Write the use of SMTP.

24. Find the output of following code.

dic = {“Nitin” : (21, “NIIT”), “Ankit” : (15, “NIIT”)}
print(“The original dictionary : ”, str(dic))
result= [(key, i, j) for key, (i, j) in dic.items()]
print(“The list after conversion : ”, str(result))


o
What output will be generate when the following Python code is executed?
def ChangeList ():
l =[]
l1=[]
l2=[]
for i in range(1, 10):
l.append(i)
for i in range(10, 1, –2):
l1.append(i)
for i in range(len (l1)):
l2.append(l1[i] + l[i])
l2.append (len(l)– len(l1))
print(l2)
ChangeList()

25. Differentiate between DROP and DELETE commands of SQL.

o
Identify any two DML commands from the following and also explain.
ALTER , INSERT , UPDATE , DROP , CREATE

Section-C

26. (a) Consider the following tables - STUDENT and STREAM :

TABLE: STUDENT
SCODE NAME AGE STRCDE POINTS GRADE
101 Amit 16 1 6 NULL
102 Arjun 13 3 4 NULL
103 Zaheer 14 2 1 NULL

TABLE: STREAM
STRCDE STRNAME

Install NODIA App to See the Solutions.

Click Here To Install
Page 5 Sample Paper 1 Computer Science Class 12

1 SCIENCE+COMP
2 SCIENCE+ BIO
3 SCIENCE+ECO
4 COMMERCE+MATHS
What will be the ouput of the following statement?
SELECT NAME, STRNAME FROM STUDENT S, STREAM ST WHERE S.STRCDE=ST.STRCDE;

(b) Write the output for SQL queries (i) to (iv), which are based on the table ITEMS.
TABLE: ITEMS
Code IName Qty Price Company TCode
1001 DIGITAL PAD 12i 120 11000 XENITA T01
1006 LED SCREEN 40 70 38000 SANTORA T02
1004 CAR GPS SYSTEM 50 2150 GEOKNOW T01
1003 DIGITAL CAMERA 12X 160 8000 DIGICLICK T02

1005 PEN DRIVE 32 GB 600 1200 STOREHOME T03

(i) SELECT MAX(Price), MIN(Price) FROM ITEMS;
(ii) SELECT Price * Qty AS AMOUNT
FROM ITEMS WHERE Code=1004;
(iii) SELECT DISTINCT TCode FROM ITEMS;
(iv) SELECT MAX(Company) FROM ITEMS WHERE Price > 7000;

27. Write a function countEU() in Python, which should read each character of a text file. IMP.TXT should count and
display the occurrence of alphabets E and U (including small cases e and u too).
e.g. If the file content is as follows :
Pinaky has gone to his friend’s house.
His friend’s name is Ravya. Her house is 12 km from Pinaky’s house.
The countEU() function should display the output as
E:8
U:3


o
Write a Python program to find the longest word in file “status.txt”. If contents of status.txt are Welcome to your one-
step solutions for all your study, practice and assessment need for various competitive and recruitment examinations
and school segment. We have been working tirelessly for over a decade to make sure that you have best in class
study resources because you deserve SUCCESS AND NOTHING LESS...
Output should be
Longest word : examinations

28. (a) Consider the following tables GARMENT and FABRIC. Write SQL commands for the statements (i) to (iv).
TABLE: GARMENT
GCODE DESCRI-PTION PRICE FCODE READY-DATE
10023 PENCIL SKIRT 1150 F03 19-DEC-08

Install NODIA App to See the Solutions.

Click Here To Install
Page 6 Sample Paper 1 Computer Science Class 12

10001 FORMAL SHIRT 1250 F01 12-JAN-08

10012 INFORMAL SHIRT 1550 F02 06-JUN-08
10024 BABY TOP 750 F03 07-APR-07
10090 TULIP SKIRT 850 F02 31-MAR-07
10019 EVENING GOWN 850 F03 06-JUN-08
10009 INFORMAL PANT 1500 F02 20-OCT-08
10007 FORMAL PANT 1350 F01 09-MAR-08
10020 FROCK 850 F04 09-SEP-07
10089 SLACKS 750 F03 20-OCT-08

TABLE: FABRIC
FCODE TYPE
F04 POLYSTER
F02 COTTON
F03 SILK
F01 TERELENE
(i) To display GCODE and DESCRIPTION of each GARMENT in descending order of GCODE.
(ii) To display the details of all the GARMENTs, which have READYDATE in between 08-DEC-07 and 16-
JUN-08 (inclusive of both the dates).
(iii) To display the average PRICE of all the GARMENTs. Which are made up of FABRIC with FCODE as F03.
(iv) To display FABRIC wise highest and lowest price of GARMENTs from GARMENT table.
(Display FCODE of each GARMENT alongwith highest and lowest price.)
(b) Write a command to remove all the records of a table “Shipping”.

29. Write the definition of a function Reverse (x) in Python, to display the elements in reverse order such that each
displayed element is the twice of the original element (element *2) of the List x in the following manner:
Example :
If List x contains 7 integers is as follows:
x [0] x [1] x [2] x [3] x [4] x [5] x [6]
4 8 7 5 6 2 10
After executing the function, the array content should be displayed as follows:
20 4 12 10 14 16 8

30. Julie has created a dictionary containing names and marks as key value pairs of 6 students. Write a program, with
separate user defined functions to perform the following operations
(a) Push the keys (name of the student) of the dictionary into a stack, where the corresponding value (marks) is
greater than 75.
(b) Pop and display the content of the stack.
For example If the sample content of the dictionary is as follows
R={“OM”:76, “JAI”:45, “BOB”:89, “ALI”:65, “ANU”:90, “TOM”:82}
The output from the program should be

Install NODIA App to See the Solutions.

Click Here To Install
Page 7 Sample Paper 1 Computer Science Class 12

TOM ANU BOB OM

o
Alam has a list containing 10 integers. You need to help him create a program with separate user defined functions
to perform the given operations based on this list.
(a) Traverse the content of the list and push the even numbers into a stack.
(b) Pop and display the content of the stack.
For example, If the sample content of the list is as follows
N = [12, 13, 34, 56, 21, 79, 98, 22, 35, 38]
Sample Output of the code should be:
38 22 98 56 34 12

Section - D
31. Red Pandas Infosystems has its 4 blocks of buildings. The number of computers and distances between them is
given below :

Building Number of Computers

HR 15
ADMIN 100
SYSTEM 25
PERS 30

Building Distance
HR -Admin 10 m
HR- System 50 m
HR- Pers 750 m
Admin- System 300 m
Admin- Pers 20 m
System-Pers 250 m

Install NODIA App to See the Solutions.

Click Here To Install
Page 8 Sample Paper 1 Computer Science Class 12

Answer the following questions with respect to the above :

(i) Suggest a suitable cable layout for the network.
(ii) Suggest the best place to house the server of the network.
(iii) Which topology should be used to connect computers in each building?
(iv) What kind of network will be formed here? (LAN/MAN/WAN)
(v) Write one advantage of the topology suggested by you.

32. (a) Find the output of the following Python program:

def makenew (mystr):
newstr = “”
count = 0
for i in mystr:
if count%2!=0:
newstr = newstr + str (count)
else:
if islower (i):
newstr = newstr + upper (i)
else:
newstr = newstr + i
count + = 1
newstr = newstr + mystr [:1]
print(“The new string is:”,
newstr)
makenew(“sTUdeNT”)
(b) Consider the table Student whose fields are
Scode Name Age Strcde Points Grade
101 Amit 16 1 6 NULL
102 Arjun 13 3 4 NULL
103 Zaheer 14 2 1 NULL
104 Gegen 15 5 2 NULL
105 Kumar 13 6 8 NULL
Write the Python code to update grade to ‘A’ for all these students who are getting more than 8 as points.
The table structure is as follows :
Scode : integer
Name : varchar
Age : integer
Strcde : integer
Points : integer
Grade : varchar
Note the following to establish the connection between Python and MySQL:
Host : localhost
Username : Admin
Password : Admin@123

Install NODIA App to See the Solutions.

Click Here To Install
Page 9 Sample Paper 1 Computer Science Class 12

The table exists in MySQL database as : Student

o
(a) Write a Python program to remove the characters of odd index values in a string.
(b) Consider the table MobileStock with following fields
M_Id. M_Name, M_Oty, M_Supplier
Write the Python code to fetch all records with fields M_Id, M_Name and M_Supplier from database Mobile.
Consider:
host : localhost
UserName : root
Password : system
Database : Mobile

33. What is CSV file?

Write a program using two functions :
(a) addCustomer( ): To write Customer code, Customer name and Amt in file “cust.csv”.
The details of the customers are as follows :
[‘CustCode’, ‘CustName’, ‘Amount’]
[‘001’, ‘Nihir’, ‘8000’]
[‘104’, ‘Akshay’, ‘5000’]
(b) readCustomer( ): To read the details of the customers and display them.


o
When do we use CSV file?
Write a program using following functions :
(a) getlnventory() : Write code to accept as many inventory records and store them to the csv file Inventory.csv
storing records of inventory as per following structure
PCode Invname Price Reorder
(b) Display() : To display the detail that store in Inventory.csv

Section - E
34. Consider the table MOVIE DETAILS given below
Table : MOVIEDETAILS
MOVIEID TITLE LANGUAGE RAT-ING PLAT-FORM
M001 Minari Korean 5 Netflix
M004 MGR Magan Tamil 4 Hotstar
M010 Kaagaz Hindi 3 Zee5
M011 Harry Potter and the English 4 Prime Video
Chamber of Secrets
M015 Uri Hindi 5 Zee5
M020 Avengers: Endgame English 4 Hotstar

Install NODIA App to See the Solutions.

Click Here To Install
Page 10 Sample Paper 1 Computer Science Class 12

(i) Identify the degree and cardinality of the table.

(ii) Which field should be made the primary key? Justify your answer.
(iii) Write statements to :
(a) Delete the records whose language is “English”
(b) Add a new record : “M050”, “Palki”,“Hindi”, 5, “Amazon Prime”.


o
(Option for part (iii) only)
Write statements to :
(a) Add a new column “DAYS” of type integer
(b) Remove the column “RATING”

35. Below is a program to delete the line having word (passed as argument). Answer the questions that follow to execute
the program successfully.
import ......
def filedel (word):
file1 = open (“Python. txt ”,
“......”)
nfile = open (“algo1.txt”, “w”)
while True:
line = file1.readline( )
if not line:
break
else :
if word in line :
......
else :
print(line)
nfile......(line)
file1.close()
nfile.close()
filedel (‘write’)
(i) Name the module that should import in Line 1.
(ii) In which mode, above program should open the file to delete the line?
(iii) Fill the blank in Line 11 and Line 14.

Install NODIA App to See the Solutions.

Click Here To Install