Data Modeling Test Questions
Course Introduction
Data Modeling is a foundational course that explores the principles and practices involved in designing and structuring data for effective storage, retrieval, and use within information systems. Students learn to conceptualize real-world scenarios and translate them into data models using methodologies such as Entity-Relationship Diagrams (ERD), normalization techniques, and UML diagrams. The course covers the lifecycle of data modeling, from requirements analysis and logical design to physical implementation, highlighting best practices for ensuring data integrity, reducing redundancy, and optimizing database performance. By completing this course, students will gain the skills to create robust data models that support organizational goals and facilitate efficient information management.
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) The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:
A) foreign key.
B) primary key.
C) surrogate key.
D) spare key.
E) secondary key.
Answer: C
Q2) A relational database stores data in the form of ________.
Answer: tables
Q3) The default file format for Microsoft Access 2013 database files is the:
A) Access 2007 format.
B) Access 2003 format.
C) Access XP format.
D) SQL Server format.
E) XBD format.
Answer: A
Q4) The Microsoft Access application generator adds the ability to create and store ________,________,and ________.
Answer: forms; reports; queries
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 surrogate key.
Answer: A surrogate key is an artificial key that is created to act as the primary key for a relation.The surrogate key is a unique,numeric value that is appended to the relation.Surrogate keys are used in situations when no suitable primary key exists within the user data,or when all available primary keys within the data are too cumbersome for an efficient design.Surrogate key values have no meaning to the users and are normally hidden on all forms,reports,and displays.Most DBMS products have the ability to automatically generate values for surrogate keys as needed.
Q2) What requirements must a two-dimensional table satisfy in order to be a relation?
Answer: For a table to be considered a relation,it must meet several requirements.First,every cell must contain a single value.Second,there can be no duplicate rows.Third,each column must have a unique name.Fourth,the order of the columns must have no significance.Fifth,all values for a given column must be of the same type.Finally,the order of the rows must have no significance.
Q3) In Microsoft Access,referential integrity constraints are created in the ________. Answer: Edit Relationships dialog box
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) In Microsoft Access,the default method of creating and running a query is
Answer: Query By Example (QBE)
Q2) Given the table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?
A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
C) SELECT Name, PhoneNum
D) SELECT (Name, PhoneNum)
E) SELECT *
Answer: C
Q3) The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.
Answer: NOT NULL
Q4) Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.
A)True
B)False
Answer: False
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) Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.
Q2) Microsoft Access can be used to prototype databases for which of the following DBMS products?
A) Microsoft Access
B) SQL Server
C) MySQL
D) Oracle Database
E) All of the above
Q3) Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.
A)True
B)False
Q4) The number of entity classes involved in a relationship is the cardinality of the relationship.
A)True
B)False
Q5) What are "business rules" and what is their role in database design?
Q6) How is maximum cardinality expressed in crow's foot E-R diagrams?
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) If a weak entity is ID-dependent but not existence-dependent,it can be represented using the same techniques as a strong entity.
A)True
B)False
Q2) Relations should always be normalized to the highest degree possible.
A)True
B)False
Q3) The key of the parent entity becomes part of the key of an ID-dependent entity.
A)True
B)False
Q4) What is denormalization and why can it be desirable?
Q5) To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.
A)True
B)False
Q6) How are 1:1,1:N and N:M relationships handled in Microsoft Access?
Q7) All recursive relationships are 1:1.
A)True
B)False
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) ________ is an important business function whose purpose is to manage the database to maximize its value to the organization.
Q2) What is the least restrictive isolation level that will prevent dirty reads?
A) Read Committed
B) Serializable
C) Read Uncommitted
D) Atomic Read
E) Repeatable Read
Q3) What are the four transaction isolation levels?
Q4) When Microsoft Access 2013 compiles VBA code in a database,the database file will be a(n):
A) *.accdb file.
B) *.accdc file.
C) *.accde file.
D) *.mdb file.
E) *.mdw file.
Q5) Breaking hardware,power outages,and human mistakes are all reasons that ________.
Q6) Briefly explain the strategy of two-phased locking.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Q7) Microsoft Access 2013 can secure database files by storing them in a(n)________.
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) A commonly used Web server on servers running the Linux operating system is
Q2) According to the ODBC standard,a(n)________ is a database and its associated DBMS,operating system,and network platform.
Q3) Every DBMS product uses the same API.
A)True
B)False
Q4) The ODBC standard defines a way to:
A) start transactions.
B) rollback transactions.
C) create a connection.
D) issue SQL commands.
E) All of the above
Q5) A(n)________ is similar to a computer program subroutine or function,but it is stored within the database.
Q6) With ODBC,a file data source is available only to the user that created it. A)True B)False
Q7) Define and briefly describe the function of ODBC.
Q8) What is the NetBeans IDE?
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) Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.
A)True
B)False
Q2) To use Access 2013 data in an Excel 2013 PivotTable,we use the:
A) "To Excel" command on the Access Data command tab.
B) "To Excel" command on the Excel Data command tab.
C) "From Access" command on the Access Data command tab.
D) "From Access" command on the Excel Data command tab.
E) "Get Data" command on the Excel Data command tab.
Q3) To create an OLAP report for an Access 2013 database,use the PivotTable tool in Access 2013.
A)True
B)False
Q4) Business Intelligence (BI)systems are information systems that help users analyze and use data.
A)True
B)False
Page 10
Q5) Compare the characteristics of an operational database and a dimensional database.
To view all questions and flashcards with answers, click on the resource link above.
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) Microsoft SQL Server 2014 Express Advanced includes:
A) SQL Server 2014 Management Studio.
B) SQL Server 2014 Reporting Services.
C) Windows Installer 4.5.
D) Both A and B
E) All of the above
Q2) SQL query results are displayed:
A) in a tabbed Resultset window.
B) in a tabbed Results window.
C) in a tabbed Document window.
D) in a tabbed Messages window.
E) in a tabbed Finished window.
Q3) To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express.
A)True
B)False
Q4) What is an SQL script,and why are SQL scripts useful?
Q5) An important reason for using SQL Server 2014 Express is that it has ________.
Q6) A new SQL Server database is created using the ________ dialog box.
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) Database objects are displayed in the ________ window in the SQL Developer.
Q2) SQL statements can be run individually or as part of a related group of SQL statements known as a:
A) Result.
B) Resultset.
C) Script.
D) Scriptset.
E) Commandset.
Q3) To run an SQL script,click the ________ button.
Q4) Users log into the Oracle Database XE 11.2 utility using the ________ account.
Q5) The NextVal method provides the next value in a sequence.
A)True
B)False
Q6) Which of the following is an account name for which you would enter a password to connect to a workspace in Oracle SQL Developer?
A) Your own personal login
B) The user login associated with the workspace
C) INTERNAL
D) A and B
E) A, B and C
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) To start working with MySQL Server Community Edition in Windows 8.1,use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.
A)True
B)False
Q2) In the MySQL Table Editor,the abbreviation for NOT NULL is:
A) PK
B) NN
C) UQ
D) BIN
E) AI
Q3) What is an SQL script,and why are SQL scripts useful?
Q4) Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.
A)True
B)False
Q5) To run an SQL script,click the ________ button on the MySQL Workbench toolbar.
Q6) To create a new SQL query,click the New Query button.
A)True
B)False
Q7) A new MySQL Server database is known as a new ________. Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
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) SQL triggers use the SQL keywords BEFORE,INSTEAD OF,and AFTER.
A)True
B)False
Q2) Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.
Q3) An SQL virtual table is called a(n)________.
Q4) SQL triggers can be used when the DBMS receives an INSERT request.
A)True
B)False
Q5) SQL views can be used to layer built-in SQL functions.
A)True
B)False
Q6) A stored program that is attached to a table or view is called a stored procedure.
A)True
B)False
Q7) SQL views can be used to hide columns.
A)True
B)False
Q8) How are SQL views handled in Microsoft Access?
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) A business process is a set of activities that transforms ________ into ________.
Q2) How does Michael Porter define support business activities?
Q3) Databases are created in a DBMS during the ________ step.
Q4) Michael Porter includes inbound logistics in his list of ________ activities.
Q5) User interviews are conducted during the requirements analysis step.
A)True
B)False
Q6) Data models are created during the ________ step.
Q7) One deliverable from the requirements analysis step is a statement of requirements (SOR).
A)True
B)False
Q8) Which of the following is not included in Michael Porter's list of support activities?
A) Technology management
B) Customer service
C) Human resources management
D) Firm infrastructure management
E) All of above are considered support activities.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in the Symbol menu is:
A) 1 and only 1.
B) 1 or more.
C) Zero or 1.
D) Zero or more.
E) Range [At least][At most].
Q2) In Microsoft Visio 2013,when the Entity object is placed in a diagram,it is labeled as a(n):
A) entity.
B) table.
C) relationship.
D) dynamic connector.
E) category.
Q3) 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 G-21.
Q4) In Microsoft Visio 2013,how do we create database designs?
To view all questions and flashcards with answers, click on the resource link above.
18
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 switchboards can be used to create:
A) application forms.
B) application reports.
C) application menus.
D) application databases.
E) All of the above
Q2) A Microsoft Access 2013 switchboard provides networking capabilities in Microsoft Access 2013.
A)True
B)False
Q3) Microsoft Access 2013 switchboards use ________ to place text on switchboards.
Q4) Microsoft Access 2013 switchboards are built using a Microsoft Access ________.
Q5) Microsoft Access 2013 switchboards use ________ as part of the switchboard.
A) text labels
B) report labels
C) Wizard labels
D) database design labels
E) All of the above
Q6) Microsoft Access 2013 switchboards use ________ to allow users to implement application actions.
Page 19
To view all questions and flashcards with answers, click on the resource link above.
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 workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to the Users group at the wwwroot folder.
A)True
B)False
Q2) 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.
Q3) The default Web page for the IIS Web server is index.html.
A)True
B)False
Q4) When running the NetBeans IDE for the first time,use a file workspace named NetBeansProjects.
A)True
B)False
Q5) What is PHP?
Page 20
To view all questions and flashcards with answers, click on the resource link above.
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) Refer to the table above.What is the definition of confidence for Drug B with reference to Drug A?
A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased
Q2) 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
Q3) Reports that do not change once prepared are called static reports.
A)True
B)False
Q4) A report that is sent to users on a predetermined schedule is called a(n)________ report.
Page 21
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following is true about XML?
A) It allows the confounding of document structure, content, and format.
B) It is non-standardized to allow for extension by developers.
C) The structure of documents is formally defined.
D) XML tags, like some HTML tags, are vague and arbitrary.
E) None of the above
Q2) The CAP theorem defines the three properties,one of which is partition tolerance.
A)True
B)False
Q3) One of the four categories of NoSQL databases used in the text is the Key-Value database.
A)True
B)False
Q4) XML provides a standardized,non-customizable way to describe the content of a document.
A)True
B)False
Q5) An important improvement of XML Schema over DTDs is that XML Schema are
To view all questions and flashcards with answers, click on the resource link above. Page 22