Page 332 - Trackpad 402_Class-X_Final
P. 332
5. List data type available in Numeric data type. [CBSE Handbook]
6. What is DBMS? Explain any two advantages of DBMS
7. Differentiate between Primary key and Foreign key.
8. Name DML commands. [CBSE Handbook]
9. Define the following:
a. Text data type
b. Memo data type
10. What is the purpose of using queries? [CBSE Handbook]
B. Long answer type questions:
1. How many types of relationships can be created in Base? Explain each of the them. [CBSE Handbook]
2. List different ways of creating tables in a database.
3. What do you mean by Sorting? In how many ways can it be done? [CBSE Handbook]
4. How to open an existing table in a database? Give two ways to do this.
5. Differentiate between Where and Order by clause of SQL statements. [CBSE Handbook]
6. What do you mean by DDL (Data definition language)? Give example.
7. Differentiate between Forms and Reports. [CBSE Handbook]
21 st #Communication
C. Competency-based/Application-based questions: Century
Skills #Leadership & Responsibility
1. Write an SQL command to do the following:
Table : FRIENDS
Rollno Student_Name DOB City Mobile_no Gender Percentage
1 Shikha 10/01/2007 Mumbai 98XX15XXXX F 98
2. Rohit 24/03/2006 Delhi 99XX20XXXX M 82
3 Sandeep 12/01/2005 Delhi 88XX17XXXX M 91
4 Jagriti 07/07/2009 Banglore 89XX15XXXX F 96
5 Praveen 15/09/2007 Mumbai 78XX00XXXX M 89
a. Display all the information from the table whose City is ‘Delhi’.
b. Display of all the students whose percentage is between 90 to 100.
c. Display name, city,gender of all students whose name has ‘a’ somewhere in name.
d. Display name, city,gender of all students whose name has the second last alphabet as ’i’.
e. Display the records after arranging them in ascending order of names.
f. Update the percentage of Rohit by adding 5 more in the percentage.
g. Display the structure of the table.
h. Display the name, dob, city of all with gender ‘F’.
i. Display only those records who were born in 2007.
j. Add another column ‘SCHOOL’ in the above created table.
2. Ananya wants to use a database in her bookshop . Suggest a database object to do the following:
a. To store the information of the total stock in the tabular form.
b. Design an interactive screen to enter and display the information.
c. Create a report of stock available in her bookshop.
d. Wanted to create a query based on a criteria.
3. Charu has to create a database named MYEARTH in MYSQL. She now needs to create a table named CITY in the database
to store the records of various cities across the globe. The table CITY has the following structure:
Table: City
FIELD NAME DATA TYPE REMARKS
CITYCODE CHAR(5) Primary Key
CITYNAME CHAR(30)
332 Trackpad Information Technology-X

