Relational Database Management Review
Questions
Course Introduction
This course explores the fundamental principles and practices of relational database management systems (RDBMS). Students will learn about data modeling, relational algebra, schema design, normalization, and Structured Query Language (SQL) for data manipulation and retrieval. The course covers topics such as database integrity, security, transaction management, and concurrency control, providing both theoretical knowledge and hands-on experience with leading database platforms. By the end of the course, students will be equipped to design, implement, and manage robust relational databases to support real-world 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) Information is processed data.
A)True
B)False
Answer: True
Q2) Which of the following is software used to create, maintain, and provide controlled access to databases?
A) Network operating system
B) User view
C) Database management system (DBMS)
D) Attribute
Answer: C
Q3) A graphical system used to capture the nature and relationships among data is called a(n):
A) XML data model.
B) hypertext graphic.
C) relational database
D) data model.
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) A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties.
B) examples.
C) who determines the value of the data.
D) who can delete the data.
Answer: D
Q2) The relationship between a weak entity type and its owner is an identifying relationship.
A)True
B)False Answer: True
Q3) A business rule should be internally consistent.
A)True
B)False
Answer: True
Q4) Some examples of attributes are: eye_color, weight, student_id, STUDENT.
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) When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator.
A)True
B)False
Answer: False
Q2) Describe how subtype discriminators are used when we have overlapping subtypes.
Answer: When we have overlapping subtypes, we need to create a composite subtype discriminator with Boolean values.
Q3) The third step in the data modeling process with a packaged data model is:
A) rename identified data elements.
B) rename relationships.
C) map data to be used from package to data in current databases.
D) interview users.
Answer: C
Q4) Packaged data models cause projects to take more time to build.
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) Discuss how to map a unary one-to-many relationship.
Q2) List and explain 1 , 2 , 3 , BCNF, 4 , and 5 normal forms.
Q3) A relation is in first normal form if it has no more than one multivalued attribute.
A)True
B)False
Q4) An anomaly is a type of flaw in the database server.
A)True
B)False
Q5) When a regular entity type contains a multivalued attribute, two new relations are created.
A)True
B)False
Q6) If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.
A)True
B)False
Q7) How do you convert weak entities to relations?
Q8) Discuss the various relational keys.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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 method to allow adjacent secondary memory space to contain rows from several tables is called:
A) cluttering.
B) clustering.
C) concatenating.
D) compiling.
Q2) Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.
A)True
B)False
Q3) Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.
A)True
B)False
Q4) A join index is a combination of two or more indexes.
A)True
B)False
Q5) Explain the differences between sequential and indexed file organizations.
Q6) Discuss coding techniques and how they could be used.
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 following query totals sales in state= 'MA' for each salesperson. Select salesperson_id, sum(sales) from salesperson group by salesperson_id having state = 'MA';
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) 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);
Q4) Explain the three classes of SQL commands and when they would be used.
Q5) What three clauses are contained in most SQL retrieval statements?
Page 8
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) MULTISET is similar to the table datatype.
A)True
B)False
Q2) Using an outer join produces this information: rows that do not have matching values in common columns are not included in the result table.
A)True
B)False
Q3) The ________ DBA view shows information about all users of the database in Oracle.
A) DBA_USERS
B) USERS
C) DBA_VIEWS
D) DBA_INDEXES
Q4) 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
Q5) What is a self-join and how is it used?
Q6) Discuss the differences between an equi-join, natural join and outer join.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) Customer-oriented architectures are a collection of services that communicate with each other in some manner.
A)True
B)False
Q2) All .html files can be processed by the web server itself.
A)True
B)False
Q3) Sets of routines that an application program uses to direct the performance of procedures by the computer's operating system is called a(n):
A) application program interface.
B) xpi.
C) application device interface.
D) CMOS.
Q4) Web services allow for communication between programs over the Internet.
A)True
B)False
Q5) XML uses bcode, long commands embedded in quotes, to characterize data.
A)True
B)False
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) An event is a database action that results from a transaction.
A)True
B)False
Q2) Factless fact tables may apply when:
A) we are deleting sales.
B) we are tracking sales.
C) we are taking inventory of the set of possible occurrences.
D) we are deleting correlated data.
Q3) When we consider data in the data warehouse to be time-variant, we mean:
A) that the time of storage varies.
B) data in the warehouse contain a time dimension so that they may be used to study trends and changes.
C) that there is a time delay between when data are posted and when we report on the data.
D) that time is relative.
Q4) A conformed dimension is one or more dimension tables associated with only one fact table.
A)True
B)False
Q5) What is data mining, and what are its goals?
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) The data reconciliation process is responsible for transforming operational data to reconciled data.
A)True
B)False
Q2) Discuss data governance and what needs to be included in a data governance program.
Q3) Data may be loaded from the staging area into the warehouse by following:
A) SQL Commands (Insert/Update).
B) SQL purge.
C) custom-written letters.
D) virus checking.
Q4) Improving data capture process is a fundamental step in data quality improvement.
A)True
B)False
Q5) An approach in which only changes in the source data are written to the data warehouse is called refresh mode.
A)True
B)False
Q6) Discuss Master Data Management.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) Big data requires effectively processing:
A) a single data type (numeric).
B) two data types (text and numeric).
C) many data types.
D) a single data type (text).
Q2) Application of statistical and computational methods to predict data events is:
A) predictive analytics.
B) descriptive analytics.
C) prescriptive analytics.
D) comparative analytics.
Q3) Allowing users to dive deeper into the view of data with online analytical processing (OLAP) is an important part of:
A) predictive analytics.
B) descriptive analytics.
C) prescriptive analytics.
D) comparative analytics.
Q4) DataNodes in an HDFS cluster represents the large number of slaves.
A)True
B)False
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(n) ________ is submitted by a DBA to test the current performance of a database or predict the response time for queries.
A) elusive query
B) performance test
C) heartbeat query
D) HTML
Q2) Open-source software always comes with complete documentation.
A)True
B)False
Q3) Which of the following functions model business rules?
A) Database planning
B) Database analysis
C) Database design
D) Operations
Q4) The record log is a record of the essential data for each transaction that has been processed against the database.
A)True
B)False
Q5) What is a journalizing facility?
Q6) What are some of the core roles of the traditional data 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) Simple paths to other databases without the benefits of one logical database are called:
A) freeways.
B) parkways.
C) gateways.
D) highways.
Q2) The overriding principle in distributed database design is that data should be stored at one central site.
A)True
B)False
Q3) ________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.
A) Location transparency
B) Location autonomy
C) Location dependency
D) Distributed locatability
Q4) 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) Overriding for optimization implements a new operation with improved code by exploiting the restrictions imposed by the superclass.
A)True
B)False
Q2) An association class is similar to an associative entity in the E-R model.
A)True
B)False
Q3) An object encapsulates both data and behavior.
A)True
B)False
Q4) A class-scope attribute is an attribute of a class that specifies a value common to an entire class, rather than a specific value for an instance.
A)True
B)False
Q5) {disjoint, complete} is an example of a UML: A) expansion.
B) HTML link.
C) business rule constraint.
D) database clause.
To view all questions and flashcards with answers, click on the resource link above. Page 16