CBSE 10th class Unit 3: Chapter 2 STARTING WITH LIBREOFFICE BASE

Unit 3: 

Chapter 2

STARTING WITH LIBREOFFICE BASE

A. Multiple Choice Questions

1. (c) Float
• Float is a numeric data type used for storing decimal numbers.
2. (b) False
• Currency data type can store monetary data in various currencies, not just dollars.
3. (a) Date
• Date data type is specifically designed to store dates.
4. (b) It is free and open-source software
• LibreOffice Base is a database management system that is part of the free and open-source LibreOffice suite.

A. Multiple Choice Questions

5. (c) Both a and b
6. (a) Database
7. (b) Ctrl+O
8. (b) 3
9. (c) Enter
10. (d) All of the above

B. State whether the following statements are True or False

1. True
2. True
3. False
4. False
5. True
6. True
7. False
8. True
9. True

C. Fill in the blanks

1. A data type refers to the type of data that will be stored in that particular field.
2. The text data is a combination of letters, numbers or special characters.
3. The varchar data type can be used to store Aadhar number.
4. The image data type used to store digitized images.
5. The shortcut key to save a table is Ctrl+S.
6. Status bar on the Base Interface Window displays information about the type of view of the object in the database.
7. A key icon appears before the field name indicating that it is a primary key.
8. The data can be entered in a table only in datasheet view.
9. The black pointing arrow just before the field name in a table is called navigation box.
10. The process of arranging the records in particular order on any field is called sorting.

D. Answer the given questions

1. Differentiate between:
• (a) Memo and Varchar data type:
• Memo: Stores long text strings.
• Varchar: Stores variable-length character strings.
• (b) Number and Decimal data type:
• Number: Stores integers.
• Decimal: Stores decimal numbers.
• (c) Design View and Datasheet view of a table:
• Design View: Used to define the structure of a table, including fields, data types, and primary keys.
• Datasheet View: Used to enter and edit data in a table.
2. Name the menu items present on the Base User Interface.
• File, Edit, View, Insert, Format, Tools, Window, Help.
3. Label the components Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base User Interface.
• Refer to a screenshot of the LibreOffice Base interface to accurately label the components.
4. How can we define a primary key in a table?
• In Design view, select the field(s) that will uniquely identify each record.
• Right-click on the selected field(s) and choose "Primary Key".
5. Write steps to sort the table in descending order of primary key.
• Open the table in Datasheet view.
• Click on the header of the primary key field.
• Right-click and select "Sort Descending".
6. What is the use of navigation box with respect to tables in a database?
• The navigation box allows you to quickly navigate between records in a table. You can use it to move to the first, last, previous, or next record.