Page 155 - iPrime_V2.2_class7
P. 155

Test Sheet-2


                                                                                     (Based on chapters 7 to 10)


                                                             Section A


                 A.  Tick ( ) the correct option.
                    1.  Which of the following data types is used to store textual data in Access?

                       a. Text                                         c. Number

                       b. Currency                                     d. Auto Number

                    2.  ................................ data type automatically stores a sequential number for every record in a
                       table.
                       a. Serial                                       c. AutoNumber

                       b. Autofill                                     d. Time/date

                    3.  Which of the following rules is incorrect for naming a field in a table in Access?

                       a.  Field name can be up to 64 characters long

                       b.  Field name can include special characters such as the asterisk (*) and dollar ($)

                       c.  Field name cannot begin with the leading spaces
                       d.  Field name cannot include a double quotation mark (")

                    4.  The ................................ attribute is used to give color to the border of the table.

                       a. BORDERCOLOR                                  c. COLOR

                       b. BGCOLOR                                      d. None of these

                    5.  Which of these attributes is used to restrict the user to resize the frame on the web page?
                       a. NOFRAME                                      c. NORESIZE

                       b. NOSIZE                                       d. RESIZE

                    6.  Which of the following values of the TYPE attribute of the <INPUT> tag is used to create
                       a check box field?

                       a. BOX                                          c. CHECKBOX

                       b. CHECK-BOX                                    d. CHECK

                 B.  Fill in the blanks.

                    1.  The collection of related records is called ................................ .
                    2.  ................................ is established between two tables based on the common field.





                                                                                                  Test Sheet-2     153
   150   151   152   153   154   155   156   157   158   159   160