CLASS 10 UNIT 3 SESSION 3 BOOK ASSESSMENT IMPORTANT QUESTIONS
CLASS 10 UNIT 3 SESSION 3 BOOK ASSESSMENT IMPORTANT QUESTION
CLASS 10 IT BOOK CODE 402 SYLLABUS ON CBSE
ASSESSMENT
Fill in the blanks:
- The types of languages used for creating and manipulating the data in the Database are________ & __________.
Answer: DDL , DML
2. A ________ is a standard for commands that define the different structures in a database.
Answer: DDL
3. A ________ is a language that enables users to access and manipulate data in a database.
Answer: DML
4. A ________ is a part of DML involving information retrieval only.
Answer: Select
5. A popular data manipulation language is __________.
Answer: SQL
6. __________are the basic building blocks of a database.
Answer: Tables
7. There are _______ types of Relationships in a table.
Answer: Three
Short Answer Questions:
- What is the file extension for databases created using OpenOffice.Org Base?
Answer: The file extension for databases is .odb
2. List any three file formats using OpenOffice.Org that can be managed using OpenOffice.Org Base?
Answer: Three file formats are:
- .odb
- .odf
- .odt
3.How many types of relationships can be created in Base? Explain each of the them.
Answer:
There are three types of relationships which can be created in tables:
- ONE to ONE
- ONE to MANY OR MANY to ONE
- MANY to MANY
One to One Relationship:
In this relationship, both the tables must have primary key columns. Example: In the given tables EMP and DEPT, EMP_ID in EMP table and DEPT_ID in DEPT table are the primary keys.
One to Many Relationship:
In this relationship, one of the table must have primary key column. It signifies that one column of primary key table is associated with all the columns of associated table.
Many to Many Relationship:
In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.
4.What do you mean by Sorting? In how many ways it can be done?
Answer: Sorting means to arrange the data in particular sequence order. There are two ways for sorting:
- Ascending order
2. Descending order.
5.Explain Referential Integrity with the help of an example.
Answer: Referential integrity is used to maintain accuracy and consistency of data in a relationship.
For example we have two tables:
Student table has fields Stu_id, Name, Fname, (Stu_id is primary key)
Teacher table has fields T_id, Stu_id, Tname (T_id is a primary key and Stu_id is foreign key)
Both tables can be linked by common fields i.e. Stu_id.