Database Management Systems
Final Exam Questions
Course Introduction
Database Management Systems is a foundational course that explores the principles and practices involved in the design, implementation, and management of databases. Students will gain an understanding of fundamental concepts such as data models, relational databases, normalization, SQL querying, and transaction management. The course also covers topics like data security, integrity, concurrency control, and recovery techniques. Through hands-on exercises and projects, students will learn to develop efficient database solutions and understand the role of database systems in modern applications across various industries.
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) All of the following are properties of metadata EXCEPT:
A) data definitions.
B) processing logic.
C) rules or constraints.
D) data structures.
Answer: B
Q2) Organizational commitment to a database project is not necessary for its success.
A)True
B)False
Answer: False
Q3) A well-structured database establishes the entities between relationships in order to derive the desired information.
A)True
B)False
Answer: False
Q4) Multitier client/server database applications contain a business logic layer.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
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) A relationship between the instances of a single entity type is called a ________ relationship.
A) ternary
B) primary
C) binary
D) unary
Answer: D
Q2) An entity type whose existence depends on another entity type is called a ________ entity.
A) strong
B) weak
C) codependent
D) variant
Answer: B
Q3) How is a strong entity different from a weak entity?
Answer: A strong entity type exists independently of any other entities. A weak entity type depends on another (strong) entity type. When an instance of the strong entity type no longer exists, any weak entity instances which depend upon the strong entity cease to exist.
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) In a supertype/subtype hierarchy, each subtype has:
A) only one supertype.
B) many supertypes.
C) at most two supertypes.
D) at least one subtype.
Answer: A
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) Adapting a packaged data model from your DBMS vendor makes it difficult for the application to work with other applications from the same vendor.
A)True
B)False
Answer: False
Q4) A subtype can become a supertype if the subtype has other subtypes beneath it.
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) Discuss the two major occasions when you benefit from using normalization.
Q2) A co-dependency is a constraint between two attributes or two sets of attributes.
A)True
B)False
Q3) Explain what a candidate key is and how it might be used.
Q4) The need to ________ relations commonly occurs when different views need to be integrated.
A) metadata
B) system
C) drop
D) merge
Q5) The entity integrity rule states that a primary key attribute can be null.
A)True
B)False
Q6) A transversal dependency is a functional dependency between two or more nonkey attributes.
A)True
B)False
Page 6
Q7) Discuss the two possible scenarios when mapping an associative entity.
To view all questions and flashcards with answers, click on the resource link above.
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 tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.
A)True
B)False
Q2) An integrity control supported by a DBMS is:
A) substitute estimates.
B) security.
C) range control.
D) GUI guards.
Q3) A range control limits the set of permissible values that a field may assume.
A)True
B)False
Q4) Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):
A) extent.
B) table.
C) tablespace.
D) partition.
Q5) What is clustering?
Q6) Discuss how data integrity can be controlled.
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) The ORDER BY clause sorts the final results rows in ascending or descending order.
A)True
B)False
Q2) Referential Integrity Constraints are generally established between:
A) Referential and Integrity keys.
B) Primary and Secondary keys.
C) Primary and Foreign keys.
D) Foreign and Domestic keys.
Q3) The ALTER TABLE command is used to change a table definition.
A)True
B)False
Q4) 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.
Q5) The SQL command used to populate tables is the INSERT command. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.
A)True
B)False
Q2) Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.
A)True
B)False
Q3) Explicit commands to manage transactions are needed when:
A) a transaction consists of just one SQL command.
B) multiple SQL commands must be run as part of a transaction.
C) autocommit is set to off.
D) DDL statements are prohibited.
Q4) Joining tables or using a subquery may produce the same result.
A)True B)False
Q5) One major disadvantage of the outer join is that information is easily lost. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) Discuss the distribution of application logic components across clients and servers in the client/server environment.
Q2) SOAP stands for:
A) what you wash your hands with.
B) Simple ODBC Access Protocol.
C) Strategic Operational Advanced Planning.
D) Simple Object Access Protocol Method.
Q3) An API is a set of routines that a database server uses to access database objects.
A)True
B)False
Q4) The ________ specification allows drivers to conform to various levels of the specification, and that affects the level of functionality of the drivers.
A) JDBC
B) ODBC
C) CORBA
D) Cobra
Q5) Explain how middleware is used in a two-tier application.
Q6) Explain how XML documents are retrieved.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) Conformed dimensions allow users to do the following:
A) delete correlated data.
B) query across fact tables with consistency.
C) identify viruses in web sites.
D) fix viruses in html documents.
Q2) Discuss the difference between transient data and periodic data.
Q3) Which of the following is true of data visualization?
A) It is more difficult to observe trends and patterns in data.
B) Correlations and clusters in data can be easily identified.
C) It is often used in conjunction with poems.
D) It is generally not helpful for decision making.
Q4) NoSQL is a great technology for storing well-structured data.
A)True
B)False
Q5) What is the role of metadata in the three-layer data architecture?
Q6) Medical claims and pharmaceutical data would be an example of big data.
A)True
B)False
Q7) What are some approaches to handling slowly changing dimensions?
Q8) What is OLAP and what types of OLAP tools are available?
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Data scrubbing is a technique using pattern recognition and other artificial intelligence techniques to upgrade the quality of raw data before transforming and moving the data to the data warehouse.
A)True
B)False
Q2) Bit-mapped indexing is often used in a data warehouse environment.
A)True
B)False
Q3) 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
Q4) In the ________ approach, one consolidated record is maintained from which all applications draw data.
A) persnickity
B) cautious
C) persistent
D) data-oriented
Q5) What is data transformation?
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) 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.
Q2) MongoDB is a proprietary NoSQL database management system created by Oracle.
A)True
B)False
Q3) Value (related to the five 'v's of big data) addresses the pursuit of a meaningful goal.
A)True
B)False
Q4) With HDFS it is less expensive to move the execution of computation to data than to move the:
A) data to hardware.
B) data to systems analysis.
C) data to computation.
D) data to processes.
Q5) Describe the Five Vs of Big Data.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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 ________ is a DBMS module that restores the database to a correct condition when a failure occurs.
A) backup facility
B) recovery manager
C) restart facility
D) transaction logger
Q2) With ________, the database itself is lost, destroyed, or cannot be read.
A) aborted transaction
B) database destruction
C) incorrect data
D) system failure
Q3) A device to measure or detect fingerprints or signatures is called a(n) ________ device.
A) biometric
B) view
C) ink
D) laser
Q4) What are some of the core roles of the traditional data administrator?
Q5) What are integrity controls? Describe the different types.
Q6) What are some of the core roles of a database administrator?
Page 14
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) Concurrency transparency allows each transaction to appear as if it were the only activity in a distributed database management system.
A)True
B)False
Q2) What are the three steps that a distributed DBMS uses to develop a query plan?
Q3) What are the functions of a distributed DBMS?
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) Discuss the different types of data replication.
Q6) Location translucency enables users and programmers to treat data as if it were located at one node even though it may move from node to node.
A)True
B)False
Q7) A distributed unit of work does not support location transparency.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) What are several motivations and benefits of object-oriented modeling?
Q2) An association class is similar to an associative entity in the E-R model.
A)True
B)False
Q3) Which of the following operations does NOT alter the state of an object?
A) Update
B) Query
C) Constructor
D) Class-Scope Update
Q4) When an object is an instance of more than one class, it is called:
A) multiplicity.
B) polymorphism.
C) multiple classification.
D) multiple associations.
Q5) The object-oriented systems development cycle consists of:
A) two phases.
B) three phases.
C) four phases.
D) five phases.
Q6) What is the difference between an abstract class and a concrete class?
Page 16
To view all questions and flashcards with answers, click on the resource link above.