Database Management Systems
Review Questions
Course Introduction
Database Management Systems (DBMS) is a foundational course that explores the principles, architecture, and design of modern database systems, with a focus on how data is modeled, stored, retrieved, and managed efficiently. Students will gain hands-on experience with relational databases, learn SQL querying, and understand concepts like normalization, indexing, transaction management, and concurrency control. The course also introduces topics such as NoSQL databases, database security, backup, recovery, and the role of databases in distributed and cloud computing environments, preparing students to effectively design and maintain robust data-driven applications.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058 Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
A) index.
B) data warehouse.
C) repository.
D) database management system.
Answer: C
Q2) The term legacy system refers to a newly installed database management system. A)True
B)False
Answer: False
Q3) Because applications are often developed independently in file processing systems: A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
C) data can always be shared with others.
D) there is a large volume of file I/O.
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) Relationships represent action being taken using a verb phrase.
A)True
B)False
Answer: True
Q2) What is the difference between an entity type and an entity instance?
Answer: An entity type is a collection of entities that share common properties. An entity instance is a single occurrence of an entity type. So, for example, STUDENT is an entity type and John Smith is an entity instance.
Q3) The total quiz points for a student for an entire semester is a(n) ________ attribute.
A) derived
B) mixed
C) stored
D) addressed
Answer: A
Q4) A business rule is a statement of how a policy is enforced or conducted.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.
A)True
B)False
Answer: True
Q2) You will never need to map data in current databases to data in a packaged data model.
A)True
B)False
Answer: False
Q3) A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship.
A)True
B)False
Answer: True
Q4) Specialization is the reverse of generalization.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) The ________ states that no primary key attribute may be null.
A) referential integrity constraint
B) entity integrity rule
C) partial specialization rule
D) range domain rule
Q2) A synonym is an attribute that may have more than one meaning.
A)True
B)False
Q3) Explain how subtype/supertype relationships are converted to relations.
Q4) ________ are anomalies that can be caused by editing data in tables.
A) Insertion
B) Deletion
C) Modification
D) Creation
Q5) Discuss when it is best to create a surrogate key for an associative entity.
Q6) A domain definition consists of all of the following components EXCEPT:
A) domain name.
B) data type.
C) integrity constraints.
D) size.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) A(n) ________ is a field of data used to locate a related field or record.
A) key
B) index
C) lock
D) pointer
Q2) What is clustering?
Q3) Horizontal partitioning refers to the process of combining several smaller relations into a larger table.
A)True
B)False
Q4) Explain what a tablespace is and how it is used.
Q5) Hash partitioning spreads data evenly across partitions independent of any partition key value.
A)True
B)False
Q6) Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) What does the following SQL statement do? Update Product_T Set Unit_Price = 775
Where Product_ID = 7
A) Changes the price of a unit called Product_T to 7
B) Changes the unit price of Product 7 to 775
C) Changes the length of the Unit_Price field to 775
D) Updates the Product_T table to have a unit price of 775
Q2) Indexes are created in most RDBMSs to:
A) provide a quicker way to store data.
B) decrease the amount of disk space utilized.
C) provide rapid random and sequential access to base-table data.
D) increase the cost of implementation.
Q3) To get all the customers from Hawaii sorted together, which of the following would be used?
A) Order By
B) Group By
C) Having
D) Sort
Q4) Discuss when to use the GROUP BY clause.
Q5) How is the HAVING clause different from the WHERE clause?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);
A) Correlated subquery.
B) Subquery.
C) JOIN.
D) FULL OUTER JOIN.
Q2) RDBMSs store database definition information in system-created tables which can be considered a data dictionary.
A)True
B)False
Q3) The natural join is very rarely used.
A)True
B)False
Q4) Discuss the differences between an equi-join, natural join and outer join.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Cloud computing will have a limited impact on three-tier applications.
A)True
B)False
Q2) ________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.
A) User interface enhancers
B) Middleware
C) Interface managers
D) MPP
Q3) An XML transformation language that allows applications to query both XML data and relational databases is called:
A) Xtransform.
B) Xstation.
C) Xdatabase.
D) XQuery.
Q4) Simple Object Access Protocol (SOAP) is an XML-Based communication protocol.
A)True
B)False
Q5) Explain how XML documents are retrieved.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) A separate data warehouse causes more contention for resources in an organization.
A)True B)False
Q2) Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.
A)True B)False
Q3) What is OLAP and what types of OLAP tools are available?
Q4) The enterprise data model controls the phased evolution of the data warehouse. A)True B)False
Q5) What is data mining, and what are its goals?
Q6) What is the role of metadata in the three-layer data architecture?
Q7) NoSQL is a great technology for storing well-structured data. A)True B)False
Page 12
Q8) Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.
A)True
B)False
Q2) The process of transforming data from detailed to summary levels is called normalization.
A)True
B)False
Q3) Application integration is achieved by coordinating the flow of event information between business applications.
A)True
B)False
Q4) All of the following are tasks of data cleansing EXCEPT:
A) decoding data to make them understandable for data warehousing applications.
B) adding time stamps to distinguish values for the same attribute over time.
C) generating primary keys for each row of a table.
D) creating foreign keys.
Q5) Dirty data can cause delays and extra work on information systems projects.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a:
A) key-value score.
B) document store.
C) wide-column store.
D) graph-oriented database.
Q2) JSON is commonly used in conjunction with the 'document store' NoSQL database model.
A)True
B)False
Q3) NoSQL databases DO NOT support ACID (atomicity, consistency, isolation, and durability).
A)True
B)False
Q4) First degree or complete price discrimination relates to:
A) the minimum price customers are willing to pay.
B) the maximum price customers are willing to pay.
C) the preferred product based on personal preference.
D) the number of products customers are willing to purchase.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) Which of the following is NOT an area of concern when trying to maintain a well-tuned database?
A) Memory usage
B) CPU usage
C) Input/output contention
D) User interface design
Q2) The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.
A)True
B)False
Q3) The record log is a record of the essential data for each transaction that has been processed against the database.
A)True
B)False
Q4) An audit trail of database changes is kept by a:
A) change control device.
B) subschema.
C) before image.
D) journalizing facility.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) A distributed DBMS must provide consistency among copies of data across the remote sites.
A)True
B)False
Q2) A transaction that requires only reference to data that are stored at the site is a remote transaction.
A)True
B)False
Q3) With an asynchronous distributed database, all data across the network is continuously kept up to date.
A)True
B)False
Q4) Data replication allowing for each transition to proceed without coordination is called:
A) reliability.
B) fast response.
C) node decoupling.
D) node coupling.
Q5) What are the three steps that a distributed DBMS uses to develop a query plan?
Q6) What is horizontal and vertical partitioning?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) If a subclass of a company inherits an operation to compute a tax but extends the inherited behavior by adding a foreign surcharge, this is an example of overriding for extension.
A)True
B)False
Q2) The process of replacing a method inherited from a superclass by a more specific implementation of that method in a subclass is called underwriting.
A)True
B)False
Q3) The implementation of an operation is called a(n):
A) attribute.
B) class.
C) method.
D) object.
Q4) The object-oriented systems development cycle consists of four phases. A)True
B)False
Q5) What is the difference between a class and an object?
Q6) What is the difference between an abstract class and a concrete class?
Page 17
To view all questions and flashcards with answers, click on the resource link above.