Page 373 - TP_IT_V1.0_C10_flipbpookl
P. 373

Exercise




                                                                   Solved


                                                   SECTION A (Objective Type Questions)

                 A.  Choose the correct option.

                    1.  Which of the following is not an example of a database?
                       a. MySql                                          b. MongoDB
                       c. LibreOffice Base                               d. FileMaker Pro

                    2.               is a collection of related data stored in the form of rows and columns.
                       a. Rows                                           b. Column
                       c. Database                                       d. Table

                    3.  Name the relationship in which one record of master table is related to only one record of transaction table.
                       a. One to One                                     b. Many to One
                       c. One to Many                                    d. Many to

                    4.               data type takes the values in the form of 0 and 1 in the database.   [CBSE Sample Paper 2021]
                       a. Integer                                        b. Text
                       c. Boolean                                        d. Memo

                    5.  Database is made up of all the following components except.
                       a. tables                                         b. queries
                       c. forms                                          d. formula bar

                    6.  Which of the following is not a database object?
                       a. Lists                                          b. Queries
                       c. Reports                                        d. Forms
                    7.  Duplication of data is known as       .
                       a. data security                                  b. data incomplete
                       c. data redundancy                                d. data inconsistency
                    8.  For what memo data type is used?
                       a. To add table                                   b. To store objects created in other programs
                       c. For long text entries                          d. For short text entries

                    9.  Out of the following, which one is the most appropriate data field in context of employee table, if only one of these
                       is required?
                       a. Age_ in_ years                                 b. Date_ of_ birth
                       c. Age_ in_ days                                  d. Age_ in_months
                   10.  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
                   11.  Rudraksh 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



                                                                        Database Management System using LibreOffice Base  371
   368   369   370   371   372   373   374   375   376   377   378