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

Section B
                                                   (Subjective Type Questions)
            A.  Answer the following questions:

                 .   hat is database
                 .   hat do you mean by    MS
                 .   efine the following terms:
                 i.  Table
                 ii. Fields
                 iii.  ecords
                 .   hat are the two ways of creating table in OpenO ce  ase.
                5.   hat do you mean by  ata type   ive example of two data type used in OpenO ce  ase.
                 .   hat is the difference between  har and  archar data type
                 .   hat do you mean by Sorting
                 .   hat is  eferential Integrity

                 .   hat is Form in OpenO ce  ase
                  .  rite two ways of creating form in OpenO ce  ase.
                .  ifferentiate between Forms and  eport.
                .  hat do you mean by  uery in OpenO ce  ase
                . In how many ways you can create  uery in OpenO ce  ase
                .  hat do you mean by  eport in OpenO ce  ase
                 5.  ist Numeric and  lphanumeric  atatypes in OpenO ce  ase.                   S  Sample  aper
                  .  our friend owns a chemist shop  he needs to keep records of the medicines with their id s  date of purchase
                 expiry date  price  etc. in a database program.  ut he does not have any knowledge about the database.  xplain
                 to him the following to get a better understanding of the   MS concepts.       S  Sample  aper
                  .   hat is   MS   xplain in brief.
                  .  Name any two database programs which can be used to create a table and store the data as per the re uirement.
                  .   hich field can be set as a  rimary  ey
                  .  Is it possible to make more than one field as a primary key in your table    es No .  ustify your answer.
                  .  efine the following:
                  .  Sorting  with respect to   MS
                  .   eferential Integrity
                  .  Many-to-Many  elationship with respect to   MS
                 4.  Foreign key

            B.  Application based questions:                                                        Cr itical   T h ink ing
                 .   onsider the following database Student.

                                                           Student
                  Roll No.  First Name  Last Name    Class  Marks Obtained (%)    Scholarship Awarded (`)
                    1205   Mohan        Garg         12th          99.9                    50000
                    1009   Dushyant     Singh        10th          98.7                    45000

                    1101   Swati         ana         11th          95.4                    30000
                    945     avindra     Saini         9th          97.5                    35000
                    1015    itika       Thakur       10th          98.6                    40000



                                                                                  Database Management          309
   306   307   308   309   310   311   312   313   314   315   316