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

Solved Exercise


                                                         Section A
                                                (Objective Type Questions)

            A.  Multiple choice questions:
               1.  Duplication or repetition of data is known as ............................. .
                   i.  Sharing of  ata                             ii.  Inconsistency

                   iii.  ata  edundancy                            iv.  ata Sharing
                .   he  same  resource  of  data  can  be  shared  by  multiple  users  or  for  different  application  by  means  of
                 ............................. .
                 i.  Data binding                                  ii.  Data manipulating

                   iii.  ata Sharing                               iv. None of these
               3.  A collection of logically related records is called ............................. .
                   i.  Sharing of  ata                             ii.  Inconsistency
                 iii. Table                                        iv. Field
               4.  Data validation refers to ............................. .
                   i.   ata Inconsistency                          ii.   ata Security
                   iii.  ata Sharing                               iv.  ata Integrity
               5.  A formal presentable printed document that lists data in a formatted manner is known as .......................... .
                   i.   uery                                       ii.  Form
                   iii.  eport                                     iv. None of these
               6.  In Tables, data are organised in ............................. .
                   i.   olumns and Fields                          ii.   ows and  ecords
                   iii. Fields and  ecords                         iv. None of these
                .   hich of the following field properties ensures that “data cannot be skipped in the field” or “field cannot
                 be left empty”
                   i.  Format                                      ii.   ntry  e uired
                   iii.  efault  alue                              iv.  ength
                .   hat data type should you prefer for a  ip code field in a table
                   i.   ext                                        ii.  Number
                   iii. Memo                                       iv.  ll of these
               9.  Database servers are referred to as ............................. .      S  Sample  aper
                   i.   Front-ends                                 ii.   ack-ends
                   iii.   lients                                   iv. Model
              10.  A table is a set of data elements that is organized using a model of vertical .............................  and horizontal
                 ............................. .                                            S  Sample  aper
                   i.    ows   ables                               ii.   olumns   ows
                   iii.   ows   olumns                             iv. Forms   eports




              Ans.  1. iii    2. iii   3. iii    4. iv    5. iii   6. iii   7. ii     8. ii    9. ii    10. ii



                                                                                  Database Management          303
   300   301   302   303   304   305   306   307   308   309   310