Question 1

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

The flat file approach refers to storing data in a single table or spreadsheet, while the database approach involves storing data in multiple related tables using a relational model.

Question 2

The two fundamental components of data structures are organization and access method.

Accepted Answer

Organization refers to how the data is stored and arranged, while access method refers to how the data can be retrieved and manipulated. These two components are essential in designing efficient and effective data structures.

Question 3

Data normalization groups data attributes into tables in accordance with specific design objectives.

Accepted Answer

Data normalization is a process of organizing data in a database in such a way that reduces redundancy and dependency while at the same time improving the performance of the database. This involves grouping data attributes or columns into tables in accordance with specific design objectives, such as eliminating duplicate data, minimizing data modification issues, and ensuring data consistency.

Question 4

View modeling begins by identifying the primary entities of the business function in question.

Accepted Answer

View modeling typically involves identifying and modeling the primary entities of a business function or system.

Question 5

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

Accepted Answer

The hierarchical database model is based on a "parent-child" relationship between data elements, and users must follow predetermined and structured paths to access data. This model is often compared to a tree-like structure, where each node (or branch) can have multiple children, but only one parent. Therefore, the correct answer is A, true.

Question 6

Generalized audit software packages are used to assist the auditor in performing substantive tests.

Accepted Answer

Generalized audit software packages can be used to automate and execute substantive tests such as data analysis, sampling, and searching for unusual transactions or patterns. Therefore, they can assist the auditor in their substantive testing procedures.

Question 7

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

An entity can be a physical thing, but it can also be an abstract concept or event about which an organization wishes to capture data.

Question 8

An ER diagram is a graphical representation of a data model.

Accepted Answer

An ER diagram is a visual representation of entities and their relationships to each other in a data model. It uses various symbols to depict entities, attributes, and relationships in a conceptual data model. Therefore, the statement is true.

Question 9

The deletion anomaly is the least important of the problems affecting unnormalized databases.

Accepted Answer

The deletion anomaly is a serious problem in unnormalized databases, as it can lead to the loss of important data when deleting records that contain information needed by other records. Normalizing the database can help prevent deletion anomalies.

Question 10

VSAM file structures are most effective where rapid access to individual records is a priority need.

Accepted Answer

VSAM file structures are most effective where rapid access to large blocks of contiguous records is a priority need.

Question 11

GAS can be used with simple data structures but not complex structures

Accepted Answer

GAS (Google Apps Script) can be used with both simple and complex data structures. It supports a variety of data structures including arrays, objects, maps, and sets.

Question 12

A join builds a new table by creating links.

Accepted Answer

The answer of A join builds a new table by...

Question 13

Under the database approach, data is viewed as proprietary or owned by users.

Accepted Answer

Under the database approach, data is not viewed as proprietary or owned by users, but rather as a shared resource that can be accessed and manipulated by multiple users through a database system.

Question 14

The physical database is an abstract representation of the database.

Accepted Answer

The physical database is the actual representation of the database that exists on the storage media, such as hard disk or solid state drive. It is not an abstract representation.

Question 15

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A one-to-many relationship would involve one customer having multiple unpaid balances. In this case, we only have one unpaid balance associated with one customer, which is a one-to-one relationship.

Question 16

An advantage of using an indexed random file structure is that records are easily added and deleted.

Accepted Answer

In an indexed random file structure, records are stored in blocks or pages, and these blocks have indexes that point to the location of records within them. This allows for easy insertion and deletion of records, as only the affected block(s) need to be modified and reorganized, without affecting the entire file structure.

Question 17

View integration combines the data needs to all users into a single-entity wide schema.

Accepted Answer

View integration is the process of creating a unified view of all data sources in an organization, allowing users to access and query data from a single, comprehensive schema.

Question 18

EAM's allow auditors to identify significant transactions for substantive testing.

Accepted Answer

Enterprise Asset Management (EAM) systems can help auditors identify significant transactions for substantive testing by providing a centralized and comprehensive view of an organization's assets, operations, and financial transactions. Through data analysis and reporting capabilities, auditors can quickly identify high-risk transactions and focus their testing efforts on those areas that are most likely to have material misstatements.

Question 19

In the relational model, a data element is called a relation.

Accepted Answer

In the relational model, a data element is called a table, not a relation. The term "relation" refers to the mathematical concept of a set of ordered pairs.

Question 20

When a large portion of the file is to be processed in one operation such as payroll, sequential data structures are an inefficient method of organizing a file.

Accepted Answer

Sequential data structures are efficient for operations that process large portions of a file in one operation, such as payroll, because they allow for straightforward, linear access to the data.

Quiz 8: Data Structures and Caatts for Data Extraction