Database Management Systems
Mock Exam
Course Introduction
Database Management Systems introduces students to the foundational concepts, design principles, and practical applications of modern database systems. The course covers data modeling using Entity-Relationship diagrams, relational database design, normalization, and Structured Query Language (SQL) for data definition, manipulation, and retrieval. Students will explore database architectures, transaction management, concurrency control, and recovery strategies to ensure data integrity and security. The curriculum emphasizes both theoretical understanding and hands-on experience with popular database management software, preparing students to design, implement, and maintain robust data storage solutions for diverse real-world scenarios.
Recommended Textbook
Database Concepts 8th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1259 Verified Questions
1259 Flashcards
Source URL: https://quizplus.com/study-set/898 Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/17704
Sample Questions
Q1) Metadata is the user data stored in the database.
A)True
B)False Answer: False
Q2) SQL stands for Structural Question Language.
A)True
B)False
Answer: False
Q3) What is a surrogate key and how does Microsoft Access 2016 create surrogate keys?
Answer: A surrogate key is usually a computer-generated unique number that serves as the identifier of each row in a table.Microsoft Access 2016 generates surrogate keys by using the Access AutoNumber data type.
Q4) Microsoft Access 2016 generates surrogate key values when the ________ data type is used.
Answer: AutoNumber
Q5) The purpose of the ________ in a database system is to receive requests from applications and to translate those requests into reads and writes on the database files. Answer: DBMS
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
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/17706
Sample Questions
Q1) Given the below functional dependency, MedicineCode (MedicineName,ShelfLife,Manufacturer,Dosage)
Which of the following statements is not known to be true?
A) MedicineCode is a determinant.
B) MedicineName is a determinant.
C) Manufacturer is functionally dependent on MedicineCode.
D) ShelfLife is functionally dependent on MedicineCode.
E) MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage).
Answer: B
Q2) The first step of the normalization process is to identify all the candidate keys of a relation.
A)True
B)False
Answer: True
Q3) In Microsoft Access,referential integrity constraints are created in the ________. Answer: Edit Relationships dialog box
Q4) Any table that meets the requirements of a(n)________ is in first normal form. Answer: relation
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
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/17708
Sample Questions
Q1) Using SQL commands,multiple tables can be queried using either subqueries or ________.
Answer: joins
Q2) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
A)True
B)False Answer: False
Q3) Which of the following cannot be done using the CONSTRAINT phrase?
A) Create a single attribute primary key.
B) Define a foreign key.
C) Establish a referential integrity constraint.
D) Define an attribute to be NOT NULL.
E) Defining a name for the constraint.
Answer: D
Q4) Microsoft Access SQL commands are run within the SQL View of a Query window. A)True
B)False Answer: True
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
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/17710
Sample Questions
Q1) Which of the following is not a basic element of the E-R Model?
A) Identifiers
B) Entities
C) Cardinalities
D) Use cases
E) Relationships
Q2) Explain maximum cardinality.
Q3) Because of its forms and reports wizards,________ can be used to build a prototype database for many different other operational DBMS.
Q4) How is minimum cardinality expressed in crow's foot E-R diagrams?
Q5) Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?
A) Referential integrity constraints
B) User interviews
C) Forms
D) Use cases
E) Business Rules
Q6) Distinguish between an entity class and an entity instance.
Q7) Distinguish between entity identifiers and keys.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/17712
Sample Questions
Q1) Which of the following is not true about surrogate keys?
A) They are identifiers that are supplied by the system, not the users.
B) They have no meaning to the users.
C) They are nonunique within a table.
D) They can be problematic when combining databases.
E) The DBMS will not allow their values to be changed.
Q2) The key of the parent entity becomes part of the key of an ID-dependent entity.
A)True
B)False
Q3) Explain the representation of a one-to-many strong entity relationship in a relational database design.
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
Q5) To normalize a relation,the determinant of every functional dependency should be a(n)________.
Page 7
Q6) How are one-to-one recursive relationships addressed using the relational model?
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
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/17714
Sample Questions
Q1) With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.
A)True
B)False
Q2) Microsoft Access 2016 databases cannot be secured by password encryption.
A)True
B)False
Q3) Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.
A)True
B)False
Q4) What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?
A) Nonrepeatable reads
B) Phantom reads
C) Dirty reads
D) Serialized reads
E) Unlocked reads
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
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17716
Sample Questions
Q1) A commonly used Web server on servers running the Linux operating system is
Q2) Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n)________.
A) ODBC data source
B) JBDC data source
C) OLE DB data source
D) LAMP data source
E) WAMP data source
Q3) Basic Web pages are created using Hypertext Markup Language (HTML).
A)True
B)False
Q4) ODBC only works with Microsoft products.
A)True
B)False
Q5) With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.
A)True
B)False
Q6) Briefly describe three types of triggers.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Data Warehouses,Business Intelligence
Systems,and Big Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/17718
Sample Questions
Q1) A star schema resembles a star,with a dimension table at the center and fact tables radiating out from the center.
A)True
B)False
Q2) When creating an OLAP report based on Access 2016 data,it is often a good idea to create a(n)________ query to organize the data needed for the OLAP report.
Q3) Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.
A)True
B)False
Q4) Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Time-critical data
D) Non-integrated data
E) Inconsistent data
Q5) What is a slowly changing dimension?
Page 10
Q6) What are objects,and how are they related to the object-oriented DBMS (OODBMS)?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Learn how to create a database in SQL Server
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/17703
Sample Questions
Q1) SQL Server DBMS objects are displayed ________.
A) in the Navigation Pane
B) in the Object Explorer
C) in the tabbed database window
D) in the tabbed document window
E) in the command tab
Q2) Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.
A)True
B)False
Q3) SQL Server 2016 requires that ________ be installed.
Q4) When SQL Server 2016 is installed,the SQL Server 2016 ODBC client is ________.
A) installed automatically as part of the installation
B) installed manually as a separate part of the installation process
C) not installed, and must be downloaded and installed manually
D) not installed because there is no ODBC client for SQL Server 2016
E) Either A or B
Q5) SQL statements can be run individually or as part of a related group of SQL statements known as a(n)________.
Q6) Describe how to create a new database in SQL Server 2016 Express. Page 11
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Learn how to create a database in Oracle
Database XE 11g Release 2
Available Study Resources on Quizplus for this Chatper
52 Verified Questions
52 Flashcards
Source URL: https://quizplus.com/quiz/17705
Sample Questions
Q1) What is imported from Excel in order to populate an Oracle Database XE Table?
A) Key
B) Workbook
C) Macro
D) Worksheet
E) All of the above
Q2) All Excel worksheets imported into Oracle Database will have an appropriate column for a primary key.
A)True
B)False
Q3) To run an SQL script in Oracle Database XE ________.
A) click the Execute button
B) click the Execute Script button
C) click the Run Script button
D) click the Ready button
E) click the Results button
Q4) There are four editions of Oracle Database 12c.
A)True
B)False
Q5) Users in SQL Developer log into a workspace using the ________ account.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Learn how to create a database in MySQL 57
Community Server Edition
Available Study Resources on Quizplus for this Chatper
72 Verified Questions
72 Flashcards
Source URL: https://quizplus.com/quiz/17707
Sample Questions
Q1) In the MySQL Table Editor,the abbreviation PK stands for partial key.
A)True
B)False
Q2) Database objects are displayed in the Object Browser window in the MySQL Workbench.
A)True
B)False
Q3) Logging into the MySQL Community Server 5.7 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
Q4) Describe how to create relationships in a MySQL Workbench database design.
Q5) Describe how to create a new database design in the MySQL Workbench.
Q6) In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.
A)True
B)False
Q8) MySQL 5.7 Server Community Edition uses ________ authentication. Page 14
Q7) Users log into MySQL 5.7 Community Server Edition using the ________ dialog box.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: Introduce the topic of importing Microsoft Excel
2016 data into a database table
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17709
Sample Questions
Q1) Microsoft Access ________.
A) supports standard SQL view statements
B) only supports SQL view statements as QBE constructions
C) can store a view equivalent Access query
D) can store a view equivalent Access query but does not provide a means to use it
E) cannot store any database object that is equivalent to an SQL view
Q2) Correlated subqueries do exactly the same type of work as join queries.
A)True
B)False
Q3) An SQL virtual table is called a view.
A)True
B)False
Q4) The SQL statement ________ is used to modify a view.
Q5) An SQL virtual table is called a(n)________.
Q6) Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/17711
Sample Questions
Q1) 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 the above are considered primary or operational activities.
Q2) 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
Q3) Data models are created during the component design step.
A)True
B)False
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 17
Chapter 14: Learn how to create E-R data models in Microsoft
Visio 2016
Available Study Resources on Quizplus for this Chatper
33 Verified Questions
33 Flashcards
Source URL: https://quizplus.com/quiz/17713
Sample Questions
Q1) In Microsoft Visio 2016,we can create data models using Entity and Relationship objects.
A)True
B)False
Q2) Microsoft Visio 2016 can be used to create data models,but not database designs.
A)True
B)False
Q3) In Microsoft Visio 2016,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
Q4) In Microsoft Visio 2016,we can create data models using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) Category and Relationship connector objects
E) We cannot create data models in Microsoft Visio 2016.
Q5) In Microsoft Visio 2016,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: Learn how to create Microsoft Access 2016 switchboards
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/17715
Sample Questions
Q1) A Microsoft Access 2016 switchboard provides a button-based menu system in Microsoft Access 2016.
A)True
B)False
Q2) A Microsoft Access 2016 switchboard provides networking capabilities in Microsoft Access 2016.
A)True
B)False
Q3) Microsoft Access 2016 provides application menuing capabilities by means of a(n)________.
Q4) Microsoft Access 2016 switchboards use ________ as part of the switchboard.
A) text labels
B) report labels
C) wizard labels
D) database design labels
E) form labels
Q5) Microsoft Access 2016 switchboards are built in a report window in Microsoft Access 2016.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 16: Know how to configure and update PHP
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/17717
Sample Questions
Q1) IIS stores its most basic web pages in a wwwroot folder,found within the inetpub folder.
A)True
B)False
Q2) There is only one way to install PHP.
A)True
B)False
Q3) When running the NetBeans IDE for the first time,use a default file workspace named ________.
A) NetBeans Workspace
B) NetBeansProjects
C) Documents
D) My Documents
E) My Workspace
Q4) Before installing the NetBeans IDE,we have to install ________.
A) the Java JRE
B) the Java SDK
C) the Java JDK
D) the Java SRE
E) Any of the above will work.
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 17: Learn the basic concepts of business intelligence (BI)systems
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/17719
Sample Questions
Q1) Report management defines who gets the report,how often,and how it is to be delivered.
A)True
B)False
Q2) Which of the following popular data mining techniques require special software?
A) Decision tree analysis
B) Logistic regression analysis
C) Neural networks
D) Both A and B
E) A, B and C
Q3) Data mining techniques are used to find patterns and relationships that can be used to ________.
A) report
B) classify
C) predict
D) Both B and C
E) None of the above
Q4) A reporting system does not maintain a database of metadata.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 18: Learn about replicated partitioned data stores for supporting clusters
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/17720
Sample Questions
Q1) XML Schema is used to define ________.
A) document content and structure
B) XQL queries
C) DOM-compliant parsers
D) DTDs
E) XPath searches
Q2) In XML Schema,the default cardinality of elements is 0.1.
A)True
B)False
Q3) The first section of an XML document might be a ________.
A) Document Definition Section (DDS)
B) Document Type Declaration (DTD)
C) Data Type (DTYPE)
D) Document Type (DOCTYPE)
E) Type Declaration (TYPEDECL)
Q4) XML Schemas consist of elements,attributes,and properties.
A)True
B)False
Q5) XML Schemas consist of ________.
Q6) What is an XML Schema?
Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23