Database Management Systems
Mock Exam
Course Introduction
Database Management Systems is a foundational course that introduces students to the principles and practices of designing, implementing, and managing modern databases. The course covers key concepts such as data models, relational algebra, SQL queries, normalization, transaction management, and database security. Students will gain hands-on experience with database management system software, learning how to design efficient databases, perform complex queries, and ensure data integrity. Emphasis is placed on real-world applications, scalability, and emerging trends in database technologies, preparing students for roles in data-driven environments.
Recommended Textbook
Database Systems Design Implementation and Management 11th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1318 Verified Questions
1318 Flashcards
Source URL: https://quizplus.com/study-set/1460
Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/29009
Sample Questions
Q1) data exist in a format that does not lend itself to processing that yields information.
A) Structured
B) Semistructured
C) Unstructured
D) Historical
Answer: C
Q2) is a special language used to represent and manipulate data elements in a textual format.
Answer: XML (Extensible Markup Language)
Extensible Markup Language (XML)
Extensible Markup Language
XML
Q3) An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
A)True
B)False
Answer: False
Q4) To reveal meaning, information requires .
Answer: context
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29016
Sample Questions
Q1) A(n) represents a particular type of object in the real world.
A) attribute
B) entity
C) relationship
D) node
Answer: B
Q2) A noun in a business rule translates to a(n) in the data model.
A) entity
B) attribute
C) relationship
D) constraint
Answer: A
Q3) A(n) in a hierarchical model is the equivalent of a record in a file system.
Answer: segment
Q4) A(n) defines the environment in which data can be managed and is used to work with the data in the database.
Answer: data manipulation language (DML)
Q5) Each column in a relation represents a(n) . Answer: attribute
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/29017
Sample Questions
Q1) , also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT
Answer: D
Q2) What is a key and how is it important in a relational model?
Answer: In a 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.
Q3) A is any key that uniquely identifies each row.
A) superkey
B) special key
C) foreign key
D) candidate key
Answer: A
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/29018
Sample Questions
Q1) 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.
Q2) The conceptual model can handle relationships and multivalued attributes.
A) 1:1
B) M:N
C) 1:M
D) 1:N
Q3) 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}
Q4) Unary relationships are common in manufacturing industries.
A)True
B)False
Q5) A(n) attribute is an attribute that must have a value.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29019
Sample Questions
Q1) An entity cluster is formed by combining multiple interrelated entities into .
A) a single abstract entity object
B) multiple abstract entity objects
C) a single entity object
D) multiple entity objects
Q2) The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics.
A)True
B)False
Q3) In specialization hierarchies with multiple levels of supertype and subtypes, a lower-level subtype can inherit only a few of the attributes and relationships from its upper-level supertypes.
A)True
B)False
Q4) Composite keys are useful as identifiers of weak entities, where the weak entity has a strong relationship with the parent entity.
Q5) A weak-entity in a strong identifying relationship with a parent entity is normally used to represent a(n) that is represented in the data model as two separate entities.
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
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/29020
Sample Questions
Q1) Denormalization produces a lower normal form.
A)True
B)False
Q2) A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in .
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q3) Explain normalization and its different forms.
Q4) An ERD is created through an process.
Q5) A determinant is any attribute whose value determines other values within a column.
A)True
B)False
Q6) For most business transactional databases, we should normalize relations into .
A) 1NF
B) 2NF
C) 3NF
D) 6NF
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
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) To delete an index, one must use the command.
Q2) Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.
A)True
B)False
Q3) is the process the DBMS uses to verify that only registered users access the database.
Q4) The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.
A)True
B)False
Q5) 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
Q6) How can a table be deleted from the database? Provide an example.
Page 9
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
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/29022
Sample Questions
Q1) Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.
Q2) The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.
A)True
B)False
Q3) Triggers can only be used to update table values.
A)True
B)False
Q4) A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.
A)True
B)False
Q5) Stored procedures help reduce code duplication by means of code isolation and code sharing.
A)True
B)False
Q6) A(n) subquery is a subquery that executes once for each row in the outer query.
Q7) Describe the important features and applications of SQL functions
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
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/29023
Sample Questions
Q1) Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).
A) planning
B) analysis
C) detailed systems design
D) implementation
Q2) In DBLC, the phase after the database initial study is .
A) operation
B) database design
C) database initial study
D) implementation and loading
Q3) In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.
A)True
B)False
Q4) List and describe the different levels at which database backups can be performed.
Q5) is the process that establishes the need for, and the extent of, an information system.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29010
Sample Questions
Q1) An optimistic approach is based on the assumption that the majority of the database operations do not conflict.
A)True
B)False
Q2) In a page-level lock, the DBMS will lock an entire diskpage.
A)True
B)False
Q3) In the wait/die scheme,:
A) the older transaction rolls back the younger transaction and reschedules it.
B) the younger, preempted transaction is rescheduled using the same time stamp.
C) the older transaction waits for the younger one to complete and release its locks.
D) both the younger and older transactions wait indefinitely to be released.
Q4) How does a shared/exclusive lock schema increase the lock manager's overhead?
Q5) The implicit beginning of a transaction is .
A) when the database is started
B) when a table is accessed for the first time
C) when the first SQL statement is encountered
D) when the COMMIT command is issued
Q6) As a rule, a(n) must unlock the object after its termination.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29011
Sample Questions
Q1) Most current-generation relational DBMSs perform automatic query optimization at the client end.
A)True
B)False
Q2) A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
A) procedure caches
B) file groups
C) data caches
D) operation modes
Q3) Bitmap indexes tend to use less space than a because they use bits instead of bytes to store their data.
A) hash index
B) sparse index
C) B-tree index
D) reverse index
Q4) helps provide a balance between performance and fault tolerance.
Q5) The SQL cache stores the end-user written SQL. 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
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) The database description, known as the distributed schema, is the common database schema used by local transaction processors (TPs) to translate user requests into subqueries that will be processed by different data processors (DPs).
Q2) A database management system needs to prepare the data for presentation to the end user or to an application program.
A) security
B) concurrency control
C) formatting
D) I/O interface
Q3) A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
A) fully heterogeneous
B) fully homogeneous
C) homogeneous
D) heterogeneous
Q4) The distributed database system must be of the computer hardware system.
Q5) The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) Multidimensional data analysis techniques include advanced computational functions.
A)True
B)False
Q2) Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
A)True
B)False
Q3) Decision support data tend to be non-normalized, , and pre-aggregated.
A) unique
B) duplicated
C) optimized
D) sorted
Q4) Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.
A)True
B)False
Q5) Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29014
Sample Questions
Q1) What is a server-side extension? Explain.
Q2) The is the most specialized object in the ADO.NET framework.
A) Command
B) DataReader
C) DataAdapter
D) DataSet
Q3) What is JavaScript? How does it work?
Q4) 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
Q5) In the ODBC architecture, a(n) is in charge of managing all database connections.
A) ODBC API
B) DLL
C) ODBC driver
D) driver manager
Q6) What are the components in the basic ODBC architecture?
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
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/29015
Sample Questions
Q1) In the context of data quality management tools, software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.
Q2) security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.
A) Debilitative
B) Preserving
C) Corrupting
D) Destructive
Q3) A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.
A)True
B)False
Q4) A(n) _____ physically stores the database's data.
Q5) Within the data security framework, is concerned with keeping data consistent and free of errors or anomalies.
Q6) In the context of ensuring integrity of a database, a(n) transaction is one that does not overload the DBMS.
To view all questions and flashcards with answers, click on the resource link above. Page 17