LibreOffice Base Quiz

Nisha wants to create a customer database for her small business. She wants to ensure each customer's email address is unique. Which key should she use in LibreOffice Base?

Vikram needs to create a report in LibreOffice Base that lists all products with prices above a certain threshold. Which feature should he use?

Ravi is building a relational database in LibreOffice Base and wants to connect two tables so that every entry in the 'Orders' table corresponds to a valid entry in the 'Customers' table. What feature should he use?

Shalini needs to automate the generation of monthly sales reports from her LibreOffice Base database. What feature should she use to perform this task automatically?

An organization wants to create a database of its employees, ensuring no two employees have the same ID number. Which constraint should be applied to the ID field?

Which type of query in LibreOffice Base allows you to combine data from multiple tables?

Match the following database terms with their correct definitions: Column A (Terms) A. Primary Key B. Foreign Key C. Index D. Composite Key Column B (Definitions) 1. Unique identifier for each record in a table 2. Connects records in one table to records in another table 3. Improves search performance 4. Combination of two or more columns to uniquely identify a record

Which feature in LibreOffice Base would you use to create a user-friendly interface for data entry?

To enforce referential integrity between two tables, which of the following should be used?

Which type of relationship between tables ensures that every record in one table is associated with one or more records in another table?