Lesson 9
Starting With LibreOffice Base
đText Books PDF
đMCQ Online Exam
đMCQ Answer
đPaid Answer (For
Membership User)
1. What is LibreOffice Base? (LibreOffice Base āĻি?)
Answer: LibreOffice Base is a database management
software used to create, edit, and manage databases. It is part of the
LibreOffice suite.(LibreOffice Base āĻšāϞ
āĻĄাāĻাāĻŦেāĻāĻ āϏৃāώ্āĻিā§° āĻŦাāĻŦে āĻŦ্āĻ¯ā§ąāĻšৃāϤ LibreOffice-ā§° āĻ
āύ্āϤ⧰্āĻāϤ āĻāĻা āϏāĻĢ্āĻā§ąেā§াā§°।)
2. What is the purpose of LibreOffice Base? (LibreOffice
Base-ā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)Answer: It allows users to create and manage
databases.
It provides tools for data entry, storage, and retrieval.(LibreOffice Base-āĻ
āĻĄাāĻাāĻŦেāĻāĻ āϏৃāώ্āĻি, āĻŦ্āĻ¯ā§ąāϏ্āĻĨাāĻĒāύা,
āĻā§°ু āĻĒুāύ⧰ুāĻĻ্āϧাā§°ā§° āĻাāĻŽ āĻā§°ে।)
3. What is a table in LibreOffice Base? (LibreOffice
Base-āϤ Table āĻি?)
Answer: A table is a collection of rows and columns
that store data in a structured format. Each row is a record and each
column is a field.(Table āĻšāϞ āĻĄাāĻাāĻŦেāĻāĻāϤ
āĻĄাāĻা āϏংā§°āĻ্āώāĻŖā§° āĻŦাāĻŦে āĻŦ্āĻ¯ā§ąāĻšৃāϤ Rows āĻā§°ু Columns-āĻ āĻāĻ িāϤ āĻāĻ āĻāĻ āύ।)
4. What is a field in LibreOffice Base? (LibreOffice
Base-āϤ Field āĻি?)Answer: A field is a column in a table that stores a
specific type of data.
For example: Name, Age, or Address.(Field āĻšāϞ āĻেāĻŦুāϞ⧰ āĻāϞাāĻŽ
āϝ'āϤ āĻŦিāĻļেāώ āϧ⧰āĻŖā§° āϤāĻĨ্āϝ āϏংā§°āĻ্āώāĻŖ āĻā§°া āĻšā§।)
5. What is a record in LibreOffice Base? (LibreOffice
Base-āϤ Record āĻি?)Answer: A record is a row in a table that contains
specific information.
Each record represents one entry in the database.(Record āĻšāϞ āĻেāĻŦুāϞ⧰ Row
āϝ'āϤ āĻāĻা
āϏāĻŽ্āĻĒূā§°্āĻŖ āϤāĻĨ্āϝ āĻĨাāĻে।)
6. What is the use of the Primary Key in LibreOffice
Base? (LibreOffice Base-āϤ Primary
Key-ā§° āĻŦ্āĻ¯ā§ąāĻšাā§° āĻি?)Answer: The primary key uniquely identifies each
record in the table.
It prevents duplicate entries.(Primary Key-āĻ
āĻেāĻŦুāϞāϤ āĻĒ্ā§°āϤিāĻো Record āĻিāύাāĻ্āϤ āĻā§°ে
āĻā§°ু āĻāĻে āĻĄাāĻা āĻĒুāύ⧰াāĻŦৃāϤ্āϤি ā§°োāϧ āĻā§°ে।)
7. What is a query in LibreOffice Base? (LibreOffice
Base-āϤ Query āĻি?)Answer: A query is used to retrieve specific data
from a database.
It allows filtering, sorting, and combining data from
multiple tables.(Query āĻšāϞ āĻĄাāĻাāĻŦেāĻāĻā§°
āĻĒā§°া āύিāϰ্āĻĻিāώ্āĻ āϤāĻĨ্āϝ āĻāϞিā§াāĻ āĻ
āύাā§° āĻ
āύুā§°োāϧ।)
8. What is a form in LibreOffice Base? (LibreOffice
Base-āϤ Form āĻি?)Answer: A form is a user-friendly interface used to
enter, edit, and view data in the database.(Form āĻšāϞ āĻāĻা
āĻĄাāĻাāĻŦেāĻāĻāϤ āĻĄাāĻা āĻĒ্ā§°ā§ąিāώ্āĻ āĻā§°াāĻো āϏāĻšāĻ āĻā§°ি āϤোāϞে।)
9. What is a report in LibreOffice Base? (LibreOffice
Base-āϤ Report āĻি?)
Answer: A report is used to display data in a
structured and readable format.
It helps in presenting data for printing or sharing.
(Report āĻšāϞ āĻĄাāĻাāĻŦেāĻāĻā§°
āĻĄাāĻা āϏুāϏংāĻāĻ িāϤ ā§°ূāĻĒāϤ āĻĒ্ā§°āĻĻā§°্āĻļāύ āĻā§°া āĻāĻি āĻŦৈāĻļিāώ্āĻ্āϝ।)
It provides tools for data entry, storage, and retrieval.
For example: Name, Age, or Address.
Each record represents one entry in the database.
It prevents duplicate entries.
It allows filtering, sorting, and combining data from multiple tables.
10. What are the different types of data types in
LibreOffice Base? (LibreOffice Base-āϤ āĻĄাāĻা
āĻাāĻāĻĒāϏāĻŽূāĻš āĻি?)Answer: Text – For storing text.
Integer – For whole numbers.
Date/Time – For date and time values.
Boolean – For true/false values.(Text, Integer, Date/Time, āĻā§°ু Boolean
āĻšāϞ āĻĒ্ā§°āϧাāύ āĻĄাāĻা āĻাāĻāĻĒāϏāĻŽূāĻš।)
11. What is the difference between Table and Query? (Table
āĻā§°ু Query-ā§° āĻŽাāĻāϤ āĻĒাā§°্āĻĨāĻ্āϝ āĻি?)Answer: Table: Used to store raw data.
Query: Used to retrieve and filter specific data from
tables.(Table-āϤ āĻĄাāĻা āϏংā§°āĻ্āώāĻŖ
āĻā§°া āĻšā§, Query-āĻ āĻĄাāĻা āĻāϞিā§াāĻ
āĻāύে।)
12. What is the use of relationships in LibreOffice Base? (LibreOffice
Base-āϤ Relationships-ā§° āĻŦ্āĻ¯ā§ąāĻšাā§° āĻি?)Answer: Relationships link two or more tables based
on a common field.
It reduces data redundancy.(Relationships-āĻ
āĻāĻাāϧিāĻ Table-ā§° āĻŽাāĻāϤ āϏāĻŽ্āĻĒā§°্āĻ
āϏ্āĻĨাāĻĒāύ āĻā§°ে āĻā§°ু āĻĄাāĻা āĻĒুāύ⧰াāĻŦৃāϤ্āϤি ā§°োāϧ āĻā§°ে।)
13. How can we create a table in LibreOffice Base? (LibreOffice
Base-āϤ Table āĻেāύেāĻৈ āϏৃāώ্āĻি āĻā§°িāĻŦ?)Answer: Open LibreOffice Base → Click on Tables →
Click on Create Table in Design View → Add fields → Save the table.(LibreOffice Base āĻুāϞāĻ → Tables-āϤ āĻ্āϞিāĻ āĻā§°āĻ → Create
Table in Design View āĻ্āϞিāĻ āĻā§°āĻ → Field
āϝোāĻ āĻā§°āĻ → Save āĻā§°āĻ।)
14. What is the difference between Form and Report? (Form
āĻā§°ু Report-ā§° āĻŽাāĻāϤ āĻĒাā§°্āĻĨāĻ্āϝ āĻি?)Answer: Form: Used for entering and editing data.
Report: Used for presenting data in a readable format.(Form-āĻ āĻĄাāĻা
āĻĒ্ā§°ā§ąিāώ্āĻ āĻā§°ে, Report-āĻ āĻĄাāĻা
āĻĒ্ā§°āĻĻā§°্āĻļāύ āĻā§°ে।)
15. What are the functions of LibreOffice Base?(LibreOffice
Base-ā§° āĻাā§°্āϝ āĻি?)Answer: Data creation and management.
Query execution.
Generating reports.
Defining relationships between tables.(LibreOffice Base-āĻ āĻĄাāĻা
āϏৃāώ্āĻি, Query āĻāϞোā§ąা, āĻā§°ু Report āϤৈā§াā§° āĻā§°াā§° āĻাāĻŽ āĻā§°ে।)
Integer – For whole numbers.
Date/Time – For date and time values.
Boolean – For true/false values.
Query: Used to retrieve and filter specific data from tables.
It reduces data redundancy.
Report: Used for presenting data in a readable format.
Query execution.
Generating reports.
Defining relationships between tables.
EDIT BY : KRISHNA SAIKIA