Which one of the following is an advantage of database management approach?
Correct answer: D. All of the above
- A. Programs are independent of data format
- B. Reduces security and the control of data
- C. Increases duplication of data
- D. All of the above
Explanation
The correct answer is (D) All of the above.Database management systems (DBMS) offer several advantages over traditional file-based systems for managing data. Here's a breakdown of why each option is a benefit of using a DBMS:(A) Programs are independent of data format: In a DBMS, the data is stored in a central repository with a defined structure (schema). This schema acts as an interface between the data and the programs that access it. Programs can interact with the data using a query language (like SQL) without needing to know the specific physical storage format of the data. This simplifies program development and maintenance, as any changes to the data storage format won't necessarily require modifying the programs themselves.(B) Reduces security and the control of data: A DBMS provides security features like access control mechanisms, user authentication, and data encryption. These features help restrict unauthorized access to data and ensure only authorized users can modify or delete it. This improves data security and control compared to file-based systems where data might be more vulnerable.(C) Increases duplication of data: A well-designed database minimizes data redundancy by storing each piece of data only once. Data integrity rules can be enforced to prevent inconsistencies. This reduces storage requirements and the risk of errors that can occur when the same data is duplicated across multiple files.In conclusion, database management systems offer significant advantages for data management, including data independence, improved security, and reduced data redundancy
Report an error
The more specific you are, the faster it gets fixed. A source beats an opinion.
Prefer email? [email protected]
About Databases
Databases cover tables, records, fields, keys and relationships, together with database management systems and relational database design. The subject includes primary and foreign keys, normalization, SQL commands such as SELECT, INSERT, UPDATE and DELETE, queries, forms and reports, while distinguishing a database from a spreadsheet used for simple tabular data.
Practise Databases
210 free Databases MCQs from Computer Science and IT, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Discussion
Stuck on an option, or know a faster way to get there? Ask or explain it here.
No comments yet. Be the first to explain this one.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 85 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.
More Databases questions
A request for information from a database in database terminology is called:
Which of the following is also known as a data set?
A database containing all students in a class would store basic data of students in:
SQL stands for
Which of the following is NOT a file type from a usage point of view?
The process of getting data from DBMS: