In this article I am going to discuss NCERT Solutions Chapter 9 Starting with LibreOffice Base. Lets start!
Topics Covered
NCERT Solutions Chapter 9 Starting with LibreOffice Base
As NCERT exercises includes MCQs, True or False, Fill in the blanks and short/long answer questions. So let see them section wise. Here we go for NCERT Solutions Chapter 9 Starting with LibreOffice Base.
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
[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
[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
[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.
[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
[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
[7] Which is the shortcut key to open an existing database?
(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F
[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
[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
[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
Now lets discuss type B questions. Type consists of questions of True or False. Lets disucss!
B. State whether the following statements are True or False
[1] The text data can contain special characters.
[2] Memo data type can be used to store descriptive data.
[3] A Boolean data type can have two or more than two values.
[4] We cannot store audio data in LibreOffice Base.
[5] The properties of a field change according to the data type selected.
[6] Field description may or may not be entered while designing a table.
[7] |< is pressed to move to the last record.
[8]
appears when the record is being edited.
[9] A table once created in a database cannot be edited.
[10] Sort dialog box can only help to sort data in ascending order.
In the next section I am going to discuss Type C questions which are Fill in the blanks questions.
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 _________________ data is a combination of letters, numbers or special characters.
[3] ____________________ data type can be used to store Aadhar number.
[4] The ___________ data type used to store digitized images.
[5] The shortcut key to save a table is _____________________.
[6] _____________ on the Base Interface Window displays information about the type of view of the object in the database.
[7] A ____________________ icon appears before the field name indicating that it is a primary key.
[8] The data can be entered in a table only in ______________ view.
[9] The black pointing arrow just before the field name in a table is called ______________.
[10] The process of arranging the records in particular order on any filed is called _____________.
D. Answer the given questions
[1] Differentiate between:
(a) Memo and Varchar data type
(b) Number and Decimal data type
(c) Design View and Datasheet view of a table
| Memo | Varchar |
| It is used to store up to maximum length data indicated by user. | It is used to store up to the specified length by user. |
| It can store the descriptive values having more than 255 characters. It can store data up to 64,000 characters. | It can store text values up to 255 characters. |
| It can store values like remarks, address, description etc. | It can store values like names, cities, locations, any other short texts having various length characters. |
| Number | Decimal |
| It can store number as exactly as precise it can defined. | It allows higher numbers and can store more digits than specified |
| If user has specified Numeric(6,2) that means 6 total digitals with 2 decimal places. No more or no less digits before or after decimals. | If user has specified Decimal(6,2) that means 1-6 total digitals with 2 decimal places. Means it can store 11.56 but not 11.005. |
| In this data type 0 is automatically ignored and not displayed in the value. For example, the value 6000.50 will be accepted as 6000.5 | It accept 0s in value. For example the 6000.50 will be accepted as 6000.50 |
| Design View | Datasheet View |
| It is not a default view of a database table. | It is a default view of database table. |
| It shows only field names and data types of fields of the table but no records. | It shows all the records of tables entered by user along with fields title. |
| It allows to create or change the table structure only. | It allows to change information entered in the table. |
| Row does not represent any record. As much fields are available in the table that much rows are displayed in design view. | Each row represents a record in the datasheet view. If five records are entered in the table, it displays five rows. |
[2] Name the menu items present on the Base User Interface.
Answer:
Base user interface offers these menu items:
- File – New, Open, Recent Documents, Close, Wizards, Save, Save As, Save All, Check out, Cancel Check out, Check in, Export, Send and Exit LibreOffice
- Edit – Undo, Cut, Copy, Paste, Paste Special, Select All, Open Database Object, Edit, Delete, Rename, Create as View, Edit in SQL view, Form Wizard, Report, Report Wizard, Database – Properties, Connection Type, Advanced Settings
- View – Tables, Queries, Forms, Reports, Toolbars, Status Bar, Sort Ascending, Sort Descending, Refresh Tables, Preview
- Insert – Form, Report, Report Wizard, Query (Design View), Query (SQL View), Table Design, View Design, View Simple, Folder
- Tools – Relationships, User Administration, Table Filter, SQL, Macros, XML Filter Settings, Extensions, Customize, Options
- Window – Close Window, Database
- Help – LibreOffice Help, What’s This?, User Guides, Show Tip of the Day, Get Help Online, Send Feedback, Restart in Safe Mode, Get Involved, Donate to LibreOffce, License Information, Check for Updates, About LibreOffice
[2] Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base User Interface.
Answer:
[3] How can we define a primary key in a table?
Answer:
Follow these steps to define primary key:
- To make a particular field as the primary key, place the mouse pointer before the field name, say Event Id in our above example and right click.
- A pop up menu appears. Select the Primary Key option from pop up menu.
- A key icon appears before the field name indicating that it is a primary key. Click on the key icon.
[4] Write steps to sort the table in descending order of primary key.
Answer:
To sort the table in descending order of primary key follow these steps:
- Open database and table in datasheet view.
- Select the Primary Key field.
- Click on Data > Sort Descending option or Sort Descending icon from toolbar.
- The fields and records gets sorted in descending order.
[5] What is the use of navigation box with respect to tables in a database?
Answer:
The navigation box is present at the bottom of datasheet view. It allows to navigate through various records in a database table. It indicates the current record of a table at any time. It has following components:
- Record Selector Box – It is a text box where the currently active record number is displayed. User may enter the record number to see in this text box.
- Navigation Buttons – These are used to scroll vertically in the table.
- |<: Used to move to first record
- > and <: Used to navigate to Next and Previous record
- >|: Used to move last record
- +: Used to insert a new record