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 āĻšāϞ āĻĄাāϟাāĻŦেāχāϚ⧰ āĻĄাāϟা āϏুāϏংāĻ—āĻ িāϤ ā§°ূāĻĒāϤ āĻĒ্ā§°āĻĻā§°্āĻļāύ āϕ⧰া āĻāϟি āĻŦৈāĻļিāώ্āϟ্āϝ।)

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 āϤৈ⧟াā§° āϕ⧰াā§° āĻ•াāĻŽ āϕ⧰ে।)
 

 

 

 

EDIT BY : KRISHNA SAIKIA