Page 187 - IT-802_class_12
P. 187

2.  Mention the different languages present in DBMS.
               3.  Explain the concepts of a Primary key and Foreign key with an example.
               4.  What are the differences between DROP and DELETE command?

               5.  What are different types of joins in SQL?
               6.  i. Mention at least 2 work areas which uses Database Management Systems.
                  ii.  Jatin has given the following query from the table Student but he is unable to execute it successfully.  Write the correct
                   query after rectifying the error.                                           [CBSE Sample Paper 2021]
                    Select Name, Marks
                    From student Table
                    Where Name =”P%”
               7.  Consider the following table and write SQL statements                       [CBSE Sample Paper 2021]
                 Table Menu

                    ID          Item           Description          Price
                  P001    Sambar Vada      South Indian       40
                  P002    Dal Maakhani     North Indian       150
                  P003    Noodles          Chinese            100
                  P004    Idli Sambhar     South Indian       50
                  P006    Sarson Saag      North Indian       170
                  P007    Dosa             South Indian       120
                  P008    Pizza            Italian            200
                 i.  To  add a new row with the following data
                   “P009”, “Lemon Rice”, “South Indian”, 140
                 ii.  Display details of all Menu items in the descending order of Price.
                 iii. Display Item and Description of those Items whose price is between 100 and 150.
                 iv. Add a new column Rating datatype as int to the table Menu.
                                                                                                       Subject Enrichment
            C.  Competency-based/Application-based question:
               Anju wants to retrieve, update, insert and delete data in a database, which SQL command should she use. Write the common
               statements of that command.





            Lab aCtiVity
                                                                                                   Subject Enrichment

            1.  Consider the following Student table:
                                                   Table Name: STUDENT
                 STUD_ID     STUDENT_NAME       CLASS     MARKS    BONUS MARKS    AGE        TEACHER_ID

                   1001     AMIT                  X         90         NULL        17           NULL

                   1009     SUMIT                 XI        88           4         18           1205

                   1004     AJAY                 XII        78           7         19           1206
                   1002     ARUN                  IX        94         NULL        16           1203









                                                                                 Database Concepts—RDBMS Tool   185
   182   183   184   185   186   187   188   189   190   191   192