Students, please go through these
-------------------------------------------------------------------------------------------------------------
Q. Database Management System
1. Create table EMPLOYEE (EMPID Char(4), EMPNAME Varchar(15), DESIGN Varchar(20), SALARY Decimal).
2. What is a primary key?
3. Categorize the following commands as DDL and DML: SELECT, ALTER, INSERT, DROP.
1. Multiple-Choice Questions (MCQs)
1. What is the importance of effective communication in a workplace? (a) Reducing office expenses (b) Enhancing team collaboration and productivity (c) Increasing employee vacation days (d) Improving office aesthetics
2. High expectations from self can leave with chronic anxiety and stress, thus leading to stress. (a) Physical (b) Emotional (c) Social (d) Financial
3. John notices that the cost of raw materials is lower in a different supplier's location compared to his current supplier. He decides to switch to the new supplier to save money. Which function that the entrepreneur is doing? (a) Makes decisions (b) Divides income (c) Takes risk (d) Innovation
4. Which organization has adopted the Sustainable Development Goals. (a) UNICEF (b) League of Nations (c) United Nations (d) World Health Organization
5. What should you do to ensure secure online transactions? (a) Lock your computer (b) Give credit card or bank details only on safe websites (c) Use anti-virus (d) Do not use pirated software
1. What is a style in LibreOffice Writer? a) A method of typing b) A collection of all formatting information c) A tool for drawing shapes d) A spell-check feature
2. Which of the following is an example for absolute cell referencing? (a) C5 (b) $C$5 (c) $C (d) #C
3. Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened? (a) Entries (b) Background (c) Styles (d) Type
4. Which of the following is true about Track Changes feature of Writer? (a) You cannot record a change made in the document. (b) A comment of a particular author only can be deleted (c) Any change made to the document is permanent. (d) None of the above
5. Imagine you are a financial analyst tasked with analyzing quarterly sales data for a multinational corporation. The data is stored in separate sheets within an Excel workbook, each representing sales figures from different regions (e.g., North Zone, East Zone, South Zone). How can you efficiently view and compare quarterly sales data from multiple regions in a single spreadsheet to identify trends and relationships? (a) By creating separate charts for each region’s data. (b) By using the Consolidate function to combine information from all regional sheets into one summary sheet. (c) By manually copying and pasting data from each region’s sheet into a new sheet. (d) By deleting unnecessary data from each region’s sheet.
6. Sore lower back is caused due to _______. (a) reaching forward frequently (b) no lumbar support (c) no upper back support from chair (d) reaching forward for long periods
1. What is the extension of spreadsheet file in Calc? (a) .odb (b) .odt (c) .odg (d) .ods
2. Which of the following is the shortcut key to open the Templates dialog box? (a) Ctrl+Alt+N (b) Ctrl+Shift+N (c) Ctrl+Alt+T (d) Shift+Alt+T
3. Which style category would you use to format a section containing text, graphics, and lists? a) Page Style b) Paragraph Style c) Character Style d) Frame Style
4. It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor. (a) Wrap Text (b) Anchoring (c) Alignment (d) BookMark
5. Which of the following is an invalid Macro Name? (a) 1formatword (b) format word (c) format*word (d) Format_word
6. A fresh food cafeteria helps to maintain the ______ of the employee. (a) Health (b) Morale (c) Productivity (d) Engagement
1. Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc? (a) Macro (b) Hyperlink (c) connect (d) Copy
2. Which of the following operations cannot be performed using LibreOffice Calc? (a) Store and manipulate data (b) Create graphical representation of data (c) Analysis of data (d) Mail merge
3. The details associated with an entity are called ____. (a) Table (b) Attributes (c) Records (d) Primary key
4. The _____ data is a combination of letters, numbers or special characters. (a) Structured (b) Unstructured (c) Semi-structured (d) Alphanumeric
5. Which kind of hazards can occur in IT industry? (a) Biological (b) Chemical (c) Physical (d) Ergonomic
6. In a Query Design wizard, which of the following buttons is clicked to move a field from ‘Available fields’ list box to ‘Fields in the query‘ list box? (a) > (b) <9 (c) ∨ (d) ∧
1. Identify the mode, where we can modify in the structure of table? a. Datasheet view b. Structure view c. Design view d. All of the above
2. What is the primary purpose of a query in a database? (a) To enter new records (b) To create reports (c) To retrieve specific data (d) To design forms
3. Which of the following is NOT true about forms? (a) It is the front end for data entry (b) It can contain text fields (c) Graphics can be inserted on the form (d) It can accept only fixed number of records
4. For an organisation, the proper security procedures will reduce ______. (a) liabilities (b) insurance (c) business revenue (d) operational charges of the company
5. Which of the following is not an example of ignition sources of open flames? (a) Gas ovens (b) Lighters in smoking areas (c) Welding torches (d) space heaters
6. Which action contributes to a healthy and safe working environment? (a) Keeping emergency exits clear (b) Leaving cables loose on the floor (c) Ignoring safety warnings (d) Using unapproved software
1. ____ are a group of words that work together to communicate an element of speech.
2. ____ refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations.
3. Having conscious knowledge of your own self, capabilities, feelings and one’s own character is called as ____ .
4. A ____ is a software that helps you type and work with text on a computer. (word processor / spreadsheet / calculator)
5. Entrepreneurs are not job seekers but they create opportunities of employment for people. (True/False)
6. ____ defines a Green economy as one that results in ‘‘improved human well-being and social equity, while significantly reducing environmental risks and ecological scarcities’’.
List any four characteristics of entrepreneurship.
List any two factors that affect self-confidence.
List any four factors causing ecological imbalance.
Section B: Subject Skills
1. Write steps to highlight text in an LibreOffice Writer.
3. List any four items that may be added in the Header area.
4. List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet.
5. Mention two ways in which a movie file may be inserted in a presentation.
6. Mention two ways of scheduling an appointment.
7. Explain two types of languages used for creating and manipulating the data in databases.
---------------------------------------------------------------------------------------------
Why are typing ergonomics important, and what factors are included in typing
ergonomics?
Ans: Importance of Typing Ergonomics:
Typing ergonomics is crucial for efficient and effective typewriting. It helps attain and
maintain accuracy and speed while reducing fatigue and discomfort. Proper
ergonomics can prevent strain and injuries, promoting long-term health and
productivity.
Factors Included in Typing Ergonomics (Include any 3 points)
1. Sitting Posture:
- Sit straight with a slightly forward-bending neck.
- Ensure comfort and proper body positioning.
- Touch the lower back to the backrest and both feet to the floor.
2. Position of Hands:
- Keep forearms level with the keyboard, palms down.
- Maintain straight wrists and natural elbow positioning, bent at about a 90-degree
angle.
3. Monitor Placement:
- Avoid neck bending by keeping the upper border of the screen at eye level.
- Maintain a distance of approximately 60–65 cm from a 17-inch screen.
4. Mouse and Keyboard Placement:
- Keep them together at a distance of about 20 cm for smooth operation.
- Ensure the same height for the keyboard, mouse, and elbows for comfort.
5. Chair and Table Placement:
- Adjust the chair and table to optimal heights.
- The chair should support the lower back.
- Ensure the computer table has enough leg space and separates vibrating devices
like printers.
6. Placement of Matter to be Typed:
- Place the material on the left or right side of the keyboard on a copy holder with a
sloping surface.