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
   249   250   251   252   253   254   255   256   257   258   259