IT-402 Ch 10 Working with Multiple Tables Question Answers
IT-402 Ch 10 Working with Multiple Tables Question Answers
A. Multiple choice questions
Q1. Which of the following actions can be performed once the tables are created in a database?
(a) Add a field in a table
(b) Rename a table
(c) Delete a table
(d) All of the above
Q2. Which of the following is checked by a DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Q3. Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.
Q4. If a record is added in a master table, which of the following is NOT true for transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table
Q5. Which type of relationship exists between a student and the subjects studied by him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above
Q6. Consider the following tables. Which type of relationship can be established between the two tables?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above
Q7. Which of the following menus contains the Relationship option?
(a) Edit
(b) File
(c) Tools
(d) View
Q8. The list of tables to be added is displayed in the ____________ dialog box in the Relationship Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)
Q9. In the relationship design screen, the relationship between the two tables is done using ______________ operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click
Q10. Which of the following is NOT an option that can be used to maintain referential integrity in a database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value
B. State whether the following statements are True or False
1. Redundancy is preferred in a database.
2. In a table, a record for a particular entity should not be repeated.
3. A single field should always have only one data value.
4. If a table is edited, the records already entered in it are deleted.
5. The record in master table should be entered before the corresponding record is entered in the transaction table.
6. In one-to-many relationship, one specific record of the master table has more than one corresponding records in the related transaction table.
7. The Relationship option is present in the Widows menu.
8. In a database, the referential integrity is maintained by the user.
9. A relationship is always set between the tables based on a common field.
10. If the master record is deleted, the transaction records will always be deleted.
C. Fill in the blanks
1. A table to be edited is displayed in __________________ view.
2. The most important prerequisite for setting a relationship between the two tables is that there must be a _____________ between them.
3. In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.
4. ___________________is one of the most common types of relationship between the tables in a database.
5. A record being entered in a ______________ table must always exist in a ________________ table.
6. The principle of _______________helps prevent missing data by keeping deleted data from getting out of synch.
7. Creating _________________ between tables restricts the user from entering invalid data in the referenced fields.
8. Data integrity is maintained by ____________________.
9. A relationship between customers and products is an example of ______ relationship.
10. The ______ window is used to set relationships between the tables.
D. Answer the following questions
Q1. Give any two advantages of relating a table in a database.
Q2. How is redundancy or inconsistency controlled in a database? Explain with an example.
Q3. Define referential integrity. Who maintains referential integrity in a database?
Q4. Differentiate between one to one relationship and one to many relationship. Give suitable examples to explain your answer.
Q5. Explain many to many relationship with an example.
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
Unit 3: Database Management system using LibreOffice Base
Chapter 8. Introduction to DBMS – NOTES
Chapter 8. Introduction to DBMS – Question Answers
Chapter 9. Starting with LibreOffice Base – NOTES
Chapter 9. Starting with LibreOffice Base – Question Answers
Chapter 10. Working with Multiple Tables – NOTES
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you the simple answers of “Ch 10 Working with Multiple Tables Question Answers“, but if you feel that there is/are mistakes in the answers of “Ch 10 Working with Multiple Tables Question Answers” given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE Website are used to create above article “Ch 10 Working with Multiple Tables Question Answers”