CPS 510 - Database Systems Exam With
Complete Solutions
Examples of database users (Topic 1) - ANSWER -Application programmers
-End users
-Database administrators (IT professionals)
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.
Complete Solutions
Examples of database users (Topic 1) - ANSWER -Application programmers
-End users
-Database administrators (IT professionals)
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.
