WGU D426 - DATA MANAGEMENT
FOUNDATIONS QUESTIONS WITH
VERIFIED ANSWERS,100%CORRECT
,Data - ANSWERnumeric, textual, visual, or audio information that describes real-world
systems.
analog - ANSWERHistorically, data was mostly ______________, encoded as
continuous variations on various physical media.
digital - ANSWERToday, data is mostly ______________, encoded as zeros and ones
on electronic and magnetic media.
database - ANSWERa collection of data in a structured format. In principle, can be
stored on paper or even clay tablets. In practice, however, modern ones are invariably
stored on computers.
database system / database management system / DBMS - ANSWERsoftware that
reads and writes data in a database. ensure data is secure, internally consistent, and
available at all times. These functions are challenging for large databases with many
users, so data base systems are complex.
database application - ANSWERsoftware that helps business users interact with
database systems.
database administrator - ANSWER- responsible for securing the database system
against unauthorized users.
- enforces procedures for user access and database system availability.
database designer - ANSWERdetermines the format of each data element and the
overall database structure. Must balance several priorities, including storage, response
time, and support for rules that govern the data. Since these priorities often conflict,
database design is technically challenging.
database programmer - ANSWERdevelops computer programs that utilize a database.
database user - ANSWER- a consumer of data in a database.
request, update, or use stored data to generate reports or information.
- usually access the database via applications but can also submit queries directly to the
database system.
transaction - ANSWERa group of queries that must be either completed or rejected as a
whole. Execution of some, but not all, queries results in inconsistent or incorrect data.
,query processor - ANSWER- interprets queries, creates a plan to modify the database
or retrieve data, and returns query results to the application.
- manages connections from multiple users and compiles queries into low-level
instructions for the storage engine.
query optimization - ANSWERThe query processor performs ______________ to
ensure the most efficient instructions are executed on the data.
indexes - ANSWERused by the storage manager to quickly locate data.
transaction manager - ANSWERensures transactions are properly executed.
log - ANSWERa file containing a complete record of all inserts, updates, and deletes
processed by the database.
relational database - ANSWERstores data in tables, columns, and rows, similar to a
spreadsheet.
SQL - ANSWERincludes statements that read and write data, create and delete tables,
and administer the database system.
big data - ANSWERThe growth of the internet in the 1990s generated massive volumes
of online data, often with poorly structured or missing information.
NoSQL - ANSWERThe newer non-relational systems, for 'not only SQL', and are
optimized for big data.
Open source - ANSWERsoftware that anyone can inspect, copy, and modify with no
licensing fee.
query - ANSWERa command for a database that typically inserts new data, retrieves
data, updates data, or deletes data from a database.
query language - ANSWERa computer programming language for writing database
queries.
CRUD - ANSWERThe four common queries are an acronym for Create, Read, Update,
and Delete data.
SELECT - ANSWERretrieves data from a table.
UPDATE - ANSWERmodifies data in a table.
CREATE TABLE - ANSWERcreates a new table by specifying the table and column
names.
, data type - ANSWEREach column is assigned a ______________ that indicates the
format of column values and can be numeric, textual, or complex.
database design - ANSWERa specification of database objects such as tables,
columns, data types, and indexes. Also refers to the process used to develop the
specification.
analysis - ANSWERspecifies database requirements without regard to a specific
database system.
ER diagrams - ANSWERdepicts entities, relationships, and attributes.
logical design - ANSWERimplements database requirements in a specific database
system. specifies tables, columns, and keys.
key - ANSWERa column used to identify individual rows of a table.
table diagram - ANSWERdepicts the logical design.
schema - ANSWERThe logical design, as specified in SQL and depicted in a table
diagram.
data independence - ANSWERThe principle that physical design never affects query
results.
application programming interface / API - ANSWERa library of procedures or classes
that links a host programming language to a database.
MySQL - ANSWERa leading relational database system sponsored by Oracle.
MySQL Community /MySQL Server - ANSWERa free edition.
MySQL Enterprise - ANSWERa paid edition for managing commercial databases,
includes MySQL Server and additional administrative applications.
root account - ANSWERthe administrative account that has full control of MySQL.
MySQL Command-Line Client - ANSWERa text interface included in the MySQL Server
download. allows developers to connect to the database server, perform administrative
functions, and execute SQL statements.
error code - ANSWERreturned by MySQL Server with a description when an SQL
statement is syntactically incorrect or the database cannot execute the statement.
MySQL Workbench - ANSWERis installed with MySQL Server and allows developers to
execute SQL commands using an editor.
FOUNDATIONS QUESTIONS WITH
VERIFIED ANSWERS,100%CORRECT
,Data - ANSWERnumeric, textual, visual, or audio information that describes real-world
systems.
analog - ANSWERHistorically, data was mostly ______________, encoded as
continuous variations on various physical media.
digital - ANSWERToday, data is mostly ______________, encoded as zeros and ones
on electronic and magnetic media.
database - ANSWERa collection of data in a structured format. In principle, can be
stored on paper or even clay tablets. In practice, however, modern ones are invariably
stored on computers.
database system / database management system / DBMS - ANSWERsoftware that
reads and writes data in a database. ensure data is secure, internally consistent, and
available at all times. These functions are challenging for large databases with many
users, so data base systems are complex.
database application - ANSWERsoftware that helps business users interact with
database systems.
database administrator - ANSWER- responsible for securing the database system
against unauthorized users.
- enforces procedures for user access and database system availability.
database designer - ANSWERdetermines the format of each data element and the
overall database structure. Must balance several priorities, including storage, response
time, and support for rules that govern the data. Since these priorities often conflict,
database design is technically challenging.
database programmer - ANSWERdevelops computer programs that utilize a database.
database user - ANSWER- a consumer of data in a database.
request, update, or use stored data to generate reports or information.
- usually access the database via applications but can also submit queries directly to the
database system.
transaction - ANSWERa group of queries that must be either completed or rejected as a
whole. Execution of some, but not all, queries results in inconsistent or incorrect data.
,query processor - ANSWER- interprets queries, creates a plan to modify the database
or retrieve data, and returns query results to the application.
- manages connections from multiple users and compiles queries into low-level
instructions for the storage engine.
query optimization - ANSWERThe query processor performs ______________ to
ensure the most efficient instructions are executed on the data.
indexes - ANSWERused by the storage manager to quickly locate data.
transaction manager - ANSWERensures transactions are properly executed.
log - ANSWERa file containing a complete record of all inserts, updates, and deletes
processed by the database.
relational database - ANSWERstores data in tables, columns, and rows, similar to a
spreadsheet.
SQL - ANSWERincludes statements that read and write data, create and delete tables,
and administer the database system.
big data - ANSWERThe growth of the internet in the 1990s generated massive volumes
of online data, often with poorly structured or missing information.
NoSQL - ANSWERThe newer non-relational systems, for 'not only SQL', and are
optimized for big data.
Open source - ANSWERsoftware that anyone can inspect, copy, and modify with no
licensing fee.
query - ANSWERa command for a database that typically inserts new data, retrieves
data, updates data, or deletes data from a database.
query language - ANSWERa computer programming language for writing database
queries.
CRUD - ANSWERThe four common queries are an acronym for Create, Read, Update,
and Delete data.
SELECT - ANSWERretrieves data from a table.
UPDATE - ANSWERmodifies data in a table.
CREATE TABLE - ANSWERcreates a new table by specifying the table and column
names.
, data type - ANSWEREach column is assigned a ______________ that indicates the
format of column values and can be numeric, textual, or complex.
database design - ANSWERa specification of database objects such as tables,
columns, data types, and indexes. Also refers to the process used to develop the
specification.
analysis - ANSWERspecifies database requirements without regard to a specific
database system.
ER diagrams - ANSWERdepicts entities, relationships, and attributes.
logical design - ANSWERimplements database requirements in a specific database
system. specifies tables, columns, and keys.
key - ANSWERa column used to identify individual rows of a table.
table diagram - ANSWERdepicts the logical design.
schema - ANSWERThe logical design, as specified in SQL and depicted in a table
diagram.
data independence - ANSWERThe principle that physical design never affects query
results.
application programming interface / API - ANSWERa library of procedures or classes
that links a host programming language to a database.
MySQL - ANSWERa leading relational database system sponsored by Oracle.
MySQL Community /MySQL Server - ANSWERa free edition.
MySQL Enterprise - ANSWERa paid edition for managing commercial databases,
includes MySQL Server and additional administrative applications.
root account - ANSWERthe administrative account that has full control of MySQL.
MySQL Command-Line Client - ANSWERa text interface included in the MySQL Server
download. allows developers to connect to the database server, perform administrative
functions, and execute SQL statements.
error code - ANSWERreturned by MySQL Server with a description when an SQL
statement is syntactically incorrect or the database cannot execute the statement.
MySQL Workbench - ANSWERis installed with MySQL Server and allows developers to
execute SQL commands using an editor.
