Class 10 Information Technology [402]
Unit 3 Relational Database Management System
300+ Important Question Answer based on NCERT book.
Session 3 – Perform Operations on Table
Questions Answers cum Notes.
1. How can you insert data into the table? Write steps.
Answer: To insert the data into the table,
Select the table and make double-click on it.
It will open the table in Datasheet View, in which new data can be inserted, and existing data can be updated or removed.
2. How can you edit records in the table? Write steps.
Answer: To edit the data in the table,
Click on Edit Data (
) Icon or Double Click on the data in the cell of a table.
Modification can be done.
3. How can you delete records from the table? Write steps.
Answer: To remove the data from the table, follow the steps:
Select the data > right click on selected data > Select the Delete option.
Records will be deleted from the table.
4. How can you change the Field Properties?
Answer: To set the field properties, steps will be followed as:
Select the table > Right-click > Select the option Edit > the table Design View window will open.
In the design view, there are different properties of fields according to the data type set for each field.
5. Write the name of the different types of Field Properties.
Answer: Different types of field properties are:-
(a) Entry Required,
(b) Length,
(c) Decimal places,
(d) Default value,
(e) Format example,
(f) Auto Value
6. Write the name of the different types of Field Properties of numeric data type.
Answer: Different types of field properties of Numeric data type are:-
(a) AutoValue ,
(b) Length,
(c) Default Value, and
(d) Format example
7. What are AutoValue field properties?
Answer: AutoValue means Auto numeric value. If you set AutoValue properties Yes, then the field will get the auto numeric values.
8. What are Length field properties?
Answer: Length field properties specify the maximum length of the data of the field. By default length of INT is 10 and TEXT is 50.
9. What are Default Value field properties?
Answer: A default value can be set for a field if the user doesn’t provide any value while entering the values in the table.
10. What are Entry Required field properties?
Answer: If Entry Required field properties are set to yes then it will be a must to insert the value in the field which means that field cannot be left blank.
11. What are Format example field properties?
Answer: This property helps to set the format of the data entered in the field such as 91-222-333.
Formatting is used to control the look of the data entered in a field.
12. What are Decimal Places field properties?
Answer: This property specifies the number of decimal places permitted in this field. The Decimal places property to display numbers differently from the say specified by the Format property setting.
13. What is Data Validation?
Answer: Data Validation refers to the process of ensuring that only valid data as per set norms or rules should be allowed in the table.
14. In Base, What operations you can perform with data stored in tables?
Answer: In Base, data is stored in tables which can be inserted, modified, and removed using appropriate options.
15. What do you mean by Sorting Data?
Answer: In Base, Sorting means arranging the data in either ascending order of descending order.
16. How can you sort records in Base?
Answer: In Base, to sort records you need to follow these steps:- (a) Select the column(s) (b) Click on the sort buttons either 
(ascending) or 
(descending).
17. What is Referential Integrity?
Answer: Referential Integrity is a system of rules that a DBMS uses to ensure that relationships between records in related tables are valued and that users do not accidentally delete or change related data.
18. What is the use of Referential Integrity?
Answer: Referential integrity is used to maintain the accuracy and consistency of data in a relationship.
Referential integrity is to ensure that no related data gets accidentally deleted or changed.
19. In Base, How data between two tables are linked?
Answer: In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.
20. In Base, How data between two tables are linked?
Answer: In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.
21. What avoids by Referential integrity?
Answer: Referential Integrity helps to avoid:-
(a) Adding records to a related table if there is no associated record available in the primary key table.
(b) Changing values in a primary if any dependent records are present in the associated table(s).
(c) Deleting records from a primary key table if there are any matching related records available in the associated table(s).
22. What is a relationship?
Answer: A relationship refers to an association or connection between two or more tables.
When you relate two tables, you don’t need to enter the same data in separate tables.
23. What are the advantages of Relationships between tables?
Answer: Relationships between tables has the following advantages :-
(a) Save time as there is no need to enter the same data in separate tables.
(b) Reduce data-entry errors.
(c) Summarize data from related tables.
24. Relationships option is available under which menu?
Answer: Relationships option is available under the Tools menu.
25. How many types of relationships are in Base?
Answer: There are three types of Relationships :
(a) One to One ( 1 : 1),
(b) One to Many (1 : n) or Many to One (n : 1),
(c) Many to Many (m : n)
