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

  Alphanumeric Types: Various data types are char, varchar, long varchar etc. They are used to store the text.

                   Binary Types:  inary data types are used for storing data in binary formats.  inary data types in a database can
                   be using for storing photos  music files  etc.
                   DATE TIME:  ate time data types are used for describing date and time values for the field used in the table of
                   a database. Date time data types in a database can be used for storing information such as date of birth, date
                   of admission, date of product sale, etc.

                 .   hich one of the following is an example of    MS
                   a   Mongo                                    b    indows registry
                   c    ublisher                                d   Oracle
              ns.   d

                9.  The ............................. has evolved since the     s to ease increasing di culties in designing  building and maintaining
                 complex information systems.

                   a    nowledge concept                        b   Formula concept
                   c    atabase concept                         d   Forms concept
              ns.   c
                 .  Malini wants to store a huge amount of information about her  one in a database. Should not be repeated in her
                 file.  er friend  argi explained her various benefits of storing data in    MS. It helps in preventing controlling
                 duplication of data.  hich of the following terms is used to refer to duplication data
                   a    ata sharing                             b    ata privacy
                   c    ata redundancy                          d    ata integrity
              ns.   c

                .   xplain the term Sorting
              ns.  Sorting means rearrangement of the data either in the ascending order  smaller value to bigger value  or
                 in the descending order  bigger value to smaller value .  he records will be rearranged with respect to the
                 sorted field.
              12.  Explain any two types or relationship that can be created in tables.
             Ans.  Two types of relationships are as follows:
                   One to one: In this type “ ach record of one table is related to only one record of another  able”. It is represented
                   as a  :  relationship. In the above created table. ON  S    N  can be in ON     SS in a session.
                   One to many: In this type “ ach record of one table is related to multiple  ecords of another table.” It is
                   represented as a  :n relationship.  et us take the example of the above tables where ON  S    N  can have
                   M   I    S      S. Similarly  ON          teaches M   I       SS S.
                .   hat is difference between Form and  eport
             Ans.   he differences between form and report are as follows:

                 Form: Form is a database object which is used to create an interactive user interface by connecting it with a table.
                  ach field of a table is displayed in a text box with a Field label on one side so that the user can enter  edit and
                 view records in an e cient way.  he data added  deleted  updated through a form will be reflected in the table
                 connected to the form.
                 Report:  eport is the formatted data displayed from one or more tables or  ueries.  his layout of the information
                 is based on a criteria. It is also known as the summary of a table and helps in data analysis. For example, creating
                 a report of students who secured 80% and above.






                                                                                  Database Management          311
   308   309   310   311   312   313   314   315   316   317   318