In this post, I am going to discuss Important PYQs Information Technology Class 10. If you are a class 10 student and preparing for the Information Technology Class 10 board exam, this post is written for you specially.
PYQs Information Technology Class 10 provides you with important questions for preparing for board exams. So let us begin with it!
Topics Covered
Important PYQs Information Technology Class 10
As per board exam structure and pattern your board question paper includes following types of questions:
Very Short Answer Type Questions (1 Mark) – (MCQs, Fill in the blanks, Ture/False, One word answer etc.)
Short Answer Type Questions (2 Mark) – (Definitions, Differences, Listing etc.)
Log Answer Type Questions (4 Marks)
So let us begin!
Part A Employability skills – 1 mark Important PYQs Information Technology Class 10
[1] _____________ is the ability to work independently. (a) Motivation
Ans.: (c) Self Reliance
Self-reliance is the ability to work independently without depending on others for guidance, support, or resources. It involves confidence in one’s own abilities, decision-making skills, and problem-solving capabilities.
A self-reliant person takes responsibility for their actions, completes tasks on their own, and finds solutions to challenges without constantly seeking help.
This quality is essential in both personal and professional life, as it enables individuals to be productive and self-sufficient.
Thus, self-reliance is the best choice for the ability to work independently.
[2] Identify the situation/thing which leads to mental stress amongchildren. (a) Stress due to change of Principal of school (b) Stress due to examination grades (c) Stress due to problem in friend’s family (d) Stress due to waking up in the morning
Explanation:
Among the given options, stress due to examination grades is the most common cause of mental stress in children.
Academic pressure and the fear of scoring low grades can create anxiety and stress.
Children may feel pressure from parents, teachers, or even themselves to perform well.
This stress can lead to emotional distress, lack of confidence, and even health issues like headaches or sleep disturbances.
Other options may cause minor stress, but exam-related stress is a widespread and significant concern for children’s mental well-being.
[3] ________________ is a type of operating system that runs on a set of computers that are interconnected by a network. (a) Multi-user
Explanation:
A distributed operating system is a type of OS that runs on multiple computers interconnected by a network. These computers work together as a single system to process tasks efficiently.
Key Features of a Distributed OS:
It manages multiple machines and makes them appear as a single system to users.
Resources (such as memory, processors, and storage) are shared across the network.
If one computer fails, others can take over its tasks, improving reliability and performance.
Thus, a distributed operating system is the correct answer!
[4] Which keys do you press to copy a file or a folder? (a) Ctrl + X
Ans.: (b) Ctrl + C
Explanation:
Ctrl + C is the shortcut key used to copy a file or folder. It creates a duplicate of the selected item without removing it from its original location.
After copying, you can use Ctrl + V to paste the copied file or folder in the desired location.
Other Options:
Ctrl + X → Cuts the file/folder (moves it instead of copying).
Ctrl + Z → Undo the last action.
Ctrl + Y → Redo an action that was undone.
Thus, Ctrl + C is the correct shortcut for copying files or folders.
[5] State whether the following statement is True or False : There is direct relationship between entrepreneurship and society.
Ans.: True
There is a direct relationship between entrepreneurship and society because entrepreneurs play a crucial role in shaping and developing society.
Job Creation: Entrepreneurs create employment opportunities, reducing unemployment and improving living standards.
Economic Growth: By starting new businesses, they contribute to the economy, increasing GDP and national income.
Innovation & Development: Entrepreneurs introduce new products, services, and technologies that improve people’s lives.
Social Change: Many entrepreneurs address social issues through their businesses, such as sustainable practices and community development.
[6] Which of the following is an example of entrepreneurship ? (a) A cook working in a restaurant (b) A mechanic who owns a garage for repairing vehicles (c) A doctor working in a hospital (d) A teacher teaching in a school
Ans.: (b) A mechanic who owns a garage for repairing vehicles
Entrepreneurship refers to the process of starting, managing, and running a business with the aim of making a profit. Entrepreneurs take risks, invest resources, and create value by offering products or services.
A mechanic who owns a garage is an entrepreneur because they run their own business, take financial risks, and manage operations independently.
The other options (cook, doctor, teacher) are employees working for someone else, not entrepreneurs.
[7] ____________ refers to focussing human efforts for maintaining a healthy body and mind, capable of withstanding stressful situations.
Stress management refers to focusing human efforts on maintaining a healthy body and mind, capable of withstanding stressful situations. It involves techniques and strategies to cope with stress effectively.
[8] Which of the following is not the benefit of stress management?
Stress management helps in improving efficiency rather than reducing it. Proper stress management techniques enhance focus, productivity, and overall well-being, making individuals more efficient in their tasks.
[9] _____________ are computer programs that can damage the data and software programs or steal the information stored on a computer.
Explanation:
A virus is a malicious software program (malware) that can infect, damage, or steal data from a computer. It can spread from one system to another through files, emails, USB drives, or the internet. Some viruses delete files, corrupt data, slow down system performance, or even give hackers control over a computer.
Other Options:
(a) Spam
Spam refers to unwanted or unsolicited messages, usually sent in bulk, often via email. These messages are typically advertisements, phishing attempts, or scams. While spam can be annoying and may sometimes lead to security risks (like phishing attacks), it does not directly damage data or steal information like a virus does.
(c) Junk Mail
Junk mail is another term for spam, especially in email services. These are irrelevant or unwanted emails sent to many recipients, usually for advertising purposes. While annoying, junk mail does not necessarily harm the computer or steal data unless it contains malicious links or attachments.
(d) BIOS (Basic Input/Output System)
BIOS is a firmware program that runs when a computer starts up. It is responsible for initializing hardware components (like the processor, RAM, and hard drive) and loading the operating system. BIOS is essential for a computer to function and is not a type of malware or threat.
[10] ______________ is a horizontal bar present at bottom of the Windows Desktop.
Ans.: (c) Task Bar
Explanation:
The taskbar is a horizontal bar present at the bottom of the Windows Desktop. It contains:
The Start button (to open the Start menu)
Quick launch icons
Open application windows (to switch between running programs)
The System Tray/Notification area (showing time, date, and system icons).
Other options:
(a) Status Bar – The status bar is a horizontal bar typically found at the bottom of application windows (such as MS Word, Excel, or web browsers). It displays information about the current status of the application, such as page number, zoom level, or cursor position.
(b) Menu Bar – The menu bar is usually located at the top of an application window and contains various menu options like File, Edit, View, Tools, Help, etc.
(d) Recycle Bin – The Recycle Bin is a desktop icon/folder where deleted files are temporarily stored. It is not a bar but a system folder that allows users to restore or permanently delete files.
[11] State whether the following statement is a myth or reality:
Ans.:
The statement “Entrepreneurs are born a certain way.” is a myth.
Reality:
Entrepreneurship is not an inborn trait; it is a skill that can be learned and developed. While some people may have natural leadership qualities or risk-taking tendencies, entrepreneurial skills such as problem-solving, decision-making, and innovation can be acquired through experience, education, and practice. Many successful entrepreneurs have developed their abilities over time through hard work, learning from failures, and adapting to challenges.
[12] Which one of the following is not true for entrepreneurs?
(a) They create needs and demands.
(b) They provide raw materials.
(c) They do not create jobs.
(d) They help society by supporting infrastructure development
Explanation:
Entrepreneurs create jobs by launching and expanding businesses. They hire employees, work with suppliers, and contribute to economic growth. Startups and businesses generate employment opportunities across various industries.
Other Options:
(a) They create needs and demands.
Entrepreneurs identify market gaps and introduce innovative products or services that create new needs and demands in the economy. For example, smartphones created a demand for mobile applications.
(b) They provide raw materials.
Entrepreneurs mainly focus on creating businesses and offering products/services rather than providing raw materials. However, some businesses (e.g., mining, agriculture) may supply raw materials.
(d) They help society by supporting infrastructure development.
Entrepreneurs contribute to infrastructure growth by investing in industries like construction, transportation, and technology. Their businesses also support local economies, increasing demand for better roads, utilities, and services.
[13] The filename and filename extension are separated by a _____________ . (A) Dollar ($)
Explanation:
The dot (.) is used to separate the filename and its extension.
Example: document.txt (where document is the filename and txt is the extension).
Other Options:
(A) Dollar ($):
The dollar sign ($) is not used to separate filenames and extensions. It is sometimes used in system variables, programming, or hidden system files (e.g., $RECYCLE.BIN in Windows).
(C) Underscore (_):
The underscore (_) is often used to replace spaces in filenames to improve readability.
Example: my_document.pdf (but it does NOT separate the filename from the extension).
(D) Hash (#):
The hash (#) is sometimes used in filenames, but it has no special role in separating filenames and extensions.
[14] Which of the following type of communication involves interchanging messages only through images or pictures? (A) Verbal
Explanation:
This involves conveying messages through images, pictures, symbols, or diagrams without using words.
Example: Traffic signs, infographics, charts, emojis, etc.
Other Options:
(A) Verbal:
This involves communication using spoken or written words.
Example: Talking, speeches, written text, etc.
(B) Gesture:
This refers to communication using hand movements, body language, or signs.
Example: Waving, thumbs-up, nodding, etc.
(D) Facial:
This involves expressing emotions and messages through facial expressions.
Example: Smiling to show happiness, frowning to show displeasure, etc.
[15] ___________ is the ability to identify and manage one’s own emotions, as well as the emotions of others. (A) Self-Awareness (B) Emotional Intelligence (C) Stress Management (D) Emotional Barrier
Explanation:
This is the ability to identify, understand, and manage one’s own emotions as well as the emotions of others. It includes self-awareness, self-regulation, motivation, empathy, and social skills. Example: A leader managing their team’s emotions during a crisis.
Other options:
(A) Self-Awareness:
This refers to recognizing and understanding one’s own emotions, strengths, and weaknesses.
It is a part of emotional intelligence but not the complete concept.
(C) Stress Management:
This refers to techniques and strategies used to control stress and maintain emotional balance.
Example: Meditation, deep breathing, time management, etc.
(D) Emotional Barrier:
This refers to obstacles in communication caused by emotions such as fear, anger, or anxiety.
Example: A person being too nervous to express their thoughts in a meeting.
[16] ___________ is the driving force that pushes us to achieve our goals,feel happy and improve our quality of life. (A) Stress Management (B) Self-Awareness (C) Self-Growth (D) Self-Motivation
Explanation:
This is the internal drive that pushes a person to achieve goals, stay positive, and improve their life.
Example: A student studying hard without external pressure to achieve good grades.
Other Options:
(A) Stress Management:
This refers to techniques used to handle stress and maintain emotional balance.
Example: Meditation, exercise, and time management.
(B) Self-Awareness:
This means understanding one’s emotions, strengths, weaknesses, and values.
Example: Recognizing what triggers stress or motivation in yourself.
(C) Self-Growth:
This refers to continuous learning and personal development to improve oneself.
Example: Learning new skills, setting personal development goals.
[17] Which of the following is not an essential quality to become a successful entrepreneur ? (A) Confidence (B) Creativity (C) Patience (D) Wealthy
Explanation:
Being rich is not a requirement to become a successful entrepreneur. Many successful entrepreneurs started with little money but had strong ideas and determination. Example: Steve Jobs, who started Apple in a garage with minimal resources.
Other Options:
(A) Confidence:
Entrepreneurs need confidence to take risks, make decisions, and lead their businesses.
Example: Believing in their ideas even when facing challenges.
(B) Creativity:
Creativity helps entrepreneurs come up with innovative ideas, solutions, and strategies.
Example: Developing unique products or marketing strategies.
(C) Patience:
Success in entrepreneurship takes time, effort, and persistence.
Example: Waiting for a startup to grow and generate profits.
[18] In total, how many SDGs were adopted by the United Nations in 2015 as a universal call to action to end poverty, protect the planet, and ensure that by 2030 all people enjoy peace and prosperity ? (A) 13
Climate Change – Sustainable development promotes the use of renewable energy and energy-efficient practices, reducing greenhouse gas emissions.
Deforestation – Sustainable development encourages afforestation, reforestation, and responsible use of natural resources to protect forests and biodiversity.
Ans.: An advantage of using solar power is that it is a renewable and eco-friendly energy source that reduces reliance on fossil fuels, lowers electricity bills, and decreases carbon emissions, helping to combat climate change.
Part A Employability skills – 2 marks Important PYQs Information Technology Class 10
[1] Explain any two benefits of stress management.
Improved Physical Health – Effective stress management reduces the risk of health issues like high blood pressure, heart disease, and weakened immunity.
Better Mental Well-being – Managing stress helps reduce anxiety, enhances focus, and promotes emotional stability, leading to a more balanced and positive mindset.
[2] What is the difference between yoga and meditation?
Aspect
Yoga
Meditation
Definition
A physical, mental, and spiritual practice that includes postures (asanas), breathing exercises (pranayama), and meditation.
A practice that focuses on mindfulness, awareness, and mental relaxation, often involving deep concentration and breathing techniques.
Focus
Improves flexibility, strength, and overall well-being through physical movements and breathing.
Enhances mental clarity, emotional balance, and relaxation by training the mind.
Techniques Used
Involves body postures, breathing exercises, and sometimes meditation.
Primarily focuses on mindfulness, concentration, and deep breathing.
Goal
Promotes overall physical and mental health, including fitness and stress relief.
Aims to achieve inner peace, mental stability, and self-awareness.
[3] What is an operating system ? Give two examples.
Ans.: An Operating System (OS) is system software that manages computer hardware and software resources and provides essential services for computer programs. It acts as an interface between the user and the computer hardware.
Examples of Operating Systems:
Windows – Developed by Microsoft, commonly used in personal computers.
Linux – An open-source operating system widely used in servers and development environments.
[5] Give any two misconceptions about an entrepreneur.
[6] What is self-awareness ? Also give any two benefits of self-awareness.
[7] Give one example each of following stress causal agents for students :
(a) Mental
(b) Social
[8] Differentiate between files and folders.
[9] Give any two qualities of a successful entrepreneur.
[10] Give any two promotional functions Of an entrepreneur.
[11] How can cultural differences be a barrier to effective communication ?
[12] Explain any two misconceptions about entrepreneurship.
[13] Briefly discuss the significance of time management skills in order to succeed in life.
[14] Very often we hear about spam mails. Explain what are spam mails, and what should be done with such mails.
[15] Mention any two ways to get clean and affordable energy.
[16] Differentiate between Agricultural Entrepreneurship and Small Scale Entrepreneurship with one point only.
[17] In our daily life we can contribute to create a Sustainable Society by following 4Rs’ and IU of Sustainability. Explain any one term out of 4Rs’ and 1 U.
[18] Explain any two roles of entrepreneurs.
[19] List any two challenges to fulfil Sustainable Development Goals.
Part B Subject Specific skills – 1 mark Important PYQs Information Technology Class 10
[1] _________________ includes margins, headers and footers, borders and backgrounds. (a) Character Style
Ans.: (b) Page Style
Explanation:
Page Style is used to define the formatting of an entire page, including:
Margins (space around the text)
Headers and Footers (text or elements at the top and bottom of the page)
Borders (lines around the page)
Backgrounds (colors or images behind the text)
Other Options:
Character Style → Applies formatting to individual characters (e.g., font, bold, italic).
Numbering Style → Used for numbered or bulleted lists.
Frame Style → Used for formatting frames that contain text or images.
[2] Pushkar has created a drawing using multiple shapes that are arranged in a particular position and manner in his document. Suggest a feature that can be used to let the objects remain set as a collection. (a) Transparency
Ans.: (c) Grouping drawing objects
Explanation:
Grouping drawing objects allows multiple shapes or objects to be treated as a single unit. This helps in maintaining their relative positions and arrangements when moving, resizing, or formatting them together.
Other Options:
Transparency → Adjusts the visibility of an object by making it partially see-through.
Posterize → Reduces the number of colors in an image to create a stylized effect.
Ordering drawing objects → Changes the stacking order of objects (e.g., bringing an object forward or sending it backward).
[3] Mehul has inserted images in his document report “Travel MyState” to make it more descriptive. Some of the images are having some extra part that needs to be removed. Which of the following option is suitable to do the task? (a) Resize
Explanation:
Cropping is the process of removing unwanted parts of an image while keeping the necessary portion. This helps in improving the composition and focusing on the important areas of the image.
Other Options:
Resize → Changes the dimensions (height & width) of an image but does not remove any parts.
Recolor → Changes the color effects of an image (e.g., grayscale, sepia).
Rotate → Turns the image in different directions (90°, 180°, etc.).
[4] Suresh has been assigned a task to create multiple documents such that the first page of every document contains the and logo in a particular style. Which feature of word processor can be used to complete the task quickly? (a) Cell styles
Explanation:
A template in a word processor is a pre-designed document that contains formatting, styles, and elements (like logos) already set up. Suresh can create a template with the required logo and style on the first page. Then, every time he creates a new document from the template, the logo and style will automatically appear, saving time.
Other Options:
Cell styles → Used in spreadsheets to format individual cells, not applicable for logos in documents.
Image → You can insert an image manually, but using a template is a more efficient solution for repeating tasks.
Table of Contents → Automatically generates a table of contents based on headings but not related to setting up a document with a logo.
[5] Writer’s ___________ feature let you build an automated index from the headings in your document. (a) Header
Explanation:
The Table of Contents (TOC) feature in a word processor lets you automatically generate an index based on the headings in your document. When you apply heading styles (like Heading 1, Heading 2) to different sections, the TOC will pull those headings and organize them into a structured list, making it easy to navigate through the document.
Other Options:
Header → Refers to the top section of a document, typically used for titles or page numbers.
Styles → Defines formatting rules for headings, text, and other elements but doesn’t generate an index automatically.
Template → Provides a pre-designed structure for documents but is not used for creating an index.
[6] To protect the table of contents from being changed accidentally, check the ________ check box. (a) Protected against manual changes (b) Allow only manual changes (c) Manual changes (d) Password
Ans.:(a) Protected against manual changes
Explanatio
The “Protected against manual changes” checkbox ensures that the table of contents (TOC) is locked and cannot be altered by accidental or unauthorized manual editing. This protects the TOC from unintended changes while still allowing it to be updated automatically based on changes to headings in the document.
Other Options:
Allow only manual changes → Allows manual changes, which could defeat the purpose of protecting the TOC.
Manual changes → This is not a valid option related to protecting the TOC.
Password → A password can be used to protect the entire document, but the specific option to protect the TOC is through the “protected against manual changes” checkbox.
[7] A statistical formula can be applied to a selected array of cells using _______________. (a) Consolidate
Explanation:
AutoSum is a feature in spreadsheet applications like Microsoft Excel that allows users to quickly apply statistical formulas (such as SUM, AVERAGE, COUNT, MAX, and MIN) to a selected array of cells. It automatically detects the range and applies the chosen function.
[8] Which of the following term refers to a cell or range of cells that canbe used in a formula ?
Explanation:
A cell reference refers to a single cell or a range of cells that can be used in a formula. It tells Excel (or any spreadsheet software) where to find the values or data that should be used in calculations.
For example:
=A1+B1 → Here, A1 and B1 are cell references.
=SUM(A1:A10) → The range A1:A10 is a cell reference.
Other options:
(b) Cell Formula → Incorrect, as a formula is an expression used to calculate values.
(c) Formula Reference → Incorrect, as it’s not a standard term.
(d) Linked Cells → Incorrect, as linked cells refer to cells that get values from another sheet or workbook.
[9] How many sheets are provided by default in spreadsheets in a workbook?
Ans.: By default, the number of sheets in a new workbook in LibreOffice Calc and OpenOffice Calc is:
LibreOffice Calc → 1 sheet (since version 4.2, earlier versions had 3 sheets by default)
OpenOffice Calc → 3 sheets
Explanation:
In LibreOffice Calc, the default number of sheets was changed from 3 to 1 in version 4.2 to reduce memory usage. However, users can manually add more sheets as needed.
In Apache OpenOffice Calc, the default is 3 sheets, but this can be modified in settings.
You can change the default number of sheets in both applications through:
Tools → Options → LibreOffice Calc/OpenOffice Calc → Defaults → Number of sheets
[10] Give an example of statistical function in Calc.
Ans.:
AVERAGE(range) → The AVERAGE() function calculates the mean (average) of a range of numbers.
SUM(range) → Adds up values
COUNT(range) → Counts numerical values
MAX(range) → Finds the highest value
MIN(range) → Finds the lowest value
STDEV(range) → Calculates the standard deviation
[11] Record changes feature of Calc marks a deleted column or row in a worksheet by a ________________. (a) red border over the cell
Explanation:
In LibreOffice Calc, the Record Changes feature tracks modifications made to a worksheet. When a row or column is deleted, Calc marks the change with a heavy colored bar on the edge of the sheet to indicate the removal.
Inserted cells → Marked with a colored border.
Deleted rows/columns → Indicated with a heavy colored bar at the edge.
Edited cells → Highlighted with a colored border and annotation.
This feature is useful for tracking modifications in collaborative work. You can enable it by going to:
Edit → Track Changes → Record
[12] A _____________ is a database object that provides a systematic way to accept data from the user and store it in a table of a database. (a) Query
Explanation:
A form is a database object designed to accept data from the user and store it in a table. It provides a user-friendly interface for entering, modifying, and viewing data while ensuring validation and accuracy.
Other Options:
(a) Query
A query is used to retrieve, filter, and manipulate data from one or more tables in a database. It does not directly accept data input from the user but helps in fetching specific information based on conditions.
(c) Report
A report is used to display and format data in a structured way for printing or viewing purposes. It does not accept data input but presents existing data in an organized format for analysis.
(d) Table
A table is a fundamental database object where data is stored in rows and columns. While it holds data, it does not directly provide a user-friendly way to accept data input from users.
[13] Primary Keys are also _____________ in the database, making it faster for the database to search for a record. (a) indexed
Explanation:
In a database, Primary Keys are indexed to improve search performance. Indexing allows the database to quickly locate records based on the primary key without scanning the entire table.
Primary Key → A unique identifier for each record in a table.
Indexing → Speeds up searching, sorting, and querying data.
Why Other Options Are Incorrect?
(b) Defined → A primary key is defined, but this doesn’t explain why searches are faster.
(c) Duplicated → Primary keys must be unique, so they cannot be duplicated.
(d) Replicated → While data may be replicated in distributed databases, primary keys themselves are not replicated for speed improvements.
[14] Record uniqueness in a table helps to avoid accidental ____________ of records caused by user or computer error. (a) duplication
Explanation:
Record uniqueness in a table ensures that each record is unique and prevents duplicate entries caused by user mistakes or system errors.
Primary Keys and Unique Constraints enforce uniqueness in a database.
Avoiding duplicate records helps maintain data integrity and prevents inconsistencies.
Why Other Options Are Incorrect?
(b) Key → While primary keys help enforce uniqueness, the question is about preventing errors, which relates more to avoiding duplication.
(c) Deletion → Uniqueness does not prevent accidental deletions.
(d) Removal → Similar to deletion, uniqueness is about avoiding duplicates, not preventing removals.
[14] Data in RDBMS is organized in ______________. (a) files
[17] ____________ is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors. (a) Sticky keys
[18] A ________________ is a collection of computers and other hardware components interconnected by communication channels (cables or satellites) that allow sharing of resources and information. (a) Computer
[19] WiFi devices such as personal computer, smartphones, video game console, etc. can connect to a network resource such as Internet through a device called the ______________. (a) PSTN
[21] Which one of the following is not a part of healthy lifestyle ? (a) Physical activities (b) Sound sleep (c) Healthy eating habits (d) Watching television for long hours
[23] ____________ controls all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting.
Explanation:
Paragraph Style controls all aspects of a paragraph’s appearance, including:
– Text alignment (left, right, center, justified)
– Tab stops
– Line spacing
– Borders and shading
– Character formatting (font, bold, italics, etc.)
Other options:
(a) Page Style:
Page Style controls the formatting of an entire page, such as page size, margins, headers, footers, and background. It does not focus on paragraph-specific formatting.
(b) Character Style:
Character Style applies formatting to individual characters or words, including font type, size, bold, italics, and color. It does not control paragraph settings like alignment or spacing.
(c) Cell Style:
Cell Style is used in tables or spreadsheets (like Excel or Word tables) to format individual cells with background colors, borders, and text alignment. It does not control paragraph formatting.
[24] How many levels of heading does Open Office Writer evaluate to build the Table of contents ?
Explanation:
LibreOffice Writer allows you to build a Table of Contents (TOC) using up to 10 levels of headings. These levels are based on the heading styles (Heading 1, Heading 2, Heading 3, etc.) that you apply to your document. Each level can represent a different depth in the structure of the content, which is reflected in the TOC.
[25] Reema has created a pamphlet on ‘Tour to West India’. She has inserted many images to make it more presentable but the size of images is occupying a lot of space. Her friend has suggested her to reduce the size of images. Which of the following options will help her in doing the task without losing any content of the image ?
Explanation:
(c) Resize – Resizing an image changes its dimensions, reducing its width and height while keeping the content intact. This option would help Reema reduce the space occupied by the image without losing any part of it.
Other options:
(a) Recolor – Recoloring changes the color scheme of an image but does not affect its size. It doesn’t help in reducing the space the image occupies.
(b) Docking – Docking refers to attaching an image or object to a particular area on the screen or in the document. It doesn’t resize the image itself.
(d) Rotate – Rotating an image changes its orientation (e.g., from landscape to portrait), but it does not resize the image or reduce the space it occupies.
[26] Which of the following Graphic filter is used to increase the contrastof an image in a document?
Explanation:
The Sharpen filter increases the contrast and clarity of the image by making the edges more defined. It highlights the differences between light and dark areas, thereby enhancing the contrast.
Other Options:
(a) Smooth – The Smooth filter is used to soften or blur the image, reducing the sharpness. It does not increase contrast but helps in making the image appear more even and less harsh.
(c) Remove Noise – The Remove Noise filter is used to reduce unwanted grain or distortion in the image, which can sometimes help clarify details, but it doesn’t directly affect contrast.
(d) Invert – The Invert filter inverts the colors of an image, turning light areas dark and dark areas light. While it alters the image’s color scheme, it does not necessarily increase contrast in a traditional sense.
[27] Which of the following is not used when creating a mail-mergedocument?
Explanation:
Paint is an image-editing program and is not used in the mail merge process. Mail merge involves text-based documents and data sources (like spreadsheets or databases), not images.
Other Options:
(a) Spreadsheet – A spreadsheet (e.g., Microsoft Excel) is commonly used in mail merge to store data such as names, addresses, or other personalized information that will be inserted into the main document.
(b) Document – A document (e.g., Microsoft Word) is used as the main template in a mail merge, where placeholders (fields) are added to merge with the data.
(d) Database – A database (e.g., Microsoft Access) can also be used as a data source for a mail merge, where the required data is stored and merged with the document.
[28] Which mode is used to apply a style to many different areas Of a document quickly without going back to styles and formatting window in Writer?
Explanation:
Fill format mode selected text or sections, bypassing the need to modify or select a predefined style.
For example, if you want to apply bold or italic formatting across different parts of a document, you can do it immediately by selecting the text and choosing the formatting options, rather than opening the Styles and Formatting window every time.
[29] A colored border, with _____________ appears around a cell where changes are made in a shared worksheet.
Explanation:
When you’re working in a shared worksheet (such as in Microsoft Excel), a colored border appears around the cell where changes are made. This is a feature that helps identify cells that are being edited by different users.
The dot in the upper left-hand corner indicates the cell where the last change was made. The colored border around the cell helps to easily identify the cell being edited.
The other options do not typically represent this indicator in shared worksheets.
[30] ____________ feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows.
Explanation:
The Subtotal feature in Calc is used to calculate subtotals for data that is arranged in a group of cells, and it can include labels for columns and rows. It helps to summarize data by applying functions like sum, average, count, etc. to a specific range.
Other Options:
(a) Average – The Average function calculates the arithmetic mean of a set of numbers, but it does not organize or group data with labels.
(c) Goal Seek – Goal Seek is a tool that helps you find the input value needed to achieve a desired result. It is used for solving simple equations but does not add data or organize it into groups with labels.
(d) Solver – Solver is a tool used for solving optimization problems with multiple constraints. It is more complex than Goal Seek and is not focused on organizing data with labels.
Wath this video for more details:
[31] Which one of the following is not a part of healthy lifestyle? (a) Physical activities (b) Sound sleep (c) Healthy eating habits (d) Watching television for long hours
Explanation:
A healthy lifestyle includes habits that promote overall well-being, such as regular exercise, proper sleep, and a balanced diet. Sitting for long periods and excessive screen time can lead to obesity, eye strain, and poor mental health, making it not a part of a healthy lifestyle. (Unhealthy habit)
Other Options:
(a) Physical activities → Engaging in regular exercise improves physical and mental health. (Healthy lifestyle component)
(b) Sound sleep → Getting adequate rest is essential for body recovery and overall health. (Healthy lifestyle component)
(c) Healthy eating habits → A balanced diet provides essential nutrients and energy for the body. (Healthy lifestyle component)
[32] Any unexpected situation that needs immediate attention and action is called __________. (a) SDGs
Explanation:
An emergency is an unexpected situation that requires immediate attention and action to prevent harm, loss, or danger. An emergency is a sudden, unexpected event that demands quick action, such as medical emergencies, natural disasters, or accidents.
Other Options:
(a) SDGs (Sustainable Development Goals) → These are global goals set by the United Nations to achieve a better and more sustainable future. (Not Related)
(c) Loss → Loss refers to a reduction in value, money, or resources, but it does not necessarily require immediate action. (Not the best fit)
(d) Profit → Profit is a financial gain and is unrelated to emergencies. (Not applicable)
[33] ___________ feature of Calc is used to test ‘what-if questions.
Explanation:
In LibreOffice Calc (or other spreadsheet software like Microsoft Excel), the Scenario feature is used to test “what-if” questions by allowing users to create and compare different sets of input values without changing the original data. The Scenario feature allows users to create multiple scenarios by changing input values to see different possible outcomes.
Other Options:
(a) Solver → Solver is used for optimization problems, where you find the best solution under given constraints. (Not for “what-if” analysis)
(b) Goal Seek → Goal Seek helps find the required input value to achieve a specific target output, but it doesn’t handle multiple scenarios. (Not the best fit for “what-if” analysis)
(d) Styles → Styles are used to format cells and documents but have no role in “what-if” analysis. (Not applicable)
[34] Macros are especially useful to ______ the same way over and over again. (a) repeat a task (b) reject a task (c) report a task (d) comment a task
Explanation:
(a) Repeat a task →
Macros are primarily used to automate repetitive tasks. By recording a series of actions, a macro allows you to repeat those actions with just a single click or command. This is the correct answer.
Other Options:
(b) Reject a task →
Macros do not reject tasks. Rejecting tasks refers to denying or discarding them, which is unrelated to the functionality of macros.
(c) Report a task →
Reporting tasks involves summarizing or generating reports about tasks, which is not what macros are designed to do.
(d) Comment a task →
Adding comments to tasks involves annotating or providing additional information, which is unrelated to macros.
[35] ______ feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change has occurred. (a) Record Changes (b) Edit record (c) Change record (d) Macro
Explanation:
This feature in LibreOffice Calc enables users to track modifications made in a spreadsheet. It records what data was changed, when the change was made, who made the change, and in which cell the change occurred. It is useful for collaborative work where multiple users edit the same spreadsheet. It found under Edit → Track Changes → Record in LibreOffice Calc.
Other options:
(b) Edit Record – This option does not exist as a feature in Calc. However, “Edit” generally refers to modifying existing data, but it does not track changes like “Record Changes” does.
(c) Change Record – This is not a recognized feature in LibreOffice Calc. It might sound similar to “Record Changes,” but it does not exist as an actual function.
(d) Macro – A macro is a recorded sequence of commands and actions that can be executed automatically to automate repetitive tasks. While macros can be used to modify data, they do not track changes like “Record Changes” does.
[36] Which one of the following is not an example of DBMS ?
Explanation:
Impress is a presentation software that is part of LibreOffice (similar to Microsoft PowerPoint). It is used for creating slideshows and not for managing databases.
Other Options:
(a) PostgreSQL – PostgreSQL is an open-source relational database management system (RDBMS). It is widely used for managing structured data with SQL (Structured Query Language).
(b) SQLite – SQLite is a lightweight, self-contained, embedded database management system. It does not require a separate server and is used in mobile applications and small projects.
(c) FoxPro – FoxPro is an old DBMS developed by Microsoft. It was used for creating and managing databases, but it is now outdated.
[37] __________ is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
Explanation:
A form is an interface that allows users to view, enter, and modify data in a structured way. It is used in database management systems (DBMS) such as Microsoft Access, LibreOffice Base, and other relational databases. Forms provide a user-friendly way to interact with tables without directly editing raw data.
Other options:
(a) Frame – A frame is a structural element in a graphical user interface (GUI). It is not specifically used for viewing or entering database data.
(c) Relation – A relation refers to a table in a relational database. It defines how different tables are related to each other but does not serve as a direct interface for user input.
(d) Report – A report is used to display or print formatted data from a database. It is mainly used for presenting information rather than data entry.
[38] Which of the following is expanded form of SQL?
Explanation:
SQL (Structured Query Language) is a standard programming language used for managing and manipulating databases. It is used in RDBMS (Relational Database Management Systems) like MySQL, PostgreSQL, Oracle, and SQL Server.
Rest of all are incorrect.
[39] ___________ is usually suitable for less amount of data. (Relational/Flat file)
Explanation:
Binary data types are designed to store various types of binary files, such as images (photos), audio files (music), and videos. These files are typically large and cannot be stored in standard text formats. Using binary data types allows databases to handle and manage these types of multimedia efficiently.
Other options:
(b) Integer values
Integer values are typically stored using numeric data types, not binary data types. Numeric types are designed to store whole numbers and perform mathematical operations, while binary data types are used for non-numeric data. Therefore, this option is incorrect in the context of binary data types.
(c) Only image files
This option is incorrect because binary data types can store a variety of file types, not just image files. While they can certainly store images, they are also capable of handling audio files, video files, and other binary data formats.
(d) Only video files
Similar to option (c), this option is incorrect because binary data types are not limited to storing only video files. They can store a wide range of binary data types, including images, audio, and any other binary formats. Thus, this option also does not accurately represent the capabilities of binary data types in a database.
[41] ___________ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
Explanation:
The WHERE clause is used to filter records and specify conditions that must be met for rows to be selected. It allows you to retrieve only those rows that satisfy certain criteria.
Other options:
(b) GROUP
The GROUP BY clause is used to group rows that have the same values in specified columns into summary rows, such as calculating aggregates (e.g., COUNT, SUM, AVG). It is often used with aggregate functions to produce a single result for each group.
(c) SAME
The SAME clause is not a valid SQL clause. There is no standard SQL command or clause known as “SAME.” This option is incorrect.
(d) SIMILAR
The SIMILAR clause is not commonly used in SQL either. While SQL does have some operators that can be used for pattern matching (like LIKE), there is no standard SQL clause specifically called “SIMILAR.”
[42] ___________ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.
Explanation:
Filter Keys is an accessibility feature in operating systems that allows users with vision impairments or cognitive disabilities to set the keyboard to ignore brief or repeated keystrokes, making it easier for them to type.
Other options:
(b) Sound Key
There is no specific accessibility feature known as “Sound Key.” This option does not refer to a recognized accessibility function.
(c) Toggle Keys
Toggle Keys is an accessibility feature that provides auditory notifications when certain keys, such as Caps Lock, Num Lock, or Scroll Lock, are pressed. While it helps users know the state of these keys, it is not specifically designed for individuals with vision impairments or cognitive disabilities.
(d) Sticky Keys
Sticky Keys is another accessibility feature that allows users to press modifier keys (like Shift, Ctrl, and Alt) one at a time instead of holding them down while pressing other keys. It can assist users with motor difficulties, but it is not specifically targeted at individuals with vision impairments or cognitive disabilities.
[43] Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called__________ networks.
Explanation:
In a client-server network, certain computers (servers) are dedicated to providing services, resources, or data to other computers (clients) on the network. This architecture allows for centralized management and resource allocation.
Other Options:
(a) Hierarchical
Hierarchical networks are structured in a way that organizes nodes in a top-down manner, often resembling a tree. This structure can be used in various contexts but does not specifically refer to dedicated tasks or services like client-server networks do.
(b) Dedicated server
While a dedicated server refers to a specific type of server that is dedicated to a single task or application, the term itself does not describe the overall network structure. It focuses more on the server’s function rather than the relationship between computers in the network.
(c) Peer to peer
In a peer-to-peer (P2P) network, all computers (peers) share resources and communicate directly with each other without a central server. Each computer can act as both a client and a server, so this option does not fit the description of networks with dedicated tasks for certain computers.
[44] ____________ provides Internet access by transmitting digital data overwires of a local telephone network.
Explanation:
DSL (Digital Subscriber Line) provides Internet access by transmitting digital data over the existing wires of a local telephone network, allowing for high-speed Internet without interfering with voice calls.
Other options:
(a) HSDPA
HSDPA (High-Speed Downlink Packet Access) is a mobile telecommunication protocol that enhances the data transfer rates of 3G networks, primarily used in mobile devices rather than over local telephone lines.
(b) P2P
P2P (peer-to-peer) refers to a network model in which each participant (peer) can act as both a client and a server, sharing resources directly without the need for a central server. It does not specifically provide Internet access over telephone lines.
(d) Modem
A modem (modulator-demodulator) is a device that converts digital data from a computer to analog for transmission over telephone lines and vice versa. While it is necessary for DSL to function, it does not exclusively provide Internet access over telephone wires as DSL does.
[45] ___________ is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes.
Explanation:
An accident is an unplanned event that occurs suddenly and can lead to unwanted or unforeseen results or outcomes, often resulting in harm or damage.
Other options:
(a) Emergency
An emergency is a situation that requires immediate action or response, typically due to a threat to life, health, property, or environment. While emergencies can be caused by accidents, they encompass a broader range of situations.
(b) Hazard
A hazard is a potential source of harm or adverse effect. It refers to a condition or situation that could lead to an accident or emergency but is not an event itself.
(d) Illness
Illness refers to a state of being unwell or having a disease. It is not necessarily an unplanned event like an accident but can result from various causes, including accidents or exposure to hazards.
[46] A ___________ worker will always perform to the best to his ability.
Explanation:
A happy and healthy worker is more likely to perform to the best of their ability, as their well-being positively influences motivation, productivity, and overall job satisfaction.
Other options:
(a) Fast working
A fast-working individual may complete tasks quickly, but speed does not necessarily equate to high-quality performance or the best effort. This option focuses on speed rather than overall effectiveness.
(b) Highly educated
While a highly educated worker may possess valuable knowledge and skills, education alone does not guarantee that the individual will always perform to the best of their ability. Factors such as motivation and well-being also play significant roles.
(d) Stressed
A stressed worker is less likely to perform at their best due to the negative effects of stress on focus, motivation, and mental health. Stress typically hampers performance rather than enhances it.
[47] _____________ is the process of emptying a place in case of an emergency,disaster.
Explanation:
Evacuation is the process of emptying a place or removing people from an area in case of an emergency or disaster to ensure their safety.
Other options:
(a) Emergency
An emergency refers to a serious, unexpected situation requiring immediate action. It is not the process of removing people but rather the circumstance that may lead to evacuation.
(b) Accident
An accident is an unplanned event that can cause harm or damage, but it does not specifically refer to the process of clearing an area or moving people.
(c) Drill
A drill is a practice or simulation of an emergency procedure, such as an evacuation. While it helps prepare individuals for an actual evacuation, it is not the process itself.
[48] Which of the following features allows one to apply a group of formats at the same time ? (A) Fill
Explanation:
Styles allow users to apply a set of formatting options (such as font, color, size, alignment, and spacing) simultaneously. Example: In LibreOffice Writer, using Heading 1 applies a predefined font size, color, and spacing to a title.
Other Options:
(A) Fill:
This feature is used to fill cells, shapes, or backgrounds with color or patterns, but it does not apply multiple formatting options at once. Example: Filling a cell in calc with a specific color.
(C) Images:
This feature is used to insert pictures into a document, but it does not relate to formatting text or applying styles.
(D) Drag and Drop:
This feature allows users to move files, text, or images by clicking and dragging, but it does not apply formatting.
[49] In Writer, the styles and formatting option is available under ____________menu. (A) Insert
Explanation:
The Format menu is the correct answer. This menu usually contains options related to text formatting, including font style, size, color, paragraph alignment, line spacing, and styles. It allows users to apply predefined styles or create custom styles for consistent formatting throughout the document.
Other Options:
(A) Insert
The Insert menu is typically used to add various elements to a document, such as images, tables, charts, links, page breaks, and other objects. It does not generally contain options related to styles and formatting.
(B) Tools
The Tools menu often includes options for settings, preferences, and utilities that enhance the functionality of the word processor. This can include spell checking, macros, and other tools, but it is not primarily focused on styles and formatting.
(D) Window
The Window menu is used to manage the document windows within the application. This can include options for arranging, splitting, or closing document windows. It does not typically contain styles and formatting options.
[50] Gaurav is creating a report in Writer. The image gets embedded in his document whenever he drags and drops the image and the document size increases. Suggest a way to link the image file instead of embedding it. (A) Drag and drop the image. (B) Hold down the Ctrl key while dragging. (C) Hold down the Shift key while dragging the image. (D) Hold down the Ctrl and Shift key while dragging and dropping the image.
Explanation:
This option allows you to create a link to the image instead of embedding it. By holding down the Ctrl key while dragging the image into the document, you tell the application to link to the file rather than embed it.
Other Options:
(A) Drag and drop the image – Simply dragging and dropping the image will embed it in the document, increasing the file size. This option does not link the image.
(C) Hold down the Shift key while dragging the image – Holding down the Shift key typically constrains the proportions of the image being dragged but does not create a link. This option would still embed the image.
(D) Hold down the Ctrl and Shift key while dragging and dropping the image – While this may have some effect on the image’s placement or dimensions, it does not serve the primary purpose of linking the image. It would still likely embed the image.
[51] Resizing a _________may badly affect the resolution of an image. (A) Vector image
Explanation:
Raster images are composed of pixels, which means that when they are resized, especially when enlarged, the individual pixels can become more apparent, leading to a loss of quality and resolution. This can result in a blurry or pixelated appearance.
Other options:
(A) Vector image
Vector images are made up of paths defined by mathematical equations, allowing them to be resized without losing quality or resolution. They maintain sharpness regardless of how much they are enlarged or reduced.
(C) CAD image
CAD (Computer-Aided Design) images can be either vector or raster, depending on how they are created. However, the term “CAD image” itself does not specifically indicate a resolution issue related to resizing.
(D) Coloured image
The term “coloured image” is too broad and could refer to either raster or vector images. The resolution impact depends more on the type of image (raster vs. vector) than on whether it is colored.
[52] In Writer, you can create your own template in ___________ way(s). (A) One
Explanation:
Using the Template Manager:
You can create a new template by opening the Template Manager, selecting a base template (or starting from scratch), and then customizing it according to your needs. After customizing, you save it as a new template.
Saving a Document as a Template:
Another method is to create a document with the desired formatting and content, and then save it as a template by choosing the “Save As” option and selecting the template format (usually .ott for OpenDocument templates). This allows you to use that document as a template for future projects.
[53] In Writer, ____________ function key is used to see the databases while implementing mail merge. (A) F1
Explanation:
LibreOffice provides a Define range option is used to assign a name to a range in consolidation.
Other Options:
Other options are not valid for LibreOffice calc.
[54] Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of changes. Which of the following options will help in knowing who made the changes and what changes were done in the spreadsheet ? (A) View changes (B) Record changes (C) Store changes (D) Track changes
Explanation:
This is the most relevant option. When enabled, LibreOffice Calc tracks edits made by different users and shows details such as who made the change and when it was made. Users can accept or reject changes from the Edit → Track Changes → Manage option. It is useful for collaborative editing and maintaining a record of modifications.
Other options:
(A) View Changes
Not a specific feature in LibreOffice Calc but could refer to the ability to check modifications made in the document. In LibreOffice Writer, there is an option called Edit → Track Changes → Show Changes, which highlights edits. However, in Calc, changes can be viewed through the Track Changes feature.
(B) Record Changes
This is the actual Track Changes feature in LibreOffice Calc. When enabled (Edit → Track Changes → Record), it records any modifications made in the spreadsheet, such as cell edits, deletions, or insertions. Changes are highlighted and can be reviewed later. Useful for collaboration, as multiple users can track what modifications were made.
(C) Store Changes
Not an existing option in LibreOffice Calc. However, changes can be stored in different ways, such as saving versions of a spreadsheet or using the Track Changes feature to maintain a record of edits.
[55] _______________ is a more elaborate form of Goal Seek. (A) Database
Explanation:
Solver is an advanced version of Goal Seek in LibreOffice Calc. While Goal Seek allows finding a single input value to achieve a target result, Solver can handle more complex scenarios with multiple constraints and variables. It is useful for optimization problems, such as maximizing profits or minimizing costs based on multiple conditions.
Other options:
(A) Database
A database is used to store, organize, and manage large amounts of structured data. It is not related to Goal Seek or solving optimization problems.
(B) Hyperlink
A Hyperlink is used to create clickable links to websites, files, or other locations within the document. It does not perform any calculations or goal-seeking functions.
(C) Report
A Report is typically used to present and summarize data in a structured format. It is more relevant to databases and not for mathematical calculations or Goal Seek functions.
[56] Macro functions can be written to behave as regular functions by writing a/an ___________. (A) Void
Explanation:
In LibreOffice Basic, a macro function must use the Return statement to send a value back to the caller (such as a spreadsheet cell or another function).
Example:
Function AddNumbers(a As Integer, b As Integer)
AddNumbers = a + b
End Function
The function AddNumbers behaves like a regular function, returning the sum of a and b.
Other options:
(A) Void
In some programming languages like C or Java, void is used to define functions that do not return a value. However, in LibreOffice Macros (written in Basic, Python, or other supported languages), there is no need to use void for defining functions. In LibreOffice Basic, functions must return a value to behave like regular spreadsheet functions.
(C) Add-In
An Add-In is a separate extension or plugin that enhances LibreOffice with additional features.
It is not related to writing functions within macros.
(D) Dim
Dim is used in LibreOffice Basic to declare variables.
Example:
Dim x As Integer
It does not define or return values from a function.
[57] ____________ option of Calc helps in viewing the changes made to a worksheet using original and edited worksheet. (A) Edit -> Revise document (B) Edit -> Consolidate (C) Edit -> Compare document (D) Edit -> Collaborate document
Explanation:
This option allows users to compare two versions of a spreadsheet (original and edited). It highlights differences, showing what changes were made. It is found under Edit → Compare Document in LibreOffice Calc.
Other options:
(A) Edit → Revise Document – Incorrect, as there is no specific “Revise Document” option in LibreOffice Calc. LibreOffice uses Track Changes for revision tracking, but “Revise Document” is not a feature.
(B) Edit → Consolidate – Incorrect, as the Consolidate option is used for combining and summarizing data from multiple sheets or ranges, not for comparing changes.
(D) Edit → Collaborate Document – Incorrect, as there is no “Collaborate Document” option in LibreOffice Calc. Collaboration features exist through Track Changes and sharing options, but not under this name.
[58] In Calc, shared workbooks allow : (A) Merging cells (B) Conditional formatting (C) Inserting pictures/graphs (D) Adding text
Explanation:
The “Remove” option allows users to delete a relationship between tables in the Relationships window. It does not delete the tables, only the relationship between them.
Other options:
(A) Clear – “Clear” is not used for removing relationships in LibreOffice Base. It is usually associated with clearing content (like clearing fields or values).
(C) Drop – “Drop” is a SQL command used in databases to delete an entire table or column, not just relationships.
(D) Delete – While “Delete” is a common term, it is not the correct option for removing relationships in LibreOffice Base. “Delete” is usually used for records (rows) in tables.
[60] In SQL, the keyword to display records in ascending order is : (A) Asce
Explanation:
The Boolean data type is specifically designed to store Yes/No or True/False values. Internally, it stores 0 for False (No) and 1 for True (Yes).
Other options:
(B) Char – The Char data type is used to store fixed-length text characters (e.g., ‘Y’ or ‘N’), not numeric Yes/No values.
(C) Binary – The Binary data type is used for storing binary data like images or raw byte data, not Yes/No values.
(D) OtherObject – “OtherObject” is not a valid data type in LibreOffice Base.
[62] Which of the following statement retrieves zero or more rows from one or more database tables or database views ? (A) UPDATE
Explanation:
The SELECT statement is used to retrieve data (zero or more rows) from one or more tables or views.
Example:
SELECT * FROM students;
It can fetch all rows or be used with conditions to filter specific records.
Other Options:
(A) UPDATE – The UPDATE statement is used to modify existing records in a table.
Example: UPDATE students SET grade = ‘A’ WHERE id = 1;
(B) DELETE – The DELETE statement is used to remove rows from a table.
Example: DELETE FROM students WHERE id = 1;
(D) DISPLAY – it is not a valid keyword for SQL.
[63] Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust_photo field. Suggest a suitable data type from the options given below. (A) IMAGE (B) PICTURE (C) LONGVARBINARY (D) GRAPHIC
Explanation:
LONGVARBINARY is the correct data type for storing binary data, including images, in SQL databases like OpenOffice (LibreOffice) Base. It is designed to store large binary objects (BLOBs), such as photographs, audio, or video files.
Other options are not valid data types in libreoffice base.
[64] By default, all the fields in OpenOffice/Libreoffice Base will have ____________ datatype. (A) int (tiny)
Explanation:
A Blog is a discussion-style website or platform that serves as an online personal diary or journal, where individuals can create and share their thoughts, experiences, and opinions. Blogs can include text, images, videos, and links, allowing for interactive discussions through comments.
(A) WWW – WWW stands for the World Wide Web, which is the system of interlinked hypertext documents accessed via the internet. It is not a specific type of website.
(B) Web – The term Web is often used informally to refer to the internet or web pages in general but does not describe a specific format or style of a website.
(D) Chat – Chat refers to real-time communication between users, typically through text messaging, and does not relate to the concept of personal web pages.
[66] Natasha works as floor manager. She has been assigned a task for conducting regular _______ to ensure safety of life in case of any disaster or emergency by evacuating the place of danger. (A) Cultural assembly (B) Open house events (C) Evacuation drill (D) Trips and excursions
Explanation:
An evacuation drill is a practice exercise that prepares individuals for a safe and orderly evacuation in case of an emergency or disaster. These drills help ensure that everyone knows how to respond effectively to various emergency situations.
Other options:
(A) Cultural assembly – A cultural assembly refers to gatherings focused on cultural activities and discussions, which are not related to safety protocols or emergency preparedness.
(B) Open house events – Open house events are typically opportunities for people to visit and learn about a place, such as schools or organizations, and are not focused on safety or evacuation procedures.
(D) Trips and excursions – Trips and excursions refer to outings or field trips and are not related to safety measures or emergency preparedness.
[67] ___________ is an accessibility feature that assists people who have difficulty using a keyboard or a mouse (or both). (A) Sticky keys
Explanation:
Sticky Keys is an accessibility feature that allows users to press and release modifier keys (like Shift, Ctrl, or Alt) one at a time rather than holding them down while pressing another key. This feature is particularly helpful for individuals who have difficulty using a keyboard or mouse simultaneously.
Other Options:
(B) Serial key – A serial key usually refers to a product activation code for software and is not related to accessibility features.
(C) Control key – The Control key (Ctrl) is a standard keyboard key used in conjunction with other keys to perform various functions. It is not an accessibility feature.
(D) Toggle keys – Toggle Keys is an accessibility feature that provides an audio cue when keys like Caps Lock, Num Lock, or Scroll Lock are pressed. While it helps with awareness, it does not assist users with keyboard or mouse difficulties as effectively as Sticky Keys.
[68] Network in which all computers have equal status is called _____________. (A) Peer-to-Peer architecture (B) Central architecture (C) Hierarchical architecture (D) Client-server architecture
Explanation:
In a Peer-to-Peer (P2P) architecture, all computers (peers) have equal status and can act as both clients and servers. Each peer can share resources, such as files and printers, without needing a central server.
Other Options:
(B) Central architecture – Central architecture implies a centralized control model where a central server manages and controls access to resources. This contradicts the concept of equal status among all computers.
(C) Hierarchical architecture – Hierarchical architecture is structured in levels or tiers, with different levels having varying statuses and roles (e.g., a central server at the top and clients below), thus not providing equal status.
(D) Client-server architecture – In Client-server architecture, there is a distinct separation between clients and servers, where clients request resources or services, and servers provide them, creating a hierarchy rather than equal status.
[69] _________ are text files with small pieces of data – like a username and password. (A) Operating System
Explanation:
Cookies are small text files stored on a user’s computer by a web browser. They contain data such as usernames, passwords, and other session information, allowing websites to remember user preferences and login status.
Other options:
(A) Operating System – An Operating System (OS) is system software that manages computer hardware and software resources. It is not a text file for storing small pieces of data like usernames and passwords.
(B) Antivirus – Antivirus software is designed to detect and eliminate malware. It does not function as a text file for storing user data.
(D) Modem – A Modem is a hardware device that modulates and demodulates signals for internet access. It does not store user data as text files.
[70] DSL stands for ______________. (A) Digital System Line
[73] __________ is the immediate assistance provided to the injured to save life and minimize health loss till the proper medical aid/facility is provided.
Ans.: Sorting refers rearranging the records according to a field in ascending or descending order.
[77] _________, is a system of interlinked hypertext documents accessed via the internet.
[78] _________ is a global system of interconnected computer networks.
[79] _________ is an accessibility feature that assists people that have difficulty using a keyboard or a mouse (or both).
[80] Write any two examples of Database Management Systems.
[81] Name the term that is used to display the records in ascending ordescending order.
[82] Define Foreign Key.
Part B Subject Specific skills – 2 marks Important PYQs Information Technology Class 10
[1] Differentiate between Aging and Posterize graphic filters.
[2] Give any two uses of creating hyperlinks in a spreadsheet.
[3] Under Record changes feature, one can control the changes that appear on the screen using filters.
[4] Explain any two criteria on which these filters are based.
[5] Differentiate between data organized in a flat file and a relational form.
[6] Expand and explain the term www.
[7] (a) Arrange the following network in decreasing order of speed : DSL, 3G, 5G (b) Give any two examples of instant messaging software.
[8] Differentiate between Keep scale and Keep image size options while cropping an image in a document.
[9] Give any two characteristics of a template in Open Office Writer.
[10] Why do we need to merge worksheets?
[11] What is a Primary Key ? How is it different from foreign key ?
[12] Expand and explain the term WAN.
[13] (a) Identify the following network / Internet connectivities as wired or wireless :
(i) Dial-up
(ii) WiMax
(b) Give any one feature of instant messaging software.
[14] Write the main steps to group drawing objects in Writer.
[15] What is the purpose of consolidating data in spreadsheets? Discuss briefly.
[16] Differentiate between LAN and WAN.
[17] What are the two parts of a cell reference while referencing data on other sheets ? Explain with an example.
[18] Give any two benefits of creating relationships between tables in a database.
[19] Mention any two basic fire safety rules to be followed in any organization.
[20] Write any four rules which is to be followed for creating strong passwords.
[21] What is the special name given to the discussion style site used by nontechnical (or technical) users for creating personal web pages ? Give any two examples of websites that help us to create such discussion style sites for free.
[22] Differentiate between LAN and WAN with two points only.
[23] Explain any two types of relationship that can be created in tables.
[24] What is difference between Form and Reports ?
[25] Identify any two Column name/Attribute and their data types from a given table: PLAYER
PID
PNAME
RUNS
GENDER
DOB
PIOI
SACHIN
13000
M
10/04/2001
P102
KAPIL
7000
M
12/02/1998
P103
SAURABH
12000
M
13/04/2001
P104
VIRAT
12500
M
17/03/2005
[26] Give a list of any four types of accidents.
[27] What are cookies ? What details are stored by the cookies ?
[28] Give one point of difference between peer-to-peer architecture and client-server architecture.
[29] Support your answer with an example.
[30] Define the following :
Data Consistency
Data Redundancy
Part B Subject Specific skills – 4 marks Important PYQs Information Technology Class 10
[1] Give two areas where Mail Merge can be used. Also give names of any two softwares that can be used to store the data list.
[2] Explain the following w.r.t. spreadsheets : (a) Scenario (b) Goalseek
[3] Write any four numeric data types in DBMS.
[4] (a) The structure of a table SUPPLIER is given below. Suggest suitable data type for each column.
Table – Supplier
Suppno
Suppname
City
Amount
11
Sourabh
Delhi
98983.00
22
Pratabh
Jaipur
45780.00
33
Faviaam
Mumbai
82875.00
44
Shekhar
Jaipur
45465.00
55
Swami
Mumbai
56784.00
(b) Consider the table “SUPPLIER” given in (a). Write queries to : (i) Display the supplier name of all suppliers from Delhi (ii) Display details of suppliers whose amount is greater than 50000.
[5] (a) Give examples of two Internet threats. (b) Most of the time fire can be prevented using appropriate measures. Give any two measures.
[6] Explain the following terms with respect to positioning the graphics in a document :
(a) Arrangement
(b) Text Wrapping
[7] Distinguish between the following with respect to spreadsheets :
Relative and Absolute hyperlink
Internet hyperlink and Document hyperlink.
[8] Explain any four data types of DBMS.
[9] (a) Structure of a table “0rders” is given below. Suggest suitable data type of each column
Table : Orders
Order_ID
Order_date
Customer_ID
Amount
A-101
12/12/19
C3445
1200.00
A-202
11/09/19
Cl’245
3456.00
A-402
09/07/19
C’2121
2312.00
(b) Consider the followin table “Books”.
BkID
BkName
Author
Qty
Price
B 101
Learni with Fun
Jacobins
5
355.00
B_103
How I Live Now
Me Rosoff
4
400.00
B_104
I Ca ture the Castle
Dodie Smith
5
520.00
B_10G
Mortal E ines
Phili Reeve
4
260.00
B_IIO
The Kite Rider
Geraldine McCau hrean
3
270.00
Write SQL queries to:
Display data of all books whose quantity is more than 3.
Display total amount Of all books whose price is less than 500. (Hint : amount Qty x Price)
[10] (a) Give two best practices for internet safety.
(b) Give any two Falls and Slips Safety rules.
[11] What is the concept of mail merge in word processing software ? Discuss in detail. Also give any two major benefits of using mail merge.
[12] Explain four types of hyperlinks that can be applied in spreadsheets.
[13] Internet security is of prime concern nowadays. Using strong passwords can lower the risk of security breach on the Internet. Himanshi has just created her first Internet based account. Help her by giving any four general guidelines for managing strong passwords.
[14] In context of OpenOffice Base, explain the concept and significance of the following : (a) Forms (b) Reports
[15] Consider the table Product and write SQL queries for the following :
Table : Product
PID
PNAME
PRICE
QUANTITY
CATEGORY
P01
BOARD
10000
2
OFFICE
P02
EYELINER
700
50
MAKEUP
P04
PENCIL
5
500
SCHOOL
P05
LAMP
250
10
DOMESTIC
P08
BEDSHEET
450
45
DOMESTIC
P09
LAPTOP
75000
15
OFFICE
(a) To display names of all products whose category is ‘‘domestic’’. (b) To display product name and price whose quantity is less than 50. (c) To display price and quantity of Laptop. (d) To display name and quantity of those products whose price is above 5000.
[16] In the context of Database Management System, write a short note on the following : (i) Database (ii) Table (iii) Field (iv) Composite Primary Key
[17] Aryan is too much worried when he came to know that someone has withdrawn all money from his uncle’s bank account. He was not able to understand how this could happen when he has not given his ATM card to anyone.
Suggest him a way by which he can be assured that he is doing secured online transaction.
Which type of software he needs to install in his computer to protect his computer from malware
Help him to understand about Phishing.
He also thinks cookies are harmless. Explain him how cookies can also cause harm to him.
[18] Due to pandemic everyone was bound to stay at home. But, due to internet the whole world was connected.
Explain how data is transferred over the internet.
What is meant by World Wide Web ? Also write any two web browsers names that you know.
[19] Consider the following table :
STUDENT
ADMNO
NAME
GRADE
DOB
MARKS
HOUSE
GENDER
1001
RUPAL
9
10/04/2006
76
GREEN
M
1002
RASHMI
9
08/12/2005
87
RED
F
1003
ARNAV
10
25/05/2004
81
GREEN
M
1004
SUMONA
9
23/08/2005
68
RED
F
1005
ARUN
9
16/07/2005
72
GREEN
M
1006
TIA
9
22/09/2005
91
BLUE
F
1007
ROSHAN
10
26/08/2004
89
BLUE
M
Write SQL Commands :
To display the details of all students of Green House.
To increase the marks by 5 whose ADMNO is 1005.
To display the details of all students whose MARKS are less than 80.
Display the list of all students in descending order of MARKS.
[20] Define the following :
Database Management System
Primary Key
Numeric Data Type
Referential Integrity
[21] Radhika is fond of cooking and wants to share her cooking tips with the world. One of her friends suggested her to start writing blogs.
Explain the purpose of a blog
List any 2 websites that provide blog service.
Explain the purpose of an offline blog editor.
Name any two free offline blog editors.
[22] Every development has advantages as well as disadvantages. With the enhanced use of internet there are many problems that all of us are facing these days.
[23] What do you understand by internet security ?
Name and explain any one online threat.
Suggest any two best practices for ensuring security over internet.
Consider the following table : EMPLOYEE
Table : EMPLOYEE
EMPID
NAME
SALARY
DOJ
COMM
DEPT
GENDER
1001
ROHAN
7000
10/04/2006
300
SALES
M
1002
RISHU
12000
08/12/2005
100
FINANCE
F
1003
DEVANSH
9000
25/05/2004
500
SALES
M
1004
SUMAN
10000
23/08/2005
300
MARKETING
F
1005
ARYAN
11000
16/07/2005
500
SALES
M
1006
TAMANNA
15000
22/09/2005
200
FINANCE
F
1007
ROHIT
8000
26/08/2004
900
SALES
M
Write SQL Commands :
To display the details of all employees of SALES Department.
To increase the SALARY by 1000 whose EMPID is 1007.
To display the details of all employees whose SALARY is more than 10000.
To display the list of all students in descending order of SALARY.