Comprehensive Guide NCERT Solutions Chapter 11 Queries in Base

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!

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

[2] Which of the following are the ways to design a query?
(a) Wizard
(b) Design View
(c) SQL
(d) All of the above

[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)

[4] Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four

[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

[6] Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6

[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

[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) ∧

[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

[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

[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

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

[2] A query cannot be created from multiple tables

[3] The shortcut key to run a query is F5.

[4] LibreOffice Base provides us with two ways to create a query.

[5]vA query with numerical data cannot be saved.

[6] By default the query result is not sorted.

[7] A query can be used to display the average value of a numerical field.

[8] While designing a query, the criterion can be set on only one field.

[9] Alias is an alternative name for a field in a query.

[10] In query Design window, the visible check box is selected by default.

[11] A query once created using a wizard can only be edited in the Design view.

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.

[2] The result of the query is displayed in _____________ form with field names in columns

[3] A query can be created in ________ways.

[4] The Query Design window is divided into ___________ sections.

[5] The shortcut key to run the query is ____________.

[6] The conditions to filter the records are set in the ____________ row.

[7] When a table is selected in a Query wizard, the corresponding fields are displayed in the __________________ list box.

[8] The result of the query can be displayed in ____________ or _______________ order of any particular field of the table.

[9] At the most _____________ search conditions can be given in the query wizard.

[10] The last step of the Query wizard displays the entire ____________ of the query.

[11] The __________________ view is a more flexible method to create a query.

[12] To edit any query, right click on the _____________ icon of the query that has to be edited.

[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.

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?

[2] Rearrange the steps given below so as to create a query using a wizard.

1. Give Alias
2. Select the fields
3. Set the criterion
4. Set the sorting order
5. Give query name

Answer:

1. Select the fields
2. Set the sorting order
3. Set the criterion
4. Give Alias
5. Give query name

[3] What all information is seen in the overview (last step) of the Query wizard?

[4] What is the use of Alias row in the Design grid of the Query Design window?

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

[6] Name the three ways of creating a query in LibreOffice Base?