Smart Learning

Digital Learning

Thursday, October 9, 2025

What are Queries in Base? Class-10-Part:B-Unit:3-Ch:4:

by
on in


CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 4 Queries in libreoffice base

A. Fill in the blanks
Q1_______ allow you to retrieve, manipulate, and analyse data efficiently.
Answer: Queries
Q2_______ is the standard language for managing and manipulating relational databases.
Answer: SQL (Structured Query Language)
Q3An _______ in a query is a custom name assigned to a field to make the output more user-friendly.
Answer: Alias
Q4 In LibreOffice Base, the _______ is a tool that provides a step-by-step guide for creating queries without writing SQL code.
Answer: Query Wizard
Q5 In Design View, you can add tables and fields by dragging them from the table list into the _______.
Answer: Design Grid

B. True or False
Q1 The Query Wizard allows users to create complex queries without needing to know SQL.
Answer:  True
Q2 In Design View, users must write all SQL commands manually to create a query.
Answer:  False
Q3 Design View provides a visual interface for adding tables and fields to a query.
Answer:  True
Q4 The Query Wizard does not allow for sorting of results after the query is created.
Answer:  False
Q5 In Design View, you can specify which fields to include in the query by dragging them into the design grid.
Answer:  True
Q6 Users can switch between Design View and SQL View in LibreOffice Base while working on a query.
Answer:  True


C. Multiple Choice Questions
Q1 What is the primary purpose of the Query Wizard in LibreOffice Base?
A) To create new tables
B) To guide users in creating queries
C) To delete existing queries
D) To back up the database
Answer: B
Q2 Which of the following can you do in Design View when creating a query?
A) Write SQL commands directly
B) Drag and drop fields from tables
C) Set primary keys for tables
D) Create new tables
Answer: B
Q3 In Design View, how can you specify criteria for filtering data?
A) By using the SQL command directly
B) By entering conditions in the Criteria row for a field
C) By changing the data type of the field
D) By selecting the Sort Ascending option
Answer: B
Q4 What type of information can you sort in a query using Design View?
A) Only text fields
B) Only numeric fields
C) Any field including text, numeric, and date fields
D) Only date fields
Answer: C
Q5 When using the Query Wizard, what is the first step to create a query?
A) Select fields to include in the query
B) Choose the tables to query
C) Specify sorting options
D) Define criteria for filtering data
Answer: B
Q6 What happens if you select the Sort Descending option for a field in Design View?
A) The query will sort the result from lowest to highest
B) The query will return no result
C) The query will sort the result from highest to lowest
D) The query will filter out records
Answer: C

D. Very Short Answer Questions
Q1 What does the Query Wizard help users create?
Answer: Queries
Q2 How can you access Design View in LibreOffice Base?
Answer: By clicking Create Query in Design View in the Queries section.
Q3 How do you specify criteria in Design View?
Answer: By entering the condition in the Criteria row under the selected field.
Q4.What types of queries can we create with the Query Wizard?
Answer: Simple select and summary queries.


E. Short Answer Questions
Q1 What is the main difference between creating queries using the Query Wizard and Design View?
Answer:
The Query Wizard is step-by-step and easy for beginners, while Design View gives more control and flexibility through a visual interface.
Q2 How do you specify sorting in Design View?
Answer:
In the Design Grid, use the Sort row under each field to choose Ascending or Descending.

F. Long Answer Question
Question 1:
What are the key steps involved in creating a query using Design View in LibreOffice Base? Explain each step in detail. Consider the following table Employees.
Answer:
Steps to create a query using Design View:
Open Database:
Open LibreOffice Base and go to the Queries section.
Create Query in Design View:
Click Create Query in Design View to open the design window.
Add Table:
From the list, select the Employees table and click Add, then Close the window.
Add Fields:
Drag and drop fields such as EmpID, Name, Profile, Salary, and Commission into the design grid.
Specify Criteria:
In the Criteria row, you can type a condition like >40000 under the Salary field to show only employees earning above 40,000.
Set Sorting Order:
In the Sort row, choose Ascending or Descending to arrange the results.
Example: Sort by Salary in Descending order.
Use Aliases (Optional):
You can assign user-friendly names in the Alias row (e.g., Employee Name for the Name field).
View SQL Code:
Switch to SQL View to check or modify the SQL code automatically generated.
Run the Query:
Click the Run Query button (green arrow) to display the results.
Save the Query:
Save it by giving a name such as “High_Salary_Employees”.
Based on the given table:
Q1 How many fields and records are there in the Employees table?
Answer: There are 5 fields and 4 records.
Q2 How can you save and run a query in LibreOffice Base? What happens when you run a query?
Answer:
You can save the query using File → Save or the save icon, and run it by clicking Run Query. When you run a query, LibreOffice Base executes the SQL command and displays only the records that match the criteria.


You May Also Like:
By
at
Tags

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)