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
   369   370   371   372   373   374   375   376   377   378   379