Class X IT (402) Preboard Sample Paper - Set 2
IT (402) Preboard Sample Paper - Set 2
SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)
Q1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
1. Example of oral communication?
Correct Answer: c) Face-to-face conversation
2. Ability to work independently without constant supervision?
Correct Answer: c) Self-Motivation
3. Example of an open-source OS?
Correct Answer: c) Linux (Ubuntu)
4. Entrepreneur who creates a new market?
Correct Answer: b) Market Creator/Innovator
5. Method of soil conservation?
Correct Answer: c) Tree Plantation (Afforestation)
6. "Clean the Disk" utility is used to:
Correct Answer: b) Remove unnecessary files to free up space
Q2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. Style that affects font, size, bold/italic format of selected characters?
Correct Answer: c) Character Style
2. Key to select non-adjacent items in Calc?
Correct Answer: b) Ctrl
3. Which is NOT a database object?
Correct Answer: d) Document
4. High Contrast is an accessibility feature under:
Correct Answer: b) Display / Ease of Access
5. The intersection of a row and a column in a spreadsheet is called a:
Correct Answer: b) Cell
6. The specific address of a resource on the internet is known as:
Correct Answer: c) URL
Q3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. Grey color lines showing page margins in Writer are called:
Correct Answer: b) Text boundaries
2. Shortcut key to create a hyperlink in Calc:
Correct Answer: b) Ctrl + K
3. "Length" is a property associated with which data type?
Correct Answer: b) Text/Varchar
4. Topology where failure of single cable breaks the entire network loop?
Correct Answer: b) Ring
5. Standard file format for audio files?
Correct Answer: a) .mp3
6. Command used to retrieve data from a database?
Correct Answer: b) SELECT
Q4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. Image format best suited for photographs?
Correct Answer: b) JPEG
2. Formula bar in a spreadsheet displays:
Correct Answer: c) Content of the active cell
3. DDL stands for:
Correct Answer: b) Data Definition Language
4. Skype is an example of software used for:
Correct Answer: b) Video Conferencing / VoIP
5. To organize posts in a blog, we use:
Correct Answer: b) Categories and Tags
6. Method to prevent falls in the workplace?
Correct Answer: b) Cleaning up spills immediately
Q5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. Mail Merge involves merging a Main Document with a:
Correct Answer: a) Data Source
2. Shared spreadsheets allow:
Correct Answer: b) Multiple users to edit simultaneously
3. In SQL, the wildcard character `%` represents:
Correct Answer: b) Zero or more characters
4. Wi-Fi stands for:
Correct Answer: a) Wireless Fidelity
5. Phishing is an attempt to acquire:
Correct Answer: b) Sensitive information like passwords/credit cards
6. CPR stands for:
Correct Answer: a) Cardio Pulmonary Resuscitation
SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)
Answer any 3 out of 5 Employability Skills questions (2 marks each)
Q6. Mention two advantages of verbal communication.
Answer: 1. It is **quick** and allows for **instant feedback**. 2. It helps build **personal relationships** and **clarifies** misunderstandings immediately.
Q7. What is "Stress"? Name two physical signs of stress.
Answer: Stress is a body's **reaction to change** that requires a physical, mental, or emotional adjustment or response. Two physical signs are: 1. **Headaches** or body aches. 2. **Increased heart rate** or difficulty sleeping.
Q8. Explain the function of the "Control Panel" in Windows.
Answer: Control Panel is a component of the Windows OS that allows users to **view and change basic system settings** and controls, such as adding hardware, adding/removing software, and managing user accounts.
Q9. Distinguish between a "Service Business" and a "Manufacturing Business".
Answer: A **Manufacturing Business** creates tangible products (e.g., car factory). A **Service Business** provides intangible services (e.g., a consultancy firm or a spa).
Q10. What is the role of the "Green Economy"?
Answer: The Green Economy aims for **sustainable development** without degrading the environment. Its role is to achieve **reduced carbon emissions** and **resource efficiency** while creating green jobs and reducing poverty.
Answer any 4 out of 6 Subject Specific Skills questions (2 marks each)
Q11. What are "Templates" in Writer? How do they save time?
Answer: **Templates** are **master documents** or pre-designed frameworks that contain styles, formatting, and boilerplate text. They save time because you don't have to recreate the basic structure and styles every time you create a new document (e.g., a letterhead).
Q12. Explain "Hyperlinks" in a spreadsheet. What are the two types?
Answer: **Hyperlinks** are clickable text or graphics that take the user to another location (web page, file, or cell in the same sheet). The two types are: **1. Absolute** (full, fixed address) and **2. Relative** (address relative to the current file location).
Q13. Differentiate between "Flat File" and "Relational" databases.
Answer: **Flat File Databases** store data in a single table, making them simple but prone to redundancy. **Relational Databases (RDBMS)** store data in multiple tables linked by relationships (keys), which reduces redundancy and improves data integrity.
Q14. What are "Sticky Keys"? Who are they beneficial for?
Answer: **Sticky Keys** allow the user to perform **key combinations** (like Ctrl+Alt+Del) by pressing the modifier keys (Ctrl, Shift, Alt, Win) **sequentially** rather than simultaneously. They are beneficial for users with physical disabilities who have difficulty holding down multiple keys at once.
Q15. Difference between P2P and Client-Server architecture?
Answer: In **P2P**, all devices are equal (peers) and share resources directly. In **Client-Server**, dedicated devices (servers) provide services and resources to other devices (clients). Client-Server is more scalable and secure.
Q16. What is an antivirus? Name any two popular antivirus software.
Answer: An **Antivirus** is software designed to **detect, prevent, and remove malicious software** (viruses, malware, spyware, etc.) from computer systems. Examples: Quick Heal, Kaspersky, Norton, Avast.
Answer any 3 out of 5 Subject Specific Skills questions (4 marks each)
Q17. (Competency) Priya's image formatting...
Answer:
a) **Steps to insert:** Insert > Image > From File... (then navigate and select).
b) The **Wrap** option she should use is **Wrap Around Page** or **Optimal Page Wrap** (and set the shape to Square).
c) To make the image transparent (Watermark effect), she should right-click the image, select **Properties > Transparency** tab, and increase the transparency level.
d) **Anchoring** determines where the image is attached (to a character, paragraph, frame, or page) and how it moves when the surrounding text changes.
a) **Steps to insert:** Insert > Image > From File... (then navigate and select).
b) The **Wrap** option she should use is **Wrap Around Page** or **Optimal Page Wrap** (and set the shape to Square).
c) To make the image transparent (Watermark effect), she should right-click the image, select **Properties > Transparency** tab, and increase the transparency level.
d) **Anchoring** determines where the image is attached (to a character, paragraph, frame, or page) and how it moves when the surrounding text changes.
Q18. (Competency) Macro for spreadsheet formatting...
Answer:
a) A **Macro** is a saved sequence of commands, keystrokes, and mouse movements that can be stored and executed to **automate repetitive tasks** in a spreadsheet or document.
b) The menu option is **Tools > Macros > Record Macro**.
c) The macro will be stored under the **My Macros & Dialogs** container. To run it, go to **Tools > Macros > Run Macro**, select the stored module, and click **Run**.
d) Macros can contain malicious code or viruses that can harm your system or steal data, which is why they should be run only from trusted sources.
a) A **Macro** is a saved sequence of commands, keystrokes, and mouse movements that can be stored and executed to **automate repetitive tasks** in a spreadsheet or document.
b) The menu option is **Tools > Macros > Record Macro**.
c) The macro will be stored under the **My Macros & Dialogs** container. To run it, go to **Tools > Macros > Run Macro**, select the stored module, and click **Run**.
d) Macros can contain malicious code or viruses that can harm your system or steal data, which is why they should be run only from trusted sources.
Q19. SQL Queries for table ITEMS...
Answer:
a)
b)
c)
d)
a)
SELECT * FROM ITEMS WHERE Price > 500;b)
SELECT ItemName, Quantity FROM ITEMS WHERE Quantity < 10;c)
UPDATE ITEMS SET Price = Price * 1.10;d)
INSERT INTO ITEMS VALUES ('A01', 'Mouse', 450, 20);Q20. Data Redundancy and how DBMS controls it.
Answer: **Data Redundancy** means **duplication of data** across different locations in a database. It wastes space and leads to data inconsistencies. A **DBMS** (Database Management System) controls it by enforcing **normalization** and using **foreign keys** to link unique records across multiple tables instead of repeating common data fields.
Q21. Working late scenario (Ergonomics, Eye Strain, Security)...
Answer:
a) **Ergonomic Practices:** 1. Use a chair that supports the lower back. 2. Keep the monitor top at eye level.
b) **20-20-20 rule:** Every 20 minutes, look at something 20 feet away for at least 20 seconds.
c) Securing Wi-Fi prevents **unauthorized access** to your network, protecting your bandwidth, and preventing intruders from accessing your connected devices/data.
d) A **Firewall** is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules, acting as a barrier between a trusted and untrusted network.
a) **Ergonomic Practices:** 1. Use a chair that supports the lower back. 2. Keep the monitor top at eye level.
b) **20-20-20 rule:** Every 20 minutes, look at something 20 feet away for at least 20 seconds.
c) Securing Wi-Fi prevents **unauthorized access** to your network, protecting your bandwidth, and preventing intruders from accessing your connected devices/data.
d) A **Firewall** is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules, acting as a barrier between a trusted and untrusted network.
Comments
Post a Comment