Database-Management-System
August 26, 2024Database-Management-System
August 26, 2024Indexing
| Question 9 |
Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems:
(a) Data redundancy and inconsistency
(b) Difficulty in accessing Data
(c) Data isolation
(d) Integrity problems
(a) Data redundancy and inconsistency
(b) Difficulty in accessing Data
(c) Data isolation
(d) Integrity problems
| (a) | |
| (a) and (d) | |
| (a), (b) and (c) | |
| (a), (b), (c) and (d) |
Question 9 Explanation:
Drawbacks of using a file system are data redundancy, data inconsistency, difficulty in accessing data, data isolation and data integrity. So to overcome all these disadvantages Database management system are used because it involves specifying the data types, structures and constraints of the data to be stored in the database. Constraints that helps in overcoming the disadvantages of file system are
1. Entity constraint: No primary key should have NULL values.
2. Key constraint: No two rows in a table should be same.
3. Domain constraint: A column in a table should not be multi valued or composite
4. Referential integrity constraint: A foreign key should contain the subset values of primary key.
1. Entity constraint: No primary key should have NULL values.
2. Key constraint: No two rows in a table should be same.
3. Domain constraint: A column in a table should not be multi valued or composite
4. Referential integrity constraint: A foreign key should contain the subset values of primary key.
Correct Answer: D
Question 9 Explanation:
Drawbacks of using a file system are data redundancy, data inconsistency, difficulty in accessing data, data isolation and data integrity. So to overcome all these disadvantages Database management system are used because it involves specifying the data types, structures and constraints of the data to be stored in the database. Constraints that helps in overcoming the disadvantages of file system are
1. Entity constraint: No primary key should have NULL values.
2. Key constraint: No two rows in a table should be same.
3. Domain constraint: A column in a table should not be multi valued or composite
4. Referential integrity constraint: A foreign key should contain the subset values of primary key.
1. Entity constraint: No primary key should have NULL values.
2. Key constraint: No two rows in a table should be same.
3. Domain constraint: A column in a table should not be multi valued or composite
4. Referential integrity constraint: A foreign key should contain the subset values of primary key.