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
   238   239   240   241   242   243   244   245   246   247   248