CHAPTER-11(QUERIES IN BASE)
Ques:1 Define a query. What is the need of creating a query in a database?
Ans: Query: Query is used to retrieve the data from the database as per your requirement by
providing the desired specifications. Depending upon given specifications, the specific records are
searched from the database and then displayed in the desired manner.
Need of creating a query in a database: As, the number of records increase, finding the desired
information in a database becomes difficult. By using queries, we can retrieve the data without going
individually through each record in the table(s) and also display them in desired format.
Ques:2 Rearrange the steps given below so as to create a query using a wizard.
a) Give Alias
b) Select the fields
c) Set the criterion
d) Set the sorting order
e) Give table name
Ans:
a) Give table name
b) Select the fields
c) Set the sorting order
d) Set the criterion
e) Give Alias
Ques:3 What all information is seen in the overview(last step) of the Query wizard?
Ans: The last step of the Query wizard displays the entire Overview of the query. It includes the
following:
a) Name of Query: If desired, type the new name in the text box
b) The action to be performed after the wizard finishes: By default Display Query option will
be selected. Click and select the Modify Query radio button if the query has to be edited in
the Design view.
c) Complete detail of the query: This section contains a summary about the query that has
been created.
Ques:4 What is the use of Alias row in the Design grid of the Query Design window?
Ans: Alias row is used to display meaningful names in the output. An Alias is an alternative name for
a field in a query.
Ques:5 Name any four mathematical functions that can be applied to numerical data in a query.
Ans: Mathematical functions that can be applied to numerical data in a query are:
Count
Sum
Minimum
Maximum
Average
Ques:6 Name the three ways of creating a query in LibreOffice Base?
Ans: A query can be created in three ways:
1. Using a Wizard
2. In Design View
3. In SQL view
