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

.  In    MS  data is organised in the form of ............................. .
                   i.   able                                       ii.   ecord

                   iii. Field                                      iv. None of these
               5.   hich of the following is not a database program
                   i.  MyS                                         ii.  Oracle
                   iii.  riter                                     iv. OpenO ce  ase
                .  Sorting means to arrange data in ............................. order.
                 i.  increasing                                    ii.  decreasing
                   iii. increasing or decreasing                   iv. None of these
                .   hich of the following acts as an interface to view  enter and change data in database
                   i.   eport                                      ii.   able
                   iii.  uery                                      iv. Form
               8.  A ............................. helps to display the data in a summarised form.
                   i.   eport                                      ii.  Form
                   iii.  uery                                      iv. None of these
                .   hich of the following application is not appropriate to store data about      ank customers
                                                                                            S  Sample  aper
                   i.  Open O ce  ase                              ii.  MS  ccess
                   iii. Open O ce  riter                           iv. MS  xcel
                .  Multiple copies of the same file leads to ............................. .       S  Sample  aper
                 i.  Data Inconsistency                            ii.  Data Consistency
                   iii.  ata  edundancy                            iv. Foreign  ey
                .  Identify the property which help to set the number of characters in text  varchar type field of a table in
                   MS.                                                                      S  Sample  aper
                   i.   ntry  e uired                              ii.   efault  alue
                   iii. Si e                                       iv.  ength

                .   he length of the field value of text data type is ............................. characters by default in   MS.
                                                                                            S  Sample  aper
                 i.  10                                            ii.  25
                 iii. 20                                           iv. 50
                .  Identify the mode  where we can modify in the structure of table         S  Sample  aper
                   i.   atasheet view                              ii.  Structure view
                 iii. Design view                                  iv. All of these
              14.  ............................. store data in a single table which is suitable to store less amount of Data.
                                                                                            S  Sample  aper
                   i.  Flat File                                   ii.   elational
                   iii. Mini File                                  iv. Single File

            B.  State whether these statements are true or false.
                1.  Data Integrity means that data is accurate and consistent in the database.
                2.  There can be multiple primary key in a table.

                3.  A record in table is also known as Attribute.
                 .   ueries are commands that are used to define the structure and modify the data in a table.
                5.  In  ase  we can create a form using design view.



         308       Touchpad Information Technology-X
   305   306   307   308   309   310   311   312   313   314   315