DBMS vs File System Quiz

Which of the following is a major disadvantage of the traditional file system compared to a DBMS?

• Low data redundancy

• High data integrity

• No data independence

• Easy concurrent access

What is the key difference between a File System and a DBMS?

• File systems use SQL to query data

• DBMS allows data to be stored in flat files

• File systems lack centralized control over data

• DBMS cannot handle large datasets

Which of the following is NOT an advantage of using a DBMS?

• Data Redundancy

• Data Integrity

• Data Security

• Concurrency Control

In a DBMS, data abstraction provides:

• Less storage space for large datasets

• A direct mapping between user application and physical storage

• Multiple views of the same data for different users

• Less control over data access

Which layer of a DBMS helps separate the user-level data access from physical data storage?

• Application Layer

• Logical Layer

• Presentation Layer

• Physical Layer