CBSE Class 10 Question Paper 2026 Solution Information Technology

FOR CBSE CLASS 10 EXAM PREPARATION

CBSE Class 10 2026
Question Paper
Solution · Information
Technology
EXAM YEAR TYPE

CBSE Class 10 2026 Question Paper Solution
SUBJECT

Information Technology

Notes · Sample Papers · Previous Year Papers · Mock Tests

m
m .co

.co
Marking Scheme
Strictly Confidential
e m
m as
se l
(For Internal and Restricted use only)
Secondary School Examination, 2026
SUBJECT NAME: INFORMATION TECHNOLOGY ag
(SUBJECT CODE – 402) (PAPER CODE – 89)
General Instructions:-
1 You are aware that evaluation is the most important process in the actual and
correct assessment of the candidates. A small mistake in evaluation may lead to
serious problems which may affect the future of the candidates, education system
and teaching profession. To avoid mistakes, it is requested that before starting
m
.co
evaluation, you must read and understand the spot evaluation guidelines carefully.
m
2
m .co
“Evaluation policy is a confidential policy as it is related to the confidentiality
of the examinations conducted, evaluation done and several other aspects. It’s s e m
s e l a
a ag
leakage to public in any manner could lead to derailment of the examination
g l
system and affect the life and future of millions of candidates. Sharing this
a
policy/document to anyone, publishing in any magazine and printing in News
Paper/Website etc. may invite action under various rules of the Board and
IPC.”
3 Evaluation is to be done as per instructions provided in the Marking Scheme. It
should not be done according to one’s own interpretation or any other consideration.
Marking Scheme should be strictly adhered to and religiously followed. However,
while evaluating, answers which are based on latest information or knowledge
m
.co
and/or are innovative, they may be assessed for their correctness otherwise
and due marks be awarded to them. In Class-X, while evaluating competency-
e m
s
based questions, please try to understand given answer and even if reply is

la
not from marking scheme but correct competency is enumerated by the
g
candidate, due marks should be awarded.
a
4 The Marking scheme carries only suggested value points for the answers. These
are in the nature of Guidelines only and do not constitute the complete answer. The
students can have their own expression and if the expression is correct, the due
marks should be awarded accordingly.
5 The Head-Examiner must go through the first five answer books evaluated by each
evaluator on the first day, to ensure that evaluation has been carried out as per the
m
.co
instructions given in the Marking Scheme. If there is any variation, the same should
m
.co
be zero after deliberation and discussion. The remaining answer books meant for

m s em
evaluation shall be given only after ensuring that there is no significant variation in

s e the marking of individual evaluators.
g la
g la 6 Evaluators will mark (√) wherever answer is correct. Forawrong answer CROSS ‘X”
a will be marked. Evaluators will not put right (✓) while evaluating which gives an
impression that answer is correct and no marks are awarded. This is the most
common mistake which evaluators are committing.
7 If a question has parts, please award marks on the right-hand margin for each part
and underline it. Marks awarded for different parts of the question should then be
totalled up and written in the left-hand margin and encircled. This may be followed
strictly.
m .
8
.co
If a question does not have any parts, marks must be awarded in the left-hand
s e m
em a
margin and encircled. This may also be followed strictly.
s l
g la IT(402)/MS/2025-26/1
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 1 of 14

9 If a student has attempted an extra question, answer of the question deserving more
marks should be retained and the other answer scored out with a note “Extra
Question/Extra Attempt”.
10 No marks to be deducted for the cumulative effect of an error. It should be penalized
only once.
11 A full scale of marks __________ (example 0 to 80/70/60/50/40/30 marks as given in
Question Paper) has to be used. Please do not hesitate to award full marks if the
answer deserves it.
12 Every examiner has to necessarily do evaluation work for full working hours i.e., 8
hours every day and evaluate 20 answer books per day in main subjects and 25
answer books per day in other subjects (Details are given in Spot Guidelines).This is
in view of the reduced syllabus and number of questions in question paper.
13 Ensure that you do not make the following common types of errors committed by the
Examiner in the past: -
● Leaving answer or part thereof unassessed in an answer book.
● Giving more marks for an answer than assigned to it.
● Wrong totalling of marks awarded on an answer.
● Wrong transfer of marks from the inside pages of the answer book to the title
page.
● Wrong question wise totalling on the title page.
● Wrong totalling of marks of the two columns on the title page.
● Wrong grand total.
● Marks in words and figures not tallying/not same.
● Wrong transfer of marks from the answer book to online award list.
● Answers marked as correct, but marks not awarded. (Ensure that the right tick
mark is correctly and clearly indicated. It should merely be a line. Same is with
the X for incorrect answer.)
● Half or a part of answer marked correct and the rest as wrong, but no marks
awarded.
14 While evaluating the answer books if the answer is found to be totally incorrect, it
should be marked as cross (X) and awarded zero (0)Marks.
15 Any unassessed portion, non-carrying over of marks to the title page, or totalling
error detected by the candidate shall damage the prestige of all the personnel
engaged in the evaluation work as also of the Board. Hence, in order to uphold the
prestige of all concerned, it is again reiterated that the instructions be followed
meticulously and judiciously.
16 The Examiners should acquaint themselves with the guidelines given in the
“Guidelines for spot Evaluation” before starting the actual evaluation.
17 Every Examiner shall also ensure that all the answers are evaluated, marks carried
over to the title page, correctly totalled and written in figures and words.
18 The candidates are entitled to obtain photocopy of the Answer Book on request on
payment of the prescribed processing fee. All Examiners/Additional Head
Examiners/Head Examiners are once again reminded that they must ensure that
evaluation is carried out strictly as per value points for each answer as given in the
Marking Scheme.

IT(402)/MS/2025-26/2
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 14

m
m .co

m .co s e m
se MARKING SCHEME
g l a
a
Secondary School Examination, 2026
INFORMATION TECHNOLOGY (Subject Code–402)
[Paper Code: 89]
Max. Time: 2 Hours Max. Marks: 50
General Instructions:
(i) Please read the instructions carefully.
(ii) This question paper consists of 21 questions in two Sections: Section A and Section B.
m
m
(iii) Section A has Objective type questions, whereas Section B contains Subjective type questions.
.co
.co
(iv) Out of the given (5 + 16) = 21 questions, a candidate has to answer (5 + 10) = 15 questions in the
m s e m
e
allotted (maximum) time of 2 hours.
s l a
a ag
(v) All questions of a particular section must be attempted in the correct order.
g l
(vi) Section A: Objective Type Questions (24 marks):
a
(a) This section has 5 questions.
(b) There is no negative marking.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.
(vii) Section B: Subjective Type Questions (26 marks) :
(a) This section has 16 questions.
(b) A candidate has to do 10 questions.
(c) Do as per the instructions given.
m
.co
(d) Marks allotted are mentioned against each question/part.

e m
number 9 in General Instructions.
las
Note: If a child has attempted more number of questions than asked for, please refer to point

Q. ag
EXPECTED ANSWER / VALUE POINTS
Marks
No.
SECTION—A
(Objective Type Questions) (24 Marks)
1. Answer any 4 out of the given 6 questions on Employability Skills. 4×1=4
(i) Identify the imperative sentence: 1
Ans: (A) Shut the front door.

o m
c
(1 mark for correct answer)
o m m .
. cAns:
(ii) Breaking down big goals into smaller parts will make the goals
e
__________
s
. 1

e m (C) achievable l a
l as (1 mark for correct answer)
a g
ag (iii) Define the term 'Time Management'. 1
Ans: Time management is the ability to plan and control how you spend the hours
of your day well and do all that you want to do.
OR
Time management means planning and organizing your time properly so that you
can complete your work on time without stress.
OR
m .
.co m
Time management includes making a daily study timetable, giving more time to
s e
em a
difficult subjects, avoiding distractions like excessive mobile use, and finishing
s l
g la IT(402)/MS/2025-26/3
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 3 of 14

homework before deadlines.
(1 mark for correct/relevant answer)
(iv) What should a strong password consist of? 1
Ans: (D) Letters, numbers and special characters
(1 mark for correct answer)
(v) A misconception about an entrepreneur is: 1
Entrepreneurs are ____________ not ___________ .
Ans: born not made OR rich not poor
(1 mark for any correct answer)
(vi) Choose the option which is not a Sustainable Development Goal according to the 1
United Nations.
Ans: (A) Population
(1 mark for correct answer)
2. Answer any 5 out of the given 6 questions. 5×1=5
(i) Ramesh wants to apply a specific paragraph style to multiple non-contiguous 1
sections of his document. Which feature of LibreOffice Writer should he use to
avoid manually applying the style each time?
Ans: (B) Fill Format
(1 mark for correct answer)
(ii) While working with images in LibreOffice Writer, __________ acts as a reference 1
point for image or drawing.
Ans: (C) Anchoring
(1 mark for correct answer)
(iii) Which of the following style categories in LibreOffice Writer is used to 1
define layout elements such as margins, headers, and footers?
Ans: (B) Page Style
(1 mark for correct answer)
(iv) LibreOffice Writer supports up to __________ levels of headings. 1
Ans: (B) 10
(1 mark for correct answer)
(v) Which of the following image tools is used to change the image to black
1
and white, grayscale or a watermark?
Ans: (B) Image Mode
(1 mark for correct answer)
(vi) A _________ is a preset layout that helps to create professional and/or formal 1
documents easily.
Ans: (A) Template

(1 mark for correct answer)

IT(402)/MS/2025-26/4
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 14

m
m .co

m .co s e m
se 3. Answer any 5 out of the given 6 questions. g la 5×1=5
a
(i) Ravi is analysing monthly sales data in Calc. He wants to test how changing 1
the discount rate affects total revenue. Which feature should he use to
simulate different outcomes?
Ans: (C) What-if Scenarios
(1 mark for correct answer)

m
(ii) While reviewing a shared spreadsheet, Priya notices that some cells have been 1

m
modified, but she’s unsure who made the changes. Which feature should she
.co
.co
use to identify the editor?
s e m
s em l a
la ag
Ans: (B) Track Changes

a g (1 mark for correct answer)
(iii) Which of the following is the correct way to record a macro in LibreOffice 1
Calc?
Ans: (A) Tools → Macros → Record Macro
(1 mark for correct answer)
(iv) Which one of the following is the default function when a Consolidate 1
dialog box opens in LibreOffice Calc?

o m
Ans: (B) Sum
c
. answer)
m
eusers to suggest edits while
(1 mark for any correct
(v) Which Calc feature allows multiple
la s 1
preserving the original data? ag
Ans: (D) Insert Comments
(1 mark for correct answer)
(vi) In Calc, which of the following types of hyperlink uses the complete 1
location where the file to be linked is stored?
Ans: (A) Absolute hyperlink
m
.co
(1 mark for correct answer)
4. om any 5 out of the given 6 questions.
c. Answer e m
s
5×1=5
(i)m In a database, a form is _____________.
e l a
l as ag 1

ag
Ans: (B) an object with a user-friendly interface for data entry
(1 mark for correct answer)
(ii) Which of the following is an example of a DBMS? 1
Ans: (B) MySQL
(1 mark for correct answer)
(iii) While forming a relationship between two tables in LibreOffice Base, the 1
__________ of the common field must be ___________.
Ans: (B) data type, same
m .
c. o(1 mark for correct answer) s e m
s em l a
g la IT(402)/MS/2025-26/5
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 5 of 14

(iv) Which of the following advantages of DBMS ensures that changes in data 1
are reflected across all tables?
Ans: (C) Data Consistency
(1 mark for correct answer)
(v) Which of the following best explains the use of a query in LibreOffice Base? 1
Ans:
(B) To retrieve data from the database and display it in the desired format
(1 mark for correct answer)
(vi) In ___________ Data Model, the data is stored in the form of linked records, 1
organised into a tree-like structure.
Ans: (D) Hierarchical
(1 mark for correct answer)
5. Answer any 5 out of the given 6 questions. 5×1=5
(i) Arjun notices that his colleague frequently complains of neck pain and sore 1
shoulders after long working hours. Which of the following is the most likely
cause?
Ans: (B) Improper ergonomic setup
(1 mark for correct answer)
(ii) Which of the following types of fire extinguishers should not be used to 1
extinguish an electrical fire?
Ans: (B) Mechanical foam
(1 mark for correct answer)
(iii) Which of the following is the correct typing posture? 1
Ans:
(A) Fingers should be above the home position (asdf and jkl; keys) on the
keyboard, when your elbows are by your sides
(1 mark for correct answer)
(iv) A company mandates regular breaks, provides adjustable desks, and 1
encourages hydration for its employees. What is the primary objective of these
policies?
Ans: (C) To promote employees’ health and safety
(1 mark for correct answer)
(v) Which type of hazards are most common in the manufacturing and 1
pharmaceutical industries?
Ans: (B) Biological and chemical hazards

(1 mark for correct answer)

IT(402)/MS/2025-26/6
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 6 of 14

m
m .co

m .co s e m
se (vi) Materials a the following falls
are classified by risk of catching fire. Which lof
g 1
in the category of Class B materials? a
Ans: (C) Grease
(1 mark for correct answer)

SECTION - B:
(Subjective Type Questions)
Answer any 3 out of the given 5 questions on Employability Skills in 20 – 30 3x2 = 6
m
words.
m .co
6.
m .co
Write the 7 C’s of Communication. 2
s e m
Ans:
s e l a
l a
7 C’s of communication are:
ag
ag Clarity
(i) Clear/
(ii) Concise/Conciseness
(iii) Concrete/Concreteness
(iv) Correct/Correctness
(v) Coherent/Coherence
(vi) Complete/Completeness

m
(vii) Courteous/Courtesy

.co
(1 mark each for any two correct/relevant answer)
7. (a) What is emotional intelligence?
s em 1+1
(b) Name any two skills included inla
g
emotional intelligence.
Ans: a
(a) Emotional intelligence is the ability to identify and manage one’s own emotions
as well as the emotions of others.
OR
Emotional Intelligence is the ability to handle your feelings positively and
respecting the emotions of people around you.

(1 mark for any correct/relevant answer)
m
m
(b) Skills included in emotional intelligence are:
c. o  Emotional awareness m.co
m s e
s e  Managing emotions
g l a
g la  Harnessing emotions
a
a 

Self-Awareness
Motivation
 Empathy
 Social Skills etc.
(1/2 mark each for any two correct/relevant answer)
8. How do ICT skills help us in our day-to-day activities? 2
Ans:
m .
.co
ICT skills helps us to communicate, run our business and stay connected with our
family and friends.
e m
em
Every person needs to acquire ICT skills and build them to stay updated with the
l as
las IT(402)/MS/2025-26/7
ag
ag For more Question Papers, Sample Papers, Notes & Syllabus visit Page 7 of 14

latest software and applications.
OR
ICT skills help us in communication, Education and Learning, Online Services
(shopping, reservations, payments, banking etc.), Improve Work Efficiency and
find information easily.
(2 marks for any correct/relevant answer)
9. State the qualities to become a successful entrepreneur. 2
Ans:
Qualities to become a successful entrepreneur are:
 Confident
 Keep trying new idea
 Patience
 Creative/ Innovative
 Responsible
 Hardworking
 Problem solving
 Risk Taking
 Leadership Skills
 Decision Making etc.
(1 mark each for any two correct/relevant answer)
10. Define the term ‘Sustainable Development’. 2
Ans:
Sustainable development is the development that satisfies the need of the present
without compromising the capacity of future generations, guaranteeing the
balance between economic growth, care for the environment and social well-being.
OR
Sustainable development means using resources wisely today so that future
generations can also meet their needs.
OR
Sustainable development is development that supports economic progress without
harming natural resources for the future.
OR
Sustainable development means improving quality of life while conserving
resources for coming generations.
OR
Sustainable development is responsible development/consumption that maintains
environmental balance along with social and economic growth.
OR
Sustainable development means attaining any of the 17 SDGs (like No poverty,
Quality education etc.)
(2 marks for any correct/relevant answer)
Answer any 4 out of the given 6 questions in 20 – 30 words. 4x2 = 8

11. What is the significance of the Table of Contents feature in LibreOffice 2
Writer? Discuss briefly.
Ans:
Table of Contents, allows to insert an automated table of contents/index in a
document. The entries or contents of this table are automatically taken from the
IT(402)/MS/2025-26/8
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 8 of 14

m
m .co

m .co s em
se g
headings and sub headings of the document. Also, these contentsl a are hyperlinked
directly to the selected topic.
a
in the table. So by clicking on any topic in the table of contents, we can navigate

(2 mark for the correct/relevant answer)
OR
Significance of Table of Contents are:
 Easy Navigation – It helps readers quickly find different sections or topics in the
document.
 Saves Time – Users can directly click on headings to jump to a specific page.
m
m
 Professional Appearance – It gives the document a neat, structured, and formal
.co
look.
m .co s e m
e
 Automatic Updating – When headings or page numbers change, the TOC is
s l a
l a
updated automatically.
g
 Useful for Long Documents – Such as projects, reports, books etc. ag
a
(1/2 mark each for any two correct/relevant significance and 1 mark for writing
correct/relevant explanation)
12. Briefly explain the purpose of the Subtotal tool in the LibreOffice Calc 2
software.
Ans:
m
.co
The Subtotal tool in Calc creates the group automatically and applies common
functions like sum, average on the grouped data. One can use any type of
e m
s
summary function for each column as per the requirements of data analysis.

la
It can group subtotals by using category and sorts them in ascending or
g
a OR
descending order so that one need not to use filters.

Purpose of Subtotal in LibreOffice Calc is to calculate summary values (like sum,
average, count, etc.) for grouped data in a worksheet.
OR
Subtotals is a feature of LibreOffice Calc software to group the data and perform
functions (like sum, average, count, etc.) on the groups which help us to analyze data
m
.co
and saves time.

o m (2 mark for any correct/relevant answer)
m
c
13. . Give any two prerequisites before consolidating data in Calc.
s e
em Ans:
2
s g l a
g la Two prerequisites before consolidating data in Calc are: a
a  The corresponding data types should match in all sheets to be consolidated.
 All the tables used for consolidation should be consistent across all sheets.
 Match the labels from all the sheets which are used for consolidating.
 Enter the first column as the primary column on the basis of which the data is
to be consolidated.
(1 mark for any two correct/relevant answer)
14.
m
How are data and information different from each other? Explain with an 2
.
appropriate example.
c. o s e m
s em l a
g la IT(402)/MS/2025-26/9
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 9 of 14

Ans:
Data Information
Raw facts, unprocessed and Processed data that is meaningful and
meaningless on their own. useful.
For Example: For Example:
Marks obtained by students and their The report card/sheet is the
roll numbers are the data. information.

(1 mark for any relevant difference and 1 mark for any relevant example)
15. List two common causes of electrical accidents at the workplace. State any 2
one measure to prevent them.
Ans:
Common causes of electrical accidents at the workplace are:
 Exposed or worn-out wiring
 Overloading of electrical outlets
 Damaged or faulty electrical wires
 Faulty or poorly maintained electrical equipment
 Wet hands or working in damp conditions
 Lack of proper earthing (grounding)
 Using electrical appliances with loose connections
 Lack of safety precautions or negligence
 Using Substandard/ low-quality wires/ electrical Equipment
 Ignoring signage/ warning signs (like sparks, burning smell, or frequent
tripping of MCB etc.)
 Unauthorized repairs or untrained handling of electrical systems etc.

Preventive Measures:
 Electrical technicians and engineers should carry out routine inspections of all
wiring to make sure there are no damaged or broken wires
 Replace damaged or exposed wires immediately
 Ensure proper earthing (grounding) of all electrical equipment
 Install MCB for circuit protection
 Avoid overloading electrical sockets
 Switch off the main power supply before repair or maintenance work
 Do not handle electrical appliances with wet hands
 Use insulated gloves and proper safety tools while working
 Use ISI-marked and standard quality electrical equipment
 Provide safety training and awareness to employees
 Display warning signs near high-voltage areas etc.

( 1/2 mark each for any two correct/relevant causes and 1 mark for any one correct/
relevant preventive measure)
16. Briefly explain any two general emergency handling procedures at the 2
workplace.
Ans:
General emergency handling procedures at the workplace are :
 First Aid : Accessible supplies to treat minor injuries such as cuts, burns,
headaches and muscle cramps

IT(402)/MS/2025-26/10
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 10 of 14

m
m .co

m .co s em
se l
 Electrical Safety : Routine inspection of electrical devices
g a
a
 Evacuation : Safely leaving the premises during an emergency under guidance
 Employees must be provided instructions about electrical safety
 Keep a list of numbers to call during emergency
 Place fire alarms/ fire extinguishers at various locations
 Never place any objects near the emergency doors or windows
 Conduct regular mock drills
 Do not panic
 Do not spread rumours
m

m
If possible, assist the person with disability to move towards the exit
.co

.co
Do not use the escalators or elevators (lifts), use the stairs/ emergency exit
s e m
em a
instead
s l
ag

la
If required, call for an ambulance

ag (1 mark each for any two correct/relevant answer)
Answer any 3 out of the given 5 questions in 50 – 80 words. 3x4=12

17. You are designing a digital brochure for a school event in LibreOffice 2+2
Writer.
(a) Mention any four ways by which an image file stored on the
computer can be inserted into a document.
(b) How do the “Wrap Off” and “Wrap Through” text wrapping options
m
differ when placing images alongside text in Writer?
m .co
Ans:
s e
g l a can be inserted into a document by
(a) The image file stored on the computer,
following ways:
 Using Insert Image dialog
a
 Using Drag and Drop option
 Using Cut, Copy and Paste option
 By linking
 Using Gallery option
(1/2 mark each for any four correct/relevant answer)

m
.co
(b)
m
.co
Wrap Off Wrap Through

m
Text is placed above and below the
s em
Superimposes the image on the text.

s e image.
OR gl
a
g la OR
a
a It means no wrap or no change. The image floats over the text and hides
the text.

(2 marks for any correct/relevant answer)
18. Mr. Prasanna, a General Manager in a multinational company, has been given 4
two spreadsheets : an original billing file Bill.ods and a reviewed version of
the same spreadsheet Rev_Bill.ods. Both contain customer billing details

m
prepared by different teams. Write the steps he should follow to compare these
.
.co
worksheets and identify the differences between them.
s e m
s em l a
g la IT(402)/MS/2025-26/11
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 11 of 14

Ans:
1. Open the spreadsheet file Bill.ods.
2. Click on Edit → Track Changes → Compare Document
3. In the Compare to dialog window, select the spreadsheet file Rev_Bill.ods to be
compared. Click the Open button.
4. The Manage Changes dialog window will appear to accept or reject the
changes. After reviewing the changes, click the Close button to close the Manage
Changes dialog window.
(1 mark for each correct step)
19. With reference to DBMS, answer the following questions: 1+1+1+1
(a) What is the purpose of using reports in DBMS?
(b) Can we generate a report from multiple tables in a database?
(c) What is a dynamic report?
(d) In LibreOffice Base, to insert the current date and time in a report,
the steps to be followed are :
Step 1 : Click inside the Page Header area to activate it.
Step 2 : Click _____________ > ______________
However, the correct menu item and option names are missing.
Identify the correct menu item and option name needed to complete
this task.
Ans:
(a) A report is one of the useful features of a database management system to
present the retrieved data in an attractive and customized manner.
OR
Reports are used to present data in a well-organized/summarized,
formatted/uneditable, and printable form for analysis and decision-making.
(b) Yes
(c) A report in which, as the field values in the base table or query change, the
report also changes automatically.
OR
Any changes or updates made even after the report has been generated will be
reflected whenever the report is refreshed or reloaded.
(d) Insert, Date and Time.
(1 mark for correct/relevant answer of each part)
20. Answer the following questions in the context of Workplace Safety : 1+1+1+1
(a) Mention any two health hazards caused by a high contrast between the
computer screen and its surroundings.
(b) Suggest one way to avoid contrast problems caused by bright
light sources behind the display screen.
(c) How can poor sitting posture while using a computer, affect a
person’s health?
(d) Mention any one way to reduce stress at the workplace.

IT(402)/MS/2025-26/12
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 12 of 14

m
m .co

m .co s em
se Ans:
g la
a Vision, Headache,
(a) Eye Fatigue, Eye Strain, Dry Eyes, Watery Eyes, Blurred
Mental Fatigue, Stress, Burnout etc. (any two)
(b) Ways to avoid contrast problems are: (any one)
 Use blinds or drapes on windows to eliminate bright light
 Use well-distributed diffuse light
 Blinds and furniture placement should be adjusted to allow light into the

m
room, but not directly into your field of view

.co

m
Use indirect or shielded lighting where possible and avoid intense or

.co m
uneven lighting in your field of vision

m s e
a
Ensure that lamps have glare shields or shades to direct light away from
s e l
ag
your line of sight

g l a
Reorient the workstation so bright lights from open windows are at correct
a
angles with the computer screen
 Rearrange the desk or monitor at a proper distance from bright light
sources.
 Adjust screen brightness to match room lighting
 Attach an anti-glare filter/screen to reduce reflections on the monitor
(c) Pain, Strain, Headache, Muscle stiffness, Spinal problems, Wrist and Hand
Problems, Poor Blood Circulation etc. (any one)
m
.co
(d) Way to reduce stress are: (any one)
 Conflict resolution with colleagues
e m
 Relaxing hobbies for stress relief against long working hours
 Plan Your Work Properly
las
 Take Short Breaks
ag
 Maintain Healthy Communication
 Practice Deep Breathing or Meditation
 Avoid Overloading Yourself
 Maintain Work-Life Balance
 Exercise Regularly
 Keep a Positive Attitude
 Organize Your Workspace
m
.co
 Get Proper Sleep etc.
o m msuch
. c (1 mark for correct/relevant answer for each part)
s e
s em as mobile phones, laptops, etc., in a table named Gadgets,glawhich has
21. An electronic gadget shop keeps records of its electronic products, 1+1+1+1

g la columns for ItemID (Primary key), ItemType (mobile, aiPad, Laptop),
a
Size, Quantity, Price and Supplier.
It also stores the billing data in another table named Bill, which has
columns as BillNo (Primary key), ItemID, Price, CustName and
CustPhoneNo.
Based on the above, answer the following questions :

m
(a) Name any two columns of the Gadgets table where duplicate values are
.
allowed. .co s e m
s em l a
g la IT(402)/MS/2025-26/13
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 13 of 14

(b) Assume that the table Gadgets already contains a product having value of
ItemID as I001. Can we enter a new record with value of ItemID as I001 ?
Justify.
(c) Is it possible to store photos of the products in a new column of the table,
Gadgets ? If yes, then suggest a suitable data type to store images.
(d) Briefly explain the principle of referential integrity with respect to the
tables, Gadgets and Bill.
Ans:
(a) ItemType, Size, Quantity, Price, Supplier (any two)
(b) No, because ItemID is a primary key in Gadget table.
(c) Yes, BINARY/ LONGVARBINARY
(d) According to the principle of referential integrity, no unmatched foreign key
values should exist in the database. Therefore, if a record of any ItemID is
not present in the Gadgets table, then it should not be present in the Bill table.
OR
Referential integrity is a rule in a database that ensures data in related tables
remains consistent and valid.
OR
It means that a foreign key in one table must match a primary key in another table.
(1 mark for correct/relevant answer for each part)

***

P.T.O.

IT(402)/MS/2025-26/14
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 14 of 14