Page 254 - IT_V1.0_Class10
P. 254
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. ............................ means that the query uses criteria you provide to hide some data and display only required
data. [CBSE Sample Paper 2023]
i. Filtering ii. Sorting iii. Report iv. Forms
2. What wildcard character is used to represent one or more characters in a query?
i. * ii. ? iii. # iv. !
3. Which dialog box appears when you first open the Query Design window to create a query?
i. Add Table ii. Add Query iii. Add Table or Query iv. None of these
4. In a query, an ............................ provides another name for a field in the output window.
i. subname ii. alias iii. named iv. title
B. State whether the following statements are true or false:
1. Wildcards in LibreOffice Base include the characters *, & and #. ............................
2. A query in a database is used to store data. ............................
3. A criterion in a query specifies the sorting order of records. ............................
4. The Sum function in a query adds up the values in a field. ............................
5. In the Query Wizard, you can specify the condition to be used for filtering records. ............................
21 st
C. Assertion and reasoning questions. Century #Critical Thinking
Skills
The following questions consist of two statements – Assertion (A) and Reason (R). Answer these questions
by selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
iii. A is true but R is false.
iv. A is false but R is true.
1. Assertion (A): In LibreOffice Base, a query can display records from multiple tables based on certain criteria.
Reason (R): The query results are displayed in a tabular format, with field names as column headers and
corresponding records in rows.
2. Assertion (A): Applying filter criteria in a query allows users to evaluate and display specific records.
Reason (R): In LibreOffice Base, queries are limited to displaying all records without any filtering.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. What do you mean by query in LibreOffice Base?
2. What are some common grouping functions used in queries, and how do they help in analysing data?
3. What is the difference between the * and ? wildcard characters in LibreOffice Base?
4. What is a group-field in a query?
5. Write steps to perform calculations in query.
252 Information Technology Play (Ver 1.0)-X

