Question 1

Relational databases establish the relationships between entities by means of common fields included in a file called a(n)________.

Accepted Answer

Relational databases establish relationships between entities by means of common fields included in a file called a relation. Relations organize data into tables with columns (fields) and rows (records) to establish relationships between data elements.

Question 2

One disadvantage of file processing systems is:

Accepted Answer

One disadvantage of file processing systems is limited data sharing. This means that data cannot be easily shared among different departments or users, leading to data duplication and inconsistency.

Question 3

With the database approach,data descriptions are stored in a central location known as a(n):

Accepted Answer

The term "repository" refers to a central location where data descriptions are stored in a database approach. It is a place where all relevant data is stored, retrieved and managed. Therefore, the correct answer is D- Repository.

Question 4

Data that describe the properties of other data are:

Accepted Answer

The term for data that describe the properties of other data is "metadata," which is not listed among the options provided.

Question 5

A database is an organized collection of ________ related data.

Accepted Answer

A database is an organized collection of logically related data. This means that the data stored in a database is structured and arranged based on its logical relationships to other pieces of data in the database. This allows for efficient querying, updating, and management of the data. A physically related database would imply that the data is organized based on its physical location, which is not typically the case in a database. Loosely related or badly organized data would not effectively serve the purpose of a database.

Question 6

Older systems that often contain data of poor quality are called ________ systems.

Accepted Answer

Legacy systems are outdated systems that may have poor data quality due to years of accumulation and lack of updates. Controlled refers to systems with limited access or permissions. Database and mainframe are types of systems and do not necessarily indicate poor data quality.

Question 7

________ are established between entities in a well-structured database so that the desired information can be retrieved.

Accepted Answer

Relationships are established between entities in a well-structured database so that the desired information can be retrieved.

Question 8

Which of the following is NOT an advantage of database systems?

Accepted Answer

Redundant data is not an advantage of database systems because it can lead to inconsistencies and confusion in the data. The other three options are all advantages of database systems.

Question 9

All of the following are primary purposes of a database management system (DBMS)EXCEPT:

Accepted Answer

The answer of All of the following are primary purposes...

Question 10

A(n)________ is often developed by identifying a form or report that a user needs on a regular basis.

Accepted Answer

The answer of A(n)________ is often developed by identifying a...

Question 11

Program-data dependence is caused by:

Accepted Answer

The answer of Program-data dependence is caused by:
...

Question 12

________ is a tool even non-programmers can use to access information from a database.

Accepted Answer

The answer of ________ is a tool even non-programmers can...

Question 13

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

Accepted Answer

Organizations that utilize the file processing approach spend as much as 80 percent of their IS development budget on maintenance.

Question 14

Which of the following types of data can be stored in a database?

Accepted Answer

Databases can store various types of data, including text (letters), numerical data (numbers), and even binary data which can represent voice recordings.

Question 15

Data processed in a way that increases a user's knowledge is:

Accepted Answer

Data processed in a way that increases a user's knowledge is information. Text may convey information, but not all text necessarily increases a user's knowledge. Graphics and hyperlinks can be used to present information, but they are not information themselves.

Question 16

A person,place,an object ,an event or concept about which the organization wishes to maintain data is called a(n):

Accepted Answer

An entity is a person, place, object, event or concept about which the organization wishes to maintain data. An entity has attributes that define the characteristics of the entity, and relationships that define how the entity is related to other entities. Therefore, option D is the correct answer.

Question 17

A graphical system used to capture the nature and relationships among data is called a(n):

Accepted Answer

The answer of A graphical system used to capture the...

Question 18

All of the following are properties of metadata EXCEPT:

Accepted Answer

Metadata does not include processing logic, as it describes the characteristics and attributes of data but not how it is processed or used. The other choices - data definitions, rules or constraints, and data structures - are all examples of metadata.

Question 19

One application of data warehouses is:

Accepted Answer

Data warehouses are specifically designed to support decision-making processes by consolidating data from multiple sources and providing complex analysis and reporting capabilities. While shipping of information and order processing are important functions, they are not the primary purpose of a data warehouse. File updating is also not a typical application of data warehouses.

Question 20

Loss of metadata integrity is often a result of:

Accepted Answer

Unplanned and uncontrolled duplication of data can lead to multiple versions of the same data, which can cause inconsistencies in metadata, leading to loss of metadata integrity. Poor design and decreased programmer productivity can also contribute to this issue, but they are not as direct of a cause as unplanned duplication of data. A large volume of file I/O may impact system performance, but it does not necessarily lead directly to loss of metadata integrity.

Quiz 1: The Database Environment and Development Process

Relational databases establish the relationships between entities by means of common fields included in a file called a(n) ________.