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

