Page 374 - TP_IT_V1.0_C10_flipbpookl
P. 374

12.                are a great way to provide additional information about the Form controls.
                    a. Tooltips                                        b. Label
                    c. Format                                          d. Text
                13.  It enables users to view, enter, and change data directly in database objects.   [CBSE Sample Paper 2023]
                    a. Report                                          b. Query
                    c. Form                                            d. Database
                14.  Suraj wants to create a database for his clients. For this purpose, he needs to store the Email IDs of his clients. Which data
                    type should he use to accomplish this purpose?                               [CBSE Sample Paper 2023]
                    a. Numeric                                         b. Varchar
                    c. Binary                                          d. Boolean
                15.                is used with WHERE clause to search for a specific pattern in a column.
                    a. ORDER BY clause                                 b. LIKE operator
                    c. INSERT command                                  d. GROUP BY clause
                16.                are used to retrieve a particular record from a table that contains a specified character.
                    a. Relationship                                    b. Tuple
                    c. LIKE operator                                   d. Wildcard characters
                Ans.  1. d  2. d  3. a  4. c  5. d  6. a  7. c  8. c  9. b  10. c  11. c  12. a  13. c  14. b

                     15. b  16. d

              B.  Fill in the blanks.
                 1.  The collection of related         arranged in the form of rows and columns will form structured data.
                 2.                is an attribute or a set of attributes whose values match the primary key of another table.

                 3.                is the extension of a database in LibreOffice base.
                 4.                file stores data in a plain text format.
                 5.  Data              means that the data is accurate and consistent in the database.
                 6.  A row in a relation is called      .
                 7.                gives you a window where you enter the names, data types and the description of the fields you wish to
                    create in a table.
                 8.  The               data type stores integer range between 0 to 255.
                 9.  The               toolbar contains various controls that can be added to the form.
                10.  A                is a step-by-step process of doing a specific task through a set of dialog boxes.
                11.  A               is a piece of text that represents the field on the form.
                12.                characters are used to retrieve a particular record from a table that contains a specified character.
                13.  Each table can have only          primary key in a database.

                14.  A Relational  database  uses          commands  which  is  a standard  user application  that provides  an  easy
                    programming interface for database interaction.
                15.  A               view helps you design a query by specifying the tables and the criteria.

                16.                is the standard language for managing relational databases and performing various operations on the
                    data in the tables.

                Ans.  1. data           2. Foreign Key     3. .odb            4. Flat            5. Integrity
                     6. Tuple           7. Design View     8. TINYINT         9. Forms Control   10. Wizard

                     11. label          12. Wildcard       13. One            14. SQL            15. Design
                     16. Structured Query Language



                372   Trackpad Information Technology (Ver. 1.0)-X
   369   370   371   372   373   374   375   376   377   378   379