Database Management System using LibreOffice Base

Topics in this chapter

• Database Fundamentals and DBMS
• Relational Database Design
• Tables, Keys and Constraints
• LibreOffice Base Setup
• Queries and SQL
• Forms and Reports

Cheat sheet

Practice questions

1. Question 1Q-9E700A

   Which of the following database objects is used to retrieve and display filtered data from one or more tables based on specific criteria in LibreOffice Base?

   1. A.Table
   2. B.Form
   3. C.Query
   4. D.Report
   See the answer and solution
2. Question 2Q-2686EA

   What is the primary purpose of a Primary Key in a relational database table?

   1. A.To encrypt sensitive user data
   2. B.To uniquely identify each record in a table and prevent duplicate or null values
   3. C.To increase the physical storage capacity of the database
   4. D.To create graphical user interface forms automatically
   See the answer and solution
3. Question 3Q-37CBFF

   Which data type in LibreOffice Base is most appropriate for storing large amounts of text, such as product descriptions or user reviews, exceeding standard character limits?

   1. A.VARCHAR
   2. B.MEMO (Long VARCHAR)
   3. C.INTEGER
   4. D.BOOLEAN
   See the answer and solution
4. Question 4Q-F3D335

   When creating a relationship between two tables, what is a Foreign Key?

   1. A.A key created using an external software tool outside LibreOffice Base.
   2. B.A field in one table that uniquely identifies a record in the same table.
   3. C.A field or set of fields in a child table that refers to the primary key of a parent table.
   4. D.A backup password used to secure the database backend.
   See the answer and solution
5. Question 5Q-372FFE

   Explain the difference between a Form and a Report in LibreOffice Base, keeping their primary functions in mind.

   See the answer and solution