Page 369 - Information_Practice_Fliipbook_Class11
P. 369

Section B (2 Marks each)

              19.  What is meant by disk fragmentation?
                         OR
                What are the security threats involved when you throw away electronic gadgets that are non-functional?

              20.  Differentiate between public cloud and private cloud.

                         OR

                List any two applications of big data.
              21.   Write a program that takes a year as an input from the user and checks whether the given year is a leap year or
                not.

              22.  What is the purpose of referential integrity constraint?

              23.  What will be the output produced on the execution of following code segment?
               for i in range( 21, 30, 2):

                   print(i)
                         OR
                What will be the output produced on the execution of following code segment?

               for i in range (55,50,-2)

                     print (i)
              24.  Differentiate between primary key and candidate key.
              25.  What do you mean by degree and the cardinality of a relation?



                                                    Section C (3 Marks each)

              26.  Consider the Student table given below:
                Table :-Student

                 RollNo   Name        Class       Fees      Gender
                 1        Aditya      10th        7000      78
                 2        Priya       11th        7500      75
                 3        Aarti       10th        7000      76
                 4        Ajay        11th        7500      74

                Write SQL statements to perform the following operations:
                (i) Display all the record of the table Student.

                (ii) Display Roll Number, Name and Class from the table Student.

                (iii) Display all the student with name Aarti.
              27.  Explain the purpose of cache memory in the computer system.

              28.   Write a program that accepts the name of student along with the marks in obtained by the student in three
                subjects - IP, Science, and Economics. Program should then create a dictionary of name of subject and the marks as
                a key value pair. For example, {'IP':70, 'Science':68, 'Economics': 65}. Finally, the program should display the total
                and average marks obtained by the student.


                                                                                                Practice Paper 1  355
   364   365   366   367   368   369   370   371   372   373   374