EGR 325
EGR 325 Final Exam Questions and
Answers 2026-2027
Which role focuses on creating software that interacts with a database?
Programmer
What does a user that interacts with a database use to read and write data?
Query language
Which database role focuses on database storage, response times, and optimization?
Designer
Which concept relates to software that reads and writes data in a database?
Management System
What design consideration would apply to a database that has special performance
requirements?
Structuring data properly on storage media
If a database system is processing three queries as part of a transaction and the third
query fails, what happens to the transaction?
The successful query results are reversed, and the transaction is canceled
How does a database system protect data when concurrent transactions occur?
Preventing multiple transactions with the same data at the same time
In terms of database architecture, which component translates the query processor
instructions into low-level file-system commands and is responsible for indexing the
data?
Storage manager
Which type of database system is optimized for big data?
NoSQL
EGR 325
,EGR 325
When a user interacts with a database, they can use a _____ to modify data with
commands.
query language
The _____ SQL statement does not alter any database data.
select
When using a SQL statement to create a table, which data type is used to store a
fractional value?
decimal
A database administrator uses which two SQL statements to view and then modify
existing customer balances with a late fee?
select, update
A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of
the statement. What does the value of (11) represent?
The number of characters allowed for the data type
The analysis phase of database design includes which process?
Specifying requirements that are not dependent on a specific database system
A database _____ is the implementation of database requirements in SQL with CREATE
TABLE statements.
schema
Which principle defines data independence?
Physical design never affects query results
What links a host programming language to a database system?
API
In a relational database model, which concept refers to a finite sequence of values that
are derived from defined domains?
Tuple
EGR 325
, EGR 325
A database administrator creates a new relational database, and a primary key is
assigned within a table to assist with governing data. What does the administrator
accomplish with this structural rule?
Unique identification of individual rows in the table
When only one value exists in each cell, a table is known to be _____.
normalized
A relational database uses _____ to structure all data.
tables
Which two rules apply to primary keys?
Values must be unique and may not be null
A view table provides which benefit when created in a database with multiple tables?
A consolidated view of specific data that does not modify the underlying source tables
Which statement is NOT an advantage of using a view table?
The creation of a new base table is always up to date
A pair of related values in a database is a(n) _____.
fact
All _____ columns depend on the _____ for a table to be in first normal form.
non-key, primary key
Redundancy is possible in a _____ normal form table when one non-key column
depends on another non-key column.
second
The EmployeeWorkspace table has a composite key of (EmployeeID, WorkspaceID).
WorkHours depends on (EmployeeID, WorkspaceID), and EmployeeLastName depends
on EmployeeID. Which column must be removed so EmployeeWorkspace is in second
normal form?
EmployeeLastName
EGR 325
EGR 325 Final Exam Questions and
Answers 2026-2027
Which role focuses on creating software that interacts with a database?
Programmer
What does a user that interacts with a database use to read and write data?
Query language
Which database role focuses on database storage, response times, and optimization?
Designer
Which concept relates to software that reads and writes data in a database?
Management System
What design consideration would apply to a database that has special performance
requirements?
Structuring data properly on storage media
If a database system is processing three queries as part of a transaction and the third
query fails, what happens to the transaction?
The successful query results are reversed, and the transaction is canceled
How does a database system protect data when concurrent transactions occur?
Preventing multiple transactions with the same data at the same time
In terms of database architecture, which component translates the query processor
instructions into low-level file-system commands and is responsible for indexing the
data?
Storage manager
Which type of database system is optimized for big data?
NoSQL
EGR 325
,EGR 325
When a user interacts with a database, they can use a _____ to modify data with
commands.
query language
The _____ SQL statement does not alter any database data.
select
When using a SQL statement to create a table, which data type is used to store a
fractional value?
decimal
A database administrator uses which two SQL statements to view and then modify
existing customer balances with a late fee?
select, update
A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of
the statement. What does the value of (11) represent?
The number of characters allowed for the data type
The analysis phase of database design includes which process?
Specifying requirements that are not dependent on a specific database system
A database _____ is the implementation of database requirements in SQL with CREATE
TABLE statements.
schema
Which principle defines data independence?
Physical design never affects query results
What links a host programming language to a database system?
API
In a relational database model, which concept refers to a finite sequence of values that
are derived from defined domains?
Tuple
EGR 325
, EGR 325
A database administrator creates a new relational database, and a primary key is
assigned within a table to assist with governing data. What does the administrator
accomplish with this structural rule?
Unique identification of individual rows in the table
When only one value exists in each cell, a table is known to be _____.
normalized
A relational database uses _____ to structure all data.
tables
Which two rules apply to primary keys?
Values must be unique and may not be null
A view table provides which benefit when created in a database with multiple tables?
A consolidated view of specific data that does not modify the underlying source tables
Which statement is NOT an advantage of using a view table?
The creation of a new base table is always up to date
A pair of related values in a database is a(n) _____.
fact
All _____ columns depend on the _____ for a table to be in first normal form.
non-key, primary key
Redundancy is possible in a _____ normal form table when one non-key column
depends on another non-key column.
second
The EmployeeWorkspace table has a composite key of (EmployeeID, WorkspaceID).
WorkHours depends on (EmployeeID, WorkspaceID), and EmployeeLastName depends
on EmployeeID. Which column must be removed so EmployeeWorkspace is in second
normal form?
EmployeeLastName
EGR 325
