WorksheetsLibreOffice Base Quiz
Total questions: 76
Worksheet time: 51mins
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
Which command in LibreOffice Base is used to create a relationship between two tables?
Create Table
Design View
Relationships
Form Wizard
Match the following SQL commands with their purposes: Column A (SQL Commands) A. SELECT B. INSERT C. UPDATE D. DELETE Column B (Purposes) 1. Retrieves data from the database 2. Adds new records to a table 3. Modifies existing records in a table 4. Removes records from a table
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-4, B-3, C-2, D-1
A-3, B-4, C-1, D-2
Which of the following is used to enforce data integrity and establish relationships between tables in LibreOffice Base?
Primary Key
Foreign Key
Index
Macro
True or False: A form in LibreOffice Base can only be used to enter data into one table at a time.
Assertion-Reasoning Question: Assertion (A): A report in LibreOffice Base is used to display formatted data. Reason (R): Reports cannot include data from multiple tables.
Both A and R are true, and R is the correct explanation of A.
Both A and R are true, but R is not the correct explanation of A.
A is true, but R is false.
A is false, but R is true.
What is the purpose of the 'Form Wizard' in LibreOffice Base?
To create tables
To automate repetitive tasks
To design forms for data entry
To format reports
Which component of LibreOffice Base helps in creating queries without writing SQL code?
SQL Command
Query Design View
Report Wizard
Macro
What is the main function of a 'Primary Key' in a database table?
To perform calculations
To uniquely identify each record
To connect two tables
To sort data
You need to ensure that a column in a table does not have duplicate values. Which constraint should be applied?
Primary Key
Foreign Key
Unique Key
Check Constraint
Which type of query in LibreOffice Base is used to perform calculations on data?
Select Query
Action Query
Crosstab Query
Update Query
Which of the following is used to create a new table in LibreOffice Base?
Form Wizard
Query Design
Table Wizard
Report Wizard
Match the following database objects in LibreOffice Base with their functionalities: Column A (Database Objects) A. Table B. Form C. Query D. Report Column B (Functionalities) 1. Stores data in rows and columns 2. Provides a user-friendly way to enter and modify data 3. Retrieves specific data based on criteria 4. Formats data for presentation or printing
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
True or False: You can use the Form Wizard in LibreOffice Base to create forms that display data from multiple tables.
What is the main purpose of using the 'Relationships' tool in LibreOffice Base?
To connect a database to an external application
To link tables based on common fields
To import data from another database
To backup the database
Assertion-Reasoning Question: Assertion (A): A query is used to update records in a table. Reason (R): Queries allow users to filter, sort, and manipulate data.
Both A and R are true, and R is the correct explanation of A.
Both A and R are true, but R is not the correct explanation of A.
A is true, but R is false.
A is false, but R is true.
Which SQL clause is used to sort the results of a query in LibreOffice Base?
WHERE
ORDER BY
GROUP BY
HAVING
To create a relationship between tables, which type of field must exist in both tables?
Primary Key
Foreign Key
Text Field
Index Field
Which type of join is used to combine rows from two or more tables, based on a related column between them?
INNER JOIN
OUTER JOIN
CROSS JOIN
SELF JOIN
True or False: In LibreOffice Base, a report can be created to display the result of a query.
Which feature in LibreOffice Base allows for the automatic generation of unique values for a primary key field?
Autonumber
Index
Foreign Key
Data Type
Which of the following is used to create a new table in LibreOffice Base?
Form Wizard
Query Design
Table Wizard
Report Wizard
Match the following database objects in LibreOffice Base with their functionalities: Column A (Database Objects) A. Table B. Form C. Query D. Report Column B (Functionalities) 1. Stores data in rows and columns 2. Provides a user-friendly way to enter and modify data 3. Retrieves specific data based on criteria 4. Formats data for presentation or printing
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
True or False: You can use the Form Wizard in LibreOffice Base to create forms that display data from multiple tables.
What is the main purpose of using the 'Relationships' tool in LibreOffice Base?
To connect a database to an external application
To link tables based on common fields
To import data from another database
To backup the database
Assertion-Reasoning Question: Assertion (A): A query is used to update records in a table. Reason (R): Queries allow users to filter, sort, and manipulate data.
Both A and R are true, and R is the correct explanation of A.
Both A and R are true, but R is not the correct explanation of A.
A is true, but R is false.
A is false, but R is true.
Which SQL clause is used to sort the results of a query in LibreOffice Base?
WHERE
ORDER BY
GROUP BY
HAVING
To create a relationship between tables, which type of field must exist in both tables?
Primary Key
Foreign Key
Text Field
Index Field
Which type of join is used to combine rows from two or more tables, based on a related column between them?
INNER JOIN
OUTER JOIN
CROSS JOIN
SELF JOIN
True or False: In LibreOffice Base, a report can be created to display the result of a query.
Which feature in LibreOffice Base allows for the automatic generation of unique values for a primary key field?
Autonumber
Index
Foreign Key
Data Type
Which of the following is used to create a new table in LibreOffice Base?
Form Wizard
Query Design
Table Wizard
Report Wizard
base index improves search performance by providing a quick way to look up data.
True
False
Match the following SQL clauses with their functions in LibreOffice Base: Column A (SQL Clauses) Column B (Functions) A. WHERE 1. Filters records based on a condition B. GROUP BY 2. Groups rows that have the same values in specified columns C. HAVING 3. Filters groups based on a condition D. SELECT 4. Retrieves specific data from a table
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
What is the purpose of using a 'Query Design View' in LibreOffice Base?
To manually write SQL code
To visually build and modify queries
To format data in a report
To enter data into a form
Which key constraint ensures that all values in a column are unique and not null?
Primary Key
Foreign Key
Unique Constraint
Index
True or False: A database form can include sub-forms that display related data from different tables in LibreOffice Base.
True
False
Which type of query in LibreOffice Base is used to change existing records in a table?
Select Query
Update Query
Delete Query
Make-Table Query
Which tool in LibreOffice Base allows you to create, edit, and manage relationships between tables?
Relationship Designer
Table Wizard
Query Wizard
Report Wizard
What is the function of a 'Foreign Key' in a relational database?
To uniquely identify each record in a table
To create a copy of another table
To link records between two tables
To create indexes for faster searching
Which feature in LibreOffice Base allows you to create a graphical representation of table relationships?
Table Wizard
Relationship Designer
Report Wizard
Query Designer
True or False: The 'Form Wizard' in LibreOffice Base can only be used to create forms for a single table.
True
False
Match the following types of queries in LibreOffice Base with their purposes: Column A (Types of Queries) Column B (Purposes) A. Select Query 1. Retrieves data from one or more tables B. Update Query 2. Modifies data in existing records C. Delete Query 3. Removes records from a table D. Make-Table Query 4. Creates a new table using query results
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-4, B-3, C-2, D-1
A-3, B-4, C-1, D-2
What is the primary purpose of using a 'Primary Key' in a table in LibreOffice Base?
To uniquely identify each record in the table
To link two tables together
To allow duplicate values in a table
To store large amounts of text data
Which SQL keyword is used to retrieve unique records from a table in LibreOffice Base?
SELECT DISTINCT
SELECT UNIQUE
SELECT NEW
SELECT EXCLUSIVE
True or False: In LibreOffice Base, you can use the 'Query Design View' to visually create and modify SQL queries without writing SQL code.
True
False
Which tool in LibreOffice Base is used to create a detailed printout of data from a table or query?
Report Wizard
Form Wizard
Query Designer
Relationship Designer
To enforce a rule that a field must always contain a value, which constraint should be used in LibreOffice Base?
UNIQUE
CHECK
NOT NULL
DEFAULT
What type of join in LibreOffice Base returns only matching records from both tables?
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
INNER JOIN
Which of the following views in LibreOffice Base allows you to enter data directly into the table?
Form View
Table Data View
Query Design View
SQL View
True or False: In LibreOffice Base, a form can be created to allow users to input data into multiple related tables simultaneously.
True
False
Which SQL statement is used to delete all records from a table in LibreOffice Base?
DELETE * FROM table_name;
DROP TABLE table_name;
DELETE FROM table_name;
REMOVE FROM table_name;
Match the following database operations in LibreOffice Base with their descriptions: Column A (Database Operations) Column B (Descriptions) A. Create Table 1. Defines the structure of a new table B. Insert Data 2. Adds new records to an existing table C. Update Data 3. Modifies existing records in a table D. Delete Data 4. Removes records from a table
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-4, B-3, C-2, D-1
A-3, B-4, C-1, D-2
True or False: A relationship in LibreOffice Base can be created using both primary and foreign keys.
True
False
Which type of constraint is used to enforce a specific condition for data in a table in LibreOffice Base?
Default Constraint
Foreign Key Constraint
Check Constraint
Unique Constraint
Which option in LibreOffice Base allows for creating a report with a specific layout for printing?
Form Wizard
Report Wizard
Query Wizard
Macro Wizard
To display data from two related tables where there is a match between the fields in LibreOffice Base, which SQL join type would be used?
INNER JOIN
OUTER JOIN
CROSS JOIN
LEFT JOIN
Which SQL statement in LibreOffice Base is used to modify the structure of an existing table?
CREATE TABLE
ALTER TABLE
DROP TABLE
INSERT INTO
Which feature in LibreOffice Base can be used to enforce data integrity by ensuring data entered in one table corresponds with data in another table?
Primary Key
Foreign Key
Index
Default Value
True or False: A 'Composite Key' in LibreOffice Base is a primary key that consists of two or more fields.
True
False
Which SQL statement is used to add a new record to a table in LibreOffice Base?
INSERT INTO
ADD RECORD
ADD TO TABLE
INSERT NEW
Match the following SQL clauses with their purposes: Column A (SQL Clauses) Column B (Purposes) A. ORDER BY 1. Sorts the result set of a query B. GROUP BY 2. Groups rows sharing a property into summary rows C. HAVING 3. Filters groups created by the GROUP BY clause D. JOIN 4. Combines rows from two or more tables
A-2, B-1, C-4, D-3
A-1, B-2, C-3, D-4
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
True or False: In LibreOffice Base, the 'Report Wizard' helps create reports that summarize data from tables or queries.
True
False
Which of the following is NOT an SQL data type in LibreOffice Base?
VARCHAR
INT
DATE
BOOLEANSTRING
Which tool in LibreOffice Base allows you to visually represent the relationships between different tables in a database?
Relationship Window
Form Designer
Query Wizard
SQL Editor
To prevent a field from being left empty in a table, which constraint should be applied in LibreOffice Base?
CHECK
UNIQUE
NOT NULL
DEFAULT
True or False: An SQL query in LibreOffice Base can be used to insert, update, delete, or retrieve data from the database.
True
False
