1st Quiz on DDBMS

What is a DDBMS

• A system managing a single-location database.

• A system governing data storage and processing across multiple sites.

• A system that only stores data

• A system requiring central server access

Which is NOT an advantage of DDBMS

• Improved performance

• Increased operating costs

• Enhanced reliability

• Geographical access

limitation of centralized databases in the 1970s

• Multiple user access

• Mobile access capabilities

• Support for rapid queries

• Slow response times

What factor contributed to the need for distributed databases

• Fewer dispersed business units

• Rise of mobile devices and applications as a service

• Decline of Internet usage

• Simplified database management.

Which statement about distributed databases is true

• Higher availability due to distribution

• Must use the same software at all sites.

• Always more cost-effective than centralized systems

• No need for synchronization

Why is rapid ad hoc data access crucial today

• Reduces complex queries needed

• Ensures decisions are structured information based

• Relies on historical data

• Supports quick decisions

Why DDBMS

• Reduced need for security

• Simplicity in management

• Handling large data volumes across locations

• Lower initial costs

Why is scalability important in DDBMS

• Accommodates growing data and users without loss.

• Performance degrades with more users

• Limits access to specific locations

• Maintains a single point of failure

consequence of centralized systems

• Single point of failure issues

• Enhanced flexibility

• Simplified backups

• Improved performance

Why might centralized systems face scalability issues

• No scalability concerns exist

• Unlimited user access without degradation.

• Easily expand without limits

• Physical constraints limit growth at one location