Question 1

A file is a collection of similar records.

Accepted Answer

A file is typically a collection of records that are related or similar in nature, organized for easy access and management.

Question 2

A database is a collection of interrelated files.

Accepted Answer

A database is designed to store, manage, and retrieve data efficiently, and it consists of interrelated files or tables that are organized to facilitate access and manipulation of the data.

Question 3

An historical advantage of using conventional files has been processing speed. They can be optimized for the access of the application.

Accepted Answer

Conventional files can be optimized for specific applications, allowing for faster data retrieval and processing compared to more generalized database systems.

Question 4

Duplication of data items in multiple files is normally cited as the principal disadvantage of file-based systems.

Accepted Answer

Duplication of data items in multiple files can lead to data inconsistency, increased storage costs, and difficulty in data management, which are common issues in file-based systems.

Question 5

A database is not necessarily dependent on the applications that use it.

Accepted Answer

A database is a standalone system that stores data independently of the applications that access it, allowing multiple applications to use the same database without being dependent on each other.

Question 6

Given the large capacity disks that are now available, database administrators no longer have to be concerned about estimating how much disk capacity is required for a new database.

Accepted Answer

Despite large capacity disks, database administrators still need to estimate disk capacity to ensure efficient resource allocation, cost management, and performance optimization.

Question 7

It is important for the database administrator to estimate how much disk capacity is required for a new database to ensure that sufficient disk space is available.

Accepted Answer

Estimating disk capacity is crucial for database administrators to ensure that the database can store all necessary data and operate efficiently without running out of space.

Question 8

Conventional files are relatively difficult to design and implement because they are normally designed for use with multiple applications or information systems.

Accepted Answer

Conventional files are typically designed for specific applications or systems, making them simpler to design and implement compared to databases, which are designed for use with multiple applications.

Question 9

Files tend to be built around single applications without regard to other, future applications.

Accepted Answer

Files are often designed for specific applications, which can limit their compatibility and usefulness for other applications in the future.

Question 10

A significant disadvantage of conventional files is their inflexibility and non-scalability.

Accepted Answer

Conventional files often lack the ability to easily adapt to changes in data structure or scale efficiently as data volume grows, unlike modern database systems.

Question 11

A significant advantage of conventional files is their flexibility and scalability.

Accepted Answer

Conventional files are typically less flexible and scalable compared to modern database systems, which are designed to handle large volumes of data and complex queries efficiently.

Question 12

As legacy file-based systems and applications become candidates for reengineering, the trend is overwhelmingly in favor of replacing file-based systems and applications with database systems and applications.

Accepted Answer

Database systems offer improved data management, integrity, and accessibility compared to legacy file-based systems, making them a preferred choice for modernizing applications.

Question 13

As enterprise systems and applications are re-engineered, the trend is overwhelmingly in favor of replacing database systems and applications with legacy file-based systems and applications.

Accepted Answer

The trend is towards modernizing and upgrading to more advanced database systems rather than reverting to outdated legacy file-based systems.

Question 14

The principal advantage of database systems is the ability to share the same data across multiple applications and systems.

Accepted Answer

Database systems allow multiple applications and users to access and manipulate the same data concurrently, ensuring data consistency and integrity.

Question 15

A principal advantage of the database approach is that you can build a single super-database that contains all data items of interest to an organization.

Accepted Answer

A principal advantage of the database approach is data independence and the ability to manage data efficiently, not necessarily creating a single super-database.

Question 16

Most organizations build several databases, each one sharing data with several information systems. Thus, there will be some redundancy between databases.

Accepted Answer

Organizations often create multiple databases for different purposes, and these databases may share data with various information systems, leading to some level of data redundancy.

Question 17

Most organizations build several databases leading to significant and uncontrolled redundancy between databases.

Accepted Answer

The answer of Most organizations build several databases leading to...

Question 18

Database technology offers the advantage of storing data in flexible formats.

Accepted Answer

Database technology allows for the storage of data in various formats such as structured, semi-structured, and unstructured, providing flexibility in how data is organized and accessed.

Question 19

A disadvantage of database technology is the lack of flexibility in data storage formats.

Accepted Answer

Database technology is designed to be flexible, allowing for various data storage formats and structures to accommodate different types of data and use cases.

Question 20

Data independence refers to the fact that databases are defined separately from the information systems and application programs that will use them.

Accepted Answer

Data independence means that the database structure can be changed without affecting the application programs that access the data, allowing for flexibility and scalability.

Quiz 14: Database Design