Database Management Systems
Exam Bank
Course Introduction
Database Management Systems explores the fundamental concepts, design, implementation, and management of databases. The course covers data models, particularly the relational model, and introduces Structured Query Language (SQL) for database querying and manipulation. Students will learn about database architecture, normalization, indexing, transaction management, concurrency control, and recovery techniques. The course also addresses security and integrity of data, distributed database systems, and emerging trends. Practical lab sessions provide hands-on experience with database management systems, equipping students with the skills to design, develop, and maintain robust, efficient database 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) The most common source of database failures in organizations is:
A) lack of planning.
B) inadequate budget.
C) inadequate hardware.
D) failure to implement a strong database administration function.
Answer: D
Q2) The three-schema approach includes which of the following schemas?
A) Internal
B) Logical
C) Cross-functional
D) Dissecting
Answer: A
Q3) Which organizational function should set database standards?
A) Management
B) Application development
C) Technical services
D) Database Administration
Answer: D
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) Business policies and rules govern all of the following EXCEPT:
A) managing employees.
B) creating data.
C) updating data.
D) removing data.
Answer: A
Q2) An attribute whose values can be calculated from related attribute values is called a derived attribute.
A)True
B)False
Answer: True
Q3) A(n) ________ is the relationship between a weak entity type and its owner.
A) member chain
B) identifying relationship
C) jump path
D) chain link
Answer: B
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) The most important challenge of customizing a purchased data model is determining the business rules that will be established through the data model.
A)True
B)False
Answer: True
Q2) In packaged data models, strong entities always have ________ between them.
A) weak entities
B) 1:1 relationships
C) 1:M relationships
D) M:N relationships
Answer: D
Q3) Discuss how attribute inheritance works in a supertype/subtype hierarchy.
Answer: Subtypes that are lower in the hierarchy inherit attributes not only from their immediate supertype but also from all supertypes higher in the hierarchy all the way to the root.
Q4) Data models of an existing database are harder for data modelers to read.
A)True
B)False
Answer: False
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) A relation that contains minimal redundancy and allows easy use is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Q2) A two-dimensional table of data sometimes is called a: A) group.
B) set.
C) declaration.
D) relation.
Q3) List and explain 1 , 2 , 3 , BCNF, 4 , and 5 normal forms.
Q4) CASE tools can model more complex data relationships, such as ternary relationships.
A)True
B)False
Q5) View integration is the process of merging relations together.
A)True
B)False
Page 6
Q6) Discuss how you would map a regular entity to a relation.
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) The Number datatype would be appropriate for a zip code.
A)True
B)False
Q2) An index on columns from two or more tables that come from the same domain of values is called a:
A) bitmap index.
B) multivalued index.
C) join index.
D) transaction index.
Q3) Along with table scans, other elements of a query can be processed in parallel.
A)True
B)False
Q4) Discuss the critical decisions that must be made during physical database design.
Q5) A file organization where files are not stored in any particular order is considered a:
A) hashed file organization.
B) hash key.
C) multi-indexed file organization.
D) heap file organization.
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) Which of the following will produce the minimum of all standard prices?
A) Select standard_price from Product_V where Standard_Price = min;
B) Select min(standard_price) from Product_V;
C) Select Standard_Price from min(Product_V);
D) Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);
Q2) Which of the following is a purpose of the SQL standard?
A) To specify syntax and semantics of SQL data definition and manipulation
B) To specify maximum and incomplete standards
C) To define every operation for every SQL database
D) To permit no degrees of freedom for SQL DBMS
Q3) In databases, null values are equivalent to zero.
A)True
B)False
Q4) What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));
A) Alters the Customer_T table to accept Type 2 Varchars
B) Alters the Customer_T table to be a Type 2 Varchar
C) Alters the Customer_T table, and adds a field called "Type"
D) Alters the Customer_T table by adding a 2-byte field called "Varchar"
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) ________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.
A) In
B) Having
C) Exists
D) Extents
Q2) Explain how to combine queries using the UNION clause.
Q3) Dynamic SQL:
A) is used to generate appropriate SQL code on the fly as an application is processing.
B) is quite volatile.
C) is not used widely on the Internet.
D) creates a less flexible application.
Q4) A type of join where a table is joined to itself is called a(n):
A) ternary join.
B) self-join.
C) unnatural join.
D) pinned join.
Q5) What can be done with Persistent Stored Modules?
Q6) What strategies can be used to write queries that run more efficiently?
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) ________ facilitates the ability of applications to query relational data along with associated structured data.
A) XPath
B) XQuery
C) XSLT
D) SOAP
Q2) The promise of Web services is the development of a standardized communication system using:
A) HTML.
B) XST.
C) XML.
D) XPath.
Q3) All of the following are newer XML schema languages EXCEPT:
A) Document Type Declarations (DTDs).
B) XML Schema Definition (XSD).
C) RELAX NG.
D) Document Structure Description (DSD).
Q4) Discuss the distribution of application logic components across clients and servers in the client/server environment.
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) All of the following are ways to handle changing dimensions EXCEPT:
A) overwrite the current value with the new value.
B) for each dimension attribute that changes, create a current value field and as many old value fields as we wish.
C) create a new dimension table row each time the dimension object changes.
D) create a snowflake schema.
Q2) Periodic data are data that are never physically altered or deleted once they have been added to the store.
A)True
B)False
Q3) An event is a database action that results from a transaction.
A)True
B)False
Q4) The enterprise data model controls the phased evolution of the data warehouse. A)True B)False
Q5) Scalable technology is critical to a data mart.
A)True
B)False
Q6) Explain what the star schema is.
Page 12
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) The data reconciliation process is responsible for transforming operational data to reconciled data.
A)True
B)False
Q2) The process of transforming data from detailed to summary levels is called normalization.
A)True
B)False
Q3) Conformance means that:
A) data have been transformed.
B) data are stored, exchanged or presented in a format that is specified by its metadata.
C) data are stored in a way to expedite retrieval.
D) data is a harbinger.
Q4) All of the following are popular architectures for Master Data Management EXCEPT:
A) Identity Registry.
B) Integration Hub.
C) Persistent.
D) Normalization.
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) HDFS requires a single master server, but does not allow slave servers.
A)True
B)False
Q2) All of the following are applications for big data and analytics EXCEPT:
A) business.
B) science and technology.
C) security and public health.
D) personal finances.
Q3) ________ are examples of Business Intelligences and Analytics 3.0 because they have millions of observations per second.
A) Administrative systems
B) Web-based interaction logs
C) Web-based customer platforms
D) Smartphones
Q4) Neo4j is a wide-column NoSQL database management system developed by Oracle.
A)True
B)False
Q5) MapReduce is an algorithm for massive parallel processing utilized by Hadoop.
A)True
B)False
Page 14
To view all questions and flashcards with answers, click on the resource link above.
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) A business transaction is a sequence of steps that constitute some well-defined business activity.
A)True
B)False
Q2) A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager.
A)True
B)False
Q3) With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.
A)True
B)False
Q4) The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.
A)True
B)False
Q5) What is backward and forward recovery?
Q6) What is the difference between shared locks and exclusive locks?
Page 15
To view all questions and flashcards with answers, click on the resource link above.
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) Horizontal partitioning is implemented by placing some rows of a table at one site and other rows at another site.
A)True
B)False
Q2) Simple paths to other databases without the benefits of one logical database are called:
A) freeways.
B) parkways.
C) gateways.
D) highways.
Q3) When separate copies of data are stored at each of two or more sites, it is called replication.
A)True
B)False
Q4) With ________, users can act as if all the data were located at a single node.
A) location transparency
B) local autonomy
C) client-based control
D) location consistency
Q5) What is the difference between a local transaction and a global transaction?
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) A(n) ________ encompasses an object's properties and the values of those properties.
A) state
B) attribute
C) method
D) behavior
Q2) A part object that belongs to only one whole object and lives and dies with the whole object is called composting.
A)True
B)False
Q3) Encapsulation is the technique of hiding the internal implementation details of an object from its external view.
A)True
B)False
Q4) What is the difference between a class and an object?
Q5) What is encapsulation?
Q6) State encompasses an object's properties and the values of those properties.
A)True
B)False
Q7) What is polymorphism?
To view all questions and flashcards with answers, click on the resource link above. Page 17