Page 56 - ipp11

SECTION B (7 × 2 = 14 Marks)
22. (a) Differentiate between compiler and interpreter. (2)
OR

(b) Define the term Machine Learning.
23. Write a short note on Cache Memory. (2)
24. What will be the output of the following code? (2)

a = "Hello"
b = "World"
print(a + b)
print(a * 2)
25. (a) What are the rules of naming an identifier in Python? (2)
OR

(b) What are the characteristics of Big Data?
26. What is type casting? (2)
27. Differentiate between primary key and candidate key. (2)
28. (a) A company has a table named Employees, which stores details of its staff. The table has 8 columns
(EmployeeID, Name, Age, Department, Salary, City, Contact_No, Joining_Date) and 65 rows
representing employee records. (2)
Based on this information, answer the following:
(i) What is the degree of Employees table?
(ii) What is the cardinality of Employees table?
OR
(b) A university maintains a database of students with attributes like Student_ID, Stu_Name, Email_ID,
Phone_No and Course. Each student is assigned a unique Student_ID and their Email_ID, Phone_No
are also unique.
Based on this information, answer the following:
(i) Identify the primary key for this table.
(ii) List the possible candidate keys and justify them.

SECTION C (3 × 3 = 9 Marks)
29. Define the following terms: (3)
(a) Domain of Relation
(b) Metadata
(c) Data Consistency
30. (a) Write an SQL statement to create a table, PATIENTS, with the following specifications: (3)
Patient_ID (Numeric, Primary Key)
Patient_Name (Varchar(25), Not NULL)
Age (Integer)
Gender (Char(1))
Phone (Unique Key, Numeric)
Disease (Varchar(30))
Admission_Date (Date)
OR
(b) Write SQL commands to perform the following tasks:
(i) Create a database named ‘Library’.
(ii) Open database ‘Library’.
(iii) Display the structure of existing table ‘Books’.

P.3