Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 68 - Modular_V2.0_SQL_Flipbook
P. 68

    E.  Long answer type questions.

                     1.   Explain the concept of Subqueries in MySQL with examples.
                     2.  What are views in SQL? Explain how they are created, updated, and deleted with examples.

                     3.   Describe the different types of indexes. Provide examples for each.
                                                                                                21 st  Century   #Collaboration
                  F.   Competency-based/Application-based question.                                 Skills  #Technology Literacy
                        Rahul has created a view in MySQL. Now, he wants to update the view. Help him by writing the rules to
                      be kept in mind before updating views.

                                                         In the lab                     21 st  Century   #Technology Literacy
                                                                                            Skills
                                                                                                 #Productivity & Accountability
                     1.  Write a query to create an equijoin between the Games and Student tables, matching the Game_id
                        column in both tables.
                     2.  Create a view STUDENT_VIEW that selects Stu_name, Age, and Fees from the STUDENT table.
                             Insert a new record into the STUDENT_VIEW with the values for Stu_name = 'Rani', Age = 19,
                            Fees = 15000.

                             Retrieve the records from STUDENT_VIEW after inserting the new data.

                   Teacher's Corner

                  1.   Discuss about Subqueries and Views with the students.
                  2.  Explain the concept of Index to the students.

                    66
                          Touchpad MODULAR (Ver. 2.0)

| 63 64 65 66 67 68 69 70 71 72 73 |