KAILASH SCHOOL OF EXCELLENCE
Affiliated to CBSE –New Delhi
Paramathy main Road, Namakkal-637002
Class : X Subject: Information Technology Date: 25/10/2024 Marks: 30
1. Choose the correct answer 10X1=10
1. A database is an organized collection of__________
A. Data b. attributes c. record d. none of these
2. Which of the following software is appropriate to store data about school students?
A. MS-access b. Writer c. Calc d. Impress
3. Which of the following is not a database programs?
A. My Sql b. Oracle c. Writer d. OObase
4. _________ store data in single table.
A. Flat file b. Relational c. single file d. One file
5. GUI act as front end and database server act as_______
A. Container b. Back end c. End [Link] of these
6. Duplication of data is called______
A. Inconsistency b. Consistency c. Redundancy d. Foreign key
7. Which of the following is not the advantage of database?
A. Sharing of data b. Reduce data redundancy c. Increase data
redundancy d. Data security
8. Which of the following is not valid field of table “student”.
A. Admno b. name c. fees [Link]
9. All the values in _______ are of same type
A. Records b. table c. database [Link]
10. By default data type of field is ________
A. Text [varchar] b. Text[char] c. Int [Link]
II. Answer the following questions: (any 5) 5 X2=10
1. What is database and DBMS?Name some two DBMS software.
2. Difference between flat file and Relational .
[Link] do you mean by database server?
4. Write any four advantages of database.
[Link] do you mean by data redundancy and data integrity?
6. Answer the following questions on the basis of following table student and teacher
TABLE :STUDENT
Stud_Id Stud_Name Class Tuition Fess
1 Aman IX 3000
2 Anil X 3200
TABLE:TEACHER
T_Id T_Name T_Salary Stud_Id
3210 [Link] 60000 1
3211 [Link] 70000 2
A. Identify the primary key in student and Teacher table.
B. Identify the foreign key in Teacher table.
II. Answer the following in detail: (any 2) 5X2=10
1. Define
(a) table (b) record (c)Foreign key (d) Primary key (e)SQL
2. (A) Define structure of the table (b) Differentiate between tuple and attributes in a
table
3. Explain about data types in brief.