Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 647 |
Match the following database terms to their function:
| (iv)(iii)(i)(ii) | |
| (ii)(iv)(i)(iii) | |
| (ii)(iv)(iii)(i) | |
| (iv)(iii)(ii)(i) |
Question 647 Explanation:
Normalization: Normalization is used to reduce the data redundancy in the database
Data Dictionary: Data dictionary contains meta describing database structure.
Referential Integrity: Referential integrity enforces match of primary key to foreign key
External Schema: Define view(s) of the database for particular user(s)
Data Dictionary: Data dictionary contains meta describing database structure.
Referential Integrity: Referential integrity enforces match of primary key to foreign key
External Schema: Define view(s) of the database for particular user(s)
Correct Answer: B
Question 647 Explanation:
Normalization: Normalization is used to reduce the data redundancy in the database
Data Dictionary: Data dictionary contains meta describing database structure.
Referential Integrity: Referential integrity enforces match of primary key to foreign key
External Schema: Define view(s) of the database for particular user(s)
Data Dictionary: Data dictionary contains meta describing database structure.
Referential Integrity: Referential integrity enforces match of primary key to foreign key
External Schema: Define view(s) of the database for particular user(s)