Page 306 - IT 402 v2.0 class 10
P. 306

B.  Fill in the blanks.

                 .   he concept of    MS was developed by ............................. at I M in     .
                2.  ............................. is the meaningful form obtained after processing of data.
                3.  Arranging records in ascending/descending order is called ............................. .
                 .   wo  ables are linked based on a field  which is known as ............................. .

                5.  The ............................. option specifies the length of the data that can be stored in a field.
                6.  ............................. property specifies the width of the field.
                7.  The ............................. property specifies and controls how data is entered and displayed.

                8.  ............................. option should be activated if the field cannot contain N    values.

               ns.   .  .F.  odd                  . information                         . Sorting
                    . key field                  5. length                              .  ength
                    . field                       .  e uired or  ntry re uired

                                                          Section B
                                                 (Subjective Type Questions)

            A.  Answer the following questions:
                 .   hat are the benefits of using   MS

              ns.   he benefits of using   MS are:
                      Reduces Data Redundancy:   MS reduces the duplication or repetition of data to a large extent  thus
                   saving valuable disk space and time.
                     Sharing of Data:  he data stored at one place can be used by multiple users or for different applications.
                   Sharing of data saves time and money. It helps in reusability.
                      Ensures Data Security: It allows only authorised users to access the data from the database.  ifferent
                   permissions or restrictions are imposed on a database according to levels.
                     Reduces Data Inconsistency:  he data remains updated in case any change is made  i.e.  when a modification
                   is made in one portion of data, the changes are automatically done in the other portion wherever that data
                   has been used.
                     Data Integrity:  he   MS ensures that only valid data can be entered into the database  according to the
                   standards laid down by an organisation.
                     Interactive Interface:   MS provides a convenient interface for entering or viewing data by providing a
                   presentable format according to the user s choice.
                2.  Write about the elements of a database.

             Ans.  The  following are the elements of database:
                     Table: A table is a collection of logically related records. The records are arranged in a tabular structure in
                   the form of rows and columns.  he columns represent fields and the rows represent records.
                     Query: It is  a call or request to retrieve  or generate  some  information from the tables. It generates
                   information according to the given conditions. It can retrieve information from a single as well as multiple
                   tables. It helps in managing as well as manipulating a database.
                     Form: It provides an interface in a user-defined layout which lets the user view  enter records as well as
                   modify records. Data of tables can be displayed in the form view.




         304       Touchpad Information Technology-X
   301   302   303   304   305   306   307   308   309   310   311