Database Management Systems Quiz

Which of the following best describes the key difference between a file-based system and a database management system?

• Storage medium

• Data organisation and management capabilities

• Cost of implementation

• Number of files stored

In the context of ACID properties, what does "Atomicity" primarily ensure?

• Data is permanently stored

• Transactions are completed entirely or not at all

• Concurrent transactions do not interfere

• Database remains in a consistent state

Which validation method ensures data follows a specific predefined pattern?

• Range check

• Type check

• Format check

• Presence check

What is the primary purpose of database transaction isolation?

• To prevent data loss

• To ensure transactions do not interfere with each other

• To reduce database complexity

• To speed up data processing

Which characteristic distinguishes quantitative data from qualitative data?

• Numerical nature

• Complexity of collection

• Storage requirements

• Processing speed

In a multi-user database environment, what does "concurrency" primarily refer to?

• The number of users accessing the database

• Simultaneous execution of multiple transactions

• Database processing speed

• Number of database servers

What is the primary limitation of a file-based approach to data storage?

• High cost

• Limited storage capacity

• Inefficient data management and potential redundancy

• Complexity of implementation

Which ACID property ensures that committed transaction changes are permanent?

• Atomicity

• Consistency

• Isolation

• Durability

What transforms raw data into meaningful information?

• Computational processing

• Contextualisation and analysis

• Storage techniques

• Database design

In database management, what does a "shared lock" typically allow?

• Exclusive data modification

• Reading data without updates

• Complete data blocking

• Permanent data storage