file sys vs DBMS Flashcards
(16 cards)
What is a file-based system?
A system where data is stored in flat files, managed by individual programs.
What is a DBMS?
Software that manages databases in a centralized way with integrated control over data.
Give one example of a file-based system.
A system using .txt or .csv files with no DBMS involved.
Give examples of DBMS software.
MySQL, Oracle, PostgreSQL, Microsoft SQL Server.
List one disadvantage of a file-based system.
Data redundancy due to repeated data across files.
List one advantage of DBMS over file-based system.
Centralized control and reduced redundancy.
How does DBMS ensure data consistency?
By centralizing data and enforcing integrity constraints.
What is data integrity?
Ensuring accuracy and consistency of data across the system.
Does file-based system support concurrency control?
No, it lacks mechanisms to handle multiple user access.
Can DBMS handle complex queries?
Yes, using SQL it supports complex and efficient data querying.
Which system is more secure?
DBMS, as it supports user-level security and access control.
Is backup and recovery automated in file-based system?
No, it’s usually manual and error-prone.
Which system is better for large-scale applications?
DBMS is better due to scalability and efficiency.
What is data redundancy?
Repetition of the same data in different places or files.
Which system offers data independence?
DBMS separates application from data structure, offering data independence.
