Page 374 - Information_Practice_Fliipbook_Class11
P. 374
Section C (3 Marks each)
26. Write any three characteristics of Big Data.
27. A department is maintaining their worker data using a WORKER table whose attributes and their types are listed
as follows:
WORKER_ID - character of size 3
FIRST_NAME – character of size 10
LAST_NAME– character of size 10
SALARY - numeric
JOINING_DATE – Date
DEPARTMENT – character of size 10
(i) Which attribute is most appropriate to be designated as the primary key of WORKER table? Justify your
answer.
(ii) Assuming that there are some records in the WORKER table. Write a SQL statement that delete all the records
of WORKER table.
28. What will be the output produced on the execution of following code snippet?
a = [ 'Cat', 'Dog', 'cat', 'Dog' ]
animal = { }
for index in a:
if index in animal:
animal[index]+=1
else:
animal[index]=1
print(animal)
print("The value is ",len(animal)**2)
29. List and explain three service models of cloud computing.
30. Consider the list given below:
result = [12,"Amita", 46,89,"B"]
Write the Python statement for each of the following tasks using BUILT-IN functions/methods only:
a. To reverse the order of elements in the list result.
b. To insert an element "Cleared" at the fourth place of list result.
c. To find the index of 89 in the list result.
Section D (5 Marks each)
31. Differentiate between the following:
a. Mutable and Immutable data types
b. append() and extend() list methods.
360 Touchpad Informatics Practices-XI

