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.

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.
(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.

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

9.
 (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

(c) None (d) None of these

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

(a) int (b) date

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

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

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

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

17.
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)

 Reason (R)
(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.

19. Riya was asked to accept a list of even numbers ,but she did not put the relevant condition while accepting the list

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.
or

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)

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))
or
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.
or
Identify any two DML commands from the following and also explain.
ALTER , INSERT , UPDATE , DROP , CREATE

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
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.
display the occurrence of alphabets E and U (including small cases e and u too).

The countEU() function should display the output asE :

8
U:3
or

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

(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
TOM ANU BOB OM
or

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 followsN =
[12, 13, 34, 56, 21, 79, 98, 22, 35, 38]
Sample Output of the code should be:38
22 98 56 34 12

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

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”)

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

The table structure is as follows :

Scode : integer
 Name : varcharAge
: integer Strcde :
integerPoints :
integerGrade :
varchar
Note the following to establish the connection between Python and MySQL:
Host : localhost
Username : Admin Password
: Admin@123

The table exists in MySQL database as : Student

or
(a) Write a Python program to remove the characters of odd index values in a string.

M_Id. M_Name, M_Oty, M_Supplier

Consider:
host : localhost
UserName : root
Password : system
Database : Mobile

33.
Write a program using two functions :

The details of the customers are as follows :

(b) readCustomer( ): To read the details of the customers and display them.
or

Write a program using following functions :

storing records of inventory as per following structure

PCode Invname Price Reorder
(b) Display() : To display the detail that store in Inventory.csv
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

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

(iii) Write statements to :

(a) Delete the records whose language is “English”
(b) Add a new record : “M050”, “Palki”,“Hindi”, 5, “Amazon Prime”.
or
(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 executethe
program successfully.
import ......

“......”)

while True:

if not line:
break
else :
if word in line :
......
else :
print(line)

(i) Name the module that should import in Line 1.

(iii) Fill the blank in Line 11 and Line 14.