Class 10 IT Chapter 9 Starting with LibreOffice Base Questions Answers

Class 10 IT Chapter 9 Starting with LibreOffice Base Questions Answers

Dear students, here I am providing exercise and additional questions answers of class 10 IT chapter 9 Starting with LibreOffice Base from Domestic Data Entry Operator book published by NCERT.

Check your Progress

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

Ans: (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

Ans: (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

Ans: (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.

Ans: (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

Ans: (c) Both a and b

6. 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

Ans: (d) All of the above

7. 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

Ans: (b) Task

8. Which is the shortcut key to open an existing database?
(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F

Ans: (b) Ctrl+O

9. The Design view of Table Creation window in LibreOffice
Base is divided into _______ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5

Ans: (a) 2

10. 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

Ans: (a) Tab

B. State whether the following statements are True or False

1. The text data can contain special characters. Ans: False
2. Memo data type can be used to store descriptive data. Ans: True
3. A Boolean data type can have two or more than two values. Ans: False
4. We cannot store audio data in LibreOffice Base. Ans: False
5. The properties of a field change according to the data Ans: True
   type selected.
6. Field description may or may not be entered while Ans: True
   designing a table.
7. <- is pressed to move to the last record. Ans: False
8. appears when the record is being edited. Ans: True
9. A table A table once created in a database cannot be edited. Ans: False
10. Sort dialog box can only help to sort data in ascending order. Ans: False

C. Fill in the blanks

1. A ___________ refers to the type of data that will be stored in
   that particular field.

Ans: data type

2. The _______ data is a combination of letters, numbers
or special characters.

Ans: Text

3. _________ data type can be used to store Aadhar number.

Ans: Numeric

4. The ________data type used to store digitized images.

Ans: Binary

5. The shortcut key to save a table is________.

Ans: Ctrl + S

6. ________on the Base Interface Window displays
information about the type of view of the object in the
database.

Ans: Tasks Pane

7. A _________ icon appears before the field name indicating
that it is a primary key.

Ans: Key

8. The data can be entered in a table only in _________view.

Ans: Datasheet

9. The black pointing arrow just before the field name in a
table is called ________.

Ans: Record Pointer

10. The process of arranging the records in particular order
on any filed is called_________.

Ans: Sorting

Class 10 IT Chapter 9 Starting with LibreOffice Base Questions Answers

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

Ans: (a) Memo and Varchar data type : Memo is used to store data into the maximum length indicated by user. It is used to store descriptive data having more than 255 characters.
Whereas Varchar data type stores data upto the specified length. It refers to a data type
of a field in a table which can store both letters and numbers.

Ans: (b) Number and Decimal data type : Number data type stores numbers in a table. The numbers can be integer or real numbers on which any type of arithmetic calculations can be performed.
Whereas Decimal data type is used to store numbers with decimal points

Ans: (c) Design View and Datasheet view of a table : Design view is used to specify the field names and their data types in a table whereas Datasheet view is used to enter values for the field names in a table

2. Name the menu items present on the Base User Interface.

Ans: The menu items present on the Base User Interface are –
i. File ii. Edit iii. Insert iv. Tools v. Window vi. Help

4. How can we define a primary key in a table ?

Ans : A primary key is a field or an attribute which uniquely identifies every record in a table. The value of
primary key is always unique.

5. Write steps to sort the table in descending order of primary key.

Ans: Ans : To sort the table in descending order of primary key we have to follow the steps given
below
i. Step 1: select the primary key field.
Ii. Step 2 : From the toolbar, click Sort descending icon.
iii. Step 3 : The table will be sorted in descending order of primary key

6. What is the use of navigation box with respect to tables in a database ?

Ans : The navigation box is used to navigate through the records of a table in a database.