Relational Database Management Systems
Midterm Exam
Course Introduction
This course offers a comprehensive introduction to Relational Database Management Systems (RDBMS), focusing on the fundamental concepts, architectures, and operations that underpin relational databases. Students will learn about data modeling with Entity-Relationship and relational models, normalization, query languages such as SQL, and transaction management. The course also covers database design, implementation, security, and integrity constraints, as well as aspects of indexing and query optimization. Practical lab sessions provide hands-on experience with popular RDBMS software, enabling students to design, create, and manipulate databases to support real-world applications.
Recommended Textbook
Concepts of Database Management 9th Edition by Joy L. Starks
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1925 Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38335
Sample Questions
Q1) Which term can be described as the duplication of data and storing it in multiple locations?
A) data independence
B) redundancy
C) data integrity
D) security
Answer: B
Q2) In an E-R diagram rectangles represent _________________________.
Answer: entities
Q3) List the disadvantages of database processing.
Answer: Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Q4) Redundancy makes changing data more cumbersome and time-consuming.
A)True
B)False
Answer: True
Q5) The problem of inconsistency in data is a direct result of ____________________.
Answer: redundancy
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38336
Sample Questions
Q1) To list the records in a query's results in a particular order, you need to ____________________ the records.
Answer: sort
Q2) Discuss the difference between the major sort key and the minor sort key.
Answer: To list the records in query results in a particular way, you need to sort the records. The field on which records are sorted is called the sort key; you can sort records using more than one field when necessary. When you are sorting records by more than one field (such as sorting by rep number and then by customer name), the first sort field (RepNum) is called the major sort key (also called the primary sort key) and the second sort field (CustomerName) is called the minor sort key (also called the secondary sort key).
Q3) Which command creates a table containing all rows that are in either or both of two tables?
A) UNION
B) SUBTRACT
C) JOIN
D) INTERSECT
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model 2: SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38337
Sample Questions
Q1) Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)
A) SELECT FirstName, LastName FROM Course WHERE StudentID='1167' ;
B) SELECT FirstName, LastName FROM * WHERE StudentID='1167' ;
C) SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ;
D) SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ;
Answer: C
Q2) Use the ____________________ data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.
Answer: CHAR
Q3) When you connect simple conditions using the ____________________ operator, the compound condition will be true whenever any of the simple conditions are true.
Answer: OR
Q4) In an SQL query, after the word _______________ , you list the fields you want to display in the query result.
Answer: SELECT
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: The Relational Model 3: Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38338
Sample Questions
Q1) Where can you save a query if you anticipate running it often?
A) index
B) stored procedure
C) system catalog
D) view
Q2) To insert a new field in a table, which keyword should be used with the ALTER TABLE command?
A) INSERT
B) ADD
C) INCLUDE
D) ALTER
Q3) What SQL feature can you use if you want to create a view that combines data from more than one table?
A) a join
B) a trigger
C) an index
D) a catalog
Q4) The type of field for which you should never allow nulls is the
Q5) What is the difference between entity integrity and referential integrity?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design 1: Normalization
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38339
Sample Questions
Q1) Discuss how candidate keys, primary key, and alternate keys are related.
Q2) What is a table that contains a repeating group called?
A) normalized relation
B) unnormalized relation
C) nominal relation
D) non-nominal relation
Q3) When the ____________________ of a table is a single column, the table is automatically in second normal form.
Q4) An interrelation constraint is a condition that involves two or more relations.
A)True
B)False
Q5) Which of the following is a characteristic of a table that is in first normal form?
A) It doesn't contain repeating groups.
B) It has at least two foreign keys.
C) It doesn't have a primary key
D) There are no alternate keys.
Q6) Any row that determines another row is called a determinant.
A)True
B)False
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Database Design 2: Design Method
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38340
Sample Questions
Q1) An entity with a minimum cardinality of one plays a(n) ____________________ role in the relationship.
Q2) As soon as you have completed Steps 1 through 3 for a given user view, you can merge the results into the __________________ design.
Q3) If each employee works in a single department and each department has several employees, what is the relationship between departments and employees?
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many
Q4) When a DBMS cannot enforce data and access restrictions, how should they be enforced?
A) by users when they are entering data using the DBMS
B) by peripheral programs written to access the database
C) by the operating system used to run the DBMS
D) by technicians who monitor database usage
Q5) What is an existence dependency? Provide an example.
Q6) ____________________ key restrictions determine the relationships between tables.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38341
Sample Questions
Q1) What strategy can programs employ to minimize the occurrence of deadlocks?
A) Only unlock records at the end of the day.
B) Unlock records in the reverse order in which they were locked.
C) Use a random order record-locking strategy.
D) Lock records in the same order.
Q2) Authentication refers to techniques for decrypting data when it accessed by authorized users.
A)True
B)False
Q3) What occurs when two or more users are waiting for the other user to release a lock before their transaction can proceed?
A) commit
B) timestamp
C) deadlock
D) transaction
Q4) You can improve the performance of the recovery program by having it first scan the log and then apply the last after image.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Administration
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38342
Sample Questions
Q1) Which DBA role makes sure the data gets from one place to another with integrity and security?
A) data architect
B) database programmer
C) data administrator
D) data operations manager
Q2) The data architect designs, builds, and deploys databases.
A)True
B)False
Q3) What type of locks forbid any other user from accessing the data in any way?
A) Shared
B) Exclusive
C) Limited
D) Concurrent
Q4) Which process converts a table that is in third normal form to a table no longer in third normal form?
A) conversion
B) denormalizing
C) normalization
D) replication
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38343
Sample Questions
Q1) Which rule for distributed databases states that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database?
A) Continuous operation
B) Local autonomy
C) Location transparency
D) Fragmentation transparency
Q2) The subclass ____________________ the structure of the class as well as its methods.
Q3) With respect to the definition of data warehouse, which of the following means that the data is read-only?
A) time-variant
B) integrated
C) nonvolatile
D) subject-oriented
Q4) The relationship between a superclass and a subclass is called a ____________________.
Q5) On a class diagram, the lines joining the classes represent the relationships and are called ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 11