Page 243 - IT_V1.0_Class10
P. 243
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. In the process of renaming a table, which dialog box appears after selecting the Rename option?
i. Rename to ii. Update Table
iii. Confirm Rename iv. Table Properties
2. What is an essential benefit of establishing relationships in a database?
i. Simplifies renaming tables ii. Enables automatic updates across related tables
iii. Allows deletion of all records at once iv. Removes the need for primary keys
3. In a Many-to-Many relationship, which of the following is true?
i. One record of a table is linked to only one record of another table
ii. One record of a table is linked to multiple records of another table
iii. Multiple records of one table are linked to multiple records of another table
iv. None of the above
4. A student is enrolled in several subjects, and each subject can be taken by multiple students. What type of
relationship exists between the “Student” and “Subjects” tables?
i. One-to-one ii. One-to-many
iii. Many-to-many iv. None of these
B. State whether the following statements are true or false:
1. Referential integrity ensures that you can add records to a child table even if there is no
associated record in the parent table. ............................
2. Renaming a table automatically updates its data content. ............................
3. Deleting a table removes its structure but not its data. ............................
4. A relationship is established between tables using a shared field. ............................
21 st
C. Assertion and reasoning question. Century #Critical Thinking
Skills
The following question consists of two statements – Assertion (A) and Reason (R).
Answer the question by selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
iii. A is true but R is false.
iv. A is false but R is true.
Assertion (A): Referential integrity ensures that records in a child table cannot exist without a corresponding
record in the parent table.
Reason (R): Referential integrity allows deleting records from the primary key table if there are matching
records in the child table(s), unless cascading delete is specified.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. Write a steps to delete a table.
2. Define many-to-many relationship.
3. Explain the steps to rename a table in LibreOffice Base.
4. Explain the options that are provided by LibreOffice Base for maintaining referential integrity.
Working with Multiple Tables 241

