Chapter 11 Queries in Base IT Code 402 Book Solution Class 10
Unit 3. Database Management System using LibreOffice Base
A. Multiple-choice questions.
Question 1:
Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database
Answer: (c)
Question 2:
Which of the following are the ways to design a query?
(a) Wizard
(b) Design View
(c) SQL
(d) All of the above
Answer: (d)
Question 3:
Which is a flexible way to create a query?
(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Answer: (b)
Question 4:
Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
Answer: (b)
Question 5:
Which of the following is NOT true about queries?
(a) It can be created using multiple tables.
(b) Multiple queries can be created in a database.
(c) A query can run multiple times.
(d) A query once created cannot be edited.
Answer: (d)
Question 6:
Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6
Answer: (c)
Question 7:
Which of the following functions can be performed on numerical data while designing a query?
(a) Sum
(b) Minimum
(c) Maximum
(d) All of the above
Answer: (d)
Question 8:
In a Query Design wizard, which of the following buttonsis clicked to move a field from ‘Available fields’ list box to ‘Fields in the query‘ list box?
(a) >
(b) < 9
(c) ∨
(d) ∧
Answer: (a)
Question 9:
Which of the following relational operators can be applied to set the criterion while designing a query in LibreOffice Base?
(a) >
(b) =
(c) !=
(d) Add Form
Answer: (d)
Question 10:
Which of the following dialog box is present when the Query Design window is opened for the first time to design a query?
(a) Add Table
(b) Add Query
(c) Add Table or Query
(d) None of the above
Answer: (c)
Question 11:
Which of the following step is not performed if there is no numerical data to be worked upon in a query?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables
Answer: (c)
B. State whether the following statements are True or False.
Question 1:
You can run a query only once.
Answer: False
Question 2:
A query cannot be created from multiple tables.
Answer: False
Question 3:
The shortcut key to run a query is F5.
Answer: True
Question 4:
LibreOffice Base provides us with two ways to create a query.
Answer: False
Question 5:
A query with numerical data cannot be saved.
Answer: False
Question 6:
By default the query result is not sorted.
Answer: True
Question 7:
A query can be used to display the average value of a numerical field.
Answer: True
Question 8:
While designing a query, the criterion can be set on only one field.
Answer: False
Question 9:
Alias is an alternative name for a field in a query.
Answer: True
Question 10:
In query Design window, the visible check box is selected by default.
Answer: True
Question 11:
A query once created using a wizard can only be edited in the Design view.
Answer: True
C. Fill in the blanks.
Question 1:
A __________ is a sort of question asked from a database.
Answer: Query
Question 2:
The result of the query is displayed in ___________ form with field names in columns.
Answer: Report
Question 3:
A query can be created in ________ ways.
Answer: Three
Question 4:
The Query Design window is divided into _________ sections.
Answer: two
Question 5:
The shortcut key to run the query is ________.
Answer: F5
Question 6:
The conditions to filter the records are set in the _________ row.
Answer: Criterion
Question 7:
When a table is selected in a Query wizard, the corresponding fields are displayed in the __________________ list box.
Answer: Available fields
Question 8:
The result of the query can be displayed in _________ or ___________ order of any particular field of the table.
Answer: ascending, descending
Question 9:
At the most _________ search conditions can be given in the query wizard.
Answer: three
Question 10:
The last step of the Query wizard displays the entire ________ of the query.
Answer: Overview
Question 11:
The ___________ view is a more flexible method to create a query.
Answer: Design
Question 12:
To edit any query, right-click on the __________ icon of the query that has to be edited.
Answer: Query
Question 13:
In the _______ row of the Query Design grid, we can type the column heading that will be displayed instead of field name when we run the query.
Answer: Alias
D. Answer the given questions.
Question 1:
Define a query. What is the need of creating a query in a database?
Answer: A query is used to collect specific information from the pool of data. A query helps us to join information from different tables and filter that information.
- Queries are required to retrieve and display data from one or more tables in a database.
- This is done by giving specific search criteria to the DBMS so that we are able to view the exact information that we want.
Question 2:
Rearrange the steps given below so as to create a query using a wizard.
- (i) Give Alias
- (ii) Select the fields
- (iii) Set the criterion
- (iv) Set the sorting order
- (v) Give table name
Answer:
- (i) Give table name
- (ii) Select the fields
- (iii) Set the sorting order
- (iv) Set the criterion
- (v) Give Alias
Question 3:
What all information is seen in the overview (last step) of the Query wizard?
Answer: The last step of the Query wizard displays the entire overview of the query. It includes the following:
- Name of the Query – By default, the name of the query is Query_Events by default. If desired, type the new name in the text box.
- 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.
- Complete detail of the query – This section contains a summary about the query that has been created.
Question 4:
What is the use of Alias row in the Design grid of the Query Design window?
Answer: Alias row can be used to display meaningful names in the output.
For example, instead of Winner, we would just like to display the Winner Name. For this, type Winner Name in the Alias text box under the Winner column.
Question 5:
Name any four mathematical functions that can be applied to numerical data in a query.
Answer: Four Mathematical functions are
- Count,
- Sum,
- Minimum,
- Maximum
- Average
Question 6:
Name the three ways of creating a query in LibreOffice Base.
Answer: A query can be created in three ways. These are –
- (i) Using a Wizard
- (ii) In Design View
- (iii) In SQL view
