Question 1

Because it uses alphabetic characters,a sequential coding system is most understandable to human beings.

Accepted Answer

False

Question 2

A description of a portion of a schema is referred to as a subschema.

Accepted Answer

This is true. A subschema refers to a section or subset of a larger database schema. It defines a specific portion of the schema and can be used to organize and manage the data stored within that part of the schema.

Question 3

In the network database model,a child record can have more than one parent record.

Accepted Answer

In the network database model, a child record can have multiple parent records, unlike in the hierarchy database model where a child record can only have one parent record. This allows for more complex relationships to be represented in the data model.

Question 4

A check digit is a code that includes an extra digit to a code in order to check the accuracy with which the code is keyed into a computer.

Accepted Answer

This statement accurately describes what a check digit is meant to do.

Question 5

Both the mnemonic and the hierarchical coding schemes attach specific meaning to particular character positions.

Accepted Answer

The answer of Both the mnemonic and the hierarchical coding...

Question 6

A database management system (DBMS)is a set of standalone programs designed to complicate the tasks of creating,accessing,and managing data.

Accepted Answer

A DBMS is designed to simplify, not complicate, the tasks of creating, accessing, and managing data, making it easier for users to interact with databases.

Question 7

Data independence refers to decoupling the data from the system applications,and it is a major difference between the centralized database approach and the applications approach.

Accepted Answer

Data independence allows for changes to be made to the database structure without affecting the applications that use it, thus decoupling the data from the system applications. This is a key advantage of a centralized database approach compared to an applications approach where the data and applications are tightly coupled.

Question 8

The centralized database approach to data management concentrates on the process being performed,rather than on the data themselves.

Accepted Answer

The centralized database approach to data management focuses primarily on the management and storage of data, rather than the specific processes being performed.

Question 9

Another name for sequential coding is block coding.

Accepted Answer

Sequential coding and block coding are not synonyms. Sequential coding refers to writing code that executes line by line in order, while block coding typically involves dragging and dropping pre-made blocks of code to create a program.

Question 10

Classifying data refers to grouping or categorizing data according to some common attributes.

Accepted Answer

Classifying data means organizing data into different groups or categories based on certain common characteristics or attributes. This can help in better analysis and understanding of the data.

Question 11

When different information about the same fact is stored in different files the integrity of the data is violated.

Accepted Answer

When different information about the same fact is stored in different files, there is a risk of inconsistencies and contradictions, which compromises the accuracy and reliability of the data. Maintaining data integrity requires ensuring that all copies of the data are consistent and up-to-date, which can be achieved through synchronization and data management practices.

Question 12

Business processes,such as hiring employees,purchasing inventory,and collecting cash from customers,are called events.

Accepted Answer

The answer of Business processes,such as hiring employees,purchasing inventory,and collecting...

Question 13

The uniform product codes (UPCs)used by supermarkets and other retailers are examples of a block coding scheme.

Accepted Answer

UPCs are structured as a block code, which means that each digit or group of digits conveys a specific meaning and is not processed independently.

Question 14

A DBMS is a set of integrated computer programs designed to simplify the tasks of creating,accessing,and managing a centralized database.

Accepted Answer

This statement is true.

Question 15

The database management system,containing data related to all an organization's applications,supports normal data processing needs and enhances the organization's management activities by providing data useful to managers.

Accepted Answer

The statement is true.

Question 16

A scanner is used to access a database and to produce inquiry reports.

Accepted Answer

A scanner is a device used for capturing and digitizing images or documents, and it is not typically used for accessing a database or producing inquiry reports.

Question 17

The centralized database approach to business event processing,in which facts about events are stored in relational database tables instead of separate files,solves many of the problems caused by data redundancy.

Accepted Answer

The centralized database approach helps to avoid data redundancy because all the facts of events are stored in a single location. This reduces the chances of inconsistencies and errors that can occur when data is duplicated across multiple files or systems.

Question 18

The database administrator is responsible for administrative and technical issues related to the database management system.

Accepted Answer

The database administrator is responsible for ensuring the security, performance, and reliability of the database management system, as well as maintaining and optimizing the database schema. They are also responsible for planning and implementing backup and recovery procedures and troubleshooting technical issues related to the database system.

Question 19

The applications approach to data management decouples the data from the applications or other users of the data.

Accepted Answer

The applications approach to data management tightly couples the data with the applications, meaning the data is managed and accessed through specific applications rather than being stored independently.

Question 20

The traditional applications approach to business event processing concentrates on the process being performed.

Accepted Answer

The traditional applications approach to business event processing focuses on the process being performed rather than the events that trigger or result from the process.

Quiz 5: Database Management Systems