Class 10 IT Chapter 11 Queries in Base Questions Answers

Class 10 IT Chapter 11 Queries in Base Questions Answers

Dear students, The Exercise Solutions of Class 10 IT Chapter 11 Queries in Base are given in this page. The questions answers have been given taking the reference of Class 10 IT book Domestic Data Entry Operator published by NCERT.

D. Answer the given questions :

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

Ans: A query is a sort of question asked from a database. It is one of the most
important feature of a DBMS. It is used to retrieve and display data from one or
more tables in a database.
Creating a query is needed in a database because using it we are able to retrieve
data without going individually through each record in a table or tables and
display them in desired format.

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

Ans: i. Give table name
ii. Select the fields
iii. Set the sorting order
iv. Set the criterion
v. Give Alias

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

Ans:
i. Name of the query
ii. How do we want to proceed after creating the query
iii. Overview

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

Ans : Using Alias row in the Design grid of the Query Design window, we can set
alternative names for fields of original table to make it convenient for user to
understand.

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

Ans : i. Sum
ii. Average
iii. Maximum
iv. Minimum

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

Ans: The three ways of creating a query in LibreOffice Base are –

i. Using Design View
ii. Using Wizard
iii. Using SQL View

Class 10 IT Chapter 11 Queries in Base Questions Answers