Data Management Study Guide Questions
Course Introduction
Data Management introduces students to the principles, concepts, and technologies used to collect, store, organize, and analyze data effectively in various organizational contexts. The course covers data models, database design, relational database systems, data integrity, and security. Students will learn about data lifecycle management, including data acquisition, cleansing, transformation, and storage, as well as methods for querying and retrieving data using structured query language (SQL). Emphasis is placed on best practices for ensuring data quality, privacy, and compliance with relevant regulations. Practical assignments and projects provide hands-on experience in designing and managing databases to support decision-making and business intelligence.
Recommended Textbook
Database Concepts 7th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1205 Verified Questions
1205 Flashcards
Source URL: https://quizplus.com/study-set/1260 Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24869
Sample Questions
Q1) Microsoft Access 2013 generates surrogate key values when the ________ data type is used.
Answer: AutoNumber
Q2) What are "referential integrity constraints"? Give an example.
Answer: A referential integrity constraint is a rule that restricts certain actions on the database data.A referential integrity constraint is used to ensure that the values in a field in one table have matching values in a corresponding field in another table.These constraints are enforced by the DBMS,which will not allow changes to the values of the database that would result in violations of this rule.For example,a database has an EMPLOYEE table and a VEHICLE table that are used to store data on employees and the vehicles that they are assigned to drive.The EMPLOYEE table has a column called EmployeeID that is used to distinguish one employee record from another.The VEHICLE table also has an EmployeeID column that is used to associate a vehicle with the appropriate employee.A referential integrity constraint could be used to prevent a vehicle from being assigned to an employee with an EmployeeID that does not appear in the EMPLOYEE table by requiring that all values in EmployeeID in the VEHICLE table have a matching value in EmployeeID in the EMPLOYEE table.
Q3) The purpose of a database is to help people ________.
Answer: keep track of things
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: The Relational Model
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/24871
Sample Questions
Q1) Explain the concept of a functional dependency.
Answer: A functional dependency is a relationship that exists among the attributes of a relation,such that if the value of one attribute or group of attributes is known,the value of another attribute or group of attributes can be determined.In a functional dependency,the attribute(s)whose value determines the value of the other attribute is called the "determinant." The other attribute,whose value is determined by the determinant,is said to be functionally dependent on the determinant.
Q2) Which of the following is true about a relation?
A) The order of the columns in a relation must go from largest to smallest.
B) All entries in any column must be of the same kind.
C) A relation may have duplicate column names.
D) A relation may have duplicate rows.
E) A relation may have multiple names.
Answer: B
Q3) The unique keys that are not chosen to be the primary key are called ________ keys.
Answer: candidate
Q4) A key that contains two or more attributes is called a(n)________ key.
Answer: composite
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/24873
Sample Questions
Q1) Data is added to a table using the SQL INSERT command.
A)True
B)False
Answer: True
Q2) The values of existing data can be removed from a table using the SQL ________ command,which can even be used to remove all the data in the table at one time.
Answer: DELETE
Q3) Standard SQL does not allow built-in functions to be used in a WHERE clause.
A)True
B)False
Answer: True
Q4) Which symbol is used in standard SQL as a wildcard to represent a single,unspecified character?
A) (percent sign) %
B) (exclamation mark) !
C) (underscore) _
D) (question mark) ?
E) (semi-colon) ;
Answer: C
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Modeling and the Entity-Relationship Model
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24875
Sample Questions
Q1) Relationships with the degree 2 are often called ________ relationships.
Q2) In crow's foot style E-R diagrams,a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent:
A) a strong entity relationship.
B) an ID-dependent weak entity relationship.
C) a non-ID-dependent weak entity relationship.
D) a supertype / subtype relationship.
E) a recursive entity relationship.
Q3) The Microsoft Access 2013 form editor is a(n):
A) banded form editor.
B) wizard-based form editor.
C) ASCII form editor.
D) WYSIWYG form editor.
E) Web-based form editor.
Q4) Explain maximum cardinality.
Q5) A(n)________ is a working demonstration of selected portions of the future system.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q6) ________ are descriptions of the ways users will employ the features and functions of the new information system.
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/24877
Sample Questions
Q1) In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.
A)True
B)False
Q2) By default,when Microsoft Access creates a relationship between two tables,it creates a(n):
A) 1:1 relationship.
B) 1:N relationship.
C) N:M relationship.
D) association relationship.
E) recursive relationship.
Q3) To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.
Q4) A surrogate key should be considered when ________.
A) a relationship is M:N
B) a composite key is required
C) the key contains a lengthy text field
D) the key contains a number
E) an index needs to be created
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24879
Sample Questions
Q1) Distinguish between reprocessing and rollforward as database recovery techniques.
Q2) Microsoft Access 2013 can secure database files by storing them in a(n)________.
Q3) One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.
A)True
B)False
Q4) When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.
Q5) Database administrators must make sure that ________ measures are in place and enforced so that only authorized users can take authorized actions at appropriate times.
Q6) Breaking hardware,power outages,and human mistakes are all reasons that ________.
Q7) Microsoft Access 2013 can secure databases by deploying databases packaged with a(n)________.
Q8) Serializable transactions are created by having a(n)________ phase,in which locks are obtained,and a(n)________ phase,in which locks are released.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/24881
Sample Questions
Q1) The first PHP element to be created is the:
A) Command object.
B) Connection.
C) Errors collection.
D) Parameters collection.
E) RecordSet object.
Q2) NetBeans is a(n)________.
Q3) XML stands for:
A) Experimental Markup Language.
B) Existential Markup Language.
C) Extendable Markup Language.
D) Extensible Markup Language.
E) Extensible Marketing Language.
Q4) A trigger is an event stored in a database that is invoked by the DBMS when specified events occur.
A)True
B)False
Q5) When using Microsoft Access and IIS,the connection to the Access database must be provided by using a(n)________.
Q6) ODBC stands for ________.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Big Data, data Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/24883
Sample Questions
Q1) Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Non-integrated data
D) Both A and B
E) All of the above
Q2) To arrange the PivotTable columns and rows in Excel 2013,we use the:
A) PivotTable Control.
B) PivotTable dialog box.
C) PivotTable Field List.
D) PivotTable Wizard.
E) PivotTable command tab.
Q3) A data warehouse database differs from an operational database because:
A) data warehouse data are not stored in tables.
B) data warehouse databases do not have metadata.
C) data warehouse data are often stored in a dimensional database.
D) Both B and C
E) All of the above
Q4) What is a reporting system?
Q5) What is a slowly changing dimension?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Getting Started With Microsoft Sql Server 2012
Available Study Resources on Quizplus for this Chatper
40 Verified Questions
40 Flashcards
Source URL: https://quizplus.com/quiz/24868
Sample Questions
Q1) To run an SQL script,click the Execute button on the Query Toolbar.
A)True
B)False
Q2) SQL Server 2014 uses ________ authentication by default.
Q3) An important reason for using SQL Server 2014 Express is that it has full SQL capabilities.
A)True
B)False
Q4) The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.
Q5) To run an SQL script or SQL command in SQL Server 2014:
A) click the Execute button on the SQL Editor Toolbar.
B) click the Execute button on the Browser Toolbar.
C) click the Run button on the Query Toolbar.
D) click the Run button on the Browser Toolbar.
E) click the Results button on the Query Toolbar.
Q6) Users can click the ________ button to enable or disable the SQL editor windows set of outlining and auto-completion features.
Q7) An important reason for using SQL Server 2014 Express is that it has ________.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Getting Started With Oracle Database 11g
Release 2
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/24870
Sample Questions
Q1) Users in SQL Developer log into a workspace using the ________ account.
Q2) With Oracle Database,using a sequence does not guarantee valid surrogate key values.
A)True
B)False
Q3) To log into Oracle Database XE 11.2,use your personal account information.
A)True
B)False
Q4) Describe how to create and run an SQL query in Oracle Database 11g Release 2 .
Q5) Which of the following tasks can be done using the Oracle SQL Developer?
A) See the structure of a table
B) Add and remove columns from a table
C) Insert and delete data from a table
D) A and B
E) A, B and C
Q6) The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.
A)True
B)False
Q7) Database objects are displayed in the ________ window in the SQL Developer. Page 12
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Getting Started With Mysql 56 Community Server
Available Study Resources on Quizplus for this Chatper
71 Verified Questions
71 Flashcards
Source URL: https://quizplus.com/quiz/24872
Sample Questions
Q1) SQL statements can be run individually or as part of a related group of SQL statements known as a script.
A)True
B)False
Q2) Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.
Q3) Describe how to create relationships in a MySQL Workbench database design.
Q4) Describe how to add a table object to a MySQL Workbench database design.
Q5) By default,the E-R diagrams created in the MySQL Workbench use:
A) IE Crow's Foot notation.
B) IDEF1X notation.
C) UML notation.
D) Microsoft Visio 2010 Arrow notation.
E) None of the above is correct.
Q6) Logging into the MySQL Community Server 5.6 DBMS is done using:
A) the Connect to Server command.
B) the Connect to Server dialog box.
C) the Connect to MySQL Server command.
D) the Connect to MySQL Server dialog box.
E) None of the above is correct.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: James River Jewelry Project Questions
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/24874
Sample Questions
Q1) Since an SQL view is essentially a stored query,Microsoft Access ________ can be used to implement SQL view equivalents.
Q2) The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.
A)True
B)False
Q3) An SQL virtual table is called a view.
A)True
B)False
Q4) SQL views contain their own data.
A)True
B)False
Q5) SQL views can be used to hide columns.
A)True
B)False
Q6) SQL statements used to construct views cannot contain the WHERE clause.
A)True
B)False
Q7) How are SQL views handled in Microsoft Access?
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Sql Views
Available Study Resources on Quizplus for this Chatper
47 Verified Questions
47 Flashcards
Source URL: https://quizplus.com/quiz/24876
Sample Questions
Q1) Define and discuss an information system.
Q2) Which of the following is not included in Michael Porter's list of primary or operational activities?
A) Procurement
B) Inbound logistics
C) Manufacturing operations
D) Outbound logistics
E) All of above are considered primary or operational activities.
Q3) A deliverable from the requirements analysis step is a(n):
A) user requirements document (URD).
B) user requirements statement (URS).
C) statement of work (SOW).
D) statement of requirements (SOR).
E) A and C
Q4) The classic systems analysis methodology is called the ________.
Q5) Data is facts and numbers.
A)True
B)False
Q6) Michael Porter includes inbound logistics in his list of ________ activities.
Q7) One definition of ________ is knowledge derived from data.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Getting Started in Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/24878
Sample Questions
Q1) In Microsoft Visio 2013,we can create data models using Entity and Relationship objects.
A)True
B)False
Q2) In Microsoft Visio 2013,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?
A) Dynamic connector object
B) Relationship connector object
C) Category object
D) Parent to category connector object
E) Category to child connector object
Q3) In Microsoft Visio 2013,how do we create data models?
Q4) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include a Category object.
A)True
B)False
Q5) Microsoft Visio 2013 can be used to create data models,but not database designs. A)True
B)False
Q6) In Microsoft Visio 2013,how do we create database designs?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/24880
Sample Questions
Q1) Microsoft Access 2013 switchboard command buttons are built using:
A) the Text Label Wizard.
B) the Command Button Wizard.
C) the All Button Wizard.
D) the Form Wizard.
E) All of the above
Q2) A Microsoft Access 2013 switchboard provides networking capabilities in Microsoft Access 2013.
A)True
B)False
Q3) A Microsoft Access 2013 switchboard provides application menuing capabilities in Microsoft Access 2013.
A)True
B)False
Q4) Microsoft Access 2013 switchboards use ________ as part of the switchboard.
A) text buttons
B) report windows
C) Wizard buttons
D) command buttons
E) All of the above
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: The Access Workbench-section Microsoft
Access
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) For a Web server running the Linux operating system,the most commonly used Web server is IIS.
A)True
B)False
Q2) The Java JDK is installed directly from the Java download page at www.oracle.com.
A)True
B)False
Q3) For a workstation running the Windows operating system,a commonly used file system utility is Microsoft Internet Explorer.
A)True
B)False
Q4) 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.28
Q5) What is the NetBeans IDE?
Q6) What is PHP?
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Getting Started With Web Servers, php, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/24884
Sample Questions
Q1) RFM analysis analyzes and ranks customers based on:
A) their purchasing patterns.
B) their income status.
C) their residential location.
D) Both A and B
E) All of the above
Q2) A(n)________ is an information system that helps users analyze and use data.
Q3) In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.
Q4) 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) non-integrated data.
D) a "wrong format" problem.
E) a "too much data" problem.
Q5) What is a star schema?
Page 20
Q6) Problematic data are called ________.
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 18: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/24885
Sample Questions
Q1) One of the four categories of NoSQL databases used in the text is the Column Family database.
A)True
B)False
Q2) The CAP Theorem defines three properties of distributed database systems,which are:
A) consistency, always-on, properties.
B) competency, always-on, properties.
C) consistency, availability, partition tolerance.
D) competency, availability, partition tolerance.
E) consistency, availability, properties.
Q3) XML Schemas consist of elements,attributes,and properties.
A)True
B)False
Q4) In XML Schema,the default minimum cardinality can be overridden using the minOccurs attributes.
A)True
B)False
Q5) What is an XML DTD?
Q6) The CAP theorem defines the three properties of ________,________,and
To view all questions and flashcards with answers, click on the resource link above. Page 22