Page 326 - Trackpad 402_Class-X_Final
P. 326

13.  Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
                                                                                           [CBSE Sample Paper 2021]
              a. Table                                           b. Form
              c. Relationships                                   d. Sorting
          14.  Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this
              purpose.                                                                     [CBSE Sample Paper 2021]
              a. Length                                          b. Default
              c. Entry required                                  d. Format
          Ans.  1. c   2. d   3. b   4. b   5. c   6. b   7. d   8. d   9. a   10. c   11. c   12. b   13. c   14. b

        B.  Fill in the blanks.

            1.  The collection of related        arranged in the form of rows and columns will form structured data.
            2.               is the smallest unit of a database and is formed by the intersection of a row and a column.
            3.  By default, data is arranged in       order using ORDER BY clause.                [CBSE Handbook]
            4.               is an attribute or a set of attributes whose values match the primary key of another table.
            5.               statement is used for modifying records in a database.               [CBSE Handbook]
            6.               clause is used with select to arrange the records in ascending or descending order.
            7.               is the extension of a database in openoffice base.
            8.              stores data in a plain text format.
            9.  Data             means that the data is accurate and consistent in the database.
          10.  A row that forms complete information is known as a       .
          11.                gives you a window where you enter the names, data types and the description of the fields you wish to
              create in a table.
          12.  The               data type stores integer range between 0 to 255.
          13.                statement is used to remove one or more records in a Database.       [CBSE Handbook]

          Ans:  1. data      2. Data Value    3. ascending    4. Foreign Key       5. UPDATE    6. Order by    7. .odb
               8. Flat file   9. integrity   10. Tuple    11. Design View     12. TINYINT   13. DELETE

        C.  Match the following:

            1.  Flat File                             a.  Row
            2.  Record                                b.  DML
            3.  Attribute                             c.  DDL
            4.  Alter table                           d.  Column
            5.  Select                                e.  Spreadsheet
          Ans.  1. e  2. a  3. d  4. c  5. b

        D.  State whether these statements are true or false:
            1.  In the database, all the data is stored at a centralized location.
            2.  Table is also known as tuple.
            3.   Field contains a set of characters.
            4.  CREATE TABLE is a DDL command.
            5.   % with like in SQL replaces only one character.
            6.  Relational File stores data of different data types like text, number, date in the form of rows and
              columns to form a table.
            7.  MySql is not an example of relational database management system.
            8.  Sharing of data means data can be accessed by multiple users at the same time.


          326   Trackpad Information Technology-X
   321   322   323   324   325   326   327   328   329   330   331