Page 383 - TP_IT_V1.0_C10_flipbpookl
P. 383

Previous Years' Questions



                    1.  In  OpenOffice Base,  the relationship  applied  on  the tables  can  be removed with  the help  of
                       option.                                                                                      [2024]
                       a. Clear                                          b. Remove
                       c. Drop                                           d. Delete
                    2.  In SQL, the keyword to display records in ascending order is:                               [2024]
                       a. Asce                                           b. Incr
                       c. Asc                                            d. High
                    3.               is a numeric data type  which  can store  Yes/No type  values in  the form of 0 or 1 in  OpenOffice
                       Base table.                                                                                  [2024]
                       a. Boolean                                        b. Binary
                       c. Char                                           d. OtherObject

                    4.  Which  of the following statement retrieves zero or more  rows from one or more  database tables or database
                       views?                                                                                       [2024]
                       a. UPDATE                                         b. DELETE
                       c. SELECT                                         d. DISPLAY
                    5.  Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust photo
                       field. Suggest a suitable data type from the options given below.                            [2024]
                       a. IMAGE                                          b. PICTURE
                       c. LONGVARBINARY                                  d. GRAPHIC
                    6.  By default, all the fields in OpenOffice Base will have    datatype.                        [2024]
                       a. int (tiny)                                     b. Boolean
                       c. text (varchar)                                 d. text (char)
                    7.  Give any two benefits of creating relationships between tables in a database.               [2024]
                    8.  In context of OpenOffice Base, explain the concept and significance of the following:       [2024]
                       a. Forms
                       b. Reports

                    9.  Consider the table Product and write SQL queries for the following:                         [2024]
                                      PID         PNAME        PRICE        QUANTITY      CATEGORY
                                      P01         BOARD        10000        2             OFFICE
                                      P02         EYELINER     700          50            MAKEUP
                                      P04         PENCIL       5            500           SCHOOL
                                      P05         LAMP         250          10            DOMESTIC
                                      P08         BEDSHEET     450          45            DOMESTIC
                                      P09         LAPTOP       75000        15            OFFICE
                       a. To display names of all products whose category is “domestic”.
                       b. To display product name and price whose quantity is less than 50.
                       c. To display price and quantity of Laptop.
                       d. To display name and quantity of those products whose price is above 5000.
                       For Visually Impaired Candidates:
                       In the context of Database Management System, write a short note on the following:
                       (i) Database
                       (ii) Table
                       (iii) Field
                       (iv) Composite Primary Key


                                                                        Database Management System using LibreOffice Base  381
   378   379   380   381   382   383   384   385   386   387   388