It

Question 1

What is a query and its need?

Answer 1

A query is used to collect specific information from a pool of data.

Queries are required to retrieve the desired data easily and accurately from database

Question 2

What is the use of Alias row in the Design grid of the Query Design window?

Answer 2

Alias can be used to display meaningful names of the fields in the output when field names are not user friendly.

Question 3

What are four mathematical function that can be applied to numerical data in a query?

Answer 3

Sum
Average
Maximum
Minimum

Question 4

Name the three ways of creating a query in LibreOffice Base

Answer 4

Three ways of creating a query in LibreOffice Base are:
* Design View
* Use Wizard
* SQL view

These methods allow users to customize and execute queries based on their needs.

Question 5

What are the advantages of relating a table in a database?

Answer 5

A relationship can help prevent data redundancy.

Creating relationships between tables restricts the user from entering invalid data in the referenced fields.

Any updation in the master table is automatically reflected in the transaction tables.

Question 6

What is Referential Integrity?

Answer 6

Referential Integrity is the control of redundancy or inconsistency in a database by setting the relationship between tables.

Question 7

Who maintains referential integrity in a database?

Answer 7

Referential integrity is maintained by ensuring that records are not duplicated and that there are no variable data values for a particular field in two or more tables.

Question 8

What happens after creating a relationship between tables?

Answer 8

After creating a relationship between tables, adding or updating a record in one table reflects the changes in all the related tables.

Question 9

What is a One-to-One relationship?

Answer 9

In this type of relationship, one specific record of a master table has one and only one corresponding record in the transaction table.

Question 10

What is a One-to-Many relationship?

Answer 10

In this type of relationship, one specific record of the master table has more than one corresponding record in the related transaction table.

For example

Question 11

Ans. Many-to -Many relationship

Answer 11

In this type of relationship there will be multiple records in the master table that corresponds to multiple records in the transaction table as well.