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. By SQL View

 

Class 10 IT Chapter 11 Queries in Base Questions Answers

Related Posts :

1. Chapter 1 Introduction to Styles Online Quizzes / MCQ Tests
2. 40+ important MCQs of Chapter 1 Introduction to Styles
3. Chapter 2 Working with Images questions answers
4. Chapter 3 Advanced Features of writer Questions Answers
5. Chapter 4 Analyse Data Using Scenarios and Goal Seek
6. Chapter 5 Using Macros in Spreadsheet questions answers
7. Chapter 6 Linking Spreadsheet data questions answers
8. Chapter 7 Share and Review Spreadsheet questions answers
9. Chapter 8 Introduction to Database Management System questions answers
10. Chapter 9 Starting with LibreOffice Base questions answers
11. Chapter 10 Working with Multiple Tables questions answers
12. Chapter 11 Queries in Base questions answers
13. Class 10 Unit 1 Communications Skills important Questions Answers.
14. Class 10 Employability Skills Unit 1 Communication Skills Exercise Solutions
15. Class 10 IT 402 free PDF download book, syllabus and previous year question paper.