CBSE Class 10 Information Technology – Solved PYQs 2022

CBSE Class 10 Information Technology – Solved PYQs 2022
By Pratap Sanjay Sir

Information Technology – Solved Paper PYQs - CBSE Board 2022

📥 Download Information Technology -PYQs 2022


CBSE Board 2022 — Complete solved paper (MCQs + Subjective answers)

SECTION A: Employability Skills (5 Marks)

  1. 1. Name the person who creatively combines factors to generate value for customers and create wealth.
    Answer: Entrepreneur
    Explanation: An entrepreneur creatively arranges factors of production to generate customer value and wealth.
  2. 2. Name the skill that helps someone lead, guide, and supervise people working in a business.
    Answer: Managerial Skill (Leadership Skill)
    Explanation: Managerial skill enables a person to lead, guide and oversee employees effectively.
  3. 3. Name any two elements of nature.
    Answer: Water and Air
    Explanation: Elements of nature include water, air, fire, earth and sky.
  4. 4. Give one method to promote sustainable development.
    Answer: Recycling
    Explanation: Recycling reduces waste and conserves resources, promoting sustainability.
  5. 5. Differentiate Agricultural Entrepreneurship and Small Scale Entrepreneurship in one point.
    Answer:
    1. Agricultural entrepreneurship involves agriculture-related activities such as farming and processing.
    2. Small scale entrepreneurship operates small manufacturing or service-related businesses.
  6. 6. Explain any one of 4Rs and 1U to contribute to a sustainable society.
    Answer: Reduce
    Explanation: Reduce means minimizing resource use and consumption to lessen environmental impact.

SECTION B: Subject-Specific Questions (12 Marks)

  1. 7. Name the organization that provides Internet access via dial-up, direct, or wireless connection.
    Answer: Internet Service Provider (ISP)
    Explanation: ISP provides Internet access services through different connection methods.
  2. 8. Name the software or hardware security device that analyzes network traffic to allow or block it.
    Answer: Firewall
    Explanation: A firewall monitors and controls incoming/outgoing traffic based on rules.
  3. 9. Name the immediate assistance given to an injured person to save life until medical help arrives.
    Answer: First Aid
    Explanation: First Aid prevents death or further injury until professional help arrives.
  4. 10. What is it called when primary key constraints are applied on one or more columns?
    Answer: Composite Key
    Explanation: A primary key made of two or more columns is a composite key.
  5. 11. What is the name of a row representing a single data item in a table?
    Answer: Record or Tuple
    Explanation: A record (tuple) is a single row containing related data items.
  6. 12. Explain the term Sorting.
    Answer: Sorting
    Explanation: Sorting arranges data in an order (ascending/descending) for easier search and analysis.
  7. 13. Write any four rules to create a strong password.
    Answer:
    1. Use uppercase and lowercase letters.
    2. Include numbers and special characters.
    3. Avoid easily guessable information (e.g., birthdays).
    4. Use at least 8 characters.
  8. 14. What is the special name for discussion-style sites used by non-technical/technical users to create personal web pages? Give two examples.
    Answer: Blogging Platforms or Discussion Forums
    Examples: WordPress, Blogger
  9. 15. Differentiate between LAN and WAN in two points.
    Answer:
    1. LAN (Local Area Network) covers a small geographical area like a home or office.
    2. WAN (Wide Area Network) covers large geographical areas, connecting multiple LANs.
  10. 16. Explain any two types of relationships that can be created between tables.
    Answer:
    1. One-to-One: Each record in Table A matches one record in Table B.
    2. One-to-Many: One record in Table A matches multiple records in Table B.
  11. 17. What is the difference between Form and Reports?
    Answer:
    1. Form: Used to enter or view data interactively.
    2. Report: A formatted, read-only view of data for presentation.
  12. 18. Identify any two column names and their data types from the PLAYER table.
    Answer:
    1. PID: Text / String (Player ID)
    2. RUNS: Integer (Number of runs scored)

SECTION C: Competency-Based Questions (8 Marks)

  1. 19. Aryan is worried because someone withdrew all money from his uncle's bank without giving ATM card. Answer the following:
    1. (a) Suggest a way to assure secure online transactions.
      Use Two-Factor Authentication (2FA) and transact only on secure sites (https).
    2. (b) Name the software needed to protect his computer from malware.
      Antivirus / Anti-malware software
    3. (c) Help him understand phishing.
      Phishing is a fraudulent attempt to obtain sensitive information by pretending to be a trustworthy source.
    4. (d) Explain how cookies can harm him.
      Cookies can track browsing habits and store personal info which may be misused if leaked.
  2. 20. Due to the pandemic, internet kept everyone connected.
    1. (a) What is World Wide Web? Name two web browsers.
      WWW is a system to access and share information using web pages over the Internet.
      Examples: Google Chrome, Mozilla Firefox
    2. (b) Explain how data is transferred over the internet.
      Data is broken into packets, sent using protocols (like TCP/IP), and reassembled at the destination.
  3. 21. Consider the STUDENT table below and write SQL commands:
    ADMNO NAME GRADE DOB MARKS HOUSE GENDER
    1001RUPAL910/04/200676GREENM
    1002RASHMI908/12/200587REDF
    1003ARNAV1025/05/200481GREENM
    1004SUMONA923/08/200568REDF
    1005ARUN916/07/200572GREENM
    1006TIA922/09/200591BLUEF
    1007ROSHAN1026/08/200489BLUEM
    SQL Commands: 
    -- (a) Display all students of Green House:
SELECT * FROM STUDENT WHERE HOUSE = 'GREEN';

-- (b) Increase marks by 5 for ADMNO 1005:
UPDATE STUDENT SET MARKS = MARKS + 5 WHERE ADMNO = 1005;

-- (c) Display all students with marks less than 80:
SELECT * FROM STUDENT WHERE MARKS < 80;

-- (d) Display all students in descending order by marks:
SELECT * FROM STUDENT ORDER BY MARKS DESC;

Definitions for Visually Impaired Students

(a) Database Management System (DBMS)
Answer: A software system that manages databases—enables creation, retrieval, update, and administration of data.
(b) Primary Key
Answer: A unique attribute or set of attributes that uniquely identify a record in a table.
(c) Numeric Data Type
Answer: Data types used to store numbers, such as integer, float, and decimal.
(d) Referential Integrity
Answer: A property ensuring relationships between tables remain consistent — foreign keys must match primary keys.
🔔 Subscribe to My Channel