Page 375 - TP_IT_V1.0_C10_flipbpookl
P. 375

C.  Match the following:
                    1.  Flat File                             a.  Ascending
                    2.  Record                                b. One to one
                    3.  Attribute                             c.  Spreadsheet
                    4.  Relationships                         d. Row
                    5.  Sort                                  e. Column
                  Ans.  1. c  2. d  3. e  4. b  5. a

                 D.  State whether these statements are true or false.

                    1.  In the database, all the data is stored at a centralised location.
                    2.  Table is also known as tuple.
                    3.  Field contains a set of characters.
                    4.  % with like in SQL replaces only one character.
                    5.  Relational file stores data of different data types like text, number, date in the form of rows and columns to
                       form a table.
                    6.  MySql is not an example of relational database management system.
                    7.  A column that stores similar data is known as an Attribute.
                    8.  Length property defines the maximum length a field can have to hold a value.
                    9.  Information is processed, organised, and meaningful data that provides context, relevance, and value.
                   10.  The field properties do not allow the user to change properties of the field.
                  Ans.  1. True  2. False  3. True  4. False  5. True  6. False  7. True  8. True  9. True  10. False


                                                  SECTION B (Subjective Type Questions)
                 A.  Short answer type questions.
                    1.  What is RDBMS?
                  Ans.  RDBMS is an advanced form of Database Management System and is based on a Relational Model. In this model, a
                       relational database has a set of related tables that are interlinked to each other on the basis of a common field. It is a very
                       efficient way of representing data and allows data in a table to be represented in a two-dimensional form and is known as
                       a relation.
                    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 is a collection of related data fields whereas a
                       column stores similar data type value.
                    5.  How does a relationship establish between two tables?
                  Ans.  A relationship between two tables establish through a primary key and a foreign key.
                    6.  Mention some names of field properties for numeric data types.
                  Ans.  AutoValue, Length, Default Value, Decimal Places.
                    7.  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.

                    8.  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.

                                                                        Database Management System using LibreOffice Base  373
   370   371   372   373   374   375   376   377   378   379   380