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?

• Foreign Key

• Composite Key

• Unique Key

• Primary Key

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

• Forms

• Queries

• Tables

• Relationships

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?

• Primary Key

• Foreign Key

• Table Design

• Relationships

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?

• Macro

• Report Wizard

• Query Design

• Form Control

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?

• Primary Key

• Foreign Key

• Index

• Default Value

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

• Action Query

• Select Query

• Crosstab Query

• Update Query

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

• A-1, B-2, C-3, D-4

• A-2, B-1, C-4, D-3

• A-3, B-4, C-1, D-2

• A-4, B-3, C-2, D-1

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

• Table

• Report

• Query

• Form

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

• Primary Key

• Foreign Key

• Unique Key

• Index

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

• One-to-One

• One-to-Many

• Many-to-Many

• Self-Referencing