Page 32 - TechPluse_C8_Flipbook
P. 32

Restart


                         A collection of programs required to store and retrieve data from a database is called
                        Database Management System (DBMS).

                        There are mainly two types of database—Flat File Database and Relational Database.

                        Table is a group of related data organised in columns and rows in a database.
                        There are two types of views in LibreOffice Base—Table Data View and Table Design

                        View.



                                                           Checkpoint




                  A.    Tick ( ) the correct option.
                             ü
                        1.   Arranging the records in a particular order is called ...................... .

                             a.  Query                                   c.  Report
                             b.  Sorting                                 d.  Table

                        2.   Which of the following keys is used to specify a unique field in a table?

                             a.  Primary Key                             c.  Composite Key

                             b.  Secondary key                           d.  None of these

                        3.   The process of displaying the information from the table is called ...................... .
                             a.  Query                                   c.  Form

                             b.  Report                                  d.  Wizard

                        4.   Which of the following is not a data type in LibreOffice Base?

                             a.  Number                                  c.  Text

                             b.  OLE                                     d.  Yes/No

                        5.   Which of the following options is used to create a table?
                             a.  Table Design view                       c.  Both a and b

                             b.  Table Data view                         d.  None of these

                  B.    Write ‘T’ for true and ‘F’ for false.

                        1.   There are two types of databases.                                           ............................
                        2.   Database pane is present on right side of LibreOffice Base window.          ............................
                        3.   Delete Record option is used to delete a record.                            ............................

                        4.   Two fields in a table can have the same name.                               ............................


               30       Premium Edition-VIII
   27   28   29   30   31   32   33   34   35   36   37