Page 331 - Trackpad 402_Class-X_Final
P. 331

9.  The user cannot enter data in the field that is assigned as    .
                  a. AutoValue                                      b. Default Value
                  c. Format value                                   d. Entry required
              10.  Which of the following is not an example of Numeric data type?
                  a. Date of Birth                                  b. Roll no
                  c. Price                                          d. Marks

            B.  Fill in the blanks.
               1.  To create a form you need to select        option available under Database section.   [CBSE Handbook]
               2.   A foreign key is a reference of the      key in another table.

               3.  A              is helps to collect specific information from the pool of data in the database.   [CBSE Handbook]
               4.  The candidate key, which is not used as the primary key is called    key.
               5.                is used to display the summary of data.                              [CBSE Handbook]
               6.  A field in a RDBMS is also called as      .
               7.  DDL stands for            .
               8.                help you define the type of the data that can be stored in a field/ column.
               9.                are the interfaces with which the user interacts.                    [CBSE Handbook]
              10.  Field             provide extra functionality to the fields created in a table.
              11.                is the formatted data displayed from one or more tables or queries.

              12.                means rearrangement of the data either in the ascending order or in the descending order.
              13.  Data from multiple tables can be stored in      .                                  [CBSE Handbook]
            C.  Match the following:

               1.  Row                                   a.  Data type
               2.  DDL                                   b.  CREATE
               3.  DML                                   c.  Tuple
               4.  Integer                               d.  SELECT

            D.  State whether these statements are true or false:
               1.  Where clause is used to display specific data from the database.
               2.  The update statement is used to delete records in the table
               3.  OpnOffice base is an open source RDBMS.
               4.   Data Redundancy means keeping multiple copies of the same data in a System.

               5.   DBMS does not provide data backup and recovery features.
               6.  The records once entered can be edited anytime in a table.
               7.  Relationship saves time as the common data need not to be repeated in different tables.
               8.  SQL is a low-level interactive language.

                                              SECTION B (Subjective Type Questions)

            A.  Short answer type questions:
               1.  How Entry Required and Default Value properties of a table field in a database are different
                  from each other?                                                             [CBSE Sample Paper 2022]
               2.  Explain the term Data Redundancy.
               3.  What is Referential Integrity? Explain its two (any) purposes.              [CBSE Sample Paper 2022]

               4.  Define Reports of a database.

                                                                                   Database  Management System  331
   326   327   328   329   330   331   332   333   334   335   336