Page 327 - Trackpad 402_Class-X_Final
P. 327

9.  A column that stores similar data is known as an Attribute.
              10.  Length property defines the maximum length a field can have to hold a value.

             Ans.  1. True  2. False  3. True  4. True  5. False  6. True  7. False  8. True  9. True  10. True

                                              SECTION B (Subjective Type Questions)

            A.  Short answer type questions:
               1.  Write the purpose of DBMS
             Ans.  DBMS is used to store logically related information at a centralised location i.e. Database server. It helps in
                  ●  Data sharing among all the applications.
                  ●  Provides Data consistency.
                  ●  Reduces data redundancy.
               2.  Write the relationship between a database and a table.
             Ans.  A database is like a container which stores all the related tables together. A table cannot be created outside a database.
               3.  What is a primary key in a database? Write any one advantage of a primary key in a table.
             Ans.  A field which uniquely identifies each record in a table is known as the primary key. e.g. Empld is the primary key of the
                  Employee table. Admno is the primary key in a Student table.
                  The advantage of a primary key is that it distinguishes one record from another and maintains unique records in a table.
               4.  What is the difference between ‘Rows’ and ‘Columns’ in a table?
             Ans.  In a table, rows are called records and columns are termed as fields. A row stores complete information of a record
                  whereas a column stores only similar data values for all records.
               5.  What do you mean by Database Servers?
             Ans.  Database servers are dedicated to store and maintain the database and run only DBMS and related software.
               6.  Write the difference between Text and Memo data types.
             Ans.  Text field can contain alphanumeric characters (A-Z and 0-9) plus special characters such as !, @ and %. Text fields have
                  a maximum length of 255 characters. Memo fields also contain alphanumeric characters, though Memo fields can store
                  much more data than text fields i.e., up to 64,000 characters.
               7.  How does a relationship occur between two tables?
             Ans.  A relationship between two tables occurs through a primary key and a foreign key.
               8.  Mention the names of any three field properties for numeric data types.
             Ans.  AutoValue, Length, Default Value, Decimal Places
               9.  What is the use of the Entry Required field property?
             Ans.  The Entry Required field property ensures that the field cannot be left blank. The user needs to enter data in this field.
              10.  What do you mean by a Query?
             Ans.  A Query is a set of commands that generates a request to access or manipulate data in a table. A query is of great help
                  when information is required to be extracted from different tables.

            B.  Long answer type questions:
               1.  Identify the columns and data types of a table: Airlines. Mention at least four columns with data type.
             Ans.  Columns         data type
                  Flight No        Text
                  No.of Passengers   Integer
                  Airlines         Text
                  Arrival Time     Date/Time
                  Departure Time   Date/Time
                  Fares            Float




                                                                                   Database  Management System  327
   322   323   324   325   326   327   328   329   330   331   332