Exercise Answers — tap any question to reveal the answer and explanation.
1. Which of the following is refer to asking questions from the database?
Answer: (c) Query
Explanation: A query is a sort of question asked from a database to retrieve specific data.
2. Which of the following are the ways to design a query?
Answer: (d) All of the above
Explanation: A query can be created using a Wizard, in Design View, or in SQL view.
3. Which is a flexible way to create a query?
Answer: (b) Design View
Explanation: Design View is a more flexible method to create a query from either a single or multiple tables, compared to the Wizard.
4. Into how many parts is the query design window divided?
Answer: (b) Two
Explanation: It is divided into the Table Pane (top, showing the added tables) and the Design grid (lower half, for fields, sorting and criteria).
5. Which of the following is NOT true about queries?
Answer: (d) A query once created cannot be edited
Explanation: A query can always be edited later in Design view; this statement is false.
6. Which of the following is the shortcut key to run the query?
Answer: (c) F5
7. Which of the following functions can be performed on numerical data while designing a query?
Answer: (d) All of the above
8. In a Query Design wizard, which of the following buttons is clicked to move a field from 'Available fields' list box to 'Fields in the query' list box?
Answer: (a) >
9. Which of the following relational operators can be applied to set the criterion while designing a query in LibreOffice Base?
Answer: (a), (b) and (c)
Explanation: >, = and != are all valid relational operators that can be applied to a criterion (the chapter states operators like <, >, <=, >=, != and = can all be used). "Add Form" (d) is not a relational operator at all.
10. Which of the following dialog box is present when the Query Design window is opened for the first time to design a query?
Answer: (c) Add Table or Query
11. Which of the following step is not performed if there is no numerical data to be worked upon in a query?
Answer: (c) Summarizing
Explanation: The steps dealing with summarizing and numerical calculations are skipped when there is no numeric field involved in the query.
Answer: False
Explanation: A saved query can be run multiple times as and when required.
Answer: False
Explanation: A query can retrieve and display data from a single table or from multiple tables.
Answer: True
Answer: False
Explanation: It provides three ways: using a Wizard, in Design View, and in SQL view.
Answer: False
Explanation: A query using mathematical functions can be saved just like any other query.
Answer: True
Answer: True
Answer: False
Explanation: Multiple conditions/criteria can be set on more than one field in the Criterion row.
Answer: True
Answer: True
Answer: True
Answer: Query
Answer: Tabular
Answer: Three
Answer: Two
Answer: F5
Answer: Criterion
Answer: Available Fields
Answer: Ascending; Descending
Answer: Three
Answer: Overview
Answer: Design
Answer: Query
Answer: Alias
Answer: A query is a sort of question asked from a database; it is used to retrieve and display specific data from one or more tables based on given search criteria. Queries are needed because, as the number of records in a table increases, finding the desired information by browsing manually becomes difficult and time-consuming. Using a query, we can retrieve the exact information we want, without going through each record individually, and display it in a desired, organised format.
Answer:
Answer:
Answer: The Alias row lets us assign an alternative, more meaningful/user-friendly name to a field, which is displayed as the column heading in the query result instead of the actual (often less readable) field name.
Answer: Sum, Average, Minimum, and Maximum.
Answer: Using a Wizard, In Design View, and In SQL view.