Chapter 11 Queries in Base Question Answer Class 10 IT using LibreOffice CBSE Python

Chapter 11 Queries in Base Question Answer Class 10 IT

A. Multiple choice questions

1. Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database

Answer:(d) Database

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) All of the above

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) Design View

4. Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four

Answer:(b) Two

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) A query once created cannot be edited

6. Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6

Answer:(c) F5

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) 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?
(a) >
(b) < 9
(c) ∨
(d) ∧

Answer:(a) >

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) Add Form

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) 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?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables

Answer:(c) Add Table or Query

B. State whether the following statements are True or False

1. You can run a query only once. [False]

2. A query cannot be created from multiple tables.[False]

3. The shortcut key to run a query is F5.[True]

4. LibreOffice Base provides us with two ways to create a query.[False]

5. A query with numerical data cannot be saved.[False]

6. By default the query result is not sorted. [True]

7. A query can be used to display the average value of a numerical field.[True]

8. While designing a query, the criterion can be set on only one field.[True]

9. Alias is an alternative name for a field in a query.[False]

10. In query Design window, the visible check box is selected by default.[True]

11. A query once created using a wizard can only be edited in the Design view.[True]

C. Fill in the blanks

1. A ____________ is a sort of question asked from a database.

Query

2. The result of the query is displayed in ____________ form with field names in columns

Report

3. A query can be created in ________ways.

Three

4. The Query Design window is divided into __________ sections.

two

5. The shortcut key to run the query is ______________.

6. The conditions to filter the records are set in the _________ row.

Criterion

7. When a table is selected in a Query wizard, the corresponding fields are displayed in the ___________list box.

Available fields

8. The result of the query can be displayed in __________ or _________ order of any particular field of the table.

ascending, descending

9. At the most __________ search conditions can be given in the query wizard.

three

10. The last step of the Query wizard displays the entire ____________ of the query.

Overview

11. The _____________ view is a more flexible method to create a query.

Design

12. To edit any query, right click on the ________ icon of the query that has to be edited.

Query

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.

Alias

D. Answer the given questions

1. Define a query? What is the need of creating a query in a database?

A query is a request to a database system to retrieve specific information. It allows you to extract relevant data from one or more tables based on certain conditions.

Need for creating a query:

Data Retrieval: To extract specific data from the database.
Data Analysis: To analyze data by applying various functions and calculations.
Data Manipulation: To modify data by updating, inserting, or deleting records.
Report Generation: To generate reports based on the extracted data.

2. Rearrange the steps given below so as to create a query using a wizard.
Give Alias
Select the fields
Set the criterion
Set the sorting order
Give table name

Give table name
Select the fields
Set the criterion
Set the sorting order
Give Alias

3. What all information is seen in the overview (last step) of the Query wizard?

In the overview step of the Query wizard, you typically see:

Table and Field Names: A list of the tables and fields included in the query.
Criteria: The conditions used to filter the data.
Sort Order: The order in which the results will be sorted.
Alias Names: The alternative names given to fields or tables.
SQL Statement: The underlying SQL query that will be executed.

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

The Alias row in the Query Design window allows you to assign alternative names to fields or tables. This can be useful for:

Clarity: Making the query more readable by using shorter or more descriptive names.
Avoiding Ambiguity: Resolving naming conflicts when multiple tables have fields with the same name.
Customization: Tailoring the output to specific needs.

5. Name any four mathematical functions that can be applied to numerical data in a query.

SUM: Calculates the sum of values.
AVG: Calculates the average of values.
COUNT: Counts the number of values.
MAX: Finds the maximum value.
MIN: Finds the minimum value.

6. Name the three ways of creating a query in LibreOffice Base?

Query Wizard: A step-by-step wizard that guides you through the query creation process.
SQL View: Allows you to write SQL queries directly.
Query Design: A visual interface where you can drag and drop fields and set criteria.

You May also Check:

Class 10 IT 402 Chapter wise Important Questions

Chapter 11 Queries in Base Question Answer Class 10 IT using LibreOffice