Enterprise Data Management Practice Questions
Course Introduction
Enterprise Data Management explores the principles and practices involved in efficiently handling and governing data across an entire organization. The course covers key topics such as data modeling, data integration, master data management, metadata, and data quality. Students will learn how to develop and implement data governance frameworks, manage large-scale databases, ensure data security and compliance, and leverage data as a strategic enterprise asset. Through real-world case studies and practical exercises, participants will gain the knowledge and skills needed to address the challenges of managing data across diverse business functions and technology platforms.
Recommended Textbook
Database Processing 12th Edition by
David M. Kroenke
Available Study Resources on Quizplus
24 Chapters
1854 Verified Questions
1854 Flashcards
Source URL: https://quizplus.com/study-set/1823
Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36220
Sample Questions
Q1) The largest databases in e-commerce are the order entry databases.
A)True
B)False
Answer: False
Q2) In a database processing system,indexes are held by the database management system (DBMS).
A)True
B)False
Answer: True
Q3) What are the three types of database design situations?
Answer: Database designs can be based on (1)existing data, (2)new systems development and (3)database redesign.Database designs from existing data may be based on data in spreadsheets or other data tables,or on data extracted from other databases.New systems development gathers user requirements for needed applications and designs a database to meet those requirements.Database redesign may be needed to migrate existing databases to a newer DBMS,or to integrate multiple existing databases.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36222
Sample Questions
Q1) In an SQL query,which built-in function is used to obtain the largest value of numeric columns?
A)AVG
B)COUNT
C)MAX
D)MIN
E)SUM
Answer: C
Q2) The Microsoft Access wildcard character "_" (underscore)indicates a single,unspecified character in a specific location in a Microsoft Access SQL query.
A)True
B)False
Answer: False
Q3) To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
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/36224
Sample Questions
Q1) A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.
A)True
B)False
Answer: True
Q2) A relation is in 4NF when multivalued dependencies are isolated in their own relation.
A)True
B)False
Answer: True
Q3) Given the functional dependency (A,B) C,(A,B)is a(n)________.
A)independent variable
B)dependent variable
C)determinant
D)composite determinant
E)C and D
Answer: E
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/36226
Sample Questions
Q1) Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.
A)True B)False
Q2) When you are given a set of tables and asked to create a database to store their data,the first step is to assess the tables' structure and content.
A)True B)False
Q3) Normalization is an advantage for a read-only database. A)True B)False
Q4) A missing value is called a null value. A)True B)False
Q5) What are inconsistent values,and why are they a problem?
Q6) Read-only databases are often updated. A)True B)False
Q7) What are the advantages and disadvantages of normalization?
To view all questions and flashcards with answers, click on the resource link above. Page 6
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/36228
Sample Questions
Q1) An entity whose identifier includes the identifier of another entity is a(n)________.
A)strong entity
B)weak entity
C)ID-dependent entity
D)A and C
E)B and C
Q2) Supertype/subtype entities are said to have a(n)________ relationship.
A)HAS-A
B)IS-A
C)recursive
D)redundant
E)multivalue
Q3) Data modelers agree that weak,non-ID-dependent entities exist and are important.
A)True
B)False
Q4) A compound identifier is an identifier consisting of two or more attributes.
A)True
B)False
Page 7
Q5) How is maximum cardinality expressed in IE Crow's Foot E-R diagrams?
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/36230
Sample Questions
Q1) A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.
A)True
B)False
Q2) Association tables sometimes connect more than two entities.
A)True
B)False
Q3) The first step in the database design process is to create tables and columns from entities and attributes.
A)True
B)False
Q4) When placing a foreign key for a 1:1 relationship,the key of either table can be used as the foreign key in the other table.
A)True
B)False
Q5) How are one-to-one recursive relationships addressed using the relational model?
Q6) Briefly describe what a final database design consists of.
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
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/36232
Sample Questions
Q1) SQL triggers are created using the SQL ADD TRIGGER statement.
A)True
B)False
Q2) If the table ITEM has a column WEIGHT,and WEIGHT has the data type Numeric (7,2),the value 4321 will be displayed by the DBMS as 43.21.
A)True
B)False
Q3) When a trigger is fired,the DBMS makes the appropriate data available to
A)the SQL interpreter
B)the application code
C)the embedded SQL code
D)the trigger code
E)the stored procedure code
Q4) Which SQL statement is used to retrieve view instances?
A)CREATE
B)DELETE
C)INSERT
D)SELECT
E)UPDATE
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36234
Sample Questions
Q1) In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.
A)reverse engineer all test databases
B)graph dependencies in all test databases
C)recover all test databases to their original state
D)A and B
E)A,B and C
Q2) To add a NULL column to a table,we ________.
A)use the REVISE TABLE command
B)use the ALTER TABLE command
C)use the MODIFY TABLE command
D)create a new table with the NULL column,move the other data,and drop the old table
E)None of the above is the correct way to add a NULL column.
Q3) EXISTS and NOT EXISTS are actually just another form of correlated subqueries.
A)True
B)False
Q4) A correlated subquery,looks very different from a noncorrelated subquery.
A)True
B)False
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/36236
Sample Questions
Q1) Distinguish between the four cursor types.
Q2) Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called:
A)statement level consistency.
B)optimistic locking.
C)transaction level consistency.
D)durable transactions.
E)ARID transactions.
Q3) A checkpoint is a point of synchronization between the database and the transaction log.
A)True
B)False
Q4) The situation that occurs when one user's changes to the database are lost by a second user's changes to the database is known as the:
A)lost update problem.
B)deadly embrace problem.
C)inconsistent read problem.
D)inconsistent write problem.
E)deadlock problem.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Managing Databases With SQL Server 2008 R2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36237
Sample Questions
Q1) Briefly explain the different SQL Server backup types.
Q2) In SQL Server,SCROLL_LOCK is a version of pessimistic locking.
A)True
B)False
Q3) Which of the following is not a lock granularity supported by SQL Server?
A)Row
B)Key
C)Table
D)Page
E)All of the above are supported.
Q4) SQL Server system functions start with the symbol ________.
A)/*
B)#
C)##
D)@
E)@@
Q5) Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.
Q6) Discuss the Microsoft PowerShell utility.
Q7) Explain the SQL Server IDENTITY constraint.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Managing Databases With Oracle Database 11g
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36238
Sample Questions
Q1) If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown?
A)SET INTO T3 VALUES (101,'Smith','02/10/03');
B)SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
C)INSERT INTO T3 VALUES (101,'Smith','02/10/2003');
D)INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
E)Any of the above will work correctly.
Q2) The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.
A)True
B)False
Q3) Briefly explain the different types of files used by the Oracle Database recovery facilities.
Q4) With Oracle Database,using a sequence does not guarantee valid surrogate key values.
A)True
B)False
Q5) Explain sequences and their relationship to surrogate keys.
Q6) What is the Oracle Enterprise Manager 11g Database Control?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing Databases With MySQL 55
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36239
Sample Questions
Q1) The MySQL keyword to create a cursor is:
A)DECLARE CURSOR {CursorName}.
B)OPEN {CursorName}.
C)FETCH.
D)CLOSE {CursorName}.
E)None of the above.
Q2) Which transaction isolation level scopes are available in MySQL?
A)GLOBAL
B)SESSION
C)TRANSACTION
D)A and B
E)A,B and C
Q3) The MySQL END statement is used to complete the basic SQL block structure. A)True
B)False
Q4) MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.
A)True
B)False
Q5) Explain the MySQL cursor statements.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/36240
Sample Questions
Q1) Which of the following is true of JDBC?
A)Programs must be written in Java.
B)JDBC only works with open-source products.
C)JDBC is only available for Unix-like operating systems,such as Linux.
D)JDBC is actually a DBMS.
E)B and C
Q2) Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?
A)Level 2 API
B)Minimum SQL Grammar
C)Core API
D)Extended SQL Grammar
E)Core SQL Grammar
Q3) JSP pages are ________.
A)automatically compiled by the servlet processor as needed
B)required to be compiled by the developer before being made public
C)automatically checked for syntax errors by the servlet as they are written
D)slower to execute but more memory efficient than CGI files
E)A and D
Q4) Briefly describe the components of the ODBC architecture.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Database Processing With XML
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36241
Sample Questions
Q1) What is an XML Schema?
Q2) SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.
A)True
B)False
Q3) XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.
A)True
B)False
Q4) XML documents that do not conform to their DTD are said to be non-type-valid XML documents.
A)True
B)False
Q5) Setting the minimum cardinality to 0 is similar to using a NULL constraint in SQL. A)True
B)False
Q6) What is XSLT?
Q7) What is an XML global element?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Processing for Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36242
Sample Questions
Q1) A data warehouse is a database system that has data,programs and personnel specialized in Business Intelligence (BI)processing.
A)True
B)False
Q2) 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
Q3) What is a data warehouse?
Q4) Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.
A)True
B)False
Q5) What is a data mining application?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Microsoft Access 2010
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/36219
Sample Questions
Q1) Microsoft Access 2010 uses the Microsoft Office Fluent User Interface.
A)True
B)False
Q2) Microsoft uses the term object as a general name for various parts of Microsoft Access 2010.
A)True
B)False
Q3) The Microsoft Access application generator provides the ability to create and store forms,reports,and queries.
A)True
B)False
Q4) To start Microsoft Access 2010,use the command:
A)Start | Microsoft Access 2010.
B)Start | Microsoft Office | Microsoft Access 2010.
C)Start | All Programs | Microsoft Access 2010.
D)Start | All Programs | Microsoft Office | Microsoft Access 2010.
E)Microsoft Access 2010.
Q5) What Microsoft Access file format is used by default in Microsoft Access 2010?
Q6) What is the Microsoft Office Fluent User Interface?
Q7) Describe the tabbed Ribbon.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: 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/36221
Sample Questions
Q1) User interviews are conducted during the requirements analysis step.
A)True
B)False
Q2) The classic systems analysis methodology is called the:
A)Systems Development Life Cycle (SDLC).
B)Analysis Development Life Cycle (ADLC).
C)Component Development Life Cycle (CDLC).
D)Information Development Life Cycle (IDLC).
E)None of the above is correct.
Q3) Database designs are created during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q4) What are the five steps or stages of the systems development life cycle (SDLC)?
Q5) Information systems must be both developed and used to help businesses reach their goals and objectives.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: 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/36223
Sample Questions
Q1) In IDEF1X,a category cluster includes BLACK and WHITE,which are the only possible categories.This is an IDEF1X:
A)complete category cluster.
B)incomplete category cluster.
C)inherited category cluster.
D)inconclusive category cluster.
E)None of the above.
Q2) What are IDEF1X domains?
Q3) IDEF1X identifying connection relationships correspond to ID-dependent relationships in the extended E-R model.
A)True
B)False
Q4) The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a dashed line with a filled-in circle by the child and no other notation.
A)True
B)False
Q5) What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?
Q6) What is IDEF1X?
Q7) What symbols are used in IDEF1X diagrams to represent cardinalities?
Page 20
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: 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/36225
Sample Questions
Q1) In UML notation,the relationship line in a relationship with a non-ID-dependent weak entity is labeled as:
A)<persistent>.
B)<identifying>.
C)<nonidentifying>.
D)<protected>.
E)There is no label used.
Q2) Which of the following is a true statement about the current version of UML?
A)UML places a filled-in diamond on the parent of a weak entity.
B)UML does not provide a means to document exclusivity among subtypes.
C)UML uses the label <identifying> to document an ID-dependent relationship.
D)UML shows the cardinality on the parent entity of a weak entity as simple "1."
E)All of the above.
Q3) UML-style E-R diagrams allow for the existence of class attributes which are attributes that pertain to the collection of all entities within that class,not to the individual entity instances themselves.
A)True
B)False
Q4) What cardinality format is used in UML-Style E-R diagrams?
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: 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/36227
Sample Questions
Q1) To add a table to a database design,click the Place a New Table button,move the cursor to the diagram area and click the left mouse button.
A)True
B)False
Q2) Describe the MySQL Connector/ODBC and how to install it.
Q3) Describe how to create relationships in a MySQL Workbench database design.
Q4) Describe how to create a new database design in the MySQL Workbench.
Q5) In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already 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.
Q6) In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.
A)True
B)False
Q7) Describe how to add a table object to a MySQL Workbench database design.
Q8) Describe how to set table properties in a MySQL Workbench database design. Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 21: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/36229
Sample Questions
Q1) In Microsoft Visio 2010,describe the possible cardinality settings for a Relationship object that can be set in the Database Properties for a relationship in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure 4-8?
Q2) In Microsoft Visio 2010,the arrow end of the Dynamic connector object points to the table containing the primary key.
A)True
B)False
Q3) In Microsoft Visio 2010,the arrow end of the Relationship connector object points to the table containing:
A)the foreign key.
B)the primary key.
C)the non-primary key unique column.
D)the non-foreign key unique column.
E)None of the above is correct.
Q4) In Microsoft Visio 2010,how do we create database designs?
Q5) In Microsoft Visio 2010,how do we format line ends in data model to represent the symbols used in the IE Crow's Foot notation?
Q6) In Microsoft Visio 2010,how do we create data models?
Page 24
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36231
Sample Questions
Q1) A hybrid object is a semantic object that contains at least one:
A)single-value group attribute that includes a multi-value semantic object attribute.
B)single-value group attribute that includes any semantic object attribute.
C)multiple-value group attribute that includes a multi-value semantic object attribute.
D)multiple-value group attribute that includes any semantic object attribute.
E)a group attribute and a semantic object attribute.
Q2) Whether a developer uses an E-R model or a semantic object model,the eventual database design that is created should be exactly the same.
A)True
B)False
Q3) Semantic objects represent the user's perceptions more closely than the E-R model.
A)True
B)False
Q4) A subtype inherits all the attributes of its parent.
A)True
B)False
Q5) 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.
25
Chapter 23: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36233
Sample Questions
Q1) How does a DBMS store data on its direct access files?
Q2) 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).
Q3) Each physical record is addressed by its sequential record number (SRN).
A)True
B)False
Q4) The primary work key is a field or fields whose value uniquely identifies a record.
A)True
B)False
Q5) A complex network is a collection of records and the 1:N relationships between them. A)True
B)False
Q6) What are tress,simple networks and complex networks?
Q7) What is a set?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 24: 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/36235
Sample Questions
Q1) The Java JRE is installed directly form the Java download page at:
A)www.java.com.
B)www.jre.com.
C)www.jdk.com.
D)www.sun.com.
E)www.oracle.com.
Q2) The version of the Eclipse IDE that works with PHP is the Eclipse PDT.
A)True
B)False
Q3) For a workstation running the Windows operating system,all the necessary user file system permissions to the Web page area are already granted.
A)True
B)False
Q4) 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.
To view all questions and flashcards with answers, click on the resource link above. Page 27