CLASS X – INFORMATION TECHNOLOGY (402)
ANSWER KEY – SET 1
SECTION A (Objective)
Q1: i) c ii) b iii) c iv) b v) b vi) a
Q2: i) c ii) a iii) b iv) c v) a vi) b
Q3: i) c ii) c iii) c iv) a v) c vi) a
Q4: i) b ii) a iii) b iv) b v) c vi) c
Q5: i) b ii) b iii) a iv) b v) d vi) b
SECTION B (Subjective)
Q6. Disadvantages of visual communication:
• May be misunderstood.
• Needs tools and equipment.
• Not suitable for visually impaired persons.
• Cannot explain complex ideas fully.
Q7. Self-regulation helps independent working by:
• Managing time and behaviour.
• Staying focused.
• Completing tasks without help.
Q8. Four features of modern OS:
• Multitasking
• File management
• Security
• Device management
Q9. Advantages of entrepreneurship:
• Independence
• Higher earning opportunities
Q10. Steps for sustainable development:
• Use resources wisely
• Reduce pollution
• Recycle and reuse
• Protect forests
Q11. Steps to group objects:
• Select objects using Shift.
• Format → Group → Group.
Q12. Relative vs Absolute links:
Relative: files/[Link]
Absolute: [Link]
Q13. Storage sizes:
Small Integer: 2 bytes
Big Integer: 8 bytes
Q14. Ways to add sheet:
• Sheet → Insert Sheet
• Click + button
Q15. Workplace emergency:
A sudden harmful situation like fire, earthquake or accident.
Q16. Precautions:
• Keep exits clear
• Avoid overloading sockets
• Follow safety signs
• Keep floors dry
Q17. Mail Merge:
Data Source: Variable data file
Main Document: Fixed text file
Salutation in Step 4
Three steps: Main doc, data source, merge
Q18. Notes:
Scenarios: Compare outcomes
Goal Seek: Find required input
Solver: Optimizes results
Subtotal: Summarizes data
Q19. DBMS advantages:
• Reduces duplication
• Security
• Data sharing
• Consistency
Q20. SQL:
i) SELECT * FROM PRODUCT;
ii) SELECT * FROM PRODUCT WHERE Price > 500;
iii) SELECT P_name FROM PRODUCT WHERE P_id = 103;
iv) DELETE FROM PRODUCT WHERE P_id = 102;
Q21. Healthy living steps:
• Eat nutritious food
• Exercise
• Proper sleep
• Reduce stress