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

i.   he marks obtained by the student with  ollNo.      is

              ii.  What is the name of the student, who has got the highest marks and what is the amount of scholarship awarded
                to him her

              iii.  ow many records are there in the table
                                                                                                L if e   S k il l s   &   V al ue s
              iv.  ow many fields are there in the table
           2.  Sandip is working in a renowned software company as a trainee.  ithout the consent of  atabase  dministrator
              he tried to make some changes in the database but database does not allow such permissions. Due to which
              feature of database  Sandip is unable to make possible changes in the database
            .   he management of a medical store   et ellSoon Medicos  decides to computeri e its inventory.
              i.  Suggest any two tables which must be present in the database.  ou can also suggest fields of the tables along
                with their data types.
              ii. Mention any two benefits that the management will have by computeri ing the inventory.

        Previous Years’ Questions



           1.   hich of the following is not an example of   MS
               a    ostgreS                                 b   S  ite
               c    Fox ro                                  d   Impress
          ns.   d

            2.  A ............................. is an interface in a user specified layout that lets users to view  enter  and changes data directly
              in database ob ects such as tables.
               a   frame                                    b   form
               c    relation                                d   report
          ns.   b
             .   hich of the following is expanded form of S

               a   Systematic  uery  anguage                b   Structure  uery  anguage
               c    Software  uery  anguage                 d   Structural  uery  anguage
          ns.   b

            4.  ............................. is usually suitable for less amount of data.   elational Flat File
         Ans.  Flat File
            5.   inary data types in a database can be used for storing ............................. .
               a   photos  music files  etc.                b   integer values
               c    only image files                        d   only video files
          ns.   a

             .   hat is primary key   ow is it different from foreign key
          ns.    primary key is a uni ue value that identifies a row in a table.  he foreign key identifies a column or set of
              columns in one  referencing  table that refers to a column or set of columns in another  referenced  table.
             .   xplain any four data types of   MS.

         Ans.    Numeric Data Type: Numeric Types: Numeric data types are used for describing numeric values for the field used
                in the table of a database. Numeric data types in a database can be used for storing information such as mobile
                number, roll number, door number, year of school admission, true or false statements, statistical values, etc.




         310       Touchpad Information Technology-X
   307   308   309   310   311   312   313   314   315   316   317