{"id":4910,"date":"2024-05-03T22:47:51","date_gmt":"2024-05-03T17:17:51","guid":{"rendered":"https:\/\/cbsepython.in\/?p=4910"},"modified":"2024-12-03T20:09:22","modified_gmt":"2024-12-03T14:39:22","slug":"working-with-multiple-tables-question-answer","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/working-with-multiple-tables-question-answer\/","title":{"rendered":"Chapter 10 Working with Multiple Tables Question Answer Class 10 IT LibreOffice Base"},"content":{"rendered":"

Chapter 10 Working with Multiple Tables Question Answer Class 10 IT<\/span><\/h2>\n

A. Multiple choice questions<\/strong><\/span><\/p>\n

1. Which of the following actions can be performed once the tables are created in a database?<\/strong><\/span>
\n(a) Add a field in a table<\/span>
\n(b) Rename a table<\/span>
\n(c) Delete a table<\/span>
\n(d) All of the above<\/span><\/p>\n

Answer:(d) All of the above\u00a0<\/strong><\/span><\/p>\n

2. Which of the following is checked by a DBMS?<\/strong><\/span>
\n(a) Redundancy<\/span>
\n(b) Inconsistency<\/span>
\n(c) Both (a) and (b)<\/span>
\n(d) Neither (a) nor (b)<\/span><\/p>\n

Answer:(c) Both (a) and (b)\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

3. Which of the following is required to set a relationship between the two tables?<\/strong><\/span>
\n(a) Both the tables must be in different databases<\/span>
\n(b) Both the tables must have a common field<\/span>
\n(c) Both the tables must have the same name<\/span>
\n(d) Both tables must be stored in documents folder only.<\/span><\/p>\n

Answer:(b) Both the tables must have a common field\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

4. If a record is added in a master table, which of the following is NOT true for transaction table<\/strong><\/span>
\n(a) The record in the master table is called the master record<\/span>
\n(b) The corresponding record in transaction table can only be entered once.<\/span>
\n(c) The record in the transaction table is called the transaction record.<\/span>
\n(d) It is possible to add a record in the master table<\/span><\/p>\n

Answer:(b) The corresponding record in transaction table can only be entered once.\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

5. Which type of relationship exists between a student and the subjects studied by him\/her?<\/strong><\/span>
\n(a) One-to-one<\/span>
\n(b) One-to-many<\/span>
\n(c) Many-to-many<\/span>
\n(d) All of the above<\/span><\/p>\n

Answer:(b) One-to-many\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

6. Consider the following tables. Which type of relationship can be established between the two tables?<\/strong><\/span>
\n(a) One-to-one<\/span>
\n(b) One-to-many<\/span>
\n(c) Many-to-many<\/span>
\n(d) None of the above<\/span>
\nTable 1: Item Table 2: Item_Category<\/span>
\nItem_Code Category_Code<\/span>
\nItem_Name Cat_Name<\/span>
\nPrice Item_Code<\/span>
\nQty Cat_Disc<\/span>
\nCategory_Code<\/span><\/p>\n

Answer:(b) One-to-many\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

7. Which of the following menus contains the Relationship option?<\/strong><\/span>
\n(a) Edit<\/span>
\n(b) File<\/span>
\n(c) Tools<\/span>
\n(d) View<\/span><\/p>\n

Answer:(c) Tools\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

8. The list of tables to be added is displayed in the __________ dialog box in the Relationship Screen.<\/strong><\/span>
\n(a) Add Tables<\/span>
\n(b) Add Databases<\/span>
\n(c) Both (a) and (b)<\/span>
\n(a) Neither (a) nor (b)<\/span><\/p>\n

Answer:(a) Add Tables\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

9. In the relationship design screen, the relationship between the two tables is done using __________ operation.<\/strong><\/span>
\n(a) Click<\/span>
\n(b) Double Click<\/span>
\n(c) Drag and Drop<\/span>
\n(d) Right click<\/span><\/p>\n

Answer:(c) Drag and Drop\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

10. Which of the following is NOT an option that can be used to maintain referential integrity in a database?<\/strong><\/span>
\n(a) No Action<\/span>
\n(b) Set NULL<\/span>
\n(c) Set Default<\/span>
\n(d) Set Value<\/span><\/p>\n

Answer:(d) Set Value\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

B. State whether the following statements are True or False<\/strong><\/span><\/p>\n

1. Redundancy is preferred in a database. [False]<\/strong><\/span><\/p>\n

2. In a table, a record for a particular entity should not be repeated. [True]<\/strong><\/span><\/p>\n

3. A single field should always have only one data value. [False]<\/strong><\/span><\/p>\n

4. If a table is edited, the records already entered in it are deleted. [False]<\/strong><\/span><\/p>\n

5. The record in master table should be entered before the corresponding record is entered in the transaction table. [True]<\/strong><\/span><\/p>\n

6. In one-to-many relationship, one specific record of the master table has more than one corresponding records in the related transaction table. [True]<\/strong><\/span><\/p>\n

7. The Relationship option is present in the Widows menu. [False]<\/strong><\/span><\/p>\n

8. In a database, the referential integrity is maintained by the user. [False]<\/strong><\/span><\/p>\n

9. A relationship is always set between the tables based on a common field. [True]<\/strong><\/span><\/p>\n

10. If the master record is deleted, the transaction records will always be deleted. [False]<\/strong><\/span><\/p>\n

 <\/p>\n

C. Fill in the blanks<\/strong><\/span><\/p>\n

1. A table to be edited is displayed in ___________ view.<\/span><\/p>\n

Design<\/strong><\/span><\/p>\n

 <\/p>\n

2. The most important prerequisite for setting a relationship between the two tables is that there must be a ____________ between them.<\/span><\/p>\n

common field<\/strong><\/span><\/p>\n

 <\/p>\n

3. In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.<\/span><\/p>\n

one-to-one<\/strong><\/span><\/p>\n

 <\/p>\n

4. _________is one of the most common types of relationship between the tables in a database.<\/span><\/p>\n

one-to-many<\/strong><\/span><\/p>\n

 <\/p>\n

5. A record being entered in a _________ table must always exist in a ________ table.<\/span><\/p>\n

transaction, master<\/strong><\/span><\/p>\n

 <\/p>\n

6. The principle of _______________helps prevent missing data by keeping deleted data from getting out of synch.<\/span><\/p>\n

referential integrity<\/strong><\/span><\/p>\n

 <\/p>\n

7. Creating ____________ between tables restricts the user from entering invalid data in the referenced fields.<\/span><\/p>\n

relationship<\/strong><\/span><\/p>\n

 <\/p>\n

8. Data integrity is maintained by ___________.<\/span><\/p>\n

DBMS<\/strong><\/span><\/p>\n

 <\/p>\n

9. A relationship between customers and products is an example of ______________ relationship.<\/span><\/p>\n

Many-to-many<\/strong><\/span><\/p>\n

 <\/p>\n

10. The _______window is used to set relationships between the tables.<\/span><\/p>\n

10<\/strong><\/span><\/p>\n

 <\/p>\n

D. Answer the following questions<\/strong><\/span><\/p>\n

1. Give any two advantages of relating a table in a database.<\/span><\/strong><\/p>\n