Relational Database Management
Midterm Exam
Course Introduction
This course provides an in-depth introduction to relational database management systems (RDBMS), focusing on the design, implementation, and management of databases. Students will learn the fundamental concepts of relational data models, entity-relationship diagrams, normalization, and integrity constraints. The course covers Structured Query Language (SQL) for data manipulation and retrieval, transaction management, concurrency control, and database security. Practical exercises and projects offer hands-on experience in modeling real-world scenarios, creating robust database schemas, and optimizing queries, preparing students to effectively manage and administer relational databases in modern information systems.
Recommended Textbook
Database Principles Fundamentals of Design Implementation and Management international 10th
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/1336 Page 2
Chapter 1: The Database Approach
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26651
Sample Questions
Q1) Most decision-support data are based on historical data obtained from ____.
A) operational databases
B) data warehouses
C) enterprise databases
D) workgroup databases
Answer: A
Q2) A desktop database is a ____ database.
A) single-user
B) multiuser
C) workgroup
D) distributed
Answer: A
Q3) Accurate, relevant, and timely information is the key to ____.
A) data management
B) good decision making
C) knowledge
D) understanding
Answer: B
Q4) To reveal meaning, information requires ____________________.
Answer: context
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Database Development Process
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26652
Sample Questions
Q1) After testing is concluded, end-user training is not necessary.
A)True
B)False
Answer: False
Q2) The last step in the DBLC is ____.
A) maintenance and evolution
B) operation
C) testing and evaluation
D) implementation and loading
Answer: A
Q3) Producing the required information flow is part of the ____ phase of the DBLC.
A) database initial study
B) database design
C) operation
D) testing and evaluation
Answer: C
Q4) Because real-world database design is generally done by teams, you should strive to organize the design's major components into ____________________.
Answer: modules
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26653
Sample Questions
Q1) In ____________________, relationships are represented by a diamond connected to the related entities through a relationship line.
Answer: Chen notation
Q2) A(n) ____ is bidirectional.
A) attribute
B) entity
C) relationship
D) constraint
Answer: C
Q3) Database designers determine the data and information that yield the required understanding of the entire business.
A)True
B)False
Answer: False
Q4) In _________________________, a three-pronged symbol represents the "many" side of the relationship.
Answer: Crow's Foot notation
Q5) Each row in a relation is called a(n) ____________________.
Answer: Trueuple
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Relational Model Characteristics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26654
Sample Questions
Q1) Codd's Rule of ____ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database
A) Nonsubversion
B) Logical Data Independence
C) Comprehensive Data Sublanguage
D) Integrity Independence
Q2) The following example exhibits ____________________ integrity: The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. Similarly, the AGENT table's primary key is AGENT_CODE, and this primary key column also is free of null entries.
Q3) Controlled ____ makes a relational database work.
A) relations
B) logic
C) chaos
D) redundancy
Q4) A foreign key must exist in both tables that have a relationship.
A)True
B)False
Q5) What is the system catalog?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Beginning Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26655
Sample Questions
Q1) The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.
A) DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
B) REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';
C) ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';
D) ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';
Q2) Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.
A)True
B)False
Q3) U.S. state abbreviations are always two characters, so ____________________(2) is a logical choice for the data type representing a state column.
Q4) The basic SQL vocabulary has fewer than ____________________ words.
Q5) If your integer values are relatively small, use ____________________ instead of INT.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Procedural Language Sql and Advanced Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26656
Sample Questions
Q1) A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
A)True
B)False
Q2) The ____ query combines rows from two queries and excludes duplicates.
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS
Q3) Explain the different basic types of join operations. What are they and how do they work?
Q4) When using a(n) ____ join, only rows that meet the given criteria are returned.
A) full
B) inner
C) outer
D) set
Q5) Oracle uses the ____________________ function to extract the various parts of a date.
Q6) The IN subquery uses a(n) ____________________ operator.
Q7) Describe the characteristics of an Oracle sequence.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Data Modeling With Entity Relationship
Diagrams
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26657
Sample Questions
Q1) In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
A)True
B)False
Q2) Failure to understand the distinction between mandatory and optional ____________________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
Q3) A derived attribute ____.
A) must be stored physically within the database
B) need not be physically stored within the database
C) has many values
D) must be based on the value of three or more attributes
Q4) All simple attributes are also single-valued.
A)True
B)False
Q5) Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Data Modeling Advanced Concepts
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26658
Sample Questions
Q1) Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.
A) 0:1
B) 1:1
C) 1:M
D) M:N
Q2) The main concern with redundant relationships is that they remain ____________________ across the model.
Q3) If you use a surrogate key, you must ensure that the candidate key of the entity in question performs properly through the use of the "____________________" and "not null" constraints.
Q4) The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
A) subtype discriminator
B) inheritance
C) specialization hierarchy
D) entity supertype
Q5) What is an entity cluster?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Normalizing Database Designs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26659
Sample Questions
Q1) Normalization is a process that is used for changing attributes to entities.
A)True
B)False
Q2) Of the following normal forms, ____ is mostly of theoretical interest.
A) 1NF
B) 3NF
C) BCNF
D) DKNF
Q3) A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.
A)True
B)False
Q4) A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q5) All relational tables satisfy the ____________________ requirements.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Distributed Databases
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26660
Sample Questions
Q1) One of the advantages of a DDBMS is ____________________ operating cost.
Q2) The ____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.
A) DO-UNDO-REDO protocol
B) two-phase commit protocol (2PC)
C) coordinator protocol
D) write-ahead protocol
Q3) A DDBMS must be communications-media-dependent.
A)True
B)False
Q4) A distributed database system requires functional characteristics that can be grouped and described as transparency features.
A)True
B)False
Q5) One of the advantages of a DDBMS is that the data is located near the site with the least demand.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Interacting With Databases Through the Web
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26661
Sample Questions
Q1) Client-side extensions are available in various forms, such as ____.
A) COBOL
B) Java and JavaScript
C) Visual Basic .NET
D) Visor.Net
Q2) ____________________ are objects that manage the connection with a data source and provide data to the consumers.
Q3) Using ____, you can extract data from an XML document and convert it into a text file.
A) XMLD
B) XSLT
C) DTD
D) XML schema
Q4) The CGI is a newer Web-server interface standard that is much more efficient and faster than a dynamic link library (DLL).
A)True
B)False
Q5) A(n) ____________________ is a unique name by which the data source will be known to ODBC, and therefore, to applications.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26662
Sample Questions
Q1) One CASE tool, ____________________ Data Modeler by Computer Associates, produces fully documented ER diagrams that can be displayed at different abstraction levels.
Q2) Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.
A)True
B)False
Q3) When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions.
A) cultural
B) managerial
C) technical
D) operational
Q4) ____ management is designed to limit access to the database.
A) Authorization
B) User access
C) View
D) DBMS utility
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Transactions and Concurrency
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26663
Sample Questions
Q1) The ____________________ rule states that only one transaction at a time can own an exclusive lock on the same object.
Q2) In the optimistic approach, during the ____ phase, changes are permanently applied to the database.
A) read
B) validation
C) write
D) shared
Q3) ____ requires that all operations of a transaction be completed.
A) Specificity
B) Atomicity
C) Durability
D) Time stamping
Q4) A field-level lock allows concurrent transactions to access the same row, as long as they require the use of different fields within that row.
A)True
B)False
Q5) Explain the transaction log. What is its function?
Q6) What are database checkpoints?
15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Managing Database and Sql Performance
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26664
Sample Questions
Q1) Character field comparisons are faster than numeric, date, and NULL comparisons.
A)True
B)False
Q2) To generate database object statistics manually, you could use the following syntax:
A) ANALYZE <TABLE/INDEX> object_name;
B) CREATE <TABLE/INDEX> object_name;
C) ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
D) CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
Q3) A(n) ____ is a logical grouping of several data files that store data with similar characteristics.
A) procedure cache
B) file group
C) data files
D) extends
Q4) The ____________________ table space is the most frequently accessed table space and should be stored in its own volume.
Q5) A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Databases for Decision Support
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26665
Sample Questions
Q1) Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
A) volatility
B) time-variation
C) subject-orientation
D) integration
Q2) In a typical ____________________ schema, each dimension record is related to thousands of fact records.
Q3) A data mart is part of the "____" section of the business intelligence framework.
A) People
B) Management
C) Processes
D) Governance
Q4) A data store is used by the data analyst to create the queries that access the database.
A)True
B)False
Q5) ____________________ is a method or process of government.
To view all questions and flashcards with answers, click on the resource link above. Page 17