CPS 510 UPDATED EXAMINATION
RESOURCES 2026 DETAILED ANSWERS
PROVIDED
◍ DBA vs DA (Topic 1, Users). Answer: DBA (Database
administrator)
-Their job is to create the database and put in technical controls to
enforce policy decisions
DA (Data Administrator)
-Job is to decide what data should be stored and who can perform
operations on data
◍ What is persistent data? What was the early name for persistent
data? (Topic 1). Answer: Data that is in the database for a long period
of time.
The earlier term used to be named operational data.
◍ What is a database? (Chapter 1). Answer: A collection of related
data.
◍ What is a DBMS? (Chapter 1). Answer: A Database Management
System is a computerized system that enables users to create and
maintain a database.
,◍ What is database manipulation? (Chapter 1). Answer: Includes
functions such as:
-querying the database to retrieve data
-updating the database
-generating reports from the data
◍ What is a query? (Chapter 1). Answer: A cause for some data to be
retrieved
◍ Pros of using a database/why use a database? (Topic 1). Answer: -
Shared data
-Reduced redundancy of data
-Reduced inconsistent data
-Transaction support (Making several update operations at once)
-Support for data integrity (accuracy of data)
-Security enforcement (restriction of data to authorized personnel
only)
-Support for standards (Ex. Phone number must be 9 digits or longer)
◍ True/False (Topic 1):
In database systems the logical and physical representation of data are
separated. Answer: True: In database systems the logical and physical
representation of data are separated
, ◍ What is a relation? (Topic 1). Answer: A mathematical term for
TABLE
◍ What is meta-data? (Chapter 1). Answer: It describes the structure
of the primary database.
A database system contains not only the database itself but also a
complete definition or description of the database structure and
constraints.
◍ True/False (Chapter 1):
All database systems require metadata.. Answer: False: Some newer
types of database systems do NOT require metadata.
Instead, the data is stored as self-describing data.
◍ What is a 'view' in a database? (Chapter 1). Answer: A subset of the
database that contains virtual data that is derived from the database
files, but is not explicitly stored.
Data can be stored or derived. In this case, data would be derived
from the table into a view.
◍ What is concurrency control software? (Chapter 1). Answer:
Software that ensures that several users can update the same data in a
controlled manner so that the result of the updates is correct.
RESOURCES 2026 DETAILED ANSWERS
PROVIDED
◍ DBA vs DA (Topic 1, Users). Answer: DBA (Database
administrator)
-Their job is to create the database and put in technical controls to
enforce policy decisions
DA (Data Administrator)
-Job is to decide what data should be stored and who can perform
operations on data
◍ What is persistent data? What was the early name for persistent
data? (Topic 1). Answer: Data that is in the database for a long period
of time.
The earlier term used to be named operational data.
◍ What is a database? (Chapter 1). Answer: A collection of related
data.
◍ What is a DBMS? (Chapter 1). Answer: A Database Management
System is a computerized system that enables users to create and
maintain a database.
,◍ What is database manipulation? (Chapter 1). Answer: Includes
functions such as:
-querying the database to retrieve data
-updating the database
-generating reports from the data
◍ What is a query? (Chapter 1). Answer: A cause for some data to be
retrieved
◍ Pros of using a database/why use a database? (Topic 1). Answer: -
Shared data
-Reduced redundancy of data
-Reduced inconsistent data
-Transaction support (Making several update operations at once)
-Support for data integrity (accuracy of data)
-Security enforcement (restriction of data to authorized personnel
only)
-Support for standards (Ex. Phone number must be 9 digits or longer)
◍ True/False (Topic 1):
In database systems the logical and physical representation of data are
separated. Answer: True: In database systems the logical and physical
representation of data are separated
, ◍ What is a relation? (Topic 1). Answer: A mathematical term for
TABLE
◍ What is meta-data? (Chapter 1). Answer: It describes the structure
of the primary database.
A database system contains not only the database itself but also a
complete definition or description of the database structure and
constraints.
◍ True/False (Chapter 1):
All database systems require metadata.. Answer: False: Some newer
types of database systems do NOT require metadata.
Instead, the data is stored as self-describing data.
◍ What is a 'view' in a database? (Chapter 1). Answer: A subset of the
database that contains virtual data that is derived from the database
files, but is not explicitly stored.
Data can be stored or derived. In this case, data would be derived
from the table into a view.
◍ What is concurrency control software? (Chapter 1). Answer:
Software that ensures that several users can update the same data in a
controlled manner so that the result of the updates is correct.
