WGU C175 – DATABASE MANAGEMENT FOUNDATIONS
COMPETENCY 1; INTRODUCTION TO DATABASES TEST
QUESTIONS AND ANSWERS
Data
Numeric, textual, graphic, or auditory information that describes real-world
systems
Scope
The amount of data produced and collected can vary
Format
data can be created in the form of number, text, image, sound or film
access
some data sources are confidential and others are freely available
Analog
data expressed as continuous fluctuations on a variety of physical media
digital
data expressed as zeros and ones on electronic and magnetic media
Database
A collection of data in an organized form.
Database System, Database Management System or DBMS
Software that stores and retrieves data in a database, ensures data is secure,
consistent, and always accessible.
### Query
A request for a database that typically inserts data, retrieves data, updates data,
or deletes data from a database.
, ### Query Language
A specialized programming language, designed especially for database systems
capable of reading and writing data efficiently, and are very different from
general-purpose languages
### Database Application
software that helps business users interact with database systems. Applications
that simplify the user experience and data access efficiently and securely
Where would a bank customer's account data be directly stored?
In the bank database
Which of the following manages the Bank database?
The banking database system
Which of the following would prevent unauthorized users from accessing the
Bank database?
The banking database system
How would a bank customer access their bank information?
Through the customer bank application
Database administrator
Responsible for safeguarding the database system against unauthorized users.
Establishes user access procedures and database system availability
Database designer
Determines the structure of every data element and the overall database
structure. Has to balance several priorities, including storage, response time, and
support for rules that control the data.
Database programmer
COMPETENCY 1; INTRODUCTION TO DATABASES TEST
QUESTIONS AND ANSWERS
Data
Numeric, textual, graphic, or auditory information that describes real-world
systems
Scope
The amount of data produced and collected can vary
Format
data can be created in the form of number, text, image, sound or film
access
some data sources are confidential and others are freely available
Analog
data expressed as continuous fluctuations on a variety of physical media
digital
data expressed as zeros and ones on electronic and magnetic media
Database
A collection of data in an organized form.
Database System, Database Management System or DBMS
Software that stores and retrieves data in a database, ensures data is secure,
consistent, and always accessible.
### Query
A request for a database that typically inserts data, retrieves data, updates data,
or deletes data from a database.
, ### Query Language
A specialized programming language, designed especially for database systems
capable of reading and writing data efficiently, and are very different from
general-purpose languages
### Database Application
software that helps business users interact with database systems. Applications
that simplify the user experience and data access efficiently and securely
Where would a bank customer's account data be directly stored?
In the bank database
Which of the following manages the Bank database?
The banking database system
Which of the following would prevent unauthorized users from accessing the
Bank database?
The banking database system
How would a bank customer access their bank information?
Through the customer bank application
Database administrator
Responsible for safeguarding the database system against unauthorized users.
Establishes user access procedures and database system availability
Database designer
Determines the structure of every data element and the overall database
structure. Has to balance several priorities, including storage, response time, and
support for rules that control the data.
Database programmer
