Here I discuss NCERT Solutions Chapter 11 Queries in Base. If you are class 10 Information Technology Student and searching for Chapter 11 Queries in Base questions and answers this is the right place. So lets begin!
Topics Covered
NCERT Solutions Chapter 11 Queries in Base
Lets starts NCERT Solutions Chapter 11 Queries in Base Type A – MCQ Questions. Here we go!
A. Multiple Choice Questions – NCERT Solutions Chapter 11 Queries in Base
[1] Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database
Ans.:(c) Query
(a) Reports display the query results in summarized manner
(b) Table is container to store data in tabular form
(d) Database is systematics way to store data in different objects
[2] Which of the following are the ways to design a query?
(a) Wizard
(b) Design View
(c) SQL
(d) All of the above
Ans.: (d) All of the above
Query can be created using query wizard, design view and SQL view in Libreoffice base.
[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)
Ans.: (b) Design View
Because it is something like drag drop way to create a query
[4] Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
Ans.: (b) Two
Tables and Query specification
[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
Ans.: (d) A query once created cannot be edited
A query can be edited any time after its creation
[6] Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6
Ans.: (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
Ans.: (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) ∧
Ans.: (a) >
Option b,c and c buttons are not present in query wizard
[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) All of the above
Ans.: (d) All of the above
There is a printing mistake in this question in textbook, as option D is given as Add a form which is not relevant to question.
[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
Ans.: (c) Add Table of 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
Ans.: (c) Summarizing
Now lets discuss True or False statements from NCERT Solutions Chapter 11 Queries in Base.
B. State whether the following statements are True or False
[1] You can run a query only once
Ans.: False
[2] A query cannot be created from multiple tables
Ans.: False
[3] The shortcut key to run a query is F5.
Ans.: True
[4] LibreOffice Base provides us with two ways to create a query.
Ans.: False
[5]vA query with numerical data cannot be saved.
Ans.: False
[6] By default the query result is not sorted.
Ans.: True
[7] A query can be used to display the average value of a numerical field.
Ans.: True
[8] While designing a query, the criterion can be set on only one field.
Ans.: False
[9] Alias is an alternative name for a field in a query.
Ans.: True
[10] In query Design window, the visible check box is selected by default.
Ans.: True
[11] A query once created using a wizard can only be edited in the Design view.
Ans.: True
Lets see Fill in the blanks now for NCERT Solutions Chapter 11 Queries in Base. Here we go!
C. Fill in the blanks
[1] A ________________ is a sort of question asked from a database.
Ans.: query
[2] The result of the query is displayed in _____________ form with field names in columns
Ans.: report
[3] A query can be created in ________ways.
Ans.: three (3)
Using Query Design, Query Wizard and SQL View
[4] The Query Design window is divided into ___________ sections.
Ans.: Two
1 Add Table or Query
2 Query Specification
[5] The shortcut key to run the query is ____________.
Ans.: F5
[6] The conditions to filter the records are set in the ____________ row.
Ans.: criterion
[7] When a table is selected in a Query wizard, the corresponding fields are displayed in the __________________ list box.
Ans.: available fields
[8] The result of the query can be displayed in ____________ or _______________ order of any particular field of the table.
Ans.: ascending, descending
[9] At the most _____________ search conditions can be given in the query wizard.
Ans.: three (3)
[10] The last step of the Query wizard displays the entire ____________ of the query.
Ans.: overview
[11] The __________________ view is a more flexible method to create a query.
Ans.: design
[12] To edit any query, right click on the _____________ icon of the query that has to be edited.
Ans.: saved query name
[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.
Ans.: alias
Now lets start descriptive questions and answers from NCERT Solutions Chapter 11 Queries in Base. Here we go!
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 SQL command used to retrieve, manipulate, or manage data in a database. It acts as a tool for users to interact with the database and access the required information. It is also a general question asked to database to fetch records from table(s).
Need of query:
1. Data Retrieval
2. Data Manipulation
3. Filtering data
4. Aggregation or Analysis
5. Data Integrity or Consistency
[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 query name
Answer:
- Select the fields
- Set the sorting order
- Set the criterion
- Give Alias
- Give query name
[3] What all information is seen in the overview (last step) of the Query wizard?
Ans.: The overview (last step) of query wizard shows following:
1. Name of query to be assigned
2. creating query by display query or modify query
3. Overview Such as selected fields, Sorting order (ASC or DESC), Search Condition (if any), groups and group conditions.
[4] What is the use of Alias row in the Design grid of the Query Design window?
Ans.: The alias row in design grid of the query design window shows the alias names for fields selected in the query. Sometime user don’t want to display the same field name as specified in the table. So other names can be given using alias row.
[5] Name any four mathematical functions that can be applied to numerical data in a query.
Ans.: The mathematical functions that can be applied to numerical data in query are as follows:
1. sum()
2. max()
3. min()
4. avg()
5. count()
[6] Name the three ways of creating a query in LibreOffice Base?
Ans.: The three ways to create a query are:
- Using Design View
- Using Query Wizard
- Using SQL View