Data Management - Foundations - D426 WGU Test
Questions and Answers Rated A
Data - -Numeric, textual, visual, or audio
information that describes real-world systems. It Responsible for securing the database system
is collected and processed to aid in a variety of against unauthorized users. They enforce
tasks. procedures for user access and database system
availability.
Analog Data - -Most common before
computers. Audio was recorded as vibrations Database Designer - -What role am I?
impressed on vinyl disks.
Determines the format of each data element AND
the overall database STRUCTURE. Must balance
Digital Data - -Most common today. priorities like including storage, response time,
Encoded as 0s and 1s on electronic magnetic and support for rules that govern the data.
data.
Database Programmer - -What role am I?
Database - -A collection of data in
structured format. In principle, can be stored on Develop programs that utilize a database and
paper or even clay tablets. write applications that combine query languages
and general purpose programming language.
Database System (DBMS) - -Software that
reads and writes in a database. Database User - -What role am I?
A consumer of data in a database. They request,
update, or use stored data to generate reports or
Query - -A request to retrieve or change
information.
data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data
from a database.
Transaction - -A group of queries that
MUST be completed or rejected as a whole.
Query Language - -Specialized
programming language designed specifically for
database systems. Reads and writes data Architecture - -Describes the internal
efficiently. components AND the relationships between
components.
Database Application - -Software that
HELPS business users interact with database Query Processor - -Interprets queries,
systems. creates a plan to modify the database or retrieve
the data, and returns query results to the
application. Performs query optimization.
Database Administrator - -What role am I?
, Data Management - Foundations - D426 WGU Test
Questions and Answers Rated A
Query Optimization - -Ensures efficient SQL Statement - -A database command
instructions are executed on the data from the such as a query that inserts, retrieves, updates,
Query Processor. or deletes data. Composed of one or more
clauses.
Storage Manager - -Translates the query
processor instructions into low-level file-system INSERT - -Inserts rows into a table.
commands that modify OR retrieve data. Uses
indexes to quickly locate data.
SELECT - -Retrieves data from a table.
Transaction Manager - -Ensures
transactions are properly executed. Prevents UPDATE - -Modifies data in a table.
conflicts between concurrent transactions. Also
restores the database to a consistent state in the
event of a failure. DELETE - -Deletes rows from a table.
Log - -A file containing a complete record CREATE TABLE - -Creates a new table by
of ALL inserts, updates, and deletes processed specifying the table and column names.
by the database. The records can be used to
restore a database.
Data Type - -Indicates the TYPE of data
that can be stored in a field of a column.
Catalog/Data Dictionary/Repository - -A
directory of tables, columns, indexes, and other
database objects.
Data Independence - -Allows database
administrators to improve query performance by
changing the organization of data on storage
Relational Database - -Stores data in devices, without affecting query results or
tables, columns, and rows, SIMILAR to a changes to programs.
spreadsheet. It also supports SQL. Made up of
relations.
Database Design - -A specification of
database objects such as tables, columns data
NoSQL - -A new generation of DBMS that types, and indexes. Also refers to the process
is NOT based on the traditional relational used to develop the specifications.
database model.
Metadata - -Data ABOUT the database,
CRUD - -Acronym for actions that can be such as column names and the number of rows
performed by a query. in each table.
Questions and Answers Rated A
Data - -Numeric, textual, visual, or audio
information that describes real-world systems. It Responsible for securing the database system
is collected and processed to aid in a variety of against unauthorized users. They enforce
tasks. procedures for user access and database system
availability.
Analog Data - -Most common before
computers. Audio was recorded as vibrations Database Designer - -What role am I?
impressed on vinyl disks.
Determines the format of each data element AND
the overall database STRUCTURE. Must balance
Digital Data - -Most common today. priorities like including storage, response time,
Encoded as 0s and 1s on electronic magnetic and support for rules that govern the data.
data.
Database Programmer - -What role am I?
Database - -A collection of data in
structured format. In principle, can be stored on Develop programs that utilize a database and
paper or even clay tablets. write applications that combine query languages
and general purpose programming language.
Database System (DBMS) - -Software that
reads and writes in a database. Database User - -What role am I?
A consumer of data in a database. They request,
update, or use stored data to generate reports or
Query - -A request to retrieve or change
information.
data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data
from a database.
Transaction - -A group of queries that
MUST be completed or rejected as a whole.
Query Language - -Specialized
programming language designed specifically for
database systems. Reads and writes data Architecture - -Describes the internal
efficiently. components AND the relationships between
components.
Database Application - -Software that
HELPS business users interact with database Query Processor - -Interprets queries,
systems. creates a plan to modify the database or retrieve
the data, and returns query results to the
application. Performs query optimization.
Database Administrator - -What role am I?
, Data Management - Foundations - D426 WGU Test
Questions and Answers Rated A
Query Optimization - -Ensures efficient SQL Statement - -A database command
instructions are executed on the data from the such as a query that inserts, retrieves, updates,
Query Processor. or deletes data. Composed of one or more
clauses.
Storage Manager - -Translates the query
processor instructions into low-level file-system INSERT - -Inserts rows into a table.
commands that modify OR retrieve data. Uses
indexes to quickly locate data.
SELECT - -Retrieves data from a table.
Transaction Manager - -Ensures
transactions are properly executed. Prevents UPDATE - -Modifies data in a table.
conflicts between concurrent transactions. Also
restores the database to a consistent state in the
event of a failure. DELETE - -Deletes rows from a table.
Log - -A file containing a complete record CREATE TABLE - -Creates a new table by
of ALL inserts, updates, and deletes processed specifying the table and column names.
by the database. The records can be used to
restore a database.
Data Type - -Indicates the TYPE of data
that can be stored in a field of a column.
Catalog/Data Dictionary/Repository - -A
directory of tables, columns, indexes, and other
database objects.
Data Independence - -Allows database
administrators to improve query performance by
changing the organization of data on storage
Relational Database - -Stores data in devices, without affecting query results or
tables, columns, and rows, SIMILAR to a changes to programs.
spreadsheet. It also supports SQL. Made up of
relations.
Database Design - -A specification of
database objects such as tables, columns data
NoSQL - -A new generation of DBMS that types, and indexes. Also refers to the process
is NOT based on the traditional relational used to develop the specifications.
database model.
Metadata - -Data ABOUT the database,
CRUD - -Acronym for actions that can be such as column names and the number of rows
performed by a query. in each table.
