Class 10 CBSE Information Technology Question Bank - 100 Two Marks Questions

Class 10 Information Technology Question Bank

CBSE Information Technology (402) | 100 Important Questions | 2 Marks Each

Total Questions: 100 | Chapter Wise | 2 Marks Each

Solution:
A Style is a predefined collection of formatting properties used to apply consistent formatting to text, paragraphs, pages and other elements in a document.

Solution:
Styles provide uniform formatting and save time. If a style is modified, all elements using that style can be updated automatically.

Solution:
A Template is a pre-designed document containing formatting, styles and layout settings that can be reused to create new documents quickly.

Solution:
A Table of Contents provides a list of headings and subheadings in a document along with their page numbers, making navigation easier.

Solution:
A hyperlink is a clickable link that connects text or an object to another document, webpage, email address or location within the same document.

Solution:
A bookmark marks a specific location in a document so that the user can quickly return to that location.

Solution:
Mail Merge is a feature used to create multiple personalized documents such as letters, certificates and labels by combining a main document with a data source.

Solution:
The two main components are the Main Document and the Data Source. The main document contains common information while the data source contains variable information.

Solution:
A macro is a recorded or programmed sequence of commands that can be executed to automate repetitive tasks.

Solution:
Document automation means using software features such as styles, templates and macros to perform repetitive document-related tasks efficiently.

Solution:
A document contains actual information, while a template provides a predefined structure and formatting that can be used to create new documents.

Solution:
Headings organize information into sections and make a document easier to read, navigate and understand.

Solution:
A page style defines page-level formatting such as margins, page size, orientation, headers, footers and columns.

Solution:
A paragraph style is a predefined set of formatting properties applied to an entire paragraph, including alignment, spacing and font settings.

Solution:
Consistent styles give the document a professional appearance and make it easier to modify formatting throughout the document.

Solution:
A field is an automatically updated element that displays information such as page number, date, time or document properties.

Solution:
A header is an area at the top of a page used to display repeated information such as document title, school name or chapter name.

Solution:
A footer is an area at the bottom of a page used for repeated information such as page numbers, dates or document details.

Solution:
Mail Merge helps schools create personalized notices, certificates, letters and student documents for many students quickly.

Solution:
Two examples are personalized letters and certificates. It can also be used for labels, invitations and notices.

Solution:
A spreadsheet is an electronic worksheet used to store, organize, calculate and analyze data in rows and columns.

Solution:
A cell is the intersection of a row and a column in a spreadsheet. It is identified by a cell address such as A1.

Solution:
A formula is an expression used to perform calculations in a spreadsheet. It normally begins with an equal sign (=).

Solution:
A function is a predefined formula that performs a specific calculation, such as SUM, AVERAGE, MAX or MIN.

Solution:
The SUM function adds all numerical values in a selected range. Example: =SUM(A1:A10).

Solution:
The AVERAGE function calculates the arithmetic mean of selected numerical values.

Solution:
The MAX function returns the largest numerical value from a selected range of cells.

Solution:
The MIN function returns the smallest numerical value from a selected range.

Solution:
A relative cell reference changes automatically when a formula is copied to another cell. Example: A1.

Solution:
An absolute cell reference remains fixed when a formula is copied. It uses the dollar symbol, such as $A$1.

Solution:
A mixed reference fixes either the row or the column. Examples are $A1 and A$1.

Solution:
Sorting means arranging data in a particular order, such as ascending or descending order.

Solution:
Filtering displays only the rows that satisfy specified conditions while temporarily hiding other rows.

Solution:
A chart is a graphical representation of data that helps users understand comparisons, patterns and trends easily.

Solution:
Two common types are column charts and pie charts. Other examples include bar, line and area charts.

Solution:
Goal Seek is a spreadsheet tool that finds the input value required to achieve a specific result in a formula.

Solution:
A scenario is a set of alternative values used to analyze different possible outcomes of a spreadsheet model.

Solution:
Data validation controls the type of data that can be entered into a cell and helps prevent incorrect entries.

Solution:
A pivot table is a tool used to summarize, organize and analyze large amounts of data quickly.

Solution:
Spreadsheets can be used for marksheets, attendance records, fee calculations, result analysis and student data management.

Solution:
A database is an organized collection of related data that can be stored, accessed, managed and updated efficiently.

Solution:
DBMS stands for Database Management System. It is software used to create, store, manage and retrieve data from databases.

Solution:
A table stores related data in rows and columns. Each row represents a record and each column represents a field.

Solution:
A field is a column in a database table that stores a particular type of information, such as Name or Roll Number.

Solution:
A record is a complete row of related information in a database table.

Solution:
A primary key is a field or combination of fields that uniquely identifies each record in a table.

Solution:
A primary key prevents duplicate records and helps identify each record uniquely.

Solution:
A query is a request used to retrieve specific information from one or more database tables based on given conditions.

Solution:
A form provides a user-friendly interface for entering, editing and viewing records in a database.

Solution:
A report presents database information in a formatted and organized manner for viewing or printing.

Solution:
A relational database stores data in tables and establishes relationships between related tables using common fields.

Solution:
Data redundancy means unnecessary repetition of the same data in a database.

Solution:
Data integrity means maintaining the accuracy, consistency and reliability of data in a database.

Solution:
Sorting records means arranging database records according to a selected field in ascending or descending order.

Solution:
Filtering displays only those records that satisfy a specified condition while hiding other records.

Solution:
DBMS reduces data redundancy and provides efficient data retrieval. It also improves data security and consistency.

Solution:
LibreOffice Base is a database management application used to create and manage databases, tables, queries, forms and reports.

Solution:
A foreign key is a field in one table that refers to the primary key of another table and helps establish a relationship between them.

Solution:
Forms make data entry easier by providing a user-friendly interface for entering and modifying records.

Solution:
Reports organize database information into a readable format that can be viewed, analyzed or printed.

Solution:
A safe working environment is a workplace where hazards are identified and controlled to protect workers from accidents and injuries.

Solution:
An occupational hazard is a condition or activity at the workplace that may cause injury, illness or harm to workers.

Solution:
Ergonomics is the science of designing workplaces, tools and tasks according to the needs and capabilities of people.

Solution:
Proper posture reduces strain on the back, neck, shoulders and eyes and helps prevent discomfort during long computer use.

Solution:
Electrical safety means following precautions while using electrical equipment to prevent electric shocks, fires and other accidents.

Solution:
A fire hazard is any condition or material that can cause or increase the risk of fire in a workplace.

Solution:
Emergency exits must remain clear so people can leave the building quickly and safely during an emergency.

Solution:
First aid is the immediate basic assistance given to an injured or ill person before professional medical help is available.

Solution:
A fire extinguisher is used to control or extinguish a small fire during an emergency.

Solution:
Workplace hygiene means maintaining cleanliness and healthy practices at the workplace to prevent illness and maintain employee well-being.

Solution:
Proper ventilation provides fresh air, reduces heat and helps maintain a healthy and comfortable working environment.

Solution:
A workplace accident is an unexpected event occurring during work that may cause injury, damage or loss.

Solution:
An emergency evacuation plan provides instructions and routes for safely leaving a workplace during an emergency.

Solution:
Properly maintained wires reduce the risk of electric shocks, short circuits and fires.

Solution:
Keep electrical connections safe and avoid liquids near computers. Also maintain proper ventilation and keep emergency exits clear.

Solution:
Heavy objects should be stored safely to prevent them from falling and causing injuries or property damage.

Solution:
Personal Protective Equipment, or PPE, includes equipment worn to protect a person from workplace hazards.

Solution:
Cleanliness reduces the spread of germs, prevents accidents and creates a healthier and more productive workplace.

Solution:
The hazard should be reported to the responsible person immediately and, where safe, appropriate steps should be taken to prevent accidents.

Solution:
Safety training teaches workers how to identify hazards, use equipment correctly and respond properly to emergencies.

Solution:
Communication is the process of exchanging information, ideas, thoughts and feelings between two or more people.

Solution:
Verbal communication uses spoken or written words, while non-verbal communication uses gestures, facial expressions, posture and body language.

Solution:
Active listening means carefully paying attention to the speaker, understanding the message and responding appropriately.

Solution:
Feedback is the response given by the receiver to the sender. It helps determine whether the message was understood correctly.

Solution:
Self-management is the ability to control one's thoughts, emotions, time and actions to achieve personal and professional goals.

Solution:
Stress management involves using healthy methods to handle pressure and maintain emotional and physical well-being.

Solution:
Time management is the process of planning and organizing tasks so that available time is used effectively.

Solution:
An entrepreneur is a person who identifies an opportunity, takes calculated risks and organizes resources to start and manage a business.

Solution:
Entrepreneurship is the process of identifying business opportunities, developing ideas and organizing resources to create value.

Solution:
Risk-taking means accepting calculated uncertainty while starting or managing a business in order to achieve a possible benefit.

Solution:
A green economy promotes economic development while reducing environmental damage and using natural resources efficiently.

Solution:
Sustainable development means meeting present needs without reducing the ability of future generations to meet their needs.

Solution:
E-waste refers to discarded electronic devices and equipment such as computers, mobile phones, printers and electronic components.

Solution:
E-waste should be recycled to recover useful materials and reduce environmental pollution caused by hazardous electronic waste.

Solution:
ICT stands for Information and Communication Technology. It includes technologies used to create, store, process and communicate information.

Solution:
Computers and smartphones are examples of ICT tools. Other examples include the internet, email and video conferencing systems.

Solution:
A strong password is difficult to guess and generally contains a combination of letters, numbers and special characters.

Solution:
Cyber safety means using digital devices and online services responsibly while protecting personal information, accounts and devices.

Solution:
A digital footprint is the record of information and activities a person leaves behind while using the internet and digital services.

Solution:
Responsible use of technology protects privacy and security, prevents misuse and helps create a safe and productive digital environment.

Note:
यह Question Bank Class 10 CBSE Information Technology (402) के अभ्यास के लिए तैयार किया गया है। प्रत्येक प्रश्न 2 Marks का है। प्रश्न पर क्लिक करके उसका Solution देखा जा सकता है।

Solution:
Character style is applied to selected characters or words, while paragraph style is applied to an entire paragraph.

Solution:
Styles provide consistent formatting and make it easier to modify the appearance of many parts of a document at once.

Solution:
They organize a document into different levels of headings and help create a structured Table of Contents.

Solution:
A Table of Contents is an automatically generated list of headings and subheadings with their corresponding page numbers.

Solution:
After making changes to headings or page numbers, the Table of Contents can be updated using its update option.

Solution:
A custom style is a user-created style with specific formatting properties according to the requirements of a document.

Solution:
A page break forces the following content to start on a new page.

Solution:
A section is a part of a document that can have its own formatting, columns, headers, footers or page settings.

Solution:
Headers and footers display repeated information such as school name, document title, date and page number.

Solution:
A cross-reference is a link to another part of the same document, such as a heading, table, figure or bookmark.

Solution:
A bookmark saves a specific location so the user can quickly navigate back to that location.

Solution:
It is a clickable text or object that opens a specified webpage when selected.

Solution:
A data source contains variable information such as names, addresses and other details used during Mail Merge.

Solution:
The main document contains the common content and fields that will be combined with information from the data source.

Solution:
Mail Merge can be used to create personalized certificates and letters. It can also be used for labels and invitations.

Solution:
A template provides a ready-made structure and formatting that saves time when creating similar documents.

Solution:
Document protection restricts unauthorized users from editing or changing important document content.

Solution:
Automatic page numbering keeps page numbers consistent and updates them automatically when pages are added or removed.

Solution:
Formatting consistency means maintaining the same style, font, spacing and layout throughout related parts of a document.

Solution:
Templates reduce repeated formatting work and allow users to create professional documents quickly.

Solution:
A cell range is a group of selected cells. For example, A1:A10 represents cells from A1 through A10.

Solution:
A formula is created by the user using operators and references, whereas a function is a predefined calculation provided by the spreadsheet software.

Solution:
COUNT counts the number of cells containing numerical values in a selected range.

Solution:
COUNTA counts the number of non-empty cells in a selected range.

Solution:
The IF function checks a condition and returns one result if the condition is true and another result if it is false.

Solution:
Example: =IF(A1>=33;"Pass";"Fail"). It displays Pass when the value is 33 or more; otherwise it displays Fail.

Solution:
Conditional formatting automatically changes the appearance of cells when specified conditions are satisfied.

Solution:
It can highlight marks according to conditions, such as identifying low marks or high scores automatically.

Solution:
A named range is a user-defined name assigned to a cell or range of cells for easier reference in formulas.

Solution:
Data consolidation combines information from multiple ranges or sheets into a single summary.

Solution:
Goal Seek determines the input value needed to obtain a desired result from a formula.

Solution:
Scenario analysis compares different sets of input values to study possible outcomes of a problem.

Solution:
A spreadsheet model represents a real-world situation using data, formulas and calculations to analyze possible results.

Solution:
Absolute references keep a particular cell fixed when a formula is copied to other cells.

Solution:
A mixed reference fixes either the row or the column. Examples include $A1 and A$1.

Solution:
It means arranging data according to more than one field, such as sorting students first by class and then by name.

Solution:
AutoFilter allows users to display only the records that meet selected conditions in a data range.

Solution:
Charts present numerical data visually, making comparisons, trends and patterns easier to understand.

Solution:
A pie chart is useful for showing how different categories contribute to a whole.

Solution:
A line chart is useful for showing changes and trends in data over a period of time.

Solution:
A relational DBMS stores data in related tables and provides facilities to create, manage and retrieve that data.

Solution:
A database table is a structured collection of related records arranged in rows and fields arranged in columns.

Solution:
A primary key uniquely identifies each record and prevents duplicate values in the key field.

Solution:
No. A primary key must contain unique values so that every record can be identified separately.

Solution:
A foreign key is used to connect records between related tables by referring to a key in another table.

Solution:
Referential integrity ensures that relationships between related tables remain valid and consistent.

Solution:
A query condition specifies criteria that database records must satisfy to be included in the result.

Solution:
Query design is the process of selecting fields, tables and conditions to retrieve required information from a database.

Solution:
A form control is an interface element such as a text box, button or list box used to enter or display data.

Solution:
Forms provide a simple and organized interface that makes entering and editing records easier for users.

Solution:
Report formatting involves arranging database information with suitable headings, spacing, alignment and layout for clear presentation.

Solution:
Data validation checks whether entered information follows the required rules and data type.

Solution:
Data redundancy is the unnecessary duplication of the same information in a database.

Solution:
DBMS can organize data into related tables so that the same information does not need to be stored repeatedly.

Solution:
Database security protects stored information from unauthorized access, modification, loss or misuse.

Solution:
Data backup is the process of creating an additional copy of important data so it can be restored if the original is lost or damaged.

Solution:
Backup helps recover important information after accidental deletion, hardware failure or other data-loss events.

Solution:
A database relationship connects related records or tables using common fields.

Solution:
In a one-to-many relationship, one record in one table can be related to many records in another table.

Solution:
Databases are used in schools for student records and in banks for customer and transaction information.

Solution:
Workplace safety involves practices and precautions used to prevent accidents, injuries and health risks at work.

Solution:
A physical hazard is a workplace condition such as excessive noise, heat, poor lighting or unsafe equipment that may cause harm.

Solution:
An ergonomic hazard occurs when workplace design, posture or repetitive tasks place excessive strain on the body.

Solution:
Proper lighting reduces eye strain and glare and helps users work comfortably and safely.

Solution:
Proper monitor position helps maintain a comfortable viewing angle and reduces strain on the eyes and neck.

Solution:
Electrical overload occurs when too many devices draw more current from a circuit than it can safely handle.

Solution:
Damaged cables may cause electric shocks, short circuits or fires and should be replaced or repaired safely.

Solution:
An emergency is an unexpected situation that requires immediate action to protect people, property or the environment.

Solution:
Emergency drills help people practice correct procedures so they can respond quickly and safely during real emergencies.

Solution:
An evacuation route is a designated path used to safely leave a building during an emergency.

Solution:
Clearly marked exits help people quickly identify safe escape routes during emergencies.

Solution:
Fire prevention includes actions taken to reduce the possibility of fire, such as safe electrical practices and proper storage of materials.

Solution:
First-aid facilities provide immediate basic assistance to injured or ill workers before professional medical help arrives.

Solution:
Good housekeeping means keeping work areas clean, organized and free from unnecessary obstacles and hazards.

Solution:
Keeping the laboratory clean helps protect equipment, maintain proper ventilation and provide a healthier working environment.

Solution:
Preventive maintenance involves regular inspection and servicing of equipment to reduce the chances of failure.

Solution:
Regular maintenance improves equipment performance, increases its useful life and reduces the risk of accidents.

Solution:
A safety sign provides visual information about hazards, warnings, prohibitions or required safety actions.

Solution:
Following workplace rules reduces risks, prevents accidents and promotes a safe and organized working environment.

Solution:
The accident should be reported immediately to the responsible authority and appropriate first aid or emergency assistance should be provided.

Solution:
Effective communication means delivering information clearly and ensuring that the receiver understands the intended message.

Solution:
Communication barriers are factors that prevent or disturb the clear exchange of information, such as language problems, noise or misunderstanding.

Solution:
Clarity means presenting information in simple, precise and understandable language without unnecessary confusion.

Solution:
Body language communicates feelings and attitudes through posture, facial expressions, gestures and eye contact.

Solution:
Self-motivation is the ability to encourage oneself to work towards goals without depending entirely on external encouragement.

Solution:
Goal setting is the process of deciding specific objectives and planning actions to achieve them.

Solution:
SMART goals are Specific, Measurable, Achievable, Relevant and Time-bound goals.

Solution:
Decision-making is the process of selecting the most suitable option from available alternatives.

Solution:
Problem-solving is the process of identifying a problem, analyzing its causes and finding an appropriate solution.

Solution:
Digital literacy is the ability to use digital devices, applications and online resources effectively, safely and responsibly.

Solution:
Cyberbullying is the use of digital communication platforms to repeatedly harass, threaten or harm another person.

Solution:
Phishing is a fraudulent attempt to obtain sensitive information by pretending to be a trustworthy person or organization.

Solution:
Two-factor authentication adds an additional verification step to the password, improving account security.

Solution:
Protecting personal information reduces the risk of identity misuse, fraud, unauthorized access and privacy violations.

Solution:
Entrepreneurship development focuses on developing knowledge, skills and attitudes required to identify and pursue business opportunities.

Solution:
Innovation means introducing a new or improved idea, product, service or method that provides useful value.

Solution:
Resource conservation means using natural resources carefully and efficiently to reduce waste and protect them for the future.

Solution:
The 3R principle stands for Reduce, Reuse and Recycle. It helps reduce waste and conserve resources.

Solution:
Sustainable use of technology means using technology efficiently while reducing energy consumption, waste and environmental impact.

Solution:
Students can save electricity and water, reduce paper waste, reuse materials, recycle e-waste properly and spread environmental awareness.

Solution:
Formatting improves the appearance, readability and organization of a document.

Solution:
Text alignment determines how text is positioned between the left and right margins, such as left, right, centre or justified.

Solution:
Justified alignment adjusts spacing so that text is aligned evenly along both the left and right margins.

Solution:
Line spacing is the vertical distance between lines of text in a paragraph.

Solution:
Paragraph spacing is the amount of space provided before or after a paragraph.

Solution:
Indentation is the distance between the paragraph text and the page margin.

Solution:
A first-line indent moves only the first line of a paragraph inward from the margin.

Solution:
In a hanging indent, the first line starts at the margin while the remaining lines are indented.

Solution:
A bullet list presents items using symbols instead of numbers.

Solution:
A numbered list presents items in a sequential numerical or alphabetical order.

Solution:
A multilevel list organizes information into different levels or sub-levels using indentation and numbering.

Solution:
A table organizes information into rows and columns for easy presentation and comparison.

Solution:
Cell merging combines two or more adjacent cells into a single larger cell.

Solution:
Cell splitting divides one cell into two or more smaller cells.

Solution:
Text wrapping controls how text flows around an image or other object in a document.

Solution:
Images improve visual presentation and help explain information more effectively.

Solution:
An anchor determines how an image is associated with a page, paragraph, character or other document element.

Solution:
A caption is descriptive text added to an image, table or other object to explain its content.

Solution:
A watermark is faint text or an image placed in the background of a document.

Solution:
Watermarks can identify a document as confidential, draft, official or belonging to a particular organization.

Solution:
Page orientation determines whether a page is displayed in portrait or landscape mode.

Solution:
Portrait is taller than it is wide, while landscape is wider than it is tall.

Solution:
Margins are blank spaces around the edges of a document page.

Solution:
Page size specifies the dimensions of a document page, such as A4 or Letter.

Solution:
A style family is a group of related styles such as paragraph, character, page, frame and list styles.

Solution:
Changing one style can update all associated content, making large-scale formatting changes quick and consistent.

Solution:
Templates provide ready-made layouts for commonly used documents and reduce repetitive work.

Solution:
A document theme provides a coordinated set of visual elements such as fonts and formatting choices.

Solution:
Headings divide content into logical sections and make navigation, reading and automatic indexing easier.

Solution:
Automatic formatting applies predefined formatting rules to document content without requiring every change to be made manually.

Solution:
An index is an organized list of important terms or topics in a document with references to their locations.

Solution:
A footnote provides additional information or a reference at the bottom of a page.

Solution:
An endnote provides additional information or references at the end of a document or section.

Solution:
Spell checking identifies possible spelling errors and suggests corrections.

Solution:
AutoCorrect automatically corrects commonly typed spelling and formatting mistakes.

Solution:
Find and Replace searches for specified text and replaces it with another text throughout a document.

Solution:
It saves time when the same word or phrase needs to be changed at multiple locations.

Solution:
Print Preview shows how a document will appear when printed and helps identify layout errors before printing.

Solution:
Checking helps identify spelling, formatting, page-layout and content errors before producing the final printed copy.

Solution:
Document collaboration allows multiple users to review, edit or contribute to a document.

Solution:
A worksheet is a single working sheet in a spreadsheet file containing rows, columns and cells.

Solution:
A workbook is a spreadsheet file that can contain one or more worksheets.

Solution:
A cell address identifies the location of a cell using its column letter and row number, such as B5.

Solution:
The active cell is the currently selected cell in which data can be entered or edited.

Solution:
The formula bar displays the contents or formula of the currently selected cell and allows it to be edited.

Solution:
The Name Box displays the address of the active cell and can also be used to select a range.

Solution:
AutoFill automatically copies values, formulas or patterns into adjacent cells.

Solution:
A series is a sequence of values following a pattern, such as 1, 2, 3 or January, February, March.

Solution:
A relative reference changes its position when the formula is copied to another cell.

Solution:
An absolute reference remains fixed when a formula is copied. Example: $A$1.

Solution:
SUM adds the numerical values in a selected range.

Solution:
AVERAGE calculates the arithmetic mean of selected numerical values.

Solution:
COUNT counts cells containing numerical values.

Solution:
COUNTA counts all non-empty cells, including cells containing text or numbers.

Solution:
MAX returns the highest numerical value from the specified range.

Solution:
MIN returns the lowest numerical value from the specified range.

Solution:
IF tests a condition and returns different results depending on whether the condition is true or false.

Solution:
It highlights cells automatically according to specified conditions.

Solution:
Sorting arranges data in ascending, descending or another specified order.

Solution:
Filtering displays only the records that satisfy specified criteria.

Solution:
A database range is a structured range of data containing field names and records that can be sorted or filtered.

Solution:
A chart data range is the group of cells whose values are used to create a chart.

Solution:
A chart legend identifies the different data series represented in a chart.

Solution:
A chart title describes the subject or information represented by the chart.

Solution:
A data series is a set of related data values represented in a chart.

Solution:
A column chart represents data using vertical bars and is useful for comparing categories.

Solution:
A bar chart represents data using horizontal bars and is useful for comparing different categories.

Solution:
A line chart connects data points with lines and is useful for showing trends over time.

Solution:
A pie chart displays data as sectors of a circle to show parts of a whole.

Solution:
A scatter chart uses points to represent the relationship between two numerical variables.

Solution:
Goal Seek finds an input value required to produce a specified result in a formula.

Solution:
Scenario management stores different sets of input values so that alternative outcomes can be compared.

Solution:
A formula error occurs when a formula contains an invalid reference, operator, function or other incorrect expression.

Solution:
It indicates that a formula is attempting to divide a value by zero or an empty cell.

Solution:
Data validation restricts entries to acceptable values and helps maintain accurate data.

Solution:
A drop-down list allows users to select a value from a predefined list instead of typing it manually.

Solution:
It prevents invalid entries and helps maintain accurate and consistent student information.

Solution:
A pivot table summarizes large amounts of data and allows information to be analyzed from different perspectives.

Solution:
They can automatically calculate totals, percentages, averages, grades and rankings and help analyze student performance.

Solution:
Spreadsheets can be used for preparing marksheets and maintaining attendance records.

Solution:
DBMS is software used to create, store, organize, update and retrieve information from databases.

Solution:
A field is a column that represents a particular type of information in a database table.

Solution:
A record is a complete set of related field values representing one entity.

Solution:
A primary key uniquely identifies each record in a database table.

Solution:
A foreign key is a field that refers to a key in another table to establish a relationship.

Solution:
A candidate key is a field or set of fields that can uniquely identify records and can potentially be selected as the primary key.

Solution:
A composite key uses two or more fields together to uniquely identify a record.

Solution:
A query is a request for specific information from one or more database tables.

Solution:
A simple query retrieves selected information from a table using specified fields or conditions.

Solution:
Query sorting arranges the retrieved records according to a selected field.

Solution:
A form provides an easy interface for entering, viewing and modifying database records.

Solution:
A report presents selected database information in an organized format suitable for viewing or printing.

Solution:
A relationship connects related data in two or more tables using common fields.

Solution:
In a one-to-one relationship, one record in one table is associated with only one record in another table.

Solution:
In a many-to-many relationship, multiple records in one table can be associated with multiple records in another table.

Solution:
Data redundancy is the unnecessary repetition of the same data in multiple places.

Solution:
Data consistency means that the same information remains accurate and uniform wherever it is stored or used.

Solution:
Database integrity ensures that stored data remains accurate, valid and consistent.

Solution:
Database security protects sensitive information from unauthorized access, modification or deletion.

Solution:
Student information systems and banking systems are common examples of database applications.

Solution:
LibreOffice Base is an application used for creating and managing databases.

Solution:
A table wizard helps users create a database table using predefined steps and options.

Solution:
A query wizard guides users through selecting fields, conditions and sorting options to create a query.

Solution:
A form wizard helps create a database form step by step.

Solution:
A report wizard helps create formatted reports from database information.

Solution:
Queries allow users to retrieve only the required information from large amounts of stored data.

Solution:
A query criterion is a condition used to select specific records from a database.

Solution:
Ascending order arranges numbers from smallest to largest and text generally from A to Z.

Solution:
Descending order arranges numbers from largest to smallest and text generally from Z to A.

Solution:
Meaningful field names make a database easier to understand, maintain and use.

Solution:
A data type defines the kind of information that can be stored in a field, such as text, number or date.

Solution:
Data types ensure that appropriate values are stored and processed correctly.

Solution:
A text field stores character-based information such as names, addresses or descriptions.

Solution:
A numeric field stores numerical values that may be used in calculations.

Solution:
A date field stores calendar dates in an appropriate date format.

Solution:
A Boolean field stores one of two logical values, such as True/False or Yes/No.

Solution:
Duplicate records can cause incorrect calculations, confusion and unnecessary storage.

Solution:
Normalization organizes data into suitable related tables to reduce redundancy and improve consistency.

Solution:
Data retrieval is the process of obtaining required information from a stored database.

Solution:
DBMS helps organizations store, retrieve, update and analyze information efficiently while improving data management.

Solution:
A hazard is a source or condition that has the potential to cause harm, injury or damage.

Solution:
Risk is the possibility that a hazard may cause harm and the potential severity of that harm.

Solution:
Risk assessment is the process of identifying hazards, evaluating their risks and deciding suitable control measures.

Solution:
It helps identify dangers before accidents occur and allows suitable preventive measures to be implemented.

Solution:
Personal safety means taking appropriate precautions to protect oneself from workplace hazards and accidents.

Solution:
Workplace health refers to maintaining physical and mental well-being while performing work-related activities.

Solution:
Proper ventilation supplies fresh air and helps control heat, humidity and indoor pollutants.

Solution:
Proper seating supports good posture and reduces strain on the back, neck and shoulders.

Solution:
Repetitive strain is discomfort or injury that can result from performing the same physical movement repeatedly.

Solution:
It can be reduced through proper posture, suitable workstation arrangement, regular breaks and correct monitor positioning.

Solution:
An electrical hazard is a condition involving electricity that can cause shock, burns, fire or equipment damage.

Solution:
Overloading can cause overheating, short circuits and fires.

Solution:
Liquids can damage electronic components and may create electrical hazards.

Solution:
Fire safety includes precautions and procedures used to prevent fires and respond safely if a fire occurs.

Solution:
An emergency contact is a person or service that should be contacted quickly during an emergency.

Solution:
An emergency assembly point is a designated safe location where people gather after evacuating a building.

Solution:
It helps account for people and keeps them away from immediate danger after evacuation.

Solution:
A safety drill is a practice exercise that prepares people to respond correctly during emergencies.

Solution:
Visible instructions help people understand what to do quickly during an emergency.

Solution:
First-aid training teaches basic skills for responding to injuries or sudden illness until professional medical help is available.

Solution:
Clear walkways reduce the possibility of trips and falls and allow safe movement during emergencies.

Solution:
Housekeeping means maintaining cleanliness, order and safety in the workplace.

Solution:
Proper disposal prevents pollution, reduces hazards and keeps the workplace clean and safe.

Solution:
Workplace hygiene involves maintaining cleanliness and healthy practices to reduce illness and contamination.

Solution:
Clean drinking water helps maintain health, hydration and workplace well-being.

Solution:
Protective equipment is equipment designed to reduce exposure to workplace hazards and protect workers.

Solution:
Understanding safety signs helps workers recognize hazards and follow required precautions.

Solution:
Preventive safety focuses on identifying and controlling hazards before they cause accidents.

Solution:
Reporting accidents helps provide assistance, document incidents and prevent similar accidents in the future.

Solution:
An incident is an unexpected event that may cause harm or damage or could have resulted in an accident.

Solution:
Inspection helps identify faults or unsafe conditions before they cause accidents.

Solution:
Equipment maintenance involves regular checking, cleaning, servicing and repair of equipment.

Solution:
Documentation provides clear instructions and ensures that safety procedures can be followed consistently.

Solution:
An unsafe act is a person's action or behavior that can increase the possibility of an accident.

Solution:
An unsafe condition is a physical or environmental condition that may cause an accident or injury.

Solution:
Safety awareness helps people recognize hazards and take preventive actions.

Solution:
A safe work practice is a recommended method of performing a task while minimizing risk.

Solution:
Training teaches employees how to use equipment correctly, identify hazards and respond to emergencies.

Solution:
A safe workstation has suitable seating, proper monitor position, adequate lighting, organized cables and enough working space.

Solution:
Regular safety training and proper identification and control of workplace hazards can improve safety.

Solution:
Communication skill is the ability to clearly exchange information, ideas and feelings with others.

Solution:
Effective listening means paying attention, understanding the speaker's message and responding appropriately.

Solution:
Feedback helps determine whether communication was understood and provides an opportunity for improvement.

Solution:
Written communication uses written words to exchange information, such as emails, letters, notices and reports.

Solution:
Oral communication involves exchanging information through spoken words.

Solution:
Non-verbal communication conveys messages through gestures, facial expressions, posture and other body-language signals.

Solution:
Visual communication uses images, symbols, charts, diagrams and other visual elements to communicate information.

Solution:
Self-management is the ability to manage one's emotions, behavior, time and responsibilities effectively.

Solution:
Self-confidence is belief in one's abilities and capacity to perform tasks and face challenges.

Solution:
Stress is a physical or emotional response to demanding or challenging situations.

Solution:
Stress management involves healthy methods for handling pressure and maintaining balance and productivity.

Solution:
Time management is planning and organizing available time to complete tasks effectively.

Solution:
Prioritization means arranging tasks according to their importance and urgency.

Solution:
Goals provide direction, motivation and a clear target for improving performance.

Solution:
SMART stands for Specific, Measurable, Achievable, Relevant and Time-bound.

Solution:
Digital literacy is the ability to use digital technologies effectively, safely and responsibly.

Solution:
Cyber security involves protecting computers, networks, accounts and information from unauthorized access and digital threats.

Solution:
A strong password is difficult to guess and uses a suitable combination of letters, numbers and special characters.

Solution:
Sharing passwords can allow unauthorized people to access accounts and personal information.

Solution:
Phishing is an attempt to trick users into providing sensitive information by pretending to be a trusted source.

Solution:
Malware is malicious software designed to damage systems, disrupt operations or gain unauthorized access.

Solution:
Cyberbullying is harmful or threatening behavior carried out through digital communication platforms.

Solution:
A digital footprint is the information and record of activities a person leaves while using digital services and the internet.

Solution:
Online privacy means controlling and protecting personal information shared through websites, applications and digital services.

Solution:
Entrepreneurship is the process of identifying opportunities and organizing resources to create a useful product or service.

Solution:
An entrepreneur is a person who develops a business idea, organizes resources and takes calculated risks to create value.

Solution:
Innovation is the introduction of a new or improved idea, product, service or process.

Solution:
A calculated risk is a decision made after considering possible benefits, costs and consequences.

Solution:
Green skills are knowledge and abilities that help people protect the environment and use resources sustainably.

Solution:
Sustainable development meets present needs while protecting the ability of future generations to meet their needs.

Solution:
Renewable energy comes from sources that are naturally replenished, such as sunlight, wind and flowing water.

Solution:
Non-renewable energy comes from limited resources such as coal, petroleum and natural gas.

Solution:
E-waste is discarded electrical and electronic equipment and its components.

Solution:
Recycling e-waste helps recover useful materials and reduces environmental pollution.

Solution:
The 3R principle means Reduce, Reuse and Recycle. It helps minimize waste and conserve resources.

Solution:
Students can switch off unnecessary lights and devices and use electricity efficiently.

Solution:
Technology can reduce paper use, improve energy efficiency, support recycling and help monitor environmental conditions.

Solution:
Resource conservation means using natural resources carefully and efficiently to reduce waste and protect them for the future.

Solution:
Environmental awareness helps people understand environmental problems and encourages responsible actions to protect nature.

Solution:
Students can conserve water and energy, reduce waste, reuse materials, recycle responsibly and promote environmental awareness.

Class 10 CBSE Information Technology 402 - Database Management - 500 Three Marks Questions

Class 10 CBSE Information Technology (402)

Database Management System | 1000 Important Questions | 3 Marks Each | Session 2026-27

Total Questions: 1000 | Database Management | 3 Marks Each

Solution:
Data are raw facts or figures, while information is processed and meaningful data. For example, 75 is data; 'Ravi scored 75 marks' is information.

Solution:
Information is organized and interpreted so that it can support understanding and decision-making. Raw data may not provide a clear meaning by itself.

Solution:
Data consists of unprocessed facts, whereas information is processed data. Example: 85, 76, 90 are data; 'the average score is 83.67' is information.

Solution:
Organized data is easier to search, compare, update and analyze. It also reduces confusion and helps produce meaningful information.

Solution:
School databases store data such as student names, roll numbers, classes and marks. This data can be processed to produce useful information such as result lists and attendance reports.