MIS Exam 1 Ch 4 – Flashcards

question
1) Which of the following statements about managing data is true? A) Reconciling inconsistent data can require a significant amount of time and money. B) Potential costs incurred by organizations for data loss are minimal. C) Today's tools eliminate the need for data management positions. D) There are no consequences associated with noncompliance of a law due to poor data management.
answer
A) Reconciling inconsistent data can require a significant amount of time and money.
question
2) Data that unambiguously describes other data for enterprise use are called: A) attributes. B) data models. C) entities. D) metadata.
answer
D) metadata.
question
3) In an ERD, a characteristic of a customer entity is diagrammed as a(n): A) sub-entity. B) attribute. C) data relationship. D) metadata.
answer
B) attribute.
question
4) A top-down data modeling approach to describe the data structure and other requirements of an organization, independent of any particular reports or screens, is called: A) corporate modeling. B) enterprise modeling. C) view integration. D) data consolidation.
answer
B) enterprise modeling.
question
5) A bottom-up approach to describe the data structure and other requirements of an organization, in which reports, screens, and relevant documents are analyzed, is called: A) corporate modeling. B) enterprise modeling. C) view integration. D) data consolidation.
answer
C) view integration.
question
6) The process of creating simple data structures from more complex ones, which yields a data model that is very stable and useful across many different requirements, is called: A) standardization. B) consistency. C) normalization. D) basic.
answer
C) normalization.
question
7) All of the following are true about using a pre-existing (packaged) data model, except: A) it cannot be customized to fit the terms and business rules of a specific organization. B) the modeling projects require less time and money. C) it may be easier to share data with other organizations in the industry. D) it is likely to work well with other applications from the same vendor.
answer
A) it cannot be customized to fit the terms and business rules of a specific organization.
question
8) The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the: A) objective. B) scope. C) outcome. D) timing.
answer
B) scope.
question
9) The data modeling guideline that captures the need that justified the data modeling effort is specified in the: A) objective. B) scope. C) outcome. D) timing.
answer
A) objective.
question
10) An example of a query language used for posing queries to a database is: A) SQL. B) ASP. C) XML. D) PHP.
answer
A) SQL.
question
11) An example of a data exchange language to pass data between computers for e-business is: A) SQL. B) ASP. C) XML. D) PHP.
answer
C) XML.
question
12) Which of the following is not true about managing data in today's large organizations? A) Application software is separate from the database software. B) Data is captured more than once to ensure accuracy. C) Data exists in databases for operational and managerial purposes. D) The need to manage data is continuous.
answer
B) Data is captured more than once to ensure accuracy.
question
13) Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________ with external data supplements. A) personnel databases B) strategic databases C) geographic databases D) operational databases
answer
D) operational databases
question
14) Which of the following statements about information processing with application independence is not true? A) Data are captured and stored in an operational database. B) Data that is accessed from a database for application processing is automatically deleted from the database. C) Subsets and aggregated operational data may be periodically transferred to a long-term data warehouse. D) none of the above
answer
B) Data that is accessed from a database for application processing is automatically deleted from the database.
question
15) An application that moves data from one database to another and permits one source of data to serve many localized systems within an organization is called a: A) data analysis and presentation application. B) data capture application. C) data transfer application. D) disposable application.
answer
C) data transfer application.
question
16) An application that distributes data to authorized users and manipulates data to create useful information from established data sources is called a: A) data analysis and presentation application. B) data capture application. C) data transfer application. D) disposable application.
answer
A) data analysis and presentation application.
question
17) An application that gathers data and populates databases is called a: A) data capture application. B) data transfer application. C) data analysis and presentation application. D) disposable application.
answer
A) data capture application.
question
18) Which of the following statements is true about the retention of data? A) All organizational data should be retained indefinitely. B) Some national laws require that certain types of data must be retained for certain periods of time. C) Emails should be retained in the same database as transaction data. D) none of the above
answer
B) Some national laws require that certain types of data must be retained for certain periods of time.
question
19) An unambiguous description of each type of data that applies to all business circumstances and users is called a(n): A) name. B) descriptor. C) identifier. D) definition.
answer
D) definition.
question
20) A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n): A) name. B) definition. C) identifier. D) integrity rule.
answer
C) identifier.
question
21) Which of the following prescribes who can do what and when to each kind of data? A) ranges B) integrity rules C) edit rules D) usage rights
answer
D) usage rights
question
22) A data dictionary/directory, or DD/D, contains each of the following, except: A) entity definitions. B) data element definitions. C) database server definitions. D) data standards.
answer
C) database server definitions.
question
23) ________ refers to the disciplines, technologies, and methods to ensure the currency, meaning and quality of reference data within and across various subject areas. A) DD/D B) MDM C) DBMS D) ERP
answer
B) MDM (Master Data Management)
question
24) What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods? A) data steward B) database administrator C) CIO D) data administration group
answer
B) database administrator
question
25) Determining the physical arrangement of data based on the data currently required by the business and expected to be required in the future is part of which of the following data resource management functions? A) organize and make accessible B) define/describe and inventory C) control quality and integrity D) accounting for usage
answer
A) organize and make accessible
question
26) What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization? A) data steward B) database administrator C) CIO D) data administration
answer
D) data administration
question
27) What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area? A) data steward B) database administrator C) CIO D) data administration
answer
A) data steward
question
28) Each of the following is a critical step in a data quality initiative, except: A) cleaning up existing data errors. B) avoiding the usage of advanced data cleansing tools. C) establishing procedures to prevent errors. D) verifying that third-party vendors provide clean data.
answer
B) avoiding the usage of advanced data cleansing tools.
question
29) Which of the following is a rationale for data ownership? A) the need to protect the privacy of personal data B) the need to protect trade secrets C) the need to share data with those who "need to know" D) all of the above
answer
D) all of the above
question
30) Which of the following is a justification given for laws that control data flows across national borders? A) promote economic imperialism B) protect a domestic industry C) protect individual privacy D) both B and C
answer
D) both B and C
question
31) If an organization maintains application independence, then application software can more easily be abandoned or replaced.
answer
Answer: TRUE
question
32) Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization.
answer
TRUE
question
33) For legal reasons, all data should be stored indefinitely.
answer
FALSE
question
34) The permissible range or set of values for each data element is defined by integrity rules.
answer
TRUE
1 of

Unlock all answers in this set

Unlock answers
question
1) Which of the following statements about managing data is true? A) Reconciling inconsistent data can require a significant amount of time and money. B) Potential costs incurred by organizations for data loss are minimal. C) Today's tools eliminate the need for data management positions. D) There are no consequences associated with noncompliance of a law due to poor data management.
answer
A) Reconciling inconsistent data can require a significant amount of time and money.
question
2) Data that unambiguously describes other data for enterprise use are called: A) attributes. B) data models. C) entities. D) metadata.
answer
D) metadata.
question
3) In an ERD, a characteristic of a customer entity is diagrammed as a(n): A) sub-entity. B) attribute. C) data relationship. D) metadata.
answer
B) attribute.
question
4) A top-down data modeling approach to describe the data structure and other requirements of an organization, independent of any particular reports or screens, is called: A) corporate modeling. B) enterprise modeling. C) view integration. D) data consolidation.
answer
B) enterprise modeling.
question
5) A bottom-up approach to describe the data structure and other requirements of an organization, in which reports, screens, and relevant documents are analyzed, is called: A) corporate modeling. B) enterprise modeling. C) view integration. D) data consolidation.
answer
C) view integration.
question
6) The process of creating simple data structures from more complex ones, which yields a data model that is very stable and useful across many different requirements, is called: A) standardization. B) consistency. C) normalization. D) basic.
answer
C) normalization.
question
7) All of the following are true about using a pre-existing (packaged) data model, except: A) it cannot be customized to fit the terms and business rules of a specific organization. B) the modeling projects require less time and money. C) it may be easier to share data with other organizations in the industry. D) it is likely to work well with other applications from the same vendor.
answer
A) it cannot be customized to fit the terms and business rules of a specific organization.
question
8) The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the: A) objective. B) scope. C) outcome. D) timing.
answer
B) scope.
question
9) The data modeling guideline that captures the need that justified the data modeling effort is specified in the: A) objective. B) scope. C) outcome. D) timing.
answer
A) objective.
question
10) An example of a query language used for posing queries to a database is: A) SQL. B) ASP. C) XML. D) PHP.
answer
A) SQL.
question
11) An example of a data exchange language to pass data between computers for e-business is: A) SQL. B) ASP. C) XML. D) PHP.
answer
C) XML.
question
12) Which of the following is not true about managing data in today's large organizations? A) Application software is separate from the database software. B) Data is captured more than once to ensure accuracy. C) Data exists in databases for operational and managerial purposes. D) The need to manage data is continuous.
answer
B) Data is captured more than once to ensure accuracy.
question
13) Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________ with external data supplements. A) personnel databases B) strategic databases C) geographic databases D) operational databases
answer
D) operational databases
question
14) Which of the following statements about information processing with application independence is not true? A) Data are captured and stored in an operational database. B) Data that is accessed from a database for application processing is automatically deleted from the database. C) Subsets and aggregated operational data may be periodically transferred to a long-term data warehouse. D) none of the above
answer
B) Data that is accessed from a database for application processing is automatically deleted from the database.
question
15) An application that moves data from one database to another and permits one source of data to serve many localized systems within an organization is called a: A) data analysis and presentation application. B) data capture application. C) data transfer application. D) disposable application.
answer
C) data transfer application.
question
16) An application that distributes data to authorized users and manipulates data to create useful information from established data sources is called a: A) data analysis and presentation application. B) data capture application. C) data transfer application. D) disposable application.
answer
A) data analysis and presentation application.
question
17) An application that gathers data and populates databases is called a: A) data capture application. B) data transfer application. C) data analysis and presentation application. D) disposable application.
answer
A) data capture application.
question
18) Which of the following statements is true about the retention of data? A) All organizational data should be retained indefinitely. B) Some national laws require that certain types of data must be retained for certain periods of time. C) Emails should be retained in the same database as transaction data. D) none of the above
answer
B) Some national laws require that certain types of data must be retained for certain periods of time.
question
19) An unambiguous description of each type of data that applies to all business circumstances and users is called a(n): A) name. B) descriptor. C) identifier. D) definition.
answer
D) definition.
question
20) A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n): A) name. B) definition. C) identifier. D) integrity rule.
answer
C) identifier.
question
21) Which of the following prescribes who can do what and when to each kind of data? A) ranges B) integrity rules C) edit rules D) usage rights
answer
D) usage rights
question
22) A data dictionary/directory, or DD/D, contains each of the following, except: A) entity definitions. B) data element definitions. C) database server definitions. D) data standards.
answer
C) database server definitions.
question
23) ________ refers to the disciplines, technologies, and methods to ensure the currency, meaning and quality of reference data within and across various subject areas. A) DD/D B) MDM C) DBMS D) ERP
answer
B) MDM (Master Data Management)
question
24) What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods? A) data steward B) database administrator C) CIO D) data administration group
answer
B) database administrator
question
25) Determining the physical arrangement of data based on the data currently required by the business and expected to be required in the future is part of which of the following data resource management functions? A) organize and make accessible B) define/describe and inventory C) control quality and integrity D) accounting for usage
answer
A) organize and make accessible
question
26) What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization? A) data steward B) database administrator C) CIO D) data administration
answer
D) data administration
question
27) What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area? A) data steward B) database administrator C) CIO D) data administration
answer
A) data steward
question
28) Each of the following is a critical step in a data quality initiative, except: A) cleaning up existing data errors. B) avoiding the usage of advanced data cleansing tools. C) establishing procedures to prevent errors. D) verifying that third-party vendors provide clean data.
answer
B) avoiding the usage of advanced data cleansing tools.
question
29) Which of the following is a rationale for data ownership? A) the need to protect the privacy of personal data B) the need to protect trade secrets C) the need to share data with those who "need to know" D) all of the above
answer
D) all of the above
question
30) Which of the following is a justification given for laws that control data flows across national borders? A) promote economic imperialism B) protect a domestic industry C) protect individual privacy D) both B and C
answer
D) both B and C
question
31) If an organization maintains application independence, then application software can more easily be abandoned or replaced.
answer
Answer: TRUE
question
32) Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization.
answer
TRUE
question
33) For legal reasons, all data should be stored indefinitely.
answer
FALSE
question
34) The permissible range or set of values for each data element is defined by integrity rules.
answer
TRUE
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New