Question 1

In DBMS,data are kept separate from the application's programming code.This means that ________.
A) an application cannot be changed without making changes to the database
B) an application's programming code needs to be updated continuously to keep up with the database
C) an application needs to be changed when database is changed
D) a database does not need to be changed if a change is made to an application
E) a database needs to be changed when a change is made to an application

Accepted Answer

In DBMS, data are kept separate from the application code. This means that changes can be made to the application without affecting the database, and vice versa. Therefore, a database does not need to be changed if a change is made to an application.

Question 2

________ are used to capture data to be added,modified,or deleted from the database.
A) Forms
B) Reports
C) Queries
D) Bots
E) Layers

Accepted Answer

Forms are typically designed to capture data from users that needs to be added, modified, or deleted from a database. They provide an interface that allows users to enter data in a structured way, providing validation and error checking to ensure accuracy and completeness of the captured data.

C) Queries 
 Queries are used to retrieve specific information from a database. While they can be used to modify or delete data, their primary purpose is to extract data from the database based on specific criteria.

B) Reports, D) Bots, and E) Layers are not the best choices because they are not typically used to capture data that needs to be added, modified, or deleted from a database. Reports are used to present data in a structured, meaningful way; bots are automated programs that can perform a variety of functions; and layers are used to organize and manage data at different levels of abstraction.

Question 3

A(n)________ is a compilation of data from the database that is organized and produced in printed format.
A) form
B) attribute
C) field
D) entity
E) report

Accepted Answer

A report is a compilation of data from the database that is organized and produced in printed format. A form is a graphical user interface that allows users to input data into a database. An attribute is a characteristic of an entity, and a field is a subcategory of an attribute that stores a specific piece of data. An entity is a person, place, thing, or event that is stored in a database.

Question 4

When we consider entities as tables,each row is a(n)________.
A) field
B) record
C) attribute
D) form
E) query

Accepted Answer

A row in a table represents a single record. Each row contains all the data related to a specific entity, such as a customer or a product. Therefore, the correct choice is B, "record."

Question 5

An attribute is also referred to as a ________.
A) form
B) record
C) field
D) query
E) bot

Accepted Answer

An attribute refers to a single piece of information or a characteristic of a data entity. It is also commonly referred to as a field in database terminology. Options A, B, D, and E are incorrect as they do not refer to an attribute specifically.

Question 6

Which of the following is a disadvantage of the database approach?
A) enforcement of standards
B) program-data independence
C) organizational conflict
D) minimal data redundancy
E) reduced program maintenance

Accepted Answer

One of the potential disadvantages of the database approach is the potential for organizational conflict. This can occur if different departments have conflicting data requirements or if there is disagreement about how data should be structured and managed. However, the other options listed are advantages of the database approach, including enforcement of standards, program-data independence, minimal data redundancy, and reduced program maintenance.

Question 7

Data type helps the DBMS ________.
A) present the data in a useful format
B) format data
C) allocate storage space
D) eliminate data duplication
E) retrieve information

Accepted Answer

Data types in a DBMS help allocate appropriate storage space for each data element. For example, a char(10) data type will take up 10 bytes of storage, whereas a float data type will take up 4 bytes of storage. This helps optimize storage and improve performance of the DBMS by minimizing the amount of storage required for each data element. Data types do not help present data, format data, eliminate data duplication, or retrieve information.

Question 8

Once the data model is created,the format of the data is documented in a(n)________.
A) data warehouse
B) data mart
C) expert system
D) data type
E) data dictionary

Accepted Answer

A data dictionary is a documentation of the format of data, including data definitions, attributes, and relationships. It serves as a reference for developers, stakeholders, and users to understand the structure and meaning of the data. A data warehouse is a large centralized repository for storing integrated data, while a data mart is a subset of a data warehouse that focuses on a specific area or department. An expert system is a computer program that uses artificial intelligence to solve problems in a specific domain. Data type refers to the category or format of the data such as integer, string, date, etc.

Question 9

Business rules are captured by the designers of the database and included in the data dictionary to ________.
A) organize and sort the data,complete calculations,and allocate storage space
B) prevent illegal or illogical entries from entering the database
C) eliminate data duplication
D) make sure that each table contains only attributes that are related to the entity
E) capture the structure of the database

Accepted Answer

Business rules are used to enforce consistency and accuracy in the data entered into the database. By including the business rules in the data dictionary, illegal or illogical entries can be prevented from entering the database. This helps maintain data integrity and ensures that the data remains useful and relevant to the organization's needs.

Question 10

A data dictionary is also known as a(n)________.
A) data mart
B) data warehouse
C) metadata repository
D) entity-relationship diagram
E) clickstream data

Accepted Answer

A data dictionary is also known as a metadata repository as it contains descriptions and definitions of data elements, data types, and other data attributes. A data mart and a data warehouse are separate databases used for storing and managing large amounts of data. An entity-relationship diagram is a graphical representation of entities and their relationships to each other. Clickstream data is the data collected from users' clicks when navigating a website.

Question 11

When the database approach makes it easier to deploy and control data access,which of the following advantages is being referred to?
A) improved data accessibility
B) improved data consistency
C) improved data quality
D) increased security
E) improved data sharing

Accepted Answer

The answer of When the database approach makes it easier...

Question 12

Bringes,a retail chain,has retail stores across three states.With its current legacy system,Bringes is having problems tracking the inventory levels for its stores.It is planning to implement an Oracle database system to replace this legacy system.Which of the following,if true,most supports Bringes' decision to replace its legacy system with an Oracle database system?
A) Implementing an Oracle database system will require hiring additional specialized personnel to manage it.
B) Partial implementation of the Oracle database system can create more problems than it is likely to solve.
C) Conversion cost required for the implementation of an Oracle database system is not supported by the IT budget.
D) Bringes' channel partners use a database system that supports the Oracle database system.
E) Maintenance of an Oracle database system is more expensive than the legacy system presently in use.

Accepted Answer

Bringes' decision to implement an Oracle database system will be most supported if its channel partners also use a database system that supports the Oracle database system. This will ensure a smoother integration and interoperability between the systems, making it easier for Bringes to track inventory levels across its retail stores. Options A, B, C, and E provide reasons why Bringes may not want to implement an Oracle database system, and do not support the decision to replace the legacy system with Oracle.

Question 13

One of the advantages of the database approach is program-data independence,which means that it is ________.
A) easier to deploy and control data access using a centralized system
B) easier to evolve and alter software to changing business needs when data and programs are independent
C) a centralized system,making it easier to enforce access restrictions
D) a centralized system,making it much easier to enforce standards and rules for data creation,modification,naming,and deletion
E) useful for eliminating redundancy,greatly reducing the possibilities of inconsistency

Accepted Answer

Program-data independence means that changes made to the program do not affect the data and changes made to the data do not affect the program. This allows for greater flexibility in modifying software to meet changing business requirements without impacting the data stored in the database.

Question 14

A ________ is a collection of related attributes about a single instance of an entity.
A) bot
B) form
C) query
D) field
E) record

Accepted Answer

A record is a collection of related attributes about a single instance of an entity. Bots automate tasks, forms are a user interface for inputting data, queries retrieve information, and fields are individual pieces of data within a record.

Question 15

A query is used to ________.
A) organize and sort the data in a database
B) allocate storage space for a database
C) eliminate data duplication
D) retrieve data from a database
E) prevent illegal or illogical entries from entering the database

Accepted Answer

A query is used to retrieve data from a database by fetching specific information based on criteria specified by the user. It allows users to extract information from one or more tables and provides a way to filter, sort, and summarize the data.

Question 16

When we consider entities as tables,each column is a(n)________.
A) attribute
B) record
C) form
D) bot
E) query

Accepted Answer

Each column in a table represents a specific characteristic or property of the entity. This is known as an attribute. Therefore, A) Attribute is the best choice.

Question 17

Which of the following statements is true about business intelligence?
A) It is the act of outsourcing tasks,traditionally performed by an employee or contractor,to an undefined,large group of people or community,through the use of information technology.
B) It is the process by which a customer-owned mutual organization or co-operative changes legal form to a joint stock company.
C) It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
D) It is an organization's process of defining its strategy,or direction,and making decisions on allocating its resources to pursue this strategy,including its capital and people.
E) It is the use of human resources to gather and analyze information from external sources in order to make better business decisions.

Accepted Answer

Business intelligence involves using information systems to collect and analyze data from various sources, both internal and external, to aid in making informed business decisions. Option A describes crowdsourcing, option B describes demutualization, option D describes strategic planning, and option E describes external information gathering through the use of human resources.

Question 18

Treston,an automobile manufacturer,has recently implemented a new database system.It is confident that this system will help enhance the company's internal (employees)and external (customers and channel partners)communication.Treston is planning to pursue a just-in-time inventory system soon after the database system is implemented.After the implementation of the database system,however,Treston realized that the database system was not effective.Which of the following,if true,can be cited as a reason for the failure of Treston's database system?
A) Microsoft launched a new version of Enterprise Microsoft Access which is better than Treston's database system.
B) The maintenance cost of Treston's new database system was less than the one it was previously using.
C) Treston's new database system was not supported by the database system of its suppliers and distributors.
D) Treston's competitors implemented its database a few days prior to Treston's implementation date.
E) Treston had internally trained personnel managing its new database system,keeping costs low.

Accepted Answer

The failure of Treston's database system could be attributed to the fact that it was not compatible with its suppliers and distributors' database systems. This communication issue could hinder the effectiveness of the database system, causing inconsistencies and errors in data management.

Question 19

"Backward looking" budgets are typically based on ________.
A) forecasts
B) marketing research
C) future trends
D) historical data
E) current market conditions

Accepted Answer

"Backward looking" budgets are based on historical data to determine past performance and expenses, which are then projected forward to create a budget for the upcoming period.

Question 20

Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the ________ level of the organization.
A) operational
B) executive
C) tactical
D) business
E) strategic

Accepted Answer

The operational level of an organization deals with day-to-day activities and processes, providing the internal data necessary for responding to immediate threats and opportunities and for continuous planning.

Quiz 6: Enhancing Business Intelligence Using Information Systems

In DBMS,data are kept separate from the application's programming code.This means that ________.

________ are used to capture data to be added,modified,or deleted from the database.

A(n) ________ is a compilation of data from the database that is organized and produced in printed format.

When we consider entities as tables,each row is a(n) ________.

An attribute is also referred to as a ________.

Which of the following is a disadvantage of the database approach?

Data type helps the DBMS ________.

Once the data model is created,the format of the data is documented in a(n) ________.

Business rules are captured by the designers of the database and included in the data dictionary to ________.

A data dictionary is also known as a(n) ________.

When the database approach makes it easier to deploy and control data access,which of the following advantages is being referred to?

One of the advantages of the database approach is program-data independence,which means that it is ________.

A ________ is a collection of related attributes about a single instance of an entity.

A query is used to ________.

When we consider entities as tables,each column is a(n) ________.

Which of the following statements is true about business intelligence?

"Backward looking" budgets are typically based on ________.

Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the ________ level of the organization.