Page 332 - Trackpad 402_Class-X_Final
P. 332

5.  List data type available in Numeric data type.                                    [CBSE Handbook]
            6.  What is DBMS? Explain any two advantages of DBMS
            7.  Differentiate between Primary key and Foreign key.
            8.  Name DML commands.                                                                [CBSE Handbook]
            9.  Define the following:
               a.  Text data type
               b.  Memo data type
           10.  What is the purpose of using queries?                                             [CBSE Handbook]

        B.  Long answer type questions:
            1.  How many types of relationships can be created in Base? Explain each of the them.   [CBSE Handbook]
            2.  List different ways of creating tables in a database.
            3.  What do you mean by Sorting? In how many ways can it be done?                     [CBSE Handbook]
            4.  How to open an existing table in a database? Give two ways to do this.
            5.  Differentiate between Where and Order by clause of SQL statements.                [CBSE Handbook]
            6.  What do you mean by DDL (Data definition language)? Give example.
            7.  Differentiate between Forms and Reports.                                          [CBSE Handbook]
                                                                                    21 st   #Communication
        C.  Competency-based/Application-based questions:                        Century
                                                                                   Skills  #Leadership & Responsibility
            1.  Write an SQL command to do the following:
                                                      Table : FRIENDS

                Rollno   Student_Name        DOB           City      Mobile_no      Gender    Percentage
                  1     Shikha           10/01/2007    Mumbai        98XX15XXXX        F         98
                  2.    Rohit            24/03/2006    Delhi         99XX20XXXX       M          82
                  3     Sandeep          12/01/2005    Delhi         88XX17XXXX       M          91
                  4     Jagriti          07/07/2009    Banglore      89XX15XXXX        F         96
                  5     Praveen          15/09/2007    Mumbai        78XX00XXXX       M          89
               a.  Display all the information from the table whose City is ‘Delhi’.
               b.  Display of all the students whose percentage is between 90 to 100.
               c.  Display name, city,gender of all students whose name has ‘a’ somewhere in name.
               d.  Display name, city,gender of all students whose name has the second last alphabet as ’i’.
               e.  Display the records after arranging them in ascending order of names.
               f.  Update the percentage of Rohit by adding 5 more in the percentage.
               g.  Display the structure of the table.
               h.  Display the name, dob, city of all with gender ‘F’.
               i.  Display only those records who were born in 2007.
               j.  Add another column ‘SCHOOL’ in the above created table.
            2.  Ananya wants to use a database in her bookshop . Suggest a database object to do the following:
               a.  To store the information of the total stock in the tabular form.
               b.  Design an interactive screen to enter and display the information.
               c.  Create a report of stock available in her bookshop.
               d.  Wanted to create a query based on a criteria.
            3.  Charu has to create a database named MYEARTH in MYSQL. She now needs to create a table named CITY in the database
              to store the records of various cities across the globe. The table CITY has the following structure:
                        Table: City
                 FIELD NAME       DATA TYPE        REMARKS
               CITYCODE        CHAR(5)          Primary Key
               CITYNAME        CHAR(30)

          332   Trackpad Information Technology-X
   327   328   329   330   331   332   333   334   335   336   337