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

