Chapter 9. Starting with LibreOffice Base

Unit 3. Database Management System using LibreOffice Base

A. Multiple-choice questions.

Question 1:
Which of the following is NOT a type of text data type?
(a) Memo
(b) Varchar
(c) Float
(d) Char

Answer: (c) Float

Question 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

Question 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

Question 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

Question 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

Question 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

Question 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

Question 8:
The Design view of the Table Creation window in LibreOffice Base is divided into __________ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5

Answer: (a) 2

Question 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

Question 10:
Which of the following is true about the primary key of a table?
(a) Every table must have a primary key
(b) The data values in the 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

B. State whether the following statements are True or False.

Question 1:
The text data can contain special characters.

Answer: True

Question 2:
Memo data type can be used to store descriptive data.

Answer: True

Question 3:
A Boolean data type can have two or more than two values.

Answer: False

Question 4:
We cannot store audio data in LibreOffice Base.

Answer: False

Question 5:
The properties of a field change according to the data type selected.

Answer: True

Question 6:
Field descriptions may or may not be entered while designing a table.

Answer: True

Question 7:
is pressed to move to the last record.

Answer: False

Question 8:
appears when the record is being edited.

Answer: True

Question 9:
A table once created in a database cannot be edited.

Answer: False

Question 10:
Sort dialog box can only help to sort data in ascending order.

Answer: False

C. Fill in the blanks.

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

Answer: Data Type

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

Answer: Text

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

Answer: Text

Question 4:
The ______ data type is used to store digitized images.

Answer: Binary

Question 5:
The shortcut key to save a table is _________.

Answer: Ctrl + S

Question 6:
_________ on the Base Interface Window displays information about the type of view of the object in the database.

Answer: Tasks Pane

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

Answer: Key

Question 8:
The data can be entered in a table only in _________ view.

Answer: Datasheet

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

Answer: Record Pointer

Question 10:
The process of arranging the records in a particular order on any filed is called ____________.

Answer: Sorting

D. Answer the given questions.

Question 1:
Differentiate between:
(a) Memo and Varchar data type
(b) Number and Decimal data type
(c) Design View and Datasheet view of a table

Answer:

(a) Memo and Varchar Data Type

(b) Number Data Type and Decimal Data Type

(c) Design View and Datasheet view of a table

Question 2:
Name the menu items present on the Base User Interface,

Answer:

Question 3:
Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base User Interface.

Answer:

Question 4:
How can we define a primary key in a table?

Answer:

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

Answer:

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

Answer: