CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A retail company stores customer data in separate flat files maintained by the sales, billing and delivery teams. The same customer's address is often different in each file. Which DBMS advantage most directly addresses this problem?
Controlled redundancy and improved consistency through a central database. Flat files kept by separate teams duplicate data, so addresses diverge. A DBMS stores data once and shares it, so a single update is visible to all users. It does not remove the need for backups.
- AControlled data redundancy and improved data consistency through a central databaseCorrect
- BFaster typing speed for data entry operators
- CElimination of the need for any backup
- DAutomatic conversion of all data into images
Explanation
The problem is duplicated data held in separate files that drifts out of sync. A DBMS keeps data centrally and controls redundancy, so one update is seen everywhere and consistency improves. Backup is still needed, so the third option is wrong.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- A bank analyses millions of past transactions to find hidden patterns, for example that customers buying a certain product combination often…
- A bank's employee, while a transaction updating a customer's balance is still uncommitted, is shown by another session a balance value that …
- In the ETL process used to populate a data warehouse, which activity is performed in the 'Transform' step?
- An e-commerce firm stores personal data of buyers. Its database designer finds that a Buyer table holds buyer name, city and also the city's…
- A company wants a data model in which records are organised as a tree, each child record having exactly one parent, and access follows fixed…
- A table EMP has 6 rows with salaries 20000, 30000, 30000, 40000, 50000 and NULL. Which of the following statements about the results is corr…