Database Management Systems
Exam Bank
Course Introduction
Database Management Systems explores the fundamental concepts and architectures underlying modern database systems. The course covers topics such as data models (including relational, hierarchical, and NoSQL models), database design using Entity-Relationship diagrams, normalization, SQL querying, transaction management, concurrency control, and database security. Emphasis is placed on both the theoretical foundation and practical application, enabling students to design, implement, and manage databases efficiently while understanding the challenges of data integrity, scalability, and performance in real-world scenarios.
Recommended Textbook
Database Systems Design Implementation and Management 10th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/556
Page 2
Available
Chapter 1: Database Systems
Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10359
Sample Questions
Q1) The same data might be simultaneously structured and unstructured depending on the intended processing.
A)True
B)False
Answer: True
Q2) A(n)____ database is designed to support a company's day-to-day operations.
A) desktop
B) workgroup
C) enterprise
D) transactional
Answer: D
Q3) A data warehouse can store data derived from many sources.
A)True
B)False
Answer: True
Q4) ____________________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.
Answer: Analytical
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10360
Sample Questions
Q1) A(n)____________________ in a hierarchical model is the equivalent of a record in a file system.
Answer: segment
Q2) The ____ model uses the term connectivity to label the relationship types.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: D
Q3) A(n)____________________ is a collection of similar objects with a shared structure and behavior.
Answer: class
Q4) An implementation-ready data model should contain a description of the data structure that will store the end-user data.
A)True
B)False
Answer: True
Q5) Each row in a relation is called a(n)____________________.
Answer: tuple
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10361
Sample Questions
Q1) What is a key and why is it important in the relational model?
Answer: In the relational model,keys are important because they are used to ensure that each row in a table is uniquely identifiable.They are also used to establish relationships among tables and to ensure the integrity of the data.A key consists of one or more attributes that determine other attributes.For example,an invoice number identifies all of the invoice attributes,such as the invoice date and the customer name.
Q2) A(n)____________________ index is an index in which the index key can have only one pointer value (row)associated with it.
Answer: unique
Q3) The DIVIDE operation uses one single-column table (e.g.,column "a")as the divisor and one two-column table (e.g.,columns "a" and "b")as the dividend.
A)True
B)False
Answer: True
Q4) In a relational model,if A determines B,C,and D,you write A = B,C,D.
A)True
B)False
Answer: False
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10362
Sample Questions
Q1) The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity;the ENROLL entity is ____.
A) weak
B) strong
C) optional
D) mandatory
Q2) Some attributes are classified as ____.
A) simple
B) complex
C) defined
D) grouped
Q3) The ERD represents the ____ database as viewed by the end user.
A) condensed
B) physical
C) logical
D) conceptual
Q4) Attributes are types of entities.
A)True
B)False
Q5) What is a weak relationship? Provide an example.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10363
Sample Questions
Q1) Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.
A)True
B)False
Q2) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q3) One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
A)True
B)False
Q4) The most common design trap is known as a(n)____________________.
Q5) ____ relationships occur when there are multiple relationship paths between related entities.
A) Redundant
B) Duplicated
C) Time-variant
D) Supertype
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10364
Sample Questions
Q1) The most likely data type for a surrogate key is ____.
A) Character
B) Date
C) Logical
D) Numeric
Q2) 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
Q3) 1NF,2NF,and 3NF are ____.
A) normalization stages
B) anomalies
C) repeating groups
D) atomic attributes
Q4) When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not _________________________.
Q5) Data redundancies occur from ____________________ of data on every row entry.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Introduction to Structured Query Language (SQL)
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10365
Sample Questions
Q1) When joining three or more tables,you need to specify a join condition for one pair of tables.
A)True B)False
Q2) Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
A) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
B) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1]
C) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1)
D) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1}
Q3) A table can be deleted from the database by using the ____________________ command.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Advanced SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10366
Sample Questions
Q1) The statement SELECT * FROM T1,T2 produces a(n)____ join.
A) cross
B) natural
C) equi-
D) full
Q2) A trigger is executed as part of the transaction that triggered it.
A)True
B)False
Q3) Triggers can only be used to update table values.
A)True
B)False
Q4) The ____________________ outer join returns not only the rows matching the join condition (that is,rows with matching values in the common column),but also the rows in the left-side table with unmatched values in the right-side table.
Q5) A stored function is another name for a stored procedure.
A)True
B)False
Q6) Each statement inside the PL/SQL code must end with a period (".").
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10367
Sample Questions
Q1) Database performance is one of the least important factors in all database implementations.
A)True
B)False
Q2) The process of database design and implementation is ____ development.
A) systems
B) database
C) network
D) transformation
Q3) ____ coupling describes the extent to which modules are independent of one another.
A) Verification
B) Process
C) Module
D) Cohesive
Q4) Because real-world database design is generally done by teams,you should strive to organize the design's major components into ____________________.
Q5) Explain the differences between a centralized and decentralized approach to database design.
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
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10368
Sample Questions
Q1) ____ are required to prevent another transaction from reading inconsistent data.
A) Locks
B) Schedules
C) Stamps
D) Logs
Q2) To ensure consistency of the database,every transaction must begin with the database in an unstable state.
A)True
B)False
Q3) A consistent database is ____.
A) one in which all tables have foreign keys
B) one in which all data integrity constraints are satisfied
C) one in which all tables are normalized
D) one in which all SQL statements only update one table at a time
Q4) If T1 has not unlocked data item Y,T2 cannot begin;if T2 has not unlocked data item X,T1 cannot continue.Consequently,T1 and T2 each wait for the other to unlock the required data item.Such a deadlock is also known as a(n)____________________.
Q5) The ____________________ rule states that only one transaction at a time can own an exclusive lock on the same object.
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
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10369
Sample Questions
Q1) The SQL cache stores the end-user written SQL.
A)True
B)False
Q2) The ____ is a shared,reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures,including triggers and functions.
A) buffer cache
B) procedure cache
C) data cache
D) permanent storage
Q3) Good database performance is easy to evaluate.
A)True
B)False
Q4) Most current-generation relational DBMSs perform automatic query optimization at the client end.
A)True
B)False
Q5) Indexes do not facilitate join operations.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10370
Sample Questions
Q1) ____ is the highest level of transparency.The end user or programmer does not need to know that a database is partitioned.
A) Performance
B) Fragmentation
C) Location
D) Local mapping
Q2) ____ transparency allows the integration of several different local DBMSs under a common,or global,schema.
A) Transaction
B) Performance
C) Distribution
D) Heterogeneity
Q3) A transaction processor is also known as the ____________________ processor.
Q4) One of the advantages of a DDBMS is less danger of a single-____________________ failure.
Q5) A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.
A)True
B)False
14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10371
Sample Questions
Q1) BI is a framework that allows a business to transform data into information,information into knowledge,and knowledge into wisdom.
A)True
B)False
Q2) MOLAP is a logical choice for companies that already use relational databases for their operational data.
A)True
B)False
Q3) Monitoring results to evaluate outcomes of the business decisions is outside the scope of BI.
A)True
B)False
Q4) Normalizing fact tables improves data access performance and saves data storage space.
A)True
B)False
Q5) ____________________ are numeric measurements (values)that represent a specific business aspect or activity.
Q6) OLAP systems share three main characteristics.What are they?
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10372
Sample Questions
Q1) The ____ type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.
A) community
B) public
C) global
D) private
Q2) Every XML document has a ____.
A) root element
B) base tag
C) schema
D) DTD
Q3) ___________________________________ is an application programming interface that allows a Java program to interact with a wide range of data sources (relational databases,tabular data sources,spreadsheets,and text files).
Q4) A good API makes it easy to develop a program by providing all of the building blocks.
A)True
B)False
Q5) What are some of the features provided by Web application servers?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10373
Sample Questions
Q1) The end user must provide testing and evaluation services for all the database and DBA applications.
A)True
B)False
Q2) At the level of middle management,the database must be able to ____.
A) represent and support the company operations as closely as possible
B) deliver the data necessary for tactical decisions and planning
C) produce query results within specified performance levels
D) provide access to external and internal data to identify growth opportunities and to chart the direction of such growth
Q3) Describe the DBA's managerial role.
Q4) A(n)____ serves as the basis for planning,development,and control of future information systems
A) access plan
B) active data dictionary
C) information systems architecture (ISA)
D) security policy
Q5) Describe the need for convenient and safe backup storage.
Q6) A(n)____________________ physically stores the database's data.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Q7) An access ____________________ describes the type of authorized access.