Question 1

In comparison with a flat file system,_____ in a database.
A)storage space is reduced
B)programs and data are interdependent
C)complex requests cannot be handled easily
D)data redundancy is introduced

Accepted Answer

In a database, data is organized into tables with strict rules for how the data can be stored and accessed. This reduces the need for redundant data, therefore reducing storage space. Additionally, programs and data are separate in a database, which reduces interdependence and allows for more flexibility in making changes. Complex requests can be handled more easily with the use of database queries and built-in functions. Therefore, data redundancy is not necessarily introduced in a database, making option D incorrect.

Question 2

Disks are sequential access devices,whereas tapes are random access devices.

Accepted Answer

Disks are random access devices while tapes are sequential access devices.

Question 3

Database marketing works by using multivariate analysis,data segmentation,and automated tools to transform marketing from a proactive to a reactive process.

Accepted Answer

Database marketing works by using customer data to segment audiences and target specific groups more effectively, but it aims to make marketing more proactive by anticipating customer needs and preferences, rather than reactive.

Question 4

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A select operation in a relational database actually filters rows based on certain criteria, not columns. To eliminate or choose specific columns, the "project" operation is used.

Question 5

Which statement is true of a database?
A)It allows more than one program to use the same data.
B)It comprises data that cannot be linked.
C)It consists of a segregated set of files.
D)It is a crucial tool for managing overseas subsidiaries.

Accepted Answer

A database allows multiple programs to access and use the same data, which is one of its primary functions. B, C, and D are all incorrect statements about databases.

Question 6

In comparison with flat file systems,databases:
A)minimize data redundancy.
B)are easier to design.
C)have less sophisticated security measures.
D)require more storage space.

Accepted Answer

Databases usually have mechanisms to eliminate or minimize duplication of data whereas flat file systems tend to repeat data in multiple files, resulting in redundancy which takes up additional storage space.

Question 7

What is one advantage of a database over a flat file system?
A)Hardware and software start-up costs are low when using a database.
B)A database is simple and easy to design.
C)Programs and data are interdependent in a database.
D)A database uses more sophisticated security measures.

Accepted Answer

A database uses more sophisticated security measures than a flat file system, making it more secure and less vulnerable to unauthorized access or data breaches. Flat file systems typically have limited security measures, making them more prone to security risks. The other options are incorrect as they do not accurately describe the advantages of a database over a flat file system.

Question 8

Which statement is true of a flat file system?
A)Same data can be stored in more than one file.
B)Programs and data are independent.
C)Complex requests can be handled easily.
D)It requires very less storage space.

Accepted Answer

Flat file systems often involve redundancy, where the same data can be stored in multiple files, leading to inefficiencies in storage and data management.

Question 9

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Accepted Answer

This statement describes the role and function of a database engine within a DBMS.

Question 10

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A database is where all the data is stored, organized and managed in a computer system. Information systems rely on data to make decisions and derive insights. Therefore, having a well-structured and maintained database is a critical component of information systems.

Question 11

Static Web sites are useful for e-commerce sites that need frequent updates.

Accepted Answer

Static Web sites are not ideal for e-commerce sites that require frequent updates as the content remains fixed and unchanged without programming knowledge. Dynamic websites are better suited for e-commerce sites that require frequent updates.

Question 12

Although a database can consist of only a single file,it is usually a group of files.

Accepted Answer

A database typically consists of multiple files such as data files, index files, log files, etc.

Question 13

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

ISAM allows for both sequential access and direct (random) access of records, using an index to quickly locate records.

Question 14

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods,which are called by sending a message to an object.

Accepted Answer

Interaction with an object-oriented database does take place via methods, which are called by sending a message to an object. This is one of the key differences between interacting with a relational database versus an object-oriented database.

Question 15

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities,whereas business analytics (BA)uses data mining tools and predictive modeling.

Accepted Answer

Business intelligence (BI) typically focuses on providing users with information through scorecards and dashboards. On the other hand, business analytics (BA) focuses on using tools such as data mining and predictive modeling to uncover insights and trends in data to support decision-making activities.

Question 16

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Accepted Answer

A network model organizes records in a graph-like structure where a record can have multiple parent and child records. In contrast, a hierarchical model organizes records in a tree-like structure where a record can only have one parent record but multiple child records. Therefore, the two models are different in their organization of records.

Question 17

The use of the OR operator in a query form,when using query by example (QBE),means that all conditions must be met.

Accepted Answer

The use of the OR operator in a query form in QBE means that at least one of the conditions must be met.

Question 18

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Accepted Answer

Labor and population statistics are typically examples of external data sources, as they are collected and published by entities outside of the organization, such as government agencies or research institutions.

Question 19

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

The statement is false. Data in a data warehouse is used for analytical purposes, while data in a database is used for capturing and managing transactions.

Question 20

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

This statement is false. Consolidating information from different departments or functional areas is actually easier in data warehouses than in data marts, as data warehouses encompass a larger and more comprehensive scope of data. Data marts, on the other hand, are designed for specific departments or business areas and may only contain a subset of the data found in a larger data warehouse.

Quiz 3: Database Systems,Data Warehouses,and Data Marts

In comparison with a flat file system,_____ in a database.