Karnataka 2nd PUC Question Paper 2026 Answer Key Computer Science

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)

KARNATAKA SCHOOL EXAMINATION AND ASSESSMENT BOARD, BENGALURU
2026 II PUC ANNUAL EXAM-1
SUBJECT: 41 COMPUTER SCIENCE (NS) SCHEME OF EVALUATION MAX.MARKS: 70

Q. No. PART-A Marks
Note : Answer all the questions. Each question carries one mark 20x1=20

1 Given Q = N/D, if D = 0 and N = 100, which built-in exception occurs?
a) Zero Division Error 1M
2 The function which returns an integer that specifies the current position of the
file-object in the file is
c) tell 1M
3 Assertion (A): A stack is a linear data structure that stores the elements in FIFO
order.
Reason (R): In stack a new element is added and removed from one end only.
d) (A) is false but (R) is true 1M
4 Which built-in function (method) is used to create an empty queue in Python?
b) list() 1M
5 In bubble sort while sorting in ascending order, which element reaches its correct
position after the first pass?
c) The largest element 1M
6 The term used to describe algorithm whose time complexity is n², typically caused
by nested loops is
c) Quadratic time algorithm 1M
7 The purpose of data constraint in database is
a) to ensure reliability 1M
8 What does the ORDER BY clause do in SQL?
a) Sorts rows based on column values 1M
9 Which data type is used to hold numbers with decimal points in MySQL?
a) FLOAT 1M
10 The prompt that indicates MySQL is ready to accept SQL statements is
b) mysql> 1M
11 The largest example of WAN is
c) Internet 1M
12 The network topology where data can be transmitted in only one direction is
b) Ring 1M

SCHEME OF EVALUATION Page 1 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
13 Example of full duplex communication mode is
d) Mobile 1M
14 The development of HTTP was led by
d) Tim Berners Lee 1M
15 The standalone programs that are capable of working on its own is
a) Worm 1M
Q. No. Marks
II Fill in the blanks choosing the appropriate word /words from those given in the
brackets:
16 Syntax errors are also known as parsing errors. 1M
17 To convert python objects for writing data to a binary file dump method is used 1M
18 Redundancy means same data are duplicated in different places. (files) 1M
19 Distinct clause is used along with select to avoid duplicate values in an SQL query. 1M
20 In SQL length function returns the number of characters in the specified string. 1M
PART-B
III Answer any FOUR questions. Each question carries two marks 4x2=8
21 What is prefix and postfix expression ?
The operators are written before the operands is called prefix expression 1M
The operators are written after the operands is called postfix expression. 1M
Any suitable definition (each carries 1 mark)
22 Write a python function to insert a new element at the end of queue. 2M
myqueue=list()
def enqueue(myqueue, element): 1M
myqueue.append(element) 1M
23 Mention any two applications of modified binary search.
a. Indexing in databases 2M
b. Implementing routing tables in routers
c. Data compression code
Any two applications each carry 1 mark
24 Given the relation Guardian write the degree and cardinality of the relation
GUID GName Gphone
4444 Amit 5711492685
11111 Bhutia 3612967082
46644 Sujata 3801923168
10101 Himanshu 4726309212
Degree= 3, Cardinality = 4 Each carry 1 mark 2M

SCHEME OF EVALUATION Page 2 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
25 Why is delete command used in SQL? Write its syntax.
Delete command is used to remove one or more record/rows/tuples from a table. 2M
Syntax : Delete from tablename ;
Or
Delete from tablename where condition;
Definition : 1 mark Syntax : 1 mark
26 What is the role of MODEM in computer network? 2M
a) Modem acts modulator and demodulator. 1M
The sending modem acts as modulator - converts digital data to analog signals.
b) The receiving modem acts as a demodulator- converts analog signals back to 1M
digital form.
27 Name any two wired media.
Twisted Pair Cable, Coaxial Cable, Optical Fiber Cable 2M
Any two cables, each carry 1 mark
Q. No. PART-C Marks
IV Answer any FOUR questions. Each question carries 3 marks 4x3=12
28 What is purpose of raise statement? Write its syntax and example.
The raise statement can be used to throw an exception. 1M
Syntax : raise exceptionname[(optional argument)] 1M
Example :raise Exception(“OOPs! Error Occurred”) any relevant example
1M
29 What is a file ? Explain any two file opening modes in python.
A file is a named location on a secondary storage media where data can be stored
permanently.
<r> - Opens the file in read-only mode.
<rb> - Opens the file in binary and read-only mode.
<r+> - Opens the file in both read and write mode.
<w> - Opens the file in write mode.
<wb+> - Opens the file in read, write and binary mode.
<a> - Opens the file in append mode. 3M
<a+> - Opens the file in append and read mode.
Definition. 1 mark Any two modes (2 marks)
30 Answer the following :
a) Define sorting
b) What is swapping?
c) How many passes are made by selection sort to sort ‘n’ elements ?
a) Sorting refers to the process of arranging elements in a specific order, either in 1M
ascending order or descending order. 1M
b) Swapping means changing the position of two elements with each other
c) n-1 1M

31 What is collision, collision resolution and perfect has function in hashing ?

SCHEME OF EVALUATION Page 3 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
1 When two elements map to the same slot in the hash table it is called collision.
2 The process of identifying a slot for the second and further items in the hash table in
the event of collision is called collision resolution.
3 A perfect hash function maps every input key to a unique index in the hash table.
Any suitable answer each carry 1 mark 3M

32 Describe database schema
i) Database schema is the design of database.
ii) It represents the structure (table names and their fields/columns)
iii) It is also called visual or logical architecture as it tells us how the data are
organized in a database.
Each carry 1 mark 3M

33 Differentiate between single and multi row function in SQL.
Single Row Functions Multi Row Functions
It operates on a single row at a time. It operates on groups of rows.
It returns one result per row. It returns one result for a group of rows.
It can be used in Select, Where and It can be used in the select clause only. 3M
Order by clause.
Math, String and Date functions are Max(), Min(), Avg(), Sum(), Count()
examples of single row functions and Count(*) are
examples of multiple row functions.
Any 3 difference each carry 1 mark
34 Explain MAC address
i) MAC stands for Media Access Control. It is also known as the physical or hardware
address.
ii) It is a unique value and assigned during manufacturing.
iii) It is a permanent address that cannot be changed. 3M
iv) It consists of 12 hexadecimal digits.
v) The first 6 digits represents manufacturer and the last six digit represents the serial
number
vi) Example DD:E4:A4:56:7A:F2
Any 3 points, each carry 1 mark
PART-D
V Answer any FOUR questions. Each question carries 5 marks 4x5=20
35 What is the ordering principle of stack? Explain different applications of stack in
programming.
The ordering principle of stack is LIFO. 1M
Applications of stack in programming are
i) When we need to reverse a string, then string is traversed from the last characters
till the first character using stack principle.
ii) To redo/undo editing of text/image stack is used to keep track of changes made.
iii) The history of browsed pages is maintained using stack.

SCHEME OF EVALUATION Page 4 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
iv) To handle matching of parenthesis.
Any 4 applications 4M
36 Define deque. Explain the operations on deque.

Deque is an arrangement in which addition and removal of element can happen from
any end.
Operations on Deque are
INSERTFRONT: This operation is used to insert a new element at the front of the deque.
INSERTREAR: This operation is the same as a normal queue, i.e. insert a new element
at the rear of the deque.
DELETIONFRONT: This operation is the same as normal queue, i.e. to remove an
element from the front of the deque.
DELETIONREAR: This operation is used to remove one element at a time from the
rear of the deque.
Definition. 1 mark operations each 1 mark 5M
37 Write an algorithm to search an element in a list using linear search technique.

Step 1: SET index = 0 1M
Step 2: while index < n, REPEAT Step 3 1M
Step 3: IF list[index]= key THEN
PRINT “Element fo und at position”, index+1 2M
STOP
ELSE
index = index+1 1M
Step 4: PRINT “Search unsuccessful”
38 Explain different types of keys in relational database.

a) Candidate key – A relation can have one or more attributes that takes distinct
values.
b) Primary key – The key used to uniquely identify the tuples in a relation.
c) Alternate key – The remaining attributes in the list of candidate keys.
d) Composite Primary Key - A Composite Primary Key is a primary key consists
of more than one attributes (columns).
e) Foreign key - A foreign key is used to represent the relationship between two
tables (relations).
Any suitable 5 points each carry 1 mark 5M

SCHEME OF EVALUATION Page 5 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
39 Write a note on LAN
a) A LAN connects devices like computers, phones, tablets and printers a limited area
such as a school, college, or university campus.
b) The connectivity is using wires or Wi-Fi.
c) Data transfers usually varies from10 Mbps to 1000 Mbps
d) LANs are relatively secure as only authorized users can access shared resources.
e) Users can print documents and upload or download files via the local server.
f) LANs support short-range, high-speed communication typically up to 1 km. 5M

Any relevant 5 points, each carry 1 mark

40 What are the properties of microwaves ?
i) Electromagnetic waves of frequency range 1GHz - 300GHz.
ii) Unidirectional, can move in only one direction.
iii) Cannot penetrate solid objects such as walls, hills or mountains.
iv) Needs line-of-sight propagation i.e. both communicating antenna must be in the direction
of each other.
v) Used in point-to-point communication or unicast communication such as radar and
satellite.
vi) Provide very large information-carrying capacity. 5M
Above any 5 points, each carry 1 mark

41 List some preventive measures against the malware.
 Install and Update Antivirus Software.
 Configure your browser security settings.
 Never use pirated on unlicensed software.
 Taking a regular backup of important data.
 Enforcing firewall protection in the network.
 Use Strong, Unique Passwords.
 Don’t enter personal or sensitive information when using a public.
 Scan any removable storage device with an antivirus software before transferring data to
and from it. 5M
 Never share your online account or banking password/pins with anyone.

Any relevant 5 points, each carry 1 mark
PART-E
VI Answer any TWO questions. Each question carries 5 marks 2x5=10

SCHEME OF EVALUATION Page 6 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
42 Write the process to sort the following elements using insertion sort method
80, 60, 20, 40, 50, 10

SCHEME OF EVALUATION Page 7 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)

5M

Any suitable method

43 The weights (in kg) of students in a class are : 54, 41, 44, 48, 50, 46, 46 use the given
weights to find
a) median b) mode c) standard deviation
a) Median : 46 1M
1M
b) Mode : 46
1M
Mean : 54+41+44+48+50+46/7 = 329/7= 47
c)
Weight (x) x-̅X (x-X̅ ) 2
54 54-47 = 7 49
41 41-47 = -6 36
44 44-47=-3 9
48 48-47= 1 1
50 50-47 = 3 9
46 46-47= -1 1
46 46-47 = -1 1
2M

∑(x-x)2 = 106
∑ (𝐱−𝐗)𝟐
Standard deviation = √
𝑛

= √𝟏𝟎𝟔
7

= √15.4 or 3.89
unit is optional

SCHEME OF EVALUATION Page 8 of 9

2026 II PUC EXAM – 1 KSEAB 41 COMPUTER SCIENCE (NS)
44 Write SQL commands for questions (a) to (e) based on data given in the
EMPLOYEE table :

ID NAME DOB DEPARTMENT SALARY

1111 AAAA 01-08-1998 ACCOUNTS 156780

2222 BBBB 12-12-2000 HR 199950

1010 CCCC 23-06-2000 SALES 140000

5456 ZZZZ 01-01-2002 PRODUCTION 250000

3486 LLLL 08-08-1998 HR 200000

a) Display information of all the employees in descending order of their SALARY.
b) Add a new column total_income.
c) Compute total_income as SALARY x 12
d) Display the count of various DEPARTMENT
e) Generate report of employees whose total_income is above 20 lakhs.
a) Select * from EMPLOYEE orderby SALARY desc;
b) Alter table EMPLOYEE add (total_income float(7, 2));
c) Update EMPLOYEE set total_income = SALARY x 12 ;
d) Select count(DEPARTMENT) from EMPLOYEE group by department;
Or
Select department, count(DEPARTMENT) from EMPLOYEE group by
department;
Or
Select department, count(*) from EMPLOYEE group by department;
Or
Select count(*) from EMPLOYEE group by department;
Or
Select department, count(*) from EMPLOYEE where department is
not null group by department;

e) Select * from EMPLOYEE where total_income>2000000;

Any appropriate answer ,each query carries 1 mark 1x5=5M

SCHEME OF EVALUATION Page 9 of 9