Ch 11 Queries in LibreOffice Base Class 10 IT-402
Ch 11 Queries in LibreOffice Base Class 10 IT-402
A. Multiple choice questions
Q1. Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database
Q2. Which of the following are the ways to design a query?
(a) Wizard
(b) Design View
(c) SQL
(d) All of the above
Q3. Which is a flexible way to create a query?
(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Q4. Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
Q5. 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
Q6. Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6
Q7. 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
Q8. 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) <
(c) ∨
(d) ∧
Q9. 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
Q10. 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
Q11. 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
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. A 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.
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.
D. Answer the given questions
Q1. Define a query? What is the need of creating a query in a database?
Q2. 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 table name
Q3. What all information is seen in the overview (last step) of the Query wizard?
Q4. What is the use of Alias row in the Design grid of the Query Design window?
Q5. Name any four mathematical functions that can be applied to numerical data in a query.
Q6. Name the three ways of creating a query in LibreOffice Base?
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
Unit 3: Database Management system using LibreOffice Base
Chapter 8. Introduction to DBMS – NOTES
Chapter 8. Introduction to DBMS – Question Answers
Chapter 9. Starting with LibreOffice Base – NOTES
Chapter 9. Starting with LibreOffice Base – Question Answers
Chapter 10. Working with Multiples Tables – NOTES
Chapter 10. Working with Multiples Tables – Question Answers
Chapter 11. Queries in Base – NOTES
Chapter 11. Queries in Base – Question Answers
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you the simple answers of “Ch 11 Queries in LibreOffice Base Class 10 IT-402“, but if you feel that there is/are mistakes in the answers of “Ch 11 Queries in LibreOffice Base Class 10 IT-402” given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE Website are used to create above article “Ch 11 Queries in LibreOffice Base Class 10 IT-402”