Page 334 - Trackpad 402_Class-X_Final
P. 334

Previous Years' Questions


            1.  Which of the following is not an example of DBMS?                                          [2023]
              a. PostgreSQL                                      b. SQLite
              c. FoxPro                                          d. Impress
            2.  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
            3.  Which one of the following is an example of RDBMS?                                         [2022]
              a. MongoDB                                         b. Windows registry
              c. Publisher                                       d. Oracle
            4.  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
            5.  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
            6.  Explain the term Sorting.                                                                  [2022]
            7.  Explain any two types or relationship that can be created in tables.
            8.  What is difference between Form and Report?                                                [2022]

            9.  Identify any two Column name/Attribute and their data types from a given table: PLAYER     [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

          10.                statement is used to add one or more records to a database.                   [2020]

          11.                statement retrieves zero or more rows from one or more database tables.       [2020]
          12.  Explain two types of languages used for creating and manipulating the data in databases.    [2020]
          13.  Explain any three data types in OpenOffice Base.                                            [2020]
          14.  Explain the following with respect to Databases:                                            [2020]
              a. Forms                                           b. Reports
              c. Table                                           d. Primary key?
              e. Categorise the following commands as DDL and DML :
                                                 SELECT, ALTER, INSERT, DROP
          15.  What is RDBMS?                                                                              [2019]
          16.  What is database server ? Explain Primary key and Foreign key.                              [2019]
          17.  What do DBMS and RDBMS stand for? Explain in short.                                         [2017]
          18.  What do you mean by primary key and foreign key?                                            [2017]



          334   Trackpad Information Technology-X
   329   330   331   332   333   334   335   336   337   338   339