WGU C170 Data Management Crucial Terms
Exam Review Questions and verified Marking
Scheme 2024/2025
Response time - correct answer Is the delay from the time that the Enter Key is
pressed to execute a query until the result appears on screen.
Throughput - correct answer Is the measure of how many queries from simultaneous
users must be satisfied in a given period of time by the application set and the database
that it supports.
Client/server architecture - correct answer (...) architecture is a network architecture in
which the server manages services consumed by the client. It is also known as two-tier
architecture.
Database directory - correct answer (...) is an organized repository of databases that
stores attributes such as the database character set and collation.
GUI (graphical user interface) - correct answer (...) is a computer program that enables
a user to communicate with a computer through the use of graphical icons.
MySQL - correct answer (...) is an open-source RDBMS based on SQL (structure
query language) and used for adding, removing, and modifying information in the
database.
Option file - correct answer (...) is an appropriate way of specifying commonly used
options on the command line while executing a program.
RDBMS (relational database management system) - correct answer (...) is a program
that lets you create, update, and administer a relational database.
, Schema - correct answer In a relational database, a (...) defines tables, fields in each
table, and relationships between fields and tables.
DB2 - correct answer (...) is a relational database management system product from
IBM that serves a number of operating system platforms.
DCL - correct answer (...) is used to control access to data stored in a database.
DDL - correct answer (...) - involves instructing the DBMS software on what tables will
be in the database, what attributes will be in the tables, which attributes will be indexed,
and so forth.
DML - correct answer (...) refers to the four basic operations that can and must be
performed on data stored in any DBMS: data retrieval, data update, insertion of new
records, and deletion of existing records.
EER (enhanced entity-relationship) diagram - correct answer (...) is a conceptual data
model incorporating extensions to the original entity-relationship model used in the
design of databases.
SQL - correct answer Is a comprehensive database management language which
incorporates DML and DDL
BLOB (binary large objects) - correct answer (...) is a collection of binary data stored
as a single entity in a database management system. It holds up to 65,535 bytes of
data.
ENUM - correct answer (...) is a special data type that enables for a variable to be a
set of predefined constants.
REAL - correct answer (...) is a numerical data which contains decimal numbers.
MySQL treats ... as a synonym for DOUBLE, unless the REAL_AS_FLOAT SQL mode
is enabled.
Exam Review Questions and verified Marking
Scheme 2024/2025
Response time - correct answer Is the delay from the time that the Enter Key is
pressed to execute a query until the result appears on screen.
Throughput - correct answer Is the measure of how many queries from simultaneous
users must be satisfied in a given period of time by the application set and the database
that it supports.
Client/server architecture - correct answer (...) architecture is a network architecture in
which the server manages services consumed by the client. It is also known as two-tier
architecture.
Database directory - correct answer (...) is an organized repository of databases that
stores attributes such as the database character set and collation.
GUI (graphical user interface) - correct answer (...) is a computer program that enables
a user to communicate with a computer through the use of graphical icons.
MySQL - correct answer (...) is an open-source RDBMS based on SQL (structure
query language) and used for adding, removing, and modifying information in the
database.
Option file - correct answer (...) is an appropriate way of specifying commonly used
options on the command line while executing a program.
RDBMS (relational database management system) - correct answer (...) is a program
that lets you create, update, and administer a relational database.
, Schema - correct answer In a relational database, a (...) defines tables, fields in each
table, and relationships between fields and tables.
DB2 - correct answer (...) is a relational database management system product from
IBM that serves a number of operating system platforms.
DCL - correct answer (...) is used to control access to data stored in a database.
DDL - correct answer (...) - involves instructing the DBMS software on what tables will
be in the database, what attributes will be in the tables, which attributes will be indexed,
and so forth.
DML - correct answer (...) refers to the four basic operations that can and must be
performed on data stored in any DBMS: data retrieval, data update, insertion of new
records, and deletion of existing records.
EER (enhanced entity-relationship) diagram - correct answer (...) is a conceptual data
model incorporating extensions to the original entity-relationship model used in the
design of databases.
SQL - correct answer Is a comprehensive database management language which
incorporates DML and DDL
BLOB (binary large objects) - correct answer (...) is a collection of binary data stored
as a single entity in a database management system. It holds up to 65,535 bytes of
data.
ENUM - correct answer (...) is a special data type that enables for a variable to be a
set of predefined constants.
REAL - correct answer (...) is a numerical data which contains decimal numbers.
MySQL treats ... as a synonym for DOUBLE, unless the REAL_AS_FLOAT SQL mode
is enabled.
