Army Public School, R

Practice set

Class – XI Sub – Informatics Practices

TIME : 90 Mins MAX. MARKS: 40

1 / (a) / Create table Student having following specifications:
Column Name / type / Size
Roll / Number
Name / Character / 20
Phone / Number
Address / Character / 50
/ 2
(b) / What will be the Degree and cardinality of above table if we insert 7 records and 2 attributes in the table? / 2
(c) / Explain Like clause in DBMS with suitable example / 2
(d) / Explain difference between DISTINCT and ALL clause in SQL statement with suitable example. / 2
(e) / Define the following with suitable example
i)Primary Key ii)Foreign Key / 2
2 / (a) / Write equivalent statement for following queries in DBMS
i)  Select * from empl where salary between 15000 and 55000;
ii)  Select sname from student where city in (“rewa”, “satna”, “Bhopal”); / 2
(b) / Based on following table write Queries for (i) to (vi) & Output for (vii) to (viii)

i)  Display the list of students in Commerce stream.
ii)  List the name of students scoring more than 80 Marks
iii)  Display Name and stream of students reading in class 11
iv)  Display Class of students who got marks less than 70
v)  Insert new record in table, assume values yourself.
vi)  SELECT * from student where grade in (‘A’,’B’);
vii)  SELECT Name, Stream from STUDENT where marks NOT BETWEEN 70 and 80
viii)  SELECT * from student where name = ‘Deepa’; / 4+2
3 / (a) / Define view? What happens when a table contained in view is deleted? / 2
(b) / Categorise the queries in DDL, DML and TCL query
INSERT, DROP, ROLLBACK, DELETE, UPDATE, ALTER, CREAT, SAVEPOINT / 3
(c) / What is order by clause in select query. Explain with suitable example. / 2
(d) / Write any 02 differences between Combo box and a List. / 2
(e) / A Cotton Shop has announced the following discount on the purchase of cloths, based on the total cost of the cloths purchased:
Total cost Discount Rate
Less than Rs. 1000 10%
More than 1000 20%

i)  Write the code to calculate discount amount.
ii)  Write the code to close the application on click of exit button. / 3
(f) /

c) Write the code for exit button
d) assume a CLEAR BUTTON and write code to clear the text boxes. / 3+2
4 / (a) / Write the command to be used to see the structure of Table / 1
(b) / Which command is used for opening an existing Database? / 1
(c) / What do you mean by data redundancy? / 1
(d) / Write the SQL command to view the list of Tables in database? / 1
(e) / List the categories into which MySQL statements can be categorized. / 1

**********BEST WISHES AND GOOD LUCK**********