CBSE 10th class Unit 3: Chapter 4 QUERIES IN BASE

 

Unit 3: 
Chapter 4
QUERIES IN BASE

A. Multiple Choice Questions

1.      (c) Query

2.      (d) All of the above

3.      (b) Design View

A. Multiple Choice Questions

4.      (c) Three

5.      (d) A query once created cannot be edited

6.      (c) F5

7.      (d) All of the above

8.      (a) >

9.      (d) Add Form

10.  (c) Add Table or Query

11.  (c) Summarizing

B. State whether the following statements are True or False

1. False
2. False
3. True
4. True
5. False
6. True
7. True
8. False
9. True
10. True
11. False

C. Fill in the blanks

1. A query is a sort of question asked from a database.
2. The result of the query is displayed in table form with field names in columns.
3. A query can be created in two ways.
4. The Query Design window is divided into three sections.
5. The shortcut key to run the query is F5.
6. The conditions to filter the records are set in the criteria row.
7. When a table is selected in a Query wizard, the corresponding fields are displayed in the fields list box.
8. The result of the query can be displayed in the order of any particular field of the table.
9. At the most five search conditions can be given in the query wizard.
10. The last step of the Query wizard displays the entire structure of the query.
11. The Design view is a more flexible method to create a query.
12. To edit any query, right click on the query icon of the query that has to be edited.
13. In the field name row of the Query Design grid, we can type the column heading that will be displayed instead of the field name when we run the query.

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 or question posed to a database to retrieve specific information. It allows you to extract relevant data from one or more tables based on specific criteria. Creating queries is essential for:

• Data retrieval: Extracting specific information needed for analysis or reporting.
• Data manipulation: Modifying data, such as updating or deleting records.
• Data analysis: Performing calculations and generating summaries based on the data.
• Data integration: Combining data from multiple tables to create a unified view.
1. Rearrange the steps given below so as to create a query using a wizard.

Here's the correct order:

1. Give table name
2. Select the fields
3. Set the criterion
4. Set the sorting order
5. Give Alias
2. What all information is seen in the overview (last step) of the Query wizard?

The overview step typically displays:

• The table names involved in the query.
• The selected fields and their aliases.
• The criteria used to filter the data.
• The sorting order specified for the results.
3. What is the use of Alias row in the Design grid of the Query Design window?

The Alias row allows you to assign user-friendly names to fields in the query results. This can make the output more readable and understandable, especially when dealing with complex queries or long field names.

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

Some common mathematical functions used in queries include:

• SUM: Calculates the sum of values.
• AVG: Calculates the average of values.
• COUNT: Counts the number of records.
• MAX: Finds the maximum value.
• MIN: Finds the minimum value.
5. Name the three ways of creating a query in LibreOffice Base?

The three primary ways to create a query in LibreOffice Base are:

• Query Wizard: A step-by-step guided approach for creating simple queries.
• SQL View: Allows you to write SQL (Structured Query Language) statements directly to create complex queries.
• Design View: Provides a visual interface to design queries by dragging and dropping fields and setting criteria.