Enterprise Data Management Exam Review
Course Introduction
Enterprise Data Management focuses on the strategies, processes, and technologies organizations use to manage their data assets effectively across their entire lifecycle. The course covers topics such as data governance, data quality, data integration, master data management, metadata management, and data security. Students will learn how to design and implement policies and frameworks that ensure the accuracy, accessibility, consistency, and security of enterprise data, while supporting business objectives and regulatory compliance. Practical case studies and hands-on exercises provide experience in leveraging modern tools and best practices for managing large-scale and diverse data environments in todays organizations.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 13th Edition by David
Available Study Resources on Quizplus
24 Chapters
1921 Verified Questions
1921 Flashcards
Source URL: https://quizplus.com/study-set/1804 Page 2
M. Kroenke
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35866
Sample Questions
Q1) A database system is typically defined as its four components: users,database applications,the DBMS and the databases.
A)True
B)False
Answer: True
Q2) A database may contain ________.
A)tables
B)metadata
C)triggers
D)stored procedures
E)All of the above
Answer: E
Q3) An online drugstore such as Drugstore.com is an example of a(n)________.
A)single-user database application
B)multiuser database application
C)e-commerce database application
D)A or B
E)Any of A,B,or C
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Introduction to Structured Query Language SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/35868
Sample Questions
Q1) In an SQL query,which built-in function is used to total numeric columns?
A)AVG
B)COUNT
C)MAX
D)MEAN
E)SUM
Answer: E
Q2) The SQL built-in function MOST obtains the largest value in a numeric column.
A)True
B)False Answer: True
Q3) Only two tables can be queried by using a subquery.
A)True
B)False
Answer: False
Q4) SQL was developed by IBM in the late 1970s.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35870
Sample Questions
Q1) A relation is a table composed of columns and rows.
A)True
B)False
Answer: True
Q2) A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.
A)True
B)False
Answer: False
Q3) A relation ________.
A)has rows containing data about an entity
B)has columns containing data about attributes of the entity
C)has cells that hold only a single value
D)has no two identical rows
E)All of the above.
Answer: E
Q4) A tuple is a group of one or more columns that uniquely identifies a row.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Database Design Using Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35872
Sample Questions
Q1) Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.
A)True
B)False
Q2) When accessing table structure,how do you determine how many rows are in a table?
Q3) The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.
A)True
B)False
Q4) When a table is created using existing data from multiple sources,you are likely to find that the different sources code data in slightly different ways.This is an example of
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
E)None of the above is correct.
Q5) What is the multivalue,multicolumn problem,and why is it a problem?
Q6) What are null values,and why are they a problem?
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35874
Sample Questions
Q1) Common variants of the E-R model include:
A)IE Crow's Foot
B)IDEF1X
C)UML
D)A and B
E)A,B,and C
Q2) An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n)________.
A)strong entity
B)weak entity
C)ID-dependent entity
D)A and C
E)B and C
Q3) A composite identifier is defined as a composite attribute that is an identifier.
A)True
B)False
Q4) An identifier of an entity instance must consist of one and only one attribute.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Transforming Data Models Into Database Designs
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/35876
Sample Questions
Q1) An intersection table can have additional attributes besides the keys of its parent tables.
A)True
B)False
Q2) Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.
A)True
B)False
Q3) Which of the following is not a step in the database design process?
A)Create tables and columns from entities and attributes
B)Select primary keys
C)Represent relationships
D)Create constraints and triggers
E)All of the above are steps in the database design process.
Q4) A data constraint is a limitation on data values.
A)True
B)False
Q5) Explain the representation of a one-to-many strong entity relationship in a relational database design.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Sql for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35878
Sample Questions
Q1) Which keyword is used to remove one or more rows from a table?
A)DELETE
B)INSERT
C)ERASE
D)SET
E)UPDATE
Q2) Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.
A)less work
B)standardized processing
C)specialization among developers
D)A and B
E)A,B,and C
Q3) SQL triggers are used for ________.
A)validity checking
B)providing default values
C)updating views
D)A and B
E)A,B,and C
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/35880
Sample Questions
Q1) A dependency graph should include:
A)tables
B)views
C)triggers
D)A and B
E)A,B,and C
Q2) When making any change to the database structure,we may need to check for effects of the change on ________.
A)data
B)foreign keys
C)constraints
D)triggers
E)All of the above may need to be checked.
Q3) In order to minimize the need to change table names,some organizations have a policy that no user or application should ever employ the true name of a table,but use views as table aliases instead.
A)True
B)False
Q4) What is a dependency graph,and what is it used for in database redesign?
Q5) Why do databases need redesigning?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35882
Sample Questions
Q1) To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.
A)True
B)False
Q2) Briefly define the four isolation levels and the problems they prevent.
Q3) Changes in the database structure usually involve only one application.
A)True
B)False
Q4) The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
A)True
B)False
Q5) A standby data repository is one which requires a person to generate the metadata and place it in the repository.
A)True
B)False
Q6) With pessimistic locking,the assumption is made that a conflict will occur. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: A: Managing Databases With SQL Server 20012
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35865
Sample Questions
Q1) In SQL Server,insert and update triggers store new values in a pseudotable named inserted.
A)True
B)False
Q2) SQL Server automatically creates an index on primary key fields only.
A)True
B)False
Q3) Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.
A)True
B)False
Q4) Anytime you want to use an SQL Server reserved word as a user identifier,enclose it in ________.
A){ }
B)[ ]
C)( )
D)" "
E)< >
Q5) What is the SQL CLR?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: B: Managing Databases With Oracle Database
11g Release 2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35864
Sample Questions
Q1) Briefly describe how Oracle Database implements serializable transaction isolation.
Q2) The Oracle Database PL/SQL block structure begins with ________.
A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF
D)LOOP
E)END;
Q3) The NextVal method provides the next value in a sequence.
A)True
B)False
Q4) Which of the following is not a transaction isolation level supported by Oracle Database?
A)Read Committed
B)Serializable
C)Repeatable Read
D)Read Only
E)All of the above are supported.
Q5) What is SQL*Plus?
Q6) Explain the Oracle Database PL/SQL Block Structure.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 10: C: Managing Databases With MySQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35863
Sample Questions
Q1) MySQL supports INSTEAD OF triggers.
A)True
B)False
Q2) What MySQL utility is used for DBMS administration?
Q3) The MySQL Workbench is the main utility used to implement MySQL security.
A)True
B)False
Q4) MySQL uses the MySQL NEW transition variable with triggers to access new data inserted into a table row.
A)True
B)False
Q5) Which schema privilege should not be specifically assigned to a user account?
A)SELECT
B)CREATE
C)GRANT
D)A and B
E)A,B,and C
Q6) MySQL supports AFTER triggers.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 11: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
198 Verified Questions
198 Flashcards
Source URL: https://quizplus.com/quiz/35884
Sample Questions
Q1) If a server is using a Microsoft Windows operating system,it is usually running Internet Information Server (IIS)as its Web server.
A)True
B)False
Q2) An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.
A)True
B)False
Q3) Distinguish among the four types of JDBC drivers.
Q4) An ADO.NET dataset can only be used with optimistic locking.
A)True
B)False
Q5) Java programs that access a database from an applet must use a Type 2 JDBC driver.
A)True
B)False
Q6) When XSLT actions are indicated in a loop,the loop ends with </xsl:for-each>.
A)True
B)False
Q7) What is XPath?
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 12: Big Data datawarehouse and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35885
Sample Questions
Q1) We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.
A)dirty data
B)inconsistent data
C)nonintegrated data
D)a "wrong format" problem
E)a "too much data" problem
Q2) Star schemas have a ________ at the center of the star.
A)fact table
B)dimension table
C)map table
D)reduce table
E)None of the above
Q3) In RFM analysis,R stands for "how recently."
A)True
B)False
Q4) What is a data warehouse?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Q5) What are objects,and how are they related to the object-oriented DBMS (OODBMS)?
Chapter 13: Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/35862
Sample Questions
Q1) Explain how to create a relationship in Microsoft Access.
Q2) In Microsoft Access,tables are added to a Query window by:
A)selecting the tables from the Use Table dialog box.
B)selecting the tables from the Show Table dialog box.
C)selecting the tables from the Tables section of the Navigation Pane.
D)selecting the tables from the Queries section of the Navigation Pane.
E)selecting the tables from the Relationships window.
Q3) To start Microsoft Access 2013,use the Start | All Programs | Microsoft Office | Microsoft Access 2013 command.
A)True
B)False
Q4) Microsoft Access is a personal database that combines a DBMS with an application generator.
A)True
B)False
Q5) Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
A)True B)False
Q6) What Microsoft Access file format is used by default in Microsoft Access 2013?
Q7) Explain how to run an SQL query in Microsoft Access
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 14: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35867
Sample Questions
Q1) The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).
A)True
B)False
Q2) Hardware is installed and tested during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q3) Databases are created in a DBMS during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q4) A business process is a set of activities that transforms materials into products.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: E-R Diagrams and the Idef1x Standard
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35869
Sample Questions
Q1) IDEF1X categories are put into a cluster.
A)True
B)False
Q2) What are IDEF1X domains?
Q3) What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?
Q4) In IDEF1X,extended E-R model subtype entities are called:
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Q5) In IDEF1X,extended E-R model 1:1 relationships are called:
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Q6) The IDEF1X excludes the concept of domains found in the extended E-R model.
A)True
B)False
Page 19
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: E-R Diagrams and the UML Standard
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/35871
Sample Questions
Q1) The classes of all entities to be stored in the database are labeled <<persistent>>.
A)True
B)False
Q2) What is OOP persistence,and how is it indicated in UML-style E-R diagrams?
Q3) How are entity classes drawn in UML-style E-R diagrams?
Q4) What new contributions to data modeling do UML-style E-R diagrams introduce?
Q5) Which of the following is true about UML?
A)UML is a methodology for developing OOP systems.
B)UML is a set of tools to support the development OOP systems.
C)UML is primarily focused on database development.
D)A and B
E)A,B,and C
Q6) In UML notation,the relationship line in a relationship with an ID-dependent weak entity is labeled as <id-dependent>.
A)True
B)False
Q7) Attributes preceded by a + are protected. A)True
B)False
Page 20
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Getting Started With MySQL Workbench Data
Modeling Tools
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/35873
Sample Questions
Q1) Table names are edited in the MySQL EER Component Editor.
A)True
B)False
Q2) In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:
A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.
Q3) To create a new MySQL Workbench EER model,you can use:
A)the Create new EER Model link on the Home page.
B)the File | New Model command.
C)the Start new EER command.
D)A or B.
E)All of the above.
Q4) In the MySQL Table Editor,the abbreviation PK stands for partial key.
A)True
B)False
Page 21
Q5) Describe how to set table properties in a MySQL Workbench database design.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/35875
Sample Questions
Q1) In Microsoft Visio 2013,the data models in this book are created using:
A)the Chen's Database Notation template.
B)the UML database Notation template.
C)the IDEF1X Database Notation template.
D)the Crow's Foot Database Notation template.
E)the Wireframe Database Diagram template.
Q2) In Microsoft Visio 2013,a group of template objects is called a stencil.
A)True
B)False
Q3) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include a Category object.
A)True
B)False
Q4) In Microsoft Visio 2013,describe the possible cardinality settings for a Relationship object that can be set in the symbols menu in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure F-20.
Q5) In Microsoft Visio 2013,how do we create data models?
Q6) When using Microsoft Visio 2013,how do we create a blank diagram for use with a data model?
Page 22
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35877
Sample Questions
Q1) A ________ is a file that has no repeating groups.
A)flat file
B)stacked file
C)record file
D)key file
E)secondary file
Q2) A complex network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q3) To represent a tree structure using indexes,store each 1:N relationship as an index.
A)True
B)False
Q4) Each physical record is addressed by its:
A)relative record number (RRN).
B)sequential record number (SRN).
C)transaction record number (TRN).
D)ultimate record number (URN).
E)unknown record number (XRN).
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 20: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35879
Sample Questions
Q1) A simple object is a semantic object that contains only:
A)single-value,simple or group attributes.
B)single-value,object attributes.
C)single-value,simple attributes.
D)multi-value,simple or group attributes.
E)simple attributes.
Q2) A semantic object must represent something with a physical existence.
A)True
B)False
Q3) Subtype objects can be:
A)Inclusive subtypes.
B)Exclusive subtypes.
C)Nested subtypes.
D)Either B or C.
E)Either A,B,or C.
Q4) The first attribute of a subtype object is the childID attribute.
A)True
B)False
Q5) Explain why semantic object attributes are call "paired attributes."
Q6) Describe the two ways that semantic object views can be used.
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 21: Getting Started With Web Servers php and the Eclipse PDT
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35881
Sample Questions
Q1) The PHP installation in the text installed version ________ of PHP .
A)5)2.13
B)5)2.14
C)5)3.0
D)5)3.5
E)5)3.6
Q2) The Eclipse PDT is installed using a standard Windows operating system installation routine.
A)True
B)False
Q3) For a Web server running the Windows operating system,the most commonly used Web server is:
A)the IIS Web server.
B)the Apache Web server.
C)the Tomcat Web server.
D)the ASP.NET Web server
E)the JSP Web server
Q4) The default Web page for the IIS Web server is index.html.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 22: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/35883
Sample Questions
Q1) In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."
A)True
B)False
Q2) Which of the following is (are)true about data mining applications?
A)They use sophisticated mathematical techniques.
B)They use sophisticated statistical techniques.
C)Their report delivery is more difficult than report delivery for reporting systems.
D)Both A and B
E)All of the above
Q3) What is a data warehouse?
Q4) Problematic data include so-called "dirty data."
A)True
B)False
Q5) A reporting system does not maintain a database of metadata.
A)True
B)False
Q6) What are Business Intelligence (BI)systems?
Q7) What is data mining application?
To view all questions and flashcards with answers, click on the resource link above. Page 26