Page 384 - TP_IT_V1.0_C10_flipbpookl
P. 384

10.  Which of the following is not an example of DBMS?                                           [2023]
                    a. PostgreSQL                                      b. SQLite
                    c. FoxPro                                          d. Impress
                11.  Which of the following is expanded form of SQL?                                             [2023]
                    a. Systematic Query Language                       b. Structure Query Language
                    c. Software Query Language                         d. Structural Query Language
                12.  Which one of the following is an example of RDBMS?                                          [2022]
                    a. MongoDB                                         b. Windows registry
                    c. Publisher                                       d. Oracle
                13.  The               has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining
                    complex information systems.                                                                 [2022]
                    a. Knowledge concept                               b. Formula concept
                    c. Database concept                                d. Forms concept
                14.  Malini wants to store a huge amount of information about her zone in a database. Should not be repeated in her file. Her
                    friend Gargi explained her various benefits of storing data in RDBMS. It helps in preventing/controlling duplication of data.
                    Which of the following terms is used to refer to duplication data?                           [2022]
                    a Data sharing                                     b. Data privacy
                    c. Data redundancy                                 d. Data integrity
                15.  Explain the term Sorting.                                                                   [2022]
                16.  Explain any two types or relationship that can be created in tables.
                17.  What is difference between Form and Report?                                                 [2022]
                18.  Identify any two Column name/Attribute and their data types from a given table:             [2022]
                                                            Table : PLAYER

                                       DOB        PNAME         RUNS       GENDER        DOB
                                       P1Ol     SACHIN          13000        M        10/04/2001
                                       P102     KAPIL           7000         M        12/02/1998

                                       P103     SAURABH         12000        M        13/04/2001

                                       P104     VIRAT           12500        M        17/03/2005

                19.  Consider the following table:                                                               [2022]
                                                            Table : STUDENT

                          ADMNO        NAME         GRADE         DOB        MARKS      HOUSE       GENDER

                          1001     RUPAL             9        10/04/2006       76       GREEN         M
                          1002     RASHMI            9        08/12/2005       87        RED           F
                          1003     ARNAV             10       25/05/2004       81       GREEN         M

                          1004     SUMONA            9        23/08/2005       68        RED           F

                          1005     ARUN              9        16/07/2005       72       GREEN         M
                          1006     TIA               9        22/09/2005       91        BLUE          F

                          1007     ROSHAN            10       26/08/2004       89        BLUE         M

                    Write SQL Commands:
                    a. To display the details of all students of Green House.
                    b. To increase the marks by 5 whose ADMNO is 1005.


                382   Trackpad Information Technology (Ver. 1.0)-X
   379   380   381   382   383   384   385   386   387   388   389