Karnataka 2nd PUC Question Paper 2025 Answer Key Information Technology

Government of Karnataka
Karnataka Secondary Education Examination Board

Question Paper
ANSWER KEY

KARNATAKA SCHOOL EXAMINATION AND ASSESSMENT BOARD
II PUC EXAM-1, MARCH 2025
SUBJECT: 61-INFORMATION TECHNOLOGY MODEL ANSWERS

Qn No. PART-A MARKS
I. Multiple Choice Questions 10X1=10
1 a. FTA 1
2 b. Registration 1
3 c. 4 1
4 b. Degree 1
5 c. ALTER 1
6 a. Alternate key 1
7 d. Notepad 1
8 c. NIC 1
9 d. Personal belongings 1
10 c. class ‘c’ material 1
PART-B
II. Answer any ten of the following questions 10x2=20
½
Step1:Login in to software by using administrator login and
password. ½
Step2: select administration > daily punches.
11 Step3: If the administrator requires to see the daily punches of ½ 2
the back date the needs change the date in the given menu.
Step4: the daily punch report can be exported in to excel format
from the given below ½

Step1:-login
Step2:select report>attendance reports>muster report
1
12 Step3: supply the data such as department, designation 2
1
Time and mode of the file in the respective field
Step4:click on submit get the muster report

1.document based enrolment ½
13 2.introducer based enrolment ½
3.head of family based enrolment ½
4.child enrolment below 5 years of age ½ 2
1.Multiple punches report
2.Absent report
½
3.Late report
½
4.Early report
½
5. Over time report
14 ½ 2
6. Tour report
7. single punch report
8. Employee leave report.
9. shift wise report.
(Consider any 4)
1. Hierarchical model ½
2. Network model ½
15 2
3. Entity relational model ½
4. Relational model ½

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(OS) MODEL ANSWERS

GRANT 1
16 2
REVOKE 1

1.Numeric data type
Ex:-> 12345, 15.5
2.string data type
Ex:-> prime name address 1
17
3. Date and time data type
Ex: 10/12/2025 12:54:01 1
(consider any 2)
2
1. MYSQL ½
2.MS-Access ½
18 2
3. Oracle ½
4. DB2 ½
1. Education and training. ½
2. Providing agricultural related information. ½
19 2
3.Dessaster management. ½
4. Office automation. ½
1. Offline 1
20 2
2. Online 1
Ergonomics: is the science concerned one with designing and
arranging things so that people can use them easily 1
and safely
21 2
purpose of ergonomic: applying one ergonomics can reduce
the potential for accidents injury to improve performance and 1
productivity
1.Air pollution is mostly caused by production of the dust
mixture of solid particles and gases in the surrounding air
2. extensive use of automobile vehicles in the campus can lead
22 1 2
to the air pollute the air.
3. ozone produce in the air can pollute the air
(Consider any two)
1
First aid kits should be quickly accessible to the employees it
should contain all the important items for first aid required to
23 2
deal with common problems such as cuts, burns headaches and
muscle cramp.
PART-C
III. Answer any six of the following questions 6x3=18
Step1:login into the software by using administrator login and
password
Step2: select report>attendance report> FILO report
24 3
Step3: supply the data in the respective fields such as
department sub-department, designation, time
Step4: click on submit button
1.Attendance resister ½
2.Advance report ½
3. Date wise attendance register ½
25 4.Customise attendance register ½ 3
5.weekly/monthly report ½
6.BAS report ½
7. BAS graphical report
1.check for eligibility 1
26 2. document required 1 3
3. online application process. Saturday. 1

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(OS) MODEL ANSWERS

Components of SQL
a) Data manipulation language(DML)
27 3
b)Data definition Language(DDL) 11
c) Data control language(DCL) 1

a) AFIS ½
b) IAFIS ½
C)NGI ½
28 d) IDENT ½ 3
e)HART ½
f)CODIS ½
g)NAFIS

1
SELECT statement is used to retrieve the data from the table
29 Syntax 1 3
Select * from Table_name
Select * from Emp_tab 1
a) Arch 1
30 b) loop 1 3
c) whorl 1
1.front end 1
31 2.back end 1 3
3.internet 1
a)trip and fall 1
32 b)slip and fall 1 3
c) Injuries caused due to escalators or elevator’s 1
1. adjust the brightness of computer screen to save your eyes 1
from strain
33 2. reposition the screen to avoid glare from lights or windows 1 3
3. keep a proper vision distance from computer screen and blink
your eyes in an interval. 1
PART-D
IV Answer any two of the following 2x6=12
False Acceptance Ratio (FAR) : The number of istances detected
over a sample data where a wrong person is authenticated.
False Rejection Ratio (FRR) : The number of istances detected
over a sample data where a right person is not authenticated FAR
and FRR are the parameters by which we can measure the
reliability of the biometric attendance system (BAS). FAR can be
computed by using a formula as below.
FAR = (NFA/NEIA) * 100 [%]
Where,
FAR = False Acceptance Rate
34 6
NFA= Number of False Acceptance
NEIA = Number of Enrollee Identification Attempt
For any good biometric system the FAR should be very low in the
range of 0.01 percent.
FRR can be computed by using a formula as given below.
FRR = (NFR/NEIA) * 100 [%]
Where,
FRR = False Rejection Rate
NFR= Number of False Rejection

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(OS) MODEL ANSWERS

NEIA = Number of Enrollee Identification Attempts
For any biometric attendance system FRR is low then the system
is more convinient to the user.

a. Data redundancy and inconsistency
1
b. Difficulty in accessing data
1
c. Isolation of data
35 1 6
d. integrity problem
1
e. Atomicity problem
1
f. concurrent access anomalies
1
components of basic cloud architecture are
1. A front end: consisting of the user’s device or computer 2
which is connected over network and accessing
data/application remotely. 2.
2
36 The back end: refers to the cloud itself. It contains all
group of networked computers, servers, storage devices
and other services that forms the cloud. 6
3. A network connection (internet):to connect the back- 2
end cloud when needed (on-demand).
1. Store all cleaning chemicals in tightly closed
containers in separate cupboards.
2. Throw rubbish daily.
3. Make sure all areas have proper lighting.
4. Do not wear loose clothing or jewellery when working
with machines.
5. Never distract the attention of people who are
working near a fire or with some machinery, tools or
equipment.
6. Where required, wear protective items, such as
goggles, safety glasses, masks, gloves, and hair
37 nets.
7. Shut down all machines before leaving for the day.
8. Do not play with electrical controls or switches.
9. Do not operate machines or equipment until you 6
have been properly trained and allowed to do so
by your supervisor.
10. Repair torn wires or broken plugs before using any
electrical equipment.
11. Do not use equipment if it smokes, sparks or looks
unsafe.
12. Cover all food with a lid, plastic wrap or aluminium foil.
[Consider any six of the above]

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(OS) MODEL ANSWERS

1
KARNATAKA SCHOOL EXAMINATION AND ASSESSMENT BOARD
II PUC EXAM-1, MARCH 2025
SUBJECT: 61-INFORMATION TECHNOLOGY (NS) MODEL ANSWERS

Qn No. PART-A MARKS
I. Multiple Choice Questions 10X1=10
1 b. Listening 1
2 d. Cntr +X 1
3 a. www.passportindia.gov.in 1
4 a. Verhoff algorithm 1
5 a. It shows all the column in the table 1
6 b. DISTINCT 1
7 c. Statement Both(A)and (B) 1
8 b. Fingerprint 1
9 b. 101 1
10 c. class ‘c’ material 1
PART-B
II. Answer any ten of the following questions 10x2=20
Stress is a state of feeling upset annoyed and hopeless is called
11 2
stress
1) Microsoft excel
2) Libre office 1
12 2
3) Google sheet 1
(consider any two)
Steps1:- Login in two the software by using administrator login and
1
13 password
1
Steps2:- select setup>Holiday master 2
EER:-It is the interest of FAR curve with FRR curve is called equal
error rate 1
14 2
FTA:-when the machine is unable to acquire the biometric data 1
then it is called as FTA(failed to acquire)
a) UIDAI: Unique Identification Authority of India 1
15 2
b) PSK: Passport Seva Kendra 1
½
Hierarchical model
½
Network model
16 ½ 2
Entity relational model
½
Relational model
1
ALTER
SYNTAX:
ALTER TABLE<TABLE_NAME> 1
ADD<COLUMN_NAME><DATA_TYPE>
17
[<SIZE>][<CONTRAINT>];
EXAMPLE
ALTER TABLE EMP_TAB
ADD PLACE VARCHAR(20) AFTER NAME; 1 2
SYNTAX:
SELECT * FROM TABLE NAME:
(OR) 1
18 SELECT COLUMN1, COLUMN2…. FROM TABLE NAME; 2
EXAMPLE:
SELECT * FROM EMP_TAB:
SELECT ROLLNO, NAME EMP_TAB;
IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(NS) MODEL ANSWERS

2
1
Offline 1
19 Online 2
1
Class ‘A’ materials:-materials such as wood ,cloth, paper 1
Class ‘B’ materials:- materials such as all liquid, grease and gas 1
20 2
materials that burns when exposed to ignition source

a) Trip and fall
b) Slip and fall 1
c) Lifts
21 2
d) Accident due to falling of goods
f) Accident due to moving abject 1
(consider any two)
❖ Hazard using computers ½
❖ Handling office equipment ½
❖ Handling objects ½
22 2
❖ Stress at work ½
❖ Working environment
[consider any 4answer each carry ½ marks ]
❖ Adjust the brightness of computer screen to save your eye 1
from strain
❖ Reposition the screen to avoid glare from lights or windows
23 ❖ Keep a paper vision distance from computer screen and 1 2
blink your eyes in an interval
❖ Wear anti-glare glasses while working in computer
(consider any two each carry 1 marks)
PART-C
III. Answer any six of the following questions 6x3=18
1.Service entrepreneurs
2.Business entrepreneurs
3. Industrial entrepreneurs ½
4. Agricultural entrepreneurs ½
5. Technical entrepreneurs ½
6. Non-technical entrepreneurs ½
24 7. Professional entrepreneurs ½ 3
8. IT- entrepreneurs ½
9. Women entrepreneurs
10. Social entrepreneurs
11. Family entrepreneurs
(consider any six each carries ½ marks )

1. Reuse scrap materials
2. Ensuring quality country
3. Waste exchange 1
25 4. Managing e-waste 1 3
5. Use of eco-friendly material 1
6. Reuse recycle
(consider any 3)
Step1: Login in to the software by using administrator login and 1
password
Step2: Select registration>off policy registration 1
26 Step3: Enter From date ,To date, Department, Sub Department, 3
Designation and type
Select appropriate off policy, such as Sunday and Fourth 1
Saturday.

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(NS) MODEL ANSWERS

3
1. attendance resister report
2. advance report
3. date wise attendance report ½
4. customised attendance report ½
27 3
5. Weekly/monthly report ½
6. BAS report ½
7. BAS graphical report ½
(consider any six each carries ½ marks) ½
1. Check for eligibility.
If a person wants to obtain a driving licence for motorcycle without
gear, then the applicant must be 16 years old and must have the 1
consent of guardian or parents. If one wish to obtain a driving
licence for motorcycle with gear then the applicant must be at least
18 years old
1
2. Documents required.
28 3
Following documents are required to obtain the driving licence.
Age proof – birth certificate / PAN card / Passport/ 10th class
mark sheet/ TC of school
3. Online application process
One can visit the nearest RTO website for the filling of online form.
One such website 1
❖ SQL is a relational database language, not a programming 1
language like C, C++, Java.
❖ It provides commands to create and modify tables, insert data into
tables, manipulate data in the tables etc. 1
❖ SQL is a non-procedural language since it describes what data to
29 3
retrieve, delete, or insert, rather than how to perform the
operation. 1
❖ As part of ensuring data security, SQL provides facility to add or
remove different types of access permissions to users on databases
or tables. [Consider any three of the above]
1.Confidentiality
½
2. Integrity
½
3. Availability
½
30 4. Secrecy 3
½
6. Denial of service attack
½
7. Sniff attack
½
8. Trojan horse
1.Capture 3
1
2.Extractor
31 1
3.Matcher
1
1) Arch
1
2) loop
32 1 3
3) whorl
1
1) First aid 1
33 2) Electrical safety 1 3
3) Evacuation 1
PART-D
IV Answer any two of the following 2x6=12

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(NS) MODEL ANSWERS

4
The hardware and software requirement for Aadhaar Seva Kendra is as
follows.
• Desktop/Laptop.
• Camera – 2Mega Pixel.
• Slap Scanner – ECMP.
• Single Finger print Device – UCL.
• IRIS Scanner.
• Printer.
• Scanner.
• Windows 7 or Windows 8 (32-bit and/or 64-bit editions).
• High-speed Bank Network Connectivity (for uninterrupted
connectivity during clientinst allation/enrolments/Updation).
• The enrolment station (Laptop/Desktop) should be pre-installed
with associated drivers for printer,
34 • Camera, scanner etc. 6
• Updated window O/S installed using windows live update.
• Anti-virus if any installed should be disabled while client
installation.
• 2 GHz,Dual core CPU or Later.
• 4GB RAM or higher.
• 160 GB HDD.
• Dedicated USB 2.0 port(Minimum 5 ports required) for use of
IRIS, Finger print scanner, Camera etc.
• Valid (alpha numeric/numeric) Bios Serial number.
The operator of the Aadhaar Seva Kendra must follow the following steps
before s/he actually start the enrollment process of the residents (to
whose card is to be generated).
• Operator must capture the GPS coordinates at start of
enrolments every day.
Consider any 12 answer each 1 marks
There are three types of components
Data definition language(DDL):-It deals with a schema(structure) 2
definition of the RDBMS the DDL commands are used to create, modify
and remove the data base object such as table views, and keys.
DDL commands are
a) CREATE
b)ALTER
c) DROP
d) TRUNCATE
Data manipulation language(DML)
35
DML commands are 2
a)UPDATE
b)DELETE
c)INSERT
6
d)SELECT
Data control language(DCL)
Is used to control access to the data base
DCL commands are 2
a) GRANT
b) REVOKE

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(NS) MODEL ANSWERS

5
components of basic cloud architecture are
1. A front end: consisting of the user’s device or computer 2
which is connected over network and accessing data/application
remotely. 2. The back end: refers
to the cloud itself. It contains all group of networked computers, 2 6
36
servers, storage devices and other services that forms the cloud.
3. A network connection (internet):to connect the back-end 2
cloud when needed (on-demand).

1. Store all cleaning chemicals in tightly closed
containers in separate cupboards.
2. Throw rubbish daily.
3. Make sure all areas have proper lighting.
4. Do not wear loose clothing or jewellery when working with
machines.
5. Never distract the attention of people who are working
near a fire or with some machinery, tools or equipment.
6. Where required, wear protective items, such as
goggles, safety glasses, masks, gloves, and hair nets.
7. Shut down all machines before leaving for the day.
37
8. Do not play with electrical controls or switches.
9. Do not operate machines or equipment until you
have been properly trained and allowed to do so by
your supervisor.
10. Repair torn wires or broken plugs before using any electrical 6
equipment.
11. Do not use equipment if it smokes, sparks or looks unsafe.
12. Cover all food with a lid, plastic wrap or aluminium foil.
13. Do not smoke in ‘No Smoking’ areas.
14. Report any unsafe condition or acts to your supervisor.
[Consider any six of the above]

IIPUC EXAM -1, MARCH 2025 KSEAB 61- IT(NS) MODEL ANSWERS

AglaSem Earn While You Learn Program!

Share your recent question papers with us and get paid!
अपने हाल के न प हम भेज और कमाएँ!

To participate, email us with the following details:
भाग लेने के लए हम न न ववरण के साथ ईमेल कर:

- Your Name
- Your Class
- Your Board
- Details of the Question Papers you have
आपके पास उपल ध न प का ववरण

Our team will reach out to you with the next steps.
हमार ट म आगे क या के लए आपसे संपक करे गी।

Email: support@

Study Materials
Notes

Model Papers Class 6 Notes

Sample Papers Class 7 Notes
Half Yearly Sample Papers Class 8 Notes

Class 9 Notes
Important Resources
Class 10 Notes
Periodic Table
Class 11 Notes
Writing Skills / Formats

Maps of India / World Class 12 Notes

Books and Solutions

NCERT Books
NCERT Book Solutions
HC Verma Chapter Wise Solutions
RD Sharma Solutions
CGBSE Solutions