FDS - Quiz 1

Why is logical database design an important step in database development? (Select three)

• It ensures that data structures are well-formed before physical storage implementation.

• It helps convert conceptual models into a structured format compatible with database management systems.

• It directly defines how data will be stored on physical storage devices.

• It involves integrating individual user views into a comprehensive database model.

Which actions are performed during the Physical Database Design and Definition phase? (Select two)

• Transforming the conceptual schema into a logical schema.

• Defining storage structures, indexing strategies, and file organization.

• Writing SQL scripts to create, modify, and retrieve database contents.

• Ensuring that data retrieval processes are optimized for performance.

How did database technology evolve in response to new computing trends in the 1990s and beyond? (Select three)

• The rise of client/server computing led to increased demand for structured data storage.

• The emergence of multimedia data resulted in the introduction of object-oriented databases.

• Relational databases lost popularity entirely due to the rise of NoSQL databases.

• Cloud computing has enabled databases to be deployed and managed by external service providers.

Which of the following best describes the iterative nature of the Systems Development Life Cycle (SDLC)? (Select two)

• The SDLC consists of sequential steps with no possibility of backtracking.

• Phases of the SDLC can overlap, run in parallel, and allow for revisiting prior decisions.

• SDLC is a circular process that refines the system through multiple levels of detail over time.

• Once a phase is completed, modifications to previous steps are not possible.

Why is data duplication considered a disadvantage in file processing systems? (Select two)

• It simplifies the management of separate applications.

• It leads to unnecessary storage consumption.

• It increases the effort needed to maintain data consistency.

• It helps ensure that each department has exclusive access to data.

Why is the distinction between a repository and a database important in database management? (Select two)

• The repository stores metadata, while the database stores actual data occurrences.

• A repository is essential for managing data definitions, whereas a database is used for user transactions.

• Without a repository, a database cannot store or retrieve data.

• The repository only benefits system developers, while the database is meant for end users.

How does the database approach contribute to improved decision support? (Select three)

• By providing a structured way to store and retrieve data efficiently.

• By enabling advanced analytics and reporting tools.

• By allowing uncontrolled modifications to organizational data.

• By supporting customer relationship management and financial analysis.

What are some advantages of cloud-based database solutions compared to traditional on-premise databases? (Select three)

• Reduced infrastructure and maintenance costs since databases are managed by service providers.

• Enhanced scalability, allowing organizations to adjust database resources as needed.

• Guaranteed security and compliance with regulatory requirements without any additional effort.

• Increased accessibility, as databases can be accessed remotely from various locations.

In the context of Agile Software Development, which principles make it a preferred alternative to traditional SDLC? (Select three)

• Emphasizing customer collaboration over contract negotiation.

• Strict adherence to detailed documentation before development.

• Responding to changes quickly rather than strictly following a predefined plan.

• Prioritizing working software over extensive planning processes.

What are some of the key costs and risks associated with the database approach? (Select three)

• The need for specialized personnel who require continuous training

• High installation and management costs due to software complexity

• The elimination of backup and recovery concerns

• Potential organizational conflicts regarding data ownership and responsibilities