Page 375 - Information_Practice_Fliipbook_Class11
P. 375

32.  Consider the table CARSALES given below:

               TABLE: CARSALES

                 carCode       Model       Make        color        capacity    dateOfPurchase
                 501           A-star      Suzuki      RED          3           '2020-10-01'
                 503           Indigo      Tata        SILVER       3           '2019-02-20'
                 502           Innova      Toyota      NULL                     '2022-07-24'

                 509           SX4         Suzuki      SILVER       4           NULL
                 510           C-Class     Mercedes    RED          4           '2022-05-21'

                Write SQL statements to perform the following:
                (i)  To display count of cars of each color.

                (ii)  To display the model and the capacity of car whose make is 'Suzuki'.

                (iii)  To display the names of cars whose capacity is not known
                (iv)  To insert the following record:
                    555, Nexon, Honda, Red, 5, '2023-09-30'


                                                    Section E (4 Marks each)

              33.  What will be the output produced on the execution of following code snippets?

                (i)

               for ch in "#PaRcel":
                   print(ch, end = '!')
               else:
                   print(" Received")
                (ii)

               for num in range(5, -5, -5):
                   print(num,  end = '#')
               else:

                   print()
                   print("OVER")
                (iii)

               a = 4
               while (a < 13 or a % 3 == 0):
                   print(a, end = '%')
                   a = a +3
                (iv)

               p = 5
               while (p <=12):

                   if p % 7 == 0:



                                                                                                Practice Paper 2  361
   370   371   372   373   374   375   376   377   378   379   380