Sample Paper Computer Science Class 12 Session 2023-24 Most important for practice

In this article, we are going to Sample Paper Computer Science Class 12 Session 2023-24. CBSE released a sample paper along with the syllabus on 01.04.2023. Here I will provide you with a detailed analysis of sample papers and some more practice papers for the board exam 2024. So let us begin!

Topics Covered

New Paper pattern for Sample Paper Computer Science Class 12 Session 2023-24

For the academic year 2023-24, CBSE has changed the paper pattern and assessment scheme via circular Acad-45/2023 dated 06.04.2023. The Board is introducing changes to Examination and Assessment practices to align assessment to Competency Focused Education, with a greater number of Competency Based Questions or questions that assess the application of concepts in real-life situations.

So let us review the previous year as well as the current year’s assessment and evaluation practices to be followed by the board.

Highlights of Sample Paper Computer Science Class 12 Session 2023-24

Some important highlights of Sample Paper Computer Science Class 12 Session 2023-24 are as follows:

1. Sample Paper Computer Science Class 12 Session 2023-24 contains 35 questions.
2. Sample Paper Computer Science Class 12 Session 2023-24 divided into 5 sections – A to E.
3. Section A – 18 Questions (1-18), Each question of 1 mark.
4. Section B – 7 Questions (19-25), Each question of 2 marks.
5. Section C – 5 Questions (26-30), Each question of 3 marks.
6. Section D – 3 Questions (31-33), Each question of 5 marks.
7. Section E – 2 Questions (34 & 35), Each question of 4 marks.
8. All programming questions are to be answered using Python language only.

Lets us discuss the sample paper now. I have explained every question in detail. So here we go!

Sample Paper Complete Analysis Chapter wise/Question Wise

I have analyzed sample papers with each question chapter-wise. Here it is:

Watch this video for blueprint understanding:

Section A Sample Paper Computer Science Class 12 Session 2023-24

1. State True or False: “In a Python program, if a break statement is given in a nested loop, it terminates the execution of all loops in one go.”
• Ans. – False: In a nested loop, the inner loop will be terminated and the outer loop executes the number of times.
2. In a table in MYSQL database, an attribute A of datatype varchar(20) has the value “Keshav”. The attribute B of datatype char(20) has value “Meenakshi”. How many characters are occupied by attribute A and attribute B?
• a. 20,6
• b. 6,20
• c. 9,6
• d. 6,9
• Ans.: b. 6,20 – Varchar is a variable length data type hence, the value “Keshav” has 6 letters and the char data type is a fixed length data type, hence it occupies 20 characters.
3. What will be the output of the following statement: print(3-2**2**3+99/11)
• a. 244
• b. 244.0
• c. -244.0
• d. Error
• Ans.: c. -2444.0, As per the operator precedence 2**3 evaluate first. So the expression will be 3-2**8+99/11, then 2**8 will be evaluated i.e. 256. After this, 99/11 will be evaluated to 9.0. Hence the expression becomes 3-256+9.0, then -256+12.0 and finally, it returns -244.0
4. Select the correct output of the code:
• s=”Python is fun”
• l=s.split()
• s_new=”-“.join([l[0].upper()],l[1],l[2].capitalize()])
• print(s_new)
• a. PYTHON-IS-Fun
• b. PYTHON-is-Fun
• c. Python-is-fun
• d. PYTHON-Is -Fun
• Ans.: b. PYTHON-is-Fun, The list object l contains [‘Python’,’is”,’fun’], it will join each word with -. l[0] refers to Python which is converted into upper case, Hence its evaluates to PYTHON then l[1] i.e. ‘is’ and fun converted into capitalize so becomes “Fun”.
5. In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?
• a. 5,3
• b. 8,15
• c. 3,5
• d. 15,8
• Ans.: b. 8,15, In the Cartesian product the number of columns will be added and rows will be multiplied. So degree refers to no. of columns and cardinality refers to no. of rows. So here degree 5+3 = 8, cardinality 3*5=15.
6. Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth Technology to connect two devices. Which type of network will be formed in this case?
• a. PAN
• b. LAN
• c. MAN
• d. WAN
• Ans.: a. PAN, When individuals share files using Bluetooth or wifi is considered as PAN network.
7. Which of the following will delete key-value pair for key = “Red” from a dictionary D1?
• a. delete D1(“Red”)
• b. del D1[“Red”]
• c. del.D1[“Red”]
• d. D1.del[“Red”]
• Ans.: b. del D1[“Red”], The del keyword requires a value from dictionary and the syntax for del is del <element>. Option b is correct.
8. Consider the statements given below and then choose the correct output from the given options:
• pride=”#G20 Presidency”
• print(pride[-2:2:-2])
• a. ndsr
• b. ceieP0
• c. ceieP
• d. yndsr
• Ans.: b. ceieP0, The slicing starts from the -2 index which is c, the step value is -2 and the stop value is 2. The slicing will get every alternate character by skipping 1 value up to 2.
9. Which of the following statement(s) would give an error during execution of the following code?
• tup = (20,30,40,50,80,79)
• print(tup) #Statement 1
• print(tup[3]+50) #Statement 2
• print(max(tup)) #Statement 3
• tup[4]=80 #Statement 4
• a. Statement 1
• b. Statement 2
• c. Statement 3
• d. Statement 4
• Ans.: d. tup[4]=80, Tuple immutable hence tuple value cannot be changed.
10. What possible outputs(s) will be obtained when the following code is executed?
• import random
• myNumber=random.randint(0,3)
• COLOR=[“YELLOW”,”WHITE”,”BLACK”,”RED”]
• for I in COLOR:
• for J in range(1, myNumber):
• print(I,end=”*”)
• print()
• a.
• RED*
• WHITE*
• BLACK*
• RED*
• b
• YELLOW*
• WHITE*
• BLACK*
• RED*
• c
• WHITE* WHITE*
• YELLOW* YELLOW*
• BLACK* BLACK*
• RED* RED*
• d
• YELLOW*
• WHITE*WHITE*
• BLACK* BLACK* BLACK*
• RED* RED* RED* RED* RED*
• Ans.: b as random generates random options starting 0 to 3 and the outer loop is traversing the given list of String. So the suitable option is b only.
11. Fill in the blank: The modem at the sender’s computer end acts as a __.
• a. Model
• b. Modulator
• c. Demodulator
• d. Convertor
• Ans.: b. Modulator, Modem is a device that converts analog signals to digital signals. Modulation is the process of converting digital data to analog data. So the sender is sending this kind of data. Hence Modem performs the the same task.
12. Consider the code given below:
• b=100
• def test(a):
• __________________ # missing statement
• b=b+a
• print(a,b)
• test(10)
• print(b)
• Which of the following statements should be given in the blank for #Missing Statement, if the output produced is 110?
• a. global a
• b. global b=100
• c. global b
• d. global a=100
• Ans.: c. global b, In the given code, b is global variable hence to access value of global variable and to change the value of that variable global keyword is used
13. State whether the following statement is True or False: An exception may be raised even if the program is syntactically correct.
• Ans. : True, Sometimes syntax is correct but due to some input error or inappropriate datatype an exception may be raised.
14. Which of the following statements is FALSE about keys in a relational database?
• a. Any candidate key is eligible to become a primary key.
• b. A primary key uniquely identifies the tuples in a relation.
• c. A candidate key that is not a primary key is a foreign key.
• d. A foreign key is an attribute whose value is derived from the primary key of another relation.
• Ans.: c. A candidate key that is not a primary key is a foreign key
15. Fill in the blank: In case of ____________________ switching, before communication starts, a dedicated path is identified between the sender and the receiver.
• Ans.:circuit, The connection is established through a physical path between two endpoint networks.
16. Which of the following functions changes the position of the file pointer and returns its new position?
• a. flush()
• b. tell()
• c. seek()
• d. offset()
• Ans.: c. seek(), tell() function is used to set the cursor position and flush() is used for memory purpose.
• Assertion(A): List is an immutable data type
• Reasoning(R): When an attempt is made to update the value of an immutable variable, the old variable is destroyed and a new variable is created by the same name in memory.
• (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
• Ans.: (c) A is True but R is False
• Assertion(A): Python standard library consists of number of modules.
• Reasoning(R): A function in a module is used to simplify the code and avoids repetition.
• (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
• Ans.: (a) Both A and R are true and R is the correct explanation for A

Section B Sample Paper Computer Science Class 12 Session 2023-24

Watch this video for more practical unerstanding:

19. (i) Expand the following terms: POP3 , URL
(ii) Give one difference between XML and HTML.

Ans.:

(i) POP3: Post Office Protocol 3, URL: Uniform Resource Locator

(ii)

20. The code given below accepts a number as an argument and returns the reverse number. Observe the following code carefully and rewrite it after removing all syntax and logical errors. Underline all the corrections made.

Ans.:

``````def revNumber(num):  #Error 1
rev = 0
rem = 0
while num>0:       #Error 2
rem=num%10      #Error 3
rev=rev*10+rem
num=num//10
return rev         #Error 4
print(revNumber(1234))``````

21. Write a function countNow(PLACES) in Python, that takes the dictionary, PLACES as an argument and displays the names (in uppercase) of the places whose names are longer than 5 characters.
For example, Consider the following dictionary
PLACES={1:”Delhi”,2:”London”,3:”Paris”,4:”New York”,5:”Doha”}
The output should be:

LONDON
NEW YORK

Ans.:

Explanation:

1. Define a function as given the question and traverse the dictionary.
2. In marking scheme dict.values() method is used to traverse the element individually.
3. Then len() returns the length of the places stored in dictionary as values.
4. In if condition(), the upper() function is used to convert the places into upper case.

Given into Marking Scheme:

``````PLACES={1:"Delhi",2:"London",3:"Paris",4:"New York",5:"Doha"}
def countNow(PLACES):
for place in PLACES.values():
if len(place)>5:
print(place.upper())
countNow(PLACES)
``````

Different Logic:

``````PLACES={1:"Delhi",2:"London",3:"Paris",4:"New York",5:"Doha"}
def countNow(PLACES):
for i in PLACES:
if len(PLACES[i])>5:
print(PLACES[i].upper())
countNow(PLACES)
``````

OR

Write a function, lenWords(STRING), that takes a string as an argument and returns a tuple containing length of each word of a string.
For example, if the string is “Come let us have some fun”, the tuple will have (4, 3, 2, 4, 4, 3)

Ans.:

Explanation:

1. The function is defined as given in the question
2. An empty tuple is declared to store the length of values
3. The length of each word is requried, so split() function is used to separate the words into a list object L
4. Now list is traversed through for loop.
5. The length of each word is stored in length variable.
6. Now the length is contacted into a tuple
7. Finally the tuple is returned
``````STR="Come let us have some fun"
def lenWords(STRING):
T=()
L=STRING.split()
for i in L:
length=len(i)
T=T+(length,)
return T
print(lenWords(STR))
``````

22. Predict the output of the following code:

``````S="LOST"
L=[10,21,33,40]
D={}
for I in range(len(S)):
if I%2==0:
D[L.pop()]=S[I]
else:
D[L.pop()]=I+3
for K,V in D.items():
print(K,V,sep='*')``````

Ans.:

Explanation:

In the above code, the string is traversed which inserts the odd-even position value from the last and assigned a key to the value from the string. Hence

33*4

40*L

21*S

10*6

23. Write the Python statement for each of the following tasks using BUILT-IN functions/methods only:
(i) To insert an element 200 at the third position, in the list L1.
(ii) To check whether a string named, message ends with a full stop / period or not.

Ans.:

(i) L1.insert(2,200)

(ii) message.endswith(‘.’)

24. Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, and Salary.
After creating the table, she realized that she has forgotten to add a primary key column in the table. Help her in writing an SQL command to add a primary key column EmpId of integer type to the table Employee.

Thereafter, write the command to insert the following record in the table:

EmpId- 999
Ename- Shweta
Department: Production
Salary: 26900

Ans.:

SQL Command to add primary key:
ALTER TABLE Employee ADD EmpId INTEGER PRIMARY KEY;
As the primary key is added as the last field, the command for inserting data will be:
INSERT INTO Employee VALUES(“Shweta”,”Production”,26900,999);

25. Predict the output of the following code:

Ans.:

Explanation: A and B are declared in top-level statements. When function Changer() is called first time A will take the final values of P returned by the function as follows:

Changer(A=200,B=20)

P=P/Q=A/B=200/20=10.0

Now Q=P%Q=A%B=10.0%20=10.0

So Final Values after Calling function: A=10.0, B=20, So the output for print(A,B,sep=’\$’) is 10.0\$20

Now again the function is called as B=Changer(B). Here B is 20 and which replaces the P and Q will be the default value 10.

Changer(B=20,A=10)

P=P/Q=B/A=20/10=2.0

Now Q=P%Q=A%B=10.0%2.0=0.0

So the final Values are A=10.0 and B=2.0. So print(A,B,sep=’\$’,end=’###’) will print 10.0\$2.0###

Hence the output is :

10.0\$20
10.0\$2.0###

Section C Sample Paper Computer Science Class 12 Session 2023-24

Watch this video for more understanding of the given questions 26 to 30.

26. Predict the output of the Python code given below:

Ans.:

Explanation:

As per codes 0 to 9 will be converted into integers. So two digits are there 2 and 3. Then Val=Val + 1, which means 2 + 1 and 3 + 1 respectively going to be concat with Text2 Variable.

A to Z letters will be contacted with next element. So I become N, N becomes D, D becomes -. The else block will be applied to – convert it into *. Hence the output will ve

ND-*34

27. Consider the table CLUB given below and write the output of the SQL queries that follow:

(i) SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
(ii) SELECT CNAME, SPORTS FROM CLUB WHERE DOAPP<“2006-04-30” AND CNAME LIKE “%NA”;
(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = “MALE” AND PAY BETWEEN 1000 AND 1200;

ANS.:

(i)

COUNT(DISTINCT SPORTS)

——————————————

4

(ii)

CNAME SPORTS

————- ————-
AMINA CHESS

(iii)

CNAME AGE PAY

——— ——- ———-
AMRIT 28 1000
VIRAT 35 1050

28. Write a function in Python to read a text file, Alpha.txt, and displays those lines which begin with the word ‘You’.

Ans.:

OR

Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt.

Ans.:

29. Consider the table Personal given below:

Table:Person

Based on the given table, write SQL queries for the following:

1. Increase the salary by 5% of personals whose allowance is known.
2. Display Name and Total Salary (sum of Salary and Allowance) of all personals. The column heading ‘Total Salary’ should also be displayed.
3. Delete the record of Supervisors who have salary greater than 25000

Ans.:

1. update person set salary=salary+(salary*0.05) where allowance is not null;
2. select name, ifnull(salary,0) +ifnull(allowance,0) as “Total salary” from personal;
3. delete from personal where salary>25000 and desig=’Superviser‘;

30. A list, NList contains following record as list elements:
[City, Country, distance from Delhi]
Each of these records are nested together to form a nested list. Write the following user-defined functions in Python to perform the specified operations on the stack named travel.

(i) Push_element(NList): It takes the nested list as an argument and pushes a list object containing name of the city and country, which are not in India and distance is less than 3500 km from Delhi.
(ii) Pop_element(): It pops the objects from the stack and displays them. Also, the function should display “Stack Empty” when there are no elements in the stack.

For example: If the nested list contains the following data:
NList=[[“New York”, “U.S.A.”, 11734],
[“Naypyidaw”, “Myanmar”, 3219],
[“Dubai”, “UAE”, 2194],
[“London”, “England”, 6693],
[“Gangtok”, “India”, 1580],
[“Columbo”, “Sri Lanka”, 3405]]
The stack should contain:
[‘Naypyidaw’, ‘Myanmar’],
[‘Dubai’, ‘UAE’],
[‘Columbo’, ‘Sri Lanka’]
The output should be:
[‘Columbo’, ‘Sri Lanka’]
[‘Dubai’, ‘UAE’]
[‘Naypyidaw’, ‘Myanmar’]
Stack Empty

Ans.:

``````NList=[["New York", "U.S.A.", 11734],
["Naypyidaw", "Myanmar", 3219],
["Dubai", "UAE", 2194],
["London", "England", 6693],
["Gangtok", "India", 1580],
["Columbo", "Sri Lanka", 3405]]
travel=[]
def pus_element(NList):
for i in NList:
if i[1]!='India' and i[2]<3500:
travel.append([i[0],i[1]])

def pop_element():
while len(travel):
print(travel.pop())
else:
print("Stack empty")

pus_element(NList)
pop_element()
``````

Section D Sample Paper Computer Science Class 12 Session 2023-24

31. Meticulous EduServe is an educational organization. It is planning to setup its India campus at Chennai with its head office at Delhi. The Chennai campus has 4 main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA

Block to Block distances (in Mtrs.):

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

a) Suggest and draw the cable layout to efficiently connect various blocks of buildings within the CHENNAI campus for connecting digital devices.
b) Which network device will be used to connect computers in each block to form a local area network?
d) Which fast and very effective wireless transmission medium should preferably be used to connect the head office at DELHI with the campus in CHENNAI?
e) Suggest a device/software to be installed in the CHENNAI Campus to take care of data security.

Ans.:

a)

Explanation: The admin block has the maximum number of computers that can be set up as server room. So all blocks should be connected directly or indirectly with it. Hence the minimum distance is considered for every block and layout is prepared.

b) Switch, is a suitable device to connect every block’s computer.
c) Admin block, as it has the maximum number of computers.
d) Microwave
e) Firewall

32. (i) Differentiate between r+ and w+ file modes in Python.

Ans.:

(ii) Consider a file, SPORT.DAT, containing records of the following structure:

[SportName, TeamName, No_Players]
Write a function, copyData(), that reads contents from the file SPORT.DAT and copies the records with Sport name as “Basket Ball” to the file named BASKET.DAT. The function should return the total number of records copied to the file BASKET.DAT.

OR

(Only for option ii)

A Binary file, CINEMA.DAT has the following structure:
{MNO:[MNAME, MTYPE]}
Where
MNO – Movie Number
MNAME – Movie Name
MTYPE is Movie Type
Write a user-defined function, findType(mtype), that accepts mtype as a parameter and displays all the records from the binary file CINEMA.DAT, that have the value of Movie Type as mtype.

33.

(i) Define the term Domain with respect to RDBMS. Give one example to support your answer.
(ii) Kabir wants to write a program in Python to insert the following record in the table named Student in MYSQL database, SCHOOL:

• rno(Roll number )- integer
• name(Name) – string
• DOB (Date of birth) – Date
• Fee – float

Note the following to establish connectivity between Python and MySQL:

• Host – localhost

The values of fields rno, name, DOB and fee has to be accepted from the user. Help Kabir to write the program in Python.

Ans.:

(i) Domain is a set of values from which an attribute can take value in each row. For example, roll no field can have only integer values and so its domain is a set of integer values.

(ii)

Section E Sample Paper Computer Science Class 12 Session 2023-24

34. Consider the tables PRODUCT and BRAND given below:

Table: PRODUCT

Table: BRAND

Write SQL queries for the following:
(i) Display product name and brand name from the tables PRODUCT and BRAND.
(ii) Display the structure of the table PRODUCT.
(iii) Display the average rating of Medimix and Dove brands
(iv) Display the name, price, and rating of products in descending order of rating.

Ans.:

(i) SELECT PName, BName FROM PRODUCT P, BRAND B WHERE P.BID=B.BID;
(ii) DESC PRODUCT;
(iii) SELECT BName, AVG(Rating) FROM PRODUCT P, BRAND B WHERE P.BID=B.BID GROUP BY BName HAVING BName=’Medimix’ OR BName=’Dove’;

(iv) SELECT PName, UPrice, Rating FROM PRODUCT ORDER BY Rating DESC;

35.

Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the results of students in different sports events. The structure of Result.csv is :
[St_Id, St_Name, Game_Name, Result] – Where

• St_Id is Student ID (integer)
• ST_name is Student Name (string)
• Game_Name is name of game in which student is participating(string)
• Result is result of the game whose value can be either ‘Won’, ‘Lost’ or ‘Tie’

For efficiently maintaining data of the event, Vedansh wants to write the following user-defined functions:
Accept() – to accept a record from the user and add it to the file Result.csv. The column headings should also be added on top of the csv file.
wonCount() – to count the number of students who have won any event.
As a Python expert, help him complete the task.

Ans.:

This section contains various sample papers for various exams. Here we go!