Enterprise Data Management
Final Exam Questions
Course Introduction
Enterprise Data Management explores the strategies, technologies, and best practices organizations use to efficiently collect, store, protect, and utilize data on an enterprise scale. The course covers topics such as data architecture, data governance, data quality, master data management, metadata management, and data security. Students will examine frameworks for integrating data from multiple sources, supporting business intelligence and analytics initiatives, and ensuring compliance with regulatory requirements. Through case studies and hands-on projects, learners will gain practical experience in designing and implementing enterprise-wide data management solutions that align with business objectives and drive value from organizational data assets.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058 Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) The term legacy system refers to a newly installed database management system.
A)True
B)False
Answer: False
Q2) A relatively small team of people who collaborate on the same project is called a: A) server group.
B) workgroup.
C) data collaborative.
D) typical arrangement.
Answer: B
Q3) The failure to implement a strong database administrative function is the most common source of database failures in organizations.
A)True
B)False
Answer: True
Q4) A data warehouse contains summarized and historical information.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) Data, rather than processes, are the most complex aspects of many modern information systems.
A)True
B)False
Answer: True
Q2) It is not permissible to associate attributes with relationships.
A)True
B)False
Answer: False
Q3) A business rule is a statement of how a policy is enforced or conducted.
A)True
B)False
Answer: False
Q4) An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):
A) composite attribute.
B) composite identifier.
C) identifying attribute.
D) relationship identifier.
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) The most important challenge of customizing a purchased data model is determining the business rules that will be established through the data model.
A)True
B)False
Answer: True
Q2) When identifying the parts of the packaged data model that apply to your organization, one should first start with:
A) entities.
B) attributes.
C) primary keys.
D) relationships.
Answer: A
Q3) An attribute of the supertype that determines the target subtype(s) is called the: A) determinant.
B) subtype decision.
C) disjoint indicator.
D) subtype discriminator.
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) Discuss how to map a unary many-to-many relationship.
Q2) What is an anomaly, and what are the three types of anomalies?
Q3) When a regular entity type contains a multivalued attribute, one must:
A) create a single relation with multiple lines for each instance of the multivalued attribute.
B) create two new relations, one containing the multivalued attribute.
C) create two new relations, both containing the multivalued attribute.
D) delete the relation and start over.
Q4) ________ database specification indicates all the parameters for data storage that are then input to database implementation.
A) Logical
B) Physical
C) Schematic
D) Conceptual
Q5) Discuss the two possible scenarios when mapping an associative entity.
Q6) How do you convert weak entities to relations?
Q7) Discuss why it is important to remove multivalued attributes from a relation.
Q8) Discuss how to map a unary one-to-many relationship.
Q9) Discuss the two major occasions when you benefit from using normalization. Page 6
Q10) Discuss the types of integrity constraints.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.
A)True
B)False
Q2) One decision in the physical design process is selecting structures.
A)True
B)False
Q3) What is a hashing algorithm and how is it used in hashed file organizations?
Q4) A requirement to begin designing physical files and databases is:
A) normalized relations.
B) physical tables created.
C) implementation complete.
D) all datatypes determined.
Q5) ________ partitioning distributes the columns of a table into several separate physical records.
A) Horizontal
B) Crossways
C) Vertical
D) Final
Q6) Why would you want to override automatic query optimization?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.
A)True
B)False
Q2) A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.
A)True B)False
Q3) The first part of an SQL query to be read is the ________ statement.
A) SELECT B) FROM C) WHERE D) ORDER BY
Q4) Some DBMS can handle graphic data types as well as text and numbers.
A)True B)False
Q5) An insert command does not need to have the fields listed. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) A procedure is:
A) stored outside the database.
B) given a reserved SQL name.
C) called by name.
D) unable to be modified.
Q2) An SQL query that implements an outer join will return rows that do not have matching values in common columns.
A)True
B)False
Q3) The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability.
A)True
B)False
Q4) The UNION clause is used to combine the output from multiple queries into a single result table.
A)True
B)False
Q5) Constraints are a special case of triggers.
A)True
B)False
10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Which of the following is NOT a common distribution logic for two-tiered server environments?
A) Fat client
B) Tall client
C) Thin client
D) Distributed
Q2) What are Web services?
Q3) Extensible Markup Language (XML) is a scripting language based upon SGML that allows the creation of customized tags.
A)True
B)False
Q4) An API is a set of routines that a database server uses to access database objects.
A)True
B)False
Q5) Document Type Declarations (DTDs) are unable to specify data types.
A)True
B)False
Q6) What are the components of a Web application?
Q7) Discuss some of the key benefits of three-tier applications.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
A)True
B)False
Q2) Explain a situation where multiple fact tables may be necessary.
Q3) Going from a summary view to progressively lower levels of detail is called data:
A) cubing.
B) drill-down.
C) dicing.
D) pivoting.
Q4) Factless fact tables may apply when:
A) we are deleting sales.
B) we are tracking sales.
C) we are taking inventory of the set of possible occurrences.
D) we are deleting correlated data.
Q5) Discuss the limitations of the independent data mart architecture.
Q6) Independent data marts do not generally lead to redundant data and efforts.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Generally, records in a customer file never become obsolete.
A)True
B)False
Q2) User interaction integration is achieved by creating fewer ________ that feed different systems.
A) clients
B) networks
C) computers
D) user interfaces
Q3) One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:
A) currency.
B) consistency.
C) referential integrity.
D) timeliness.
Q4) A method of capturing data in a snapshot at a point in time is called static extract.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 13
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) Hive creates MapReduce jobs and executes them on a Hadoop Cluster.
A)True
B)False
Q2) HDFS allows indexing which specifically allows applications real-time access to the data.
A)True
B)False
Q3) ________ are examples of Business Intelligences and Analytics 3.0 because they have millions of observations per second.
A) Administrative systems
B) Web-based interaction logs
C) Web-based customer platforms
D) Smartphones
Q4) Apache Cassandra is a leading producer of ________ NoSQL database management systems.
A) key-value store
B) wide-column
C) relational
D) graph
Q5) Describe the Five Vs of Big Data.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) Three-factor authentication is most often implemented with a credit card.
A)True
B)False
Q2) A deadlock results when two transactions try to read the same record.
A)True
B)False
Q3) The granularity of locking is not a critical decision in database design.
A)True
B)False
Q4) A repository of information about data is called a catalog.
A)True
B)False
Q5) What are some of the core roles of the traditional data administrator?
Q6) Backward recovery starts with an earlier copy of the database.
A)True
B)False
Q7) The logical beginning and end of a transaction is called a transaction boundary. A)True
B)False
Q8) What are integrity controls? Describe the different types.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) Which of the following are business conditions that encourage the use of distributed databases?
A) Companies with less than 10 employees
B) Lack of Data sharing needs
C) Data communication reliability
D) Companies that only store data on spreadsheets
Q2) What are the three steps that a distributed DBMS uses to develop a query plan?
Q3) A remote unit of work allows updates at the single remote computer.
A)True
B)False
Q4) Replication is often used for noncollaborative data.
A)True
B)False
Q5) ________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.
A) Location transparency
B) Location autonomy
C) Location dependency
D) Distributed locatability
Q6) Describe the range of distributed database environments.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) A graph of instances that are compatible within a class diagram is called a(n):
A) object group.
B) method chart.
C) object diagram.
D) ERD.
Q2) According to the UML Notation Guide, the term disjoint means that a descendent may not be descended from more than one of the subclasses.
A)True
B)False
Q3) Which of the following refers to a set of objects that share common structures and behaviors?
A) Supertype
B) Object class
C) Model
D) Entity group
Q4) A destructor operation creates a new instance of a class.
A)True
B)False
Q5) What is the difference between a class and an object?
Q6) What is the difference between an abstract class and a concrete class?
Page 17
To view all questions and flashcards with answers, click on the resource link above.