CPS 510 Final Exam Questions and
Correct Answers| Guaranteed Pass
Examples of database users (Topic 1)
-Application programmers
-End users
-Database administrators (IT professionals)
DBA vs DA (Topic 1, Users)
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)
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)
A collection of related data.
What is a DBMS? (Chapter 1)
A Database Management System is a computerized system that enables users to
create and maintain a database.
What is database manipulation? (Chapter 1)
Includes functions such as:
-querying the database to retrieve data
-updating the database
-generating reports from the data
What is a query? (Chapter 1)
A cause for some data to be retrieved
, Pros of using a database/why use a database? (Topic 1)
-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
True: In database systems the logical and physical representation of data are
separated
What is a relation? (Topic 1)
A mathematical term for TABLE
What is meta-data? (Chapter 1)
It describes the structure of the primary database.
Correct Answers| Guaranteed Pass
Examples of database users (Topic 1)
-Application programmers
-End users
-Database administrators (IT professionals)
DBA vs DA (Topic 1, Users)
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)
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)
A collection of related data.
What is a DBMS? (Chapter 1)
A Database Management System is a computerized system that enables users to
create and maintain a database.
What is database manipulation? (Chapter 1)
Includes functions such as:
-querying the database to retrieve data
-updating the database
-generating reports from the data
What is a query? (Chapter 1)
A cause for some data to be retrieved
, Pros of using a database/why use a database? (Topic 1)
-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
True: In database systems the logical and physical representation of data are
separated
What is a relation? (Topic 1)
A mathematical term for TABLE
What is meta-data? (Chapter 1)
It describes the structure of the primary database.
