Starting with LibreOffice Base Question Answer Class 10 IT
A. Multiple choice questions
1. Which of the following is NOT a type of text data type?
(a) Memo
(b) Varchar
(c) Float
(d) Char
Answer:(c) Float
2. A currency data type can only store monetary data that is in dollars.
(a) True
(b) False
(c) Neither a nor b
(d) Both a and b
Answer:(b) False
3. Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time
Answer:(c) Both date and time
4. Which of the following is true about LibreOffice Base?
(a) It is a spreadsheet software
(b) It is free and open source software
(c) It can store only character data
(d) It is a licensed software.
Answer:(b) It is free and open source software
5. Which of the following methods can be used to create a table in Base?
(a) Using a table wizard
(b) Design View
(c) Both a and b
(d) Neither a nor b
Answer:(c) Both a and b
Starting with LibreOffice Base Question Answer Class 10
6. The related objects of a database can be seen in _________ pane of the Base Database window.
(a) Database
(b) Task
(c) Title Bar
(d) Menu Bar
Answer:(a) Database
7. Which is the shortcut key to open an existing database?
(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F
Answer:(b) Ctrl+O
8. The Design view of Table Creation window in LibreOffice Base is divided into ______ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5
Answer:(a) 2
9. While entering records in a table, we can move to the next field by pressing the _________ key.
(a) Tab
(b) Ctrl
(c) Enter
(d) Shift
Answer:(a) Tab
10. Which of the following is true about primary key of a table?
(a) Every table must have a primary key
(b) The data values in primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above
Answer:(d) All of the above
Starting with LibreOffice Base Question Answer Class 10
B. State whether the following statements are True or False
1. The text data can contain special characters. [True]
2. Memo data type can be used to store descriptive data.[True]
3. A Boolean data type can have two or more than two values.[False]
4. We cannot store audio data in LibreOffice Base.[False]
5. The properties of a field change according to the data type selected.[True]
6. Field description may or may not be entered while designing a table.[True]
7. A table once created in a database cannot be edited.[False]
8. Sort dialog box can only help to sort data in ascending order.[True]
Starting with LibreOffice Base Question Answer Class 10
C. Fill in the blanks
1. A ___________ refers to the type of data that will be stored in that particular field.
Data type
2. The __________ data is a combination of letters, numbers or special characters.
Text
3. ________ data type can be used to store Aadhar number.
Text
4. The __________ data type used to store digitized images.
Binary
5. The shortcut key to save a table is _______________.
Ctrl+S
6. ______________ on the Base Interface Window displays information about the type of view of the object in the
database.
Tasks Pane
7. A __________ icon appears before the field name indicating that it is a primary key.
Key
8. The data can be entered in a table only in __________ view.
Datasheet
9. The black pointing arrow just before the field name in a table is called ____________.
Record pointer
10. The process of arranging the records in particular order on any filed is called _______________.
Sorting
Starting with LibreOffice Base Question Answer Class 10
D. Answer the given questions
1. Differentiate between:
(a) Memo and Varchar data type
Answer:
Memo: Used for large text entries; can store up to 2 GB of data.
Varchar: Used for shorter text entries; stores a specified maximum length of characters, typically up to 255 characters.
(b) Number and Decimal data type
Answer:
Number: Used for general numeric values, including integers and floating-point numbers.
Decimal: Used for precise numeric values with a fixed number of decimal places, ideal for financial calculations.
(c) Design View and Datasheet view of a table
Answer:
Design View: Used to define and modify the structure of a table, including fields, data types, and primary keys.
Datasheet View: Used to enter, edit, and view data in the table, displaying data in a grid format similar to a spreadsheet.
Starting with LibreOffice Base Question Answer Class 10
2. Name the menu items present on the Base User Interface,
Answer:
- 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.
Answer:
Title Bar: The top bar displaying the name of the application and the current database.
Database Pane: The section that lists database objects such as Tables, Queries, Forms, and Reports.
Tasks Pane: The area where tasks related to the selected database object are shown.
Status Bar: The bottom bar providing information about the current status of the database and operations.
Starting with LibreOffice Base Question Answer Class 10
4. How can we define a primary key in a table?
Answer:
- Open the table in Design View.
- Select the field (or combination of fields) to be the primary key.
- Right-click on the selected field(s) and choose Primary Key from the context menu, or click the Primary Key icon in the toolbar.
5. Write steps to sort the table in descending order of primary key.
Answer:
- Open the table in Datasheet View.
- Click on the column header of the primary key field to select it.
- Click the Sort Descending button (Z→A) in the toolbar, or right-click on the column header and select Sort Descending from the context menu.
6. What is the use of navigation box with respect to tables in a database?
Answer: The navigation box allows users to move through the records in a table. It provides buttons to go to the first, previous, next, and last record, as well as options to add new records and search for specific records. This facilitates easy data entry and browsing within the table.
You May also Check:
Class 10 IT 402 Chapter wise Important Questions
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1: Introduction to Styles
Chapter 2: Working with Images
Chapter 3: Advanced Features of Writer
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4: Analyse Data using Scenarios and Goal Seek
Chapter 5: Using Macros in Spreadsheet
Chapter 6: Linking Spreadsheet Data
Chapter 7: Share and Review a Spreadsheet
Unit 3: Database Management System using LibreOffice Base
Chapter 8: Introduction to Database Management System
Chapter 10: Working with Multiple Tables
Chapter 11: Queries in Base
Chapter 12: Forms and Reports
Unit 4: Maintain Healthy, Safe and Secure Working Environment
Chapter 13: Health, Safety and Security at Workplace
Chapter 14: Workplace Quality Measures
Chapter 15: Prevent Accidents and Emergencies