(1001CJA101021240045) *1001CJA101021240045* Test Pattern
Board Pattern
SCORE-II
(Academic Session : 2024 - 2025) 12-02-2025
JEE(MAIN + ADVANCED) : ENTHUSIAST COURSE
COMPUTER SCIENCE
Time : 3 Hrs. Max. Marks : 70
General Instructions :
● This question paper contains 37 questions.
● All questions are compulsory. However, internal choices have been provided in some questions.
Attempt only one of the choices in such questions
● The paper is divided into 5 Sections- A, B, C, D and E.
● Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
● Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
● Section C consists of 3 questions (29 to 31). Each question carries 3 Marks.
● Section D consists of 4 questions (32 to 35). Each question carries 4 Marks.
● Section E consists of 2 questions (36 to 37). Each question carries 5 Marks.
● All programming questions are to be answered using Python Language only.
● In case of MCQ, text of the correct answer should also be written.
HAVE CONTROL → HAVE PATIENCE → HAVE CONFIDENCE ⇒ 100% SUCCESS
SECTION–A
[21 × 1 = 21]
1. State True or False:
"In a python if …… elif block, the else block is compulsory to write. [1]
2. Kajal has created a MySQL table storing the details of players. She wants to see the structure of
thetable with the fields, data type, size and constraints. Which command out of the following she
has to use ? [1]
(A) Describe (B) Alter
(C) Show table (D) None of the above
3. What will be the output of the following code ? [1]
2**3**2 + 625**0.5 + 7//2
(A) 542.50 (B) 540.0
(C) 539 (D) 541.0
CAREER INSTITUTE Pvt. Ltd.
Registered & Corporate Office : ‘SANKALP’, CP-6, Indra Vihar, Kota (Rajasthan) INDIA-324005 1/12
Ph. : +91-744-3556677, +91-744-2757575|E-mail : info@allen.in|Website : www.allen.ac.in
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
4. Write the output of the following code snippet : [1] O
tup= ('geek',)
n=5
for I in range(int(n)) :
tup=(tup,)
print(tup)
(A) (('geek',),)
((('geek',),),)
(((('geek',),),),)
((((('geek',),),),),)
(((((('geek',),),),),),)
(B) ('geek',)
((('geek',),),)
(((('geek',),),),)
((((('geek',),),),),)
(((((('geek',),),),),),)
(C) (('geek',),)
(('geek',),)
(((('geek',),),),)
((((('geek',),),),),)
(((((('geek',),),),),),)
(D) (('geek',),)
((('geek',),),)
(((('geek',),),),)
((((('geek',),),),),)
((((('geek',),),),),)
5. A table Product has 5 columns and 10 rows. Another table Transaction has 6 columns and
18 rows. What will be the degree and cardinality of Product × Transaction ? [1]
(A) Degree : 28, Cardinality : 10 (B) Degree : 5, Cardinality : 28
(C) Degree : 11, Cardinality : 180 (D) Degree : 30, Cardinality : 28
6. Sudhir found that signals send by him to his friend were weak. Which of the following devices he
needed install ? [1]
(A) NIC (B) RJ45
(C) Modem (D) Repeater
2/12 1001CJA101021240045
zGn
Enthusiast Course/12-02-2025
7. What will be the output for the following Python statements ? [1]
D= ("AMIT":90, "RESHMA":96, "SUKHBIR":92, "JOHN":95)
print("JOHN" in D, 90 in D, sep = "#")
(A) True#False (B) True#True (C) False#True (D) False#False
8. Given a tuple tupl= (10, 20, 30, 40, 50, 60, 70, 80, 90). [1]
What will be the output of print (tup1 [3:7:2]) ?
(A) (40,50,60,70,80) (B) (40,50,60,70)
(C) [40,60] (D) (40,60)
9. Consider a tuple tup1 = (10, 15, 25, 30). Identify the statement that will result in an
error. [1]
(A) print(tup1[2]) (B) tup1[2] = 20
(C) print(min(tup1)) (D) print (len1(tup1))
10. Study the following program and select the possible output(s) from the options (A) to (D) following
it : [1]
import random
X= random.random()
Y= random.randint(0,4)
print int(X), ":", Y+int(X)
(A) 0 : 0 (B) 1 : 6 (C) 2 : 4 (D) 2 : 3
11. Fill in the blank: [1]
An IP address is of _______
(A) 4 bytes (B) 3 bytes (C) 16 bytes (D) 32 bytes
12. Given the following code. What should be filled in the missing blank for proper execution of the
code. [1]
def square(n) : #Function to find the square of the last digit of
the argument and return
d-n%10
d=d**2
________# Missing blank
(A) ret d (B) print(n) (C) return d (D) return n%10
13. State True or False : EOFError is a kind of Exception. [1]
14. Which of the following statements is correct regarding Alternate key ? [1]
An Alternate key can be defined as :
(A) An attribute which is a primary key (B) An attribute which is not a primary key
(C) A candidate key (D) None of these
1001CJA101021240045 3/12
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
15. Fill in the blank: [1]
A network with all client computer and no server is called _______.
16. Which of the following statements opens a binary file "Emp.dat: for adding more records keeping
the existing records ? [1]
(A) f=open("Emp.dat","w")
(B) f=openfile("Emp.dat","wb")
(C) f=open("Emp.dat","ab")
(D) f=openfile("Emp.dat","r")
17. Which protocol is used to transfer files over the Internet?
(A) HTTP (B) FTP
(C) PPP (D) HTTPS
18. Which network device is used to connect two networks that use different protocols?
(A) Modem (B) Gateway
(C) Switch (D) Repeater
19. Which switching technique breaks data into smaller packets for transmission, allowing multiple
packets to share the same network resources.
(A) Circuit Switching (B) Packet Switching
(C) Message Switching (D) None of the above
Assertion and Reason :
In the following questions, A statement of Assertion (A) is followed by a statement of Reason (R).
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
20. Assertion (A): If the arguments in function call statement match the number and order of
arguments as defined in the function definition, such arguments are called positional arguments.
Reason (R): During a function call, the argument list first contains default argument(s) followed by
positional argument(s). [1]
21. Assertion (A): CSV (Comma Separated Values) is a file format for data storage which looks like a
text file.
Reason (R): The information is organized with one record on cach line and each field is separated
by comma. [1]
4/12 1001CJA101021240045
zGn
Enthusiast Course/12-02-2025
SECTION–B
This section comprises of 7 very short answer (VSA) type questions of 2 marks each. [7 × 2 = 14]
22. Identify the errors(s) in the code and write the correct code. [2]
def describe intelliegent life form():
height = input ("Enter the height")
raw_input("Is it correct?")
weight = input ("Enter the weight")
favourite-game = input("Enter favourite game")
print("your height", height,'and weight',weight)
print("and your favourite game is", favouritism,'.')
23. Find and write the output of the following Python code : [2]
p = 1
q = 6
def change_values():
global p
q = 5
p = p + q
return (p)
change_values()
print(p,q)
24. Write a Python program using functions to calculate area of a triangle after obtaining its three sides.
[2]
OR
Write a function namely checkPrime(num) that receives a number and returns True if the
argument passe is a prime number, else returns False.
25. Find and write the output of the following Python code def status(P ,Q=35): [2]
P=P+Q
Q=P–Q
print(P,"@",Q)
return (P)
R=300
S=150
R=status(R,S)
print(R,"!!",S)
S=status(S)
1001CJA101021240045 5/12
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
26. Write the output of the following code: [2]
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)
B=Changer(B)
print(A,"$",B)
A=Changer(A)
print (A,"$",B)
27. A table, Teacher has been created in a database with the following fields: [2]
Tcode, Tname, Dept, Post, Salary
Give the SQL command to make Tcode as the primary key
Then after write a query to increase the salary of "Computer" department teachers by 25%.
OR
Define Equi join
28. (a) When a user browses a website, the web server sends a text file to the web browser. What is
the name, this? [2]
(b) What is the purpose of server in a network?
OR
(a) Write the expanded names for the following abbreviated terms SMTP, VoIP
(b) How is packet switching different from circuit switching?
SECTION–C
This section comprises of 3 short answer (SA) type questions of 3 marks each. [3 × 3 = 9]
29. Write a function showords() to open a text file "words.txt" and display the words which
have more than 5 letters. [3]
OR
Write a function to count the number of lines in a text file "players.txt".
6/12 1001CJA101021240045
zGn
Enthusiast Course/12-02-2025
30. (A) Write a function to push any student's information to stack. [3]
OR
(B) Write the definition of a user-defined function 'push_even(N)' which accepts a list of integers
in a parameter 'N' and pushes all those integers which are even from the list 'N' into a Stack
named 'EvenNumbers'.
Write function pop_even() to pop the topmost number from the stack and returns it. If the
stack is already empty, the function should display "Empty".
Write function Disp_even() to display all element of the stack without deleting them. If the
stack is empty, the function should display 'None'.
For example:
If the integers input into the list 'VALUES' are:
[10, 5, 8, 3, 12]
Then the stack 'EvenNumbers' should store:
[10, 8, 12]
31. (A) Find and write the output of the following Python code: [3]
def fun(s):
k=len(s)
m=" "
for i in rang(0,k):
if (s[i].isupper())|:
m=n+s[i].lower()
else s[i].isalpha():
m=m+s[i].upper()
else:
m=m+'bb'
print(m)
fun('school2@com' )
OR
(B) Predict the output of the following code:
line=[4,9,12,6,20]
for I in line:
for j in range(1,i%5):
print(j,’#’,end=””)
print()
1001CJA101021240045 7/12
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
SECTION–D
This section comprises of 4 long answer (LA) type questions of 4 marks each. [4 × 4 = 16]
32. Consider the table Teacher given below: [4]
Table : Teacher
T_ID NAME Age Department Date_of_join Salary Gender
1 Arunan 34 Computer Sc 2019-01-10 12000 M
2 Saman 31 History 2017-03-24 20000 F
3 Randeep 32 Mathematics 2020-12-12 30000 M
4 Samira 35 History 2018-07-01 40000 F
5 Raman 42 Mathematics 2021-09-05 25000 M
6 Shyam 50 History 2019-06-27 30000 M
7 Shiv 44 Computer Sc 2019-02-25 21000 M
8 Shalakha 33 Mathematics 2018-07-31 20000 F
Based on the table write SQL queries for the following :
(i) To display only names of teachers of "History" department.
(ii) To display the name, age and department of teachers whose name has "a" as the 2nd letter,
(iii) To increase the salary of Male teachers by 5% who are in "Computer Sc" department.
(iv) Display all Teacher in descending order by Name;
OR
(i) Give one difference between alternate key and candidate key.
(ii) Sartaj has created a 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:
• Username - root "
• Password - tiger
• Host - localhost
Sartaj, now wants to display the records of students whose fee is more than 5000. Help Sartaj
to write the program in Python.
8/12 1001CJA101021240045
zGn
Enthusiast Course/12-02-2025
33. Write a function in Python, Push (SItem) where , SItem is a dictionary containing the
details of stationary items- {Sname: price}.
The function should push the names of those items in the stack who have price greater than 75.
Also display the count of elements pushed into the stack.
For example:
If the dictionary contains the following data:
Ditem={"Pen":106,"Pencil":59,"Notebook":80,"Eraser":25}
The stack should contain
Notebook
Pen
The output should be:
The count of elements in the stack is 2 [4]
34. Write SQL queries for (i) to (iv) based on the table EMPLOYEE and DEPARTMENT given
below : [4]
Table : EMPLOYEE
EMPID NAME DOB DEPTID DESIG SALARY
120 Alisha 23-Jan-1978 D001 Manager 75,000
123 Nitin 10-Oct-1977 D002 AO 59,000
129 Navjot 12-Jul-1971 D003 Supervisor 40,000
130 Jimmy 30-Dec-1930 D004 Sales Rep
131 Faiz 06-Apr-1984 D001 Dep Manager 65,000
Table : DEPARTMENT
DEPTID DEPTNAME FLOORNO
D001 Personal 4
D002 Admin 10
D003 Production 1
D004 Sales 3
(i) To display the average salary of all employees, department wise.
(ii) To display name and respective department name of each employee whose salary is more
than 5000.
(iii) To display the name of employees whose salary not known, in alphabetical order.
(iv) To display DEPTID from the table EMPLOYEE without repetition.
1001CJA101021240045 9/12
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
OR
(i) Define the term Domain with respect to RDBMS. Give one example to support your answer.
[4]
(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:
• Username - root
• Password - tiger
• 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.
35. Rohit is a computer sciene student working on a program to add and search records from a csv file
stud.csv.
The file comprises of : Admno, Sname and Perc of students.
Where
(a) admno : Admission number integer
(b) sname : Student name String
(c) perc : Percentage float
Help him in coding the functions :
Addrecord() : To add data of 5 new students to the file
Searchrecords (adm) : To search a student whose admission number is given as parameter,
and display the record. [4]
10/12 1001CJA101021240045
zGn
Enthusiast Course/12-02-2025
SECTION–E
[5 × 2 = 10]
36. Surya is a manager working in a recruitment agency. He needs to manage the records of various
candidates. For this, he wants the following information of each candidate to be stored:
- Candidate_ID – integer
- Candidate_Name – string
- Designation – string
- Experience – float
You, as a programmer of the company, have been assigned to do this job for Surya.
(I) Write a function to input the data of a candidate and append it in a binary file.
(II) Write a function to update the data of candidates whose experience is more than 10 years and
change their designation to "Senior Manager".
(III) Write a function to read the data from the binary file and display the data of all those
candidates who are not "Senior Manager".
37. MakeInIndia Corporation, an Uttarakhand based IT training company, is planning to set up training
centres in various cities in next 2 years. Their first campus is coming up in Kashipur district. At
Kashipur campus, they are planning to have 3 different blocks for App development, Web
designing and Movie editing. Each block has number of computers, which are required to be
connected in a network for communication, data and resource sharing. As a network consultant of
this company, you have to suggest the best network related solutions for them for issues/problems
raised in question nos. (i) to (iv), keeping in mind the distances between various blocks/locations
and other given parameters.
Kashmir
App Campus
Develop- Movie
Editing
ment
Massoorie
Campus
Web
Designing
Distance between various blocks/locations : [5]
Block Distance
App development to Web designing 28 m
App development to Movie editing 55 m
Web designing to Movie editing 32m
Kashipur Campus to Mussoorie Campus 232 m
1001CJA101021240045 11/12
zGn
Target : JEE (Main + Advanced) 2025/12-02-2025
Number of computers
Block Number of computers
App development 75
Web designing 50
Movie editing 80
(i) Suggest the most appropriate block/location to house the SERVER in the Kashipur campus
(out of the 3 blocks) to get the best and effective connectivity. Justify the answer.
(ii) Suggest a device/software to be installed in the Kashipur Campus to take care of data
security.
(iii) Suggest the best wired medium and draw the cable layout (Block to Block) to economically
connect various blocks within the Kashipur campus.
(iv) Suggest the placement of the following devices with appropriate reason:
(a) Switch / Hub
(b) Repeater
(v) Suggest a protocol that shall be needed to provide video conferencing solution between
Kashipur Campus and Mussoorie Campus.
OR
What do you mean by Router, Gateway and Repeater?
12/12 1001CJA101021240045
zGn
