Page 335 - Trackpad 402_Class-X_Final
P. 335

19.  Consider the following table : STUDENT                                                      [2022]

                       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.

                  c. To display the details of all students whose MARKS are less than 80.
                  d. Display the list of all students in descending order of MARKS.

              20.  Create table EMPLOYEE                                                                       [2020]
                  EMPID                                             Char(4)
                  EMPNAME                                           Varchar(15)
                  DESIGN                                            Varchar(20)
                  SALARY                                            Decimal
              21.                command is used to create a new table in a database.                          [2018]
                  a. New                                            b. Create
                  c. Alter                                          d. Select
              22.  Write SQL query to create the Table Flight with the following structure:                    [2018]












              23.  Consider the following table and answer the following:                                      [2018]










                  a. Identify suitable Primary Key from the above table.
                  b. Add a new record with the following data:
                      (‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)
                  c. Write a select query to display records of those Doctors whose OPD_DAYS are ‘MWF’.
              24.  What is DDL ? Mention any two DDL statements.                                               [2018]
              25.  What do you mean by DDL and DML commands?                                                   [2017]




                                                                                   Database  Management System  335
   330   331   332   333   334   335   336   337   338   339   340