Relational Database Systems Review Questions
Course Introduction
This course provides a comprehensive introduction to relational database systems, covering foundational concepts such as relational algebra, database design, SQL queries, normalization, and transaction management. Students will learn the principles of data modeling, schema design, integrity constraints, and efficient query processing. The course also explores issues of concurrency control, recovery, and security in multi-user environments, along with practical experience in designing, implementing, and optimizing relational databases using modern database management systems.
Recommended Textbook
Database Systems Design Implementation and Management 13th Edition by Carlos Coronel
Available Study Resources on Quizplus
16 Chapters
1194 Verified Questions
1194 Flashcards
Source URL: https://quizplus.com/study-set/1337
2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26666
Sample Questions
Q1) _____ exists when different versions of the same data appear in different places.
A) Data inconsistency
B) Poor data security
C) Structural dependence
D) Conceptual dependence
Answer: A
Q2) A workgroup database is a(n) _____ database.
A) single-user
B) multiuser
C) desktop
D) distributed
Answer: B
Q3) What are the advantages of having the DBMS between the end user's applications and the database?
Answer: Having a DBMS between the end user's applications and the database offers some important advantages.First, the DBMS enables the data in the database to be shared among multiple applications or users.Second, the DBMS integrates the many different users' views of the data into a single all-encompassing data repository.
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26667
Sample Questions
Q1) The _____ data model is said to be a semantic data model.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Q2) A(n) _____ is a restriction placed on the data.
A) attribute
B) entity
C) relationship
D) constraint
Answer: D
Q3) Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
A)True
B)False
Answer: True
Q4) The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.
Answer: logical design
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Database Model
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26668
Sample Questions
Q1) _____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
A) Predicate
B) Database
C) Relational
D) Index
Answer: A
Q2) A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.
A)True
B)False
Answer: True
Q3) As rare as 1:1 relationships should be, certain conditions absolutely require their use.
A)True
B)False
Answer: True
Q4) The _____ relationship is the relational database norm.
Answer: 1:M
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Entity Relationship Er Modeling
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26669
Sample Questions
Q1) A _____ attribute is one that cannot be subdivided.
A) composite
B) simple
C) single-valued
D) multivalued
Q2) In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.
A) (max, min)
B) (min, max)
C) [min ... max]
D) {min|max}
Q3) If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity.
A) weak
B) alone
C) unary
D) strong
Q4) A person's Social Security number would be an example of a(n) _____ attribute.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26670
Sample Questions
Q1) The default comparison condition for the subtype discriminator attribute is the _____ comparison.
A) nonequality
B) less than
C) greater than D) equality
Q2) One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.
A) primary
B) natural
C) foreign
D) surrogate
Q3) At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
A)True
B)False
Q4) What do specialization hierarchies do?
Q5) _____ completeness means that every supertype occurrence must be a member of at least one subtype.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26671
Sample Questions
Q1) What steps are involved in the conversion to third normal form?
Q2) BCNF can be violated only if the table contains more than one _____ key.
A) primary
B) candidate
C) foreign
D) secondary
Q3) _____ is a process to help reduce the likelihood of data anomalies.
Q4) An atomic attribute _____.
A) cannot exist in a relational table
B) cannot be further subdivided
C) displays multiplicity
D) is always chosen to be a foreign key
Q5) In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.
A)True
B)False
Q6) Normalization represents a micro view of the entities within the ERD.
A)True
B)False
Q7) Any attribute that is at least part of a key is known as a(n) _____.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Introduction to Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26672
Sample Questions
Q1) In SQL, all _____ expressions evaluate to true or false.
Q2) The syntax of theEXCEPT statement in Oracle is _____.
Q3) The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.
A) COUNT
B) MIN
C) MAX
D) SUM
Q4) _____ is a relational set operator.
A) EXCEPT
B) PLUS
C) ALL
D) EXISTS
Q5) _____ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.
Q6) The SQL data manipulation command HAVING:
A) restricts the selection of rows based on a conditional expression.
B) restricts the selection of grouped rows based on a condition.
C) modifies an attribute's values in one or more table's rows.
Page 9
D) groups the selected rows based on one or more attributes.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26673
Sample Questions
Q1) You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This isknown as _____.
A) batch updating
B) referential integrity
C) authentication
D) cross joining
Q2) To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.
A)True
B)False
Q3) The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.
A) COMMIT
B) SELECT
C) ROLLBACK
D) UPDATE
Q4) To delete an index, one must use the _____ command.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26674
Sample Questions
Q1) The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.
A) two
B) three
C) four
D) five
Q2) The process of creating an information system is known as _____.
A) systems development
B) database development
C) network development
D) enterprise development
Q3) The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.
A)True
B)False
Q4) The overall purpose of the database initial study is to create the conceptual design.
A)True
B)False
Q5) What are the factors affecting the purchasing decision for DBMS software?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Transaction Management and Concurrency Control
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26675
Sample
Questions
Q1) A(n) _____ phase in a two phase lock is when a transaction releases all locks and cannot obtain a new lock.
A) growing
B) shrinking
C) locking
D) unlocking
Q2) A diskpage, or page, is the equivalent of a _____.
A) database table
B) disk sector
C) database schema
D) diskblock
Q3) The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.
A)True
B)False
Q4) How does a shared/exclusive lock schema increase the lock manager's overhead?
Q5) The _____ occurs when two concurrent transactions, T1 and T2, are updating the same data element and one of the updates is lost.
Q6) What is transaction isolation and why it is important?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26676
Sample Questions
Q1) _____ is the central activity during the parsing phase in query processing.
A) Clustering
B) Partitioning
C) Query validation
D) Query optimization
Q2) The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.
A) data cache
B) SQL cache
C) sort cache
D) optimizer mode
Q3) If there is no index, the DBMS will perform a _____ scan.
A) loop
B) range
C) row ID table access
D) full table
Q4) A system will perform best when its hardware and software resources are _____.
Q5) Why do we need to optimize a DBMS with SQL performance tuning, even though they automatically optimize SQL queries?
Q6) _____ are ordered sets of values that are crucial in speeding up data access. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26677
Sample Questions
Q1) A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.
A) distributed
B) transaction
C) fragmented
D) remote
Q2) Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
A)True
B)False
Q3) _____ fragmentation refers to the division of a relation into subsets of tuples.
A) Vertical
B) Horizontal
C) Data
D) Mixed
Q4) Data _____ describes the process of deciding where to locate data.
Q5) Distribution transparency is supported by a distributed data dictionary.
A)True
B)False
Q6) Explain the three types of operations defined by the DO-UNDO-REDO protocol.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26678
Sample Questions
Q1) Which type of data describes numeric facts or measuresthat can becan be counted, ordered, and aggregated?
A) qualitative
B) ordinal
C) nominal
D) quantitative
Q2) _____ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
Q3) What is data visualization? Name different techniques of data visualization.
Q4) In a star schema, attributes are often used to search, filter, or classify _____.
A) tables
B) sales
C) facts
D) dimensions
Q5) The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Big Data and Nosql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26679
Sample Questions
Q1) ______ isthe coexistence of a variety of data storage and data management technologies within an organization's infrastructure.
Q2) Under the HDFS system, using a write-one, ready-many model simplifies concurrency issues.
A)True
B)False
Q3) In the context of Big Data, ______ relates to changes in meaning.
A) variety
B) variability
C) veracity
D) viability
Q4) Neo4j is a ______ database.
A) graph
B) column family
C) key-value
D) row-centric
Q5) Discuss NewSQL and what it attempts to do.
Q6) Discuss the need for a Hadoop ecosystem and identify the key components.
Q7) The interactive, declarative query language in Neo4j is called ______.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Q8) Define the four key assumptions of the Hadoop Distributed File System (HDFS).
Chapter 15: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
73 Verified Questions
73 Flashcards
Source URL: https://quizplus.com/quiz/26680
Sample Questions
Q1) Another name for a database server-side extension program is _____.
A) web server
B) web application middleware
C) web-to-database middleware
D) database application server
Q2) A(n) _____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.
A) XMLD
B) XHTML
C) DTD
D) meta
Q3) The first line of an XML document represents the document declaration, and it is mandatory.
A)True
B)False
Q4) The browser's interpretation and presentation capabilities are sufficient to develop web-based applications.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26681
Sample Questions
Q1) Coordinating, monitoring, and allocating database administration resources is included in a DBA's _____ role.
A) operative
B) arbitration
C) technical
D) managerial
Q2) The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.
A)True
B)False
Q3) In the context of an organization's managerial structure, _____ decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.
Q4) Within the data security framework, _____ is concerned with keeping data consistent and free of errors or anomalies.
Q5) Concurrent backups take place while the user is working on the database.
A)True
B)False
Q6) Describe the DBA's managerial role.
Page 19
To view all questions and flashcards with answers, click on the resource link above.