Database Management Systems
Exam Bank
Course Introduction
Database Management Systems is a comprehensive course that explores the fundamental concepts, architectures, and technologies used to store, manage, and retrieve data efficiently in large-scale information systems. The course covers relational database models, schema design, normalization, structured query language (SQL), and transaction processing, as well as newer topics such as NoSQL databases and distributed database systems. Students will gain hands-on experience with database design, implementation, and administration, and will learn how to ensure data integrity, security, and scalability to support business and software applications.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by David
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437 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/48385
Sample Questions
Q1) A database stores ________.
A)data
B)relationships
C)applications
D)Both A and B are correct
Answer: D
Q2) This database component is used to maintain database accuracy and enforce data constraints.
A)Tables
B)Metadata
C)Triggers
D)Stored procedures
Answer: C
Q3) The database management system (DBMS)is responsible for inserting,modifying,reading,and deleting data.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Introduction to Structured Query Language
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/48388
Sample Questions
Q1) A WHERE clause can contain only one condition.
A)True
B)False
Answer: False
Q2) SQL,although very popular,has never become a national standard.
A)True
B)False
Answer: False
Q3) When one SQL query is embedded in another SQL query,the top level SQL query can still contain an SQL ________ clause.
A)FROM or SORT BY
B)UNIQUE IN C)GROUP BY D)WHERE IN Answer: C
Q4) To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.
A)True
B)False
Answer: True
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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/48391
Sample Questions
Q1) Candidate keys are called interlocking candidate keys when they share one or more attributes.
A)True
B)False
Answer: False
Q2) A relation is in third normal form (3NF)if and only if it is in 2NF and ________.
A)all non-key attributes are determined by the entire primary key
B)there are no non-key attributes determined by another non-key attribute
C)every attribute is a candidate key
D)every candidate key is a determinant
Answer: B
Q3) Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.
A)True
B)False
Answer: True
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/48393
Sample Questions
Q1) For a number of reasons,________ is not often an advantage for a read-only database.
A)updating
B)normalization
C)denormalization
D)Both A and B are correct
Q2) A form of multivalued dependency is found in ________.
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
Q3) The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.
A)True
B)False
Q4) The advantages of normalization include ________.
A)the elimination of modification anomalies
B)the elimination of duplicated data
C)more complex SQL for multitable subqueries and joins
D)simpler SQL queries
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
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48395
Sample Questions
Q1) You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place many orders and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?
A)N:M
B)1:1
C)1:N
D)N:1
Q2) In E-R modeling,entities within an entity class may have different attributes. A)True
B)False
Q3) Recursive relationships can have all of the following maximum cardinalities except ________.
A)1:1
B)1:N
C)N:M
D)M:M
Q4) Distinguish between entity identifiers and keys.
Q5) What is meant by the degree of a relationship?
To view all questions and flashcards with answers, click on the resource link above. Page 7
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/48397
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 ________.
A)incremental updates
B)incremental deletes
C)cascading updates
D)cascading deletes
Q2) Each attribute of an entity becomes a(n)________ of a table.
A)column
B)primary key
C)foreign key
D)alternate key
Q3) The design transformation for all IS-A relationships can be summarized by the phrase "place the key of the parent table in the child table."
A)True
B)False
Q4) What are the four sets of minimum cardinalities that can be present in a 1:N binary relationship?
8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: SQL for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48399
Sample Questions
Q1) The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.
A)True
B)False
Q2) SQL triggers can be used when the DBMS receives a(n)________ request.
A)INSERT
B)SELECT
C)ALTER
D)CREATE
Q3) SQL triggers can be used when the DBMS receives an update request.
A)True
B)False
Q4) The SQL keyword CONSTRAINT is used to limit column values to specific values. A)True B)False
Q5) Which SQL keyword is used to delete a table's structure? A)DELETE
B)DROP
C)DISPOSE
D)ALTER
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
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/48401
Sample Questions
Q1) When dropping tables and relationships,which of the following steps is/are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )
A)Drop the foreign key constraints from the tables
B)Drop the tables
C)Drop the primary key constraints from the tables
D)Both A and B are correct
Q2) What is a correlated subquery? Include an example.
Q3) 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
Q4) When running an SQL query that uses NOT EXISTS,the NOT EXISTS keyword will be true if ________.
A)any row in the subquery meets the condition
B)all rows in the subquery meet the condition
C)no row in the subquery meets the condition
D)any row in the subquery fails to meet the condition
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/48403
Sample Questions
Q1) The size of a lock is referred to as the lock granularity.
A)True
B)False
Q2) A durable transaction is one for which all committed changes are permanent.
A)True
B)False
Q3) A static cursor processes a snapshot of the relation that was taken when the cursor was opened.
A)True
B)False
Q4) The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.
A)True
B)False
Q5) One important reason for documenting changes to the database structure is for diagnosing errors.
A)True
B)False
Q6) Explain the process of using optimistic locking.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Managing Databases With SQL Server 2014
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48383
Sample Questions
Q1) When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."
A)True
B)False
Q2) The SQL Server default when creating a new database is to create ________ for each database.
A)one data file and one log file
B)one data file and two log files
C)two data files and one log file
D)There is no default-the database creator must specify how many data files and log files will be created.
Q3) When creating a T-SQL statement,you should ________.
A)predefine it graphically in Enterprise Manager
B)limit it to one table
C)limit it to two tables
D)end it with the semicolon normally used to terminate SQL statements
Q4) When using SQL Server,developers place explicit locks.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Managing Databases With Oracle Database
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/48386
Sample Questions
Q1) INSTEAD OF triggers are placed on views.
A)True
B)False
Q2) The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.
A)True
B)False
Q3) In Oracle Database,indexes are created using the ALTER command.
A)True
B)False
Q4) With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.
A)True
B)False
Q5) Oracle Database supports the ON UPDATE CASCADE constraint.
A)True
B)False
Q6) The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.
A)True
B)False
Q7) What is the Oracle Enterprise Manager Database Express?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing Databases With Mysql 56
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48389
Sample Questions
Q1) The MySQL keyword to actually start using a cursor is ________.
A)DECLARE CURSOR {CursorName}
B)OPEN {CursorName}
C)FETCH
D)CLOSE {CursorName}
Q2) The MySQL statement used to define a set of MySQL procedure statements is ________.
A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF D)REPEAT
Q3) The MySQL statement used to repeat a set of SQL statements as long as some condition is true is ________.
A)LOOP
B)BEGIN
C)IF...THEN.ELSE...END IF D)REPEAT
Q4) Briefly explain the process for configuring MySQL for importing Excel 2013 spreadsheet data into a SQL Server table,then discuss the import process using the MySQL for Excel Add-In.
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
128 Verified Questions
128 Flashcards
Source URL: https://quizplus.com/quiz/48405
Sample Questions
Q1) Which of the following is true about JSP code?
A)It must be written in Java or JavaScript.
B)It does not have access to HTTP functionality.
C)It must be coded as complete Java classes and methods.
D)It is automatically converted into Java servlets.
Q2) Explain the process by which JSP pages are compiled.
Q3) Every DBMS product uses the same API.
A)True
B)False
Q4) 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
Q5) An ADO.NET dataset can only be used with optimistic locking.
A)True
B)False
Q6) In general,the best type of ODBC data source to define for a Web application is a system data source.
A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Big Data, Data-Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/48407
Sample Questions
Q1) Business Intelligence (BI)systems obtain data in three different ways.
A)True
B)False
Q2) In RFM analysis,R stands for "how recently."
A)True
B)False
Q3) Metadata about the data's source,format,assumptions,and constraints are kept in a data warehouse metadata database.
A)True
B)False
Q4) We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of ________.
A)dirty data
B)inconsistent data
C)nonintegrated data
D)a "wrong format" problem
Q5) Dimensional databases use the star schema.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Getting Started With Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
53 Verified Questions
53 Flashcards
Source URL: https://quizplus.com/quiz/48384
Sample Questions
Q1) Microsoft Access uses the AutoNumber data type to create surrogate keys.
A)True
B)False
Q2) In Microsoft Access,referential integrity constraints are created ________.
A)by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
B)by setting a property value on the foreign key in the table which contains it
C)by setting a property value on the primary key in the Relationships window
D)by setting a property value on the foreign key in the Relationships window.
Q3) Microsoft Access is a personal database that combines a DBMS with an application generator.
A)True
B)False
Q4) Microsoft Access wizards allow easy building of forms and reports.
A)True
B)False
Q5) In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48387
Sample Questions
Q1) One deliverable from the requirements analysis step is a statement of requirements (SOR).
A)True
B)False
Q2) How does Michael Porter define primary or operational business activities? What do they include?
Q3) 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
Q4) How does Michael Porter define support business activities? What do they include?
Q5) The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Q6) What are the five steps or stages of the systems development life cycle (SDLC)?
Chapter 17: E-R Diagrams and the IDEF1X Standard
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48390
Sample Questions
Q1) In IDEF1X,a non-specific relationship is indicated by ________.
A)a hollow circle on each end of the solid relationship line
B)no circles on either end of the dotted relationship line
C)a solid circle on each end of the solid relationship line
D)a solid circle on each end of the dotted relationship line
Q2) The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one,with a mandatory parent and an optional child.
A)True
B)False
Q3) In an IDEF1X identifying connection relationship,________.
A)the identifier of the child is always part of the identifier of the parent
B)the identifier of the parent is always part of the identifier of the child
C)the identifier of the parent is always the same as the identifier of the child
D)the identifier of the parent is optional
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 line symbols are used in IDEF1X diagrams to represent relationships?
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: 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/48392
Sample Questions
Q1) What new contributions to data modeling do UML-style E-R diagrams introduce?
Q2) In UML,cardinalities are represented by an x ..y format.
A)True
B)False
Q3) Attributes preceded by a + are public.
A)True
B)False
Q4) Which of the following is not a characteristic that was introduced to E-R diagramming by UML?
A)Class attributes
B)Relationship attributes
C)Visibility of attributes
D)Methods
Q5) In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.
A)an entity attribute
B)a method
C)a constraint
D)a class attribute
Q6) How are entity classes drawn in UML-style E-R diagrams?
Q7) 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 20
Chapter 19: 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/48394
Sample Questions
Q1) In the Windows 8 or 8.1 OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.
A)True
B)False
Q2) The MySQL Installer for Windows can be used to install the MySQL Workbench.
A)True
B)False
Q3) In the MySQL Table Editor,the abbreviation for NOT NULL is ________.
A)PK
B)NN
C)UQ
D)BIN
Q4) The installation of the MySQL Community Edition 5.6 always includes the installation of the MySQL Workbench.
A)True
B)False
Q5) Describe how to create relationships in a MySQL Workbench database design.
Q6) Describe how to set table properties in a MySQL Workbench database design.
Q7) Describe how to add a table object to a MySQL Workbench database design.
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
32 Verified Questions
32 Flashcards
Source URL: https://quizplus.com/quiz/48396
Sample Questions
Q1) In Microsoft Visio 2013,both data models and database designs are created using the Database Model Diagram template.
A)True
B)False
Q2) In Microsoft Visio 2013,a group of template objects is called a stencil.
A)True
B)False
Q3) In Microsoft Visio 2013,the cardinalities of the Relationship connector object end points are formatted using ________.
A)the Set Begin Symbol command
B)the Set End Symbol command
C)the Set Non-primary Key Unique column
D)Both A and B are correct
Q4) Microsoft Visio 2013 is a component of Microsoft Office 2013.
A)True
B)False
Q5) Microsoft Visio 2013 can be used to create data models. A)True
B)False
Q6) In Microsoft Visio 2013,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 21: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
39 Verified Questions
39 Flashcards
Source URL: https://quizplus.com/quiz/48398
Sample Questions
Q1) 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)
Q2) Linked lists can be used to keep records in a logical order even if they are not necessarily in physical order.
A)True
B)False
Q3) A ________ is a file that has no repeating groups.
A)flat file
B)stacked file
C)record file
D)key file
Q4) The primary work key is a field or fields whose value uniquely identifies a record. A)True
B)False
Q5) What is a set?
Q6) What is a linked list?
Page 23
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/48400
Sample Questions
Q1) A semantic object must represent something with a physical existence.
A)True
B)False
Q2) Group attributes are composites of other attributes.
A)True
B)False
Q3) What type of attribute is composed of other attributes?
A)Simple
B)Group
C)Compound
D)Composite
Q4) A version object ________.
A)may be a composite object
B)typically contains the archetype object in its identifier
C)typically is a simple object
D)produces archetype objects
Q5) The first attribute of a subtype object is the childID attribute.
A)True
B)False
Q6) Explain why semantic object attributes are called paired attributes.
Page 24
To view all questions and flashcards with answers, click on the resource link above.
Chapter 23: Getting Started With Web Servers, PHP, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/48402
Sample Questions
Q1) What is PHP?
Q2) 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 ________ folder.
A)wwwroot
B)inetpub
C)Web
D)eclipse
Q3) For a workstation running the Windows operating system,the additional user file system permissions ________ must be granted to the Users group at the wwwroot folder.
A)Read and Write
B)Modify and Read
C)Modify and Write
D)Read and Execute
Q4) The default Web page for the IIS Web server is ________.
A)startup.html
B)startup.htm
C)index.htm
D)iisstart.htm
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 24: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/48404
Sample Questions
Q1) BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.
A)True
B)False
Q2) In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."
A)True
B)False
Q3) A digital dashboard is an electronic display customized for an individual user.
A)True
B)False
Q4) Which of the following is a common unsupervised data mining technique?
A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)QBE queries
Q5) Business Intelligence (BI)reporting systems can analyze data using standard SQL. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 25: Big Data
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/48406
Sample Questions
Q1) Which of the following is not true about XSLT?
A)It requires the use of CSS.
B)It is a transformation language.
C)It can materialize XML documents into HTML.
D)It is a declarative language.
Q2) Unlike SQL views,XML views are not limited to one multivalued path.
A)True
B)False
Q3) 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.
Q4) The document type declaration for an XML document begins with the keyword
A)XML
B)DTD
C)TYPE
D)DOCTYPE
Q5) What is XML,and why is it significantly better than HTML?
Page 27
To view all questions and flashcards with answers, click on the resource link above.