Data Management - Foundations - D426
WGU Exam 100% Accurate!!
Data - ANSWERSNumeric, textual, visual, or audio information that describes real-world
systems. It is collected and processed to aid in a variety of tasks.
Analog Data - ANSWERSMost common before computers. Audio was recorded as
vibrations impressed on vinyl disks.
Digital Data - ANSWERSMost common today. Encoded as 0s and 1s on electronic
magnetic data.
Database - ANSWERSA collection of data in structured format. In principle, can be
stored on paper or even clay tablets.
Database System (DBMS) - ANSWERSSoftware that reads and writes in a database.
Query - ANSWERSA request to retrieve or change data in a database. Typically inserts
new data, retrieves data, updates, data, or deletes data from a database.
Query Language - ANSWERSSpecialized programming language designed specifically
for database systems. Reads and writes data efficiently.
Database Application - ANSWERSSoftware that HELPS business users interact with
database systems.
Database Administrator - ANSWERSWhat role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability.
Database Designer - ANSWERSWhat role am I?
Determines the format of each data element AND the overall database STRUCTURE.
Must balance priorities like including storage, response time, and support for rules that
govern the data.
Database Programmer - ANSWERSWhat role am I?
Develop programs that utilize a database and write applications that combine query
languages and general purpose programming language.
Database User - ANSWERSWhat role am I?
, A consumer of data in a database. They request, update, or use stored data to generate
reports or information.
Transaction - ANSWERSA group of queries that MUST be completed or rejected as a
whole.
Architecture - ANSWERSDescribes the internal components AND the relationships
between components.
Query Processor - ANSWERSInterprets queries, creates a plan to modify the database
or retrieve the data, and returns query results to the application. Performs query
optimization.
Query Optimization - ANSWERSEnsures efficient instructions are executed on the data
from the Query Processor.
Storage Manager - ANSWERSTranslates the query processor instructions into low-level
file-system commands that modify OR retrieve data. Uses indexes to quickly locate
data.
Transaction Manager - ANSWERSEnsures transactions are properly executed.
Prevents conflicts between concurrent transactions. Also restores the database to a
consistent state in the event of a failure.
Log - ANSWERSA file containing a complete record of ALL inserts, updates, and
deletes processed by the database. The records can be used to restore a database.
Catalog/Data Dictionary/Repository - ANSWERSA directory of tables, columns, indexes,
and other database objects.
Relational Database - ANSWERSStores data in tables, columns, and rows, SIMILAR to
a spreadsheet. It also supports SQL. Made up of relations.
NoSQL - ANSWERSA new generation of DBMS that is NOT based on the traditional
relational database model.
CRUD - ANSWERSAcronym for actions that can be performed by a query.
SQL Statement - ANSWERSA database command such as a query that inserts,
retrieves, updates, or deletes data. Composed of one or more clauses.
INSERT - ANSWERSInserts rows into a table.
SELECT - ANSWERSRetrieves data from a table.
WGU Exam 100% Accurate!!
Data - ANSWERSNumeric, textual, visual, or audio information that describes real-world
systems. It is collected and processed to aid in a variety of tasks.
Analog Data - ANSWERSMost common before computers. Audio was recorded as
vibrations impressed on vinyl disks.
Digital Data - ANSWERSMost common today. Encoded as 0s and 1s on electronic
magnetic data.
Database - ANSWERSA collection of data in structured format. In principle, can be
stored on paper or even clay tablets.
Database System (DBMS) - ANSWERSSoftware that reads and writes in a database.
Query - ANSWERSA request to retrieve or change data in a database. Typically inserts
new data, retrieves data, updates, data, or deletes data from a database.
Query Language - ANSWERSSpecialized programming language designed specifically
for database systems. Reads and writes data efficiently.
Database Application - ANSWERSSoftware that HELPS business users interact with
database systems.
Database Administrator - ANSWERSWhat role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability.
Database Designer - ANSWERSWhat role am I?
Determines the format of each data element AND the overall database STRUCTURE.
Must balance priorities like including storage, response time, and support for rules that
govern the data.
Database Programmer - ANSWERSWhat role am I?
Develop programs that utilize a database and write applications that combine query
languages and general purpose programming language.
Database User - ANSWERSWhat role am I?
, A consumer of data in a database. They request, update, or use stored data to generate
reports or information.
Transaction - ANSWERSA group of queries that MUST be completed or rejected as a
whole.
Architecture - ANSWERSDescribes the internal components AND the relationships
between components.
Query Processor - ANSWERSInterprets queries, creates a plan to modify the database
or retrieve the data, and returns query results to the application. Performs query
optimization.
Query Optimization - ANSWERSEnsures efficient instructions are executed on the data
from the Query Processor.
Storage Manager - ANSWERSTranslates the query processor instructions into low-level
file-system commands that modify OR retrieve data. Uses indexes to quickly locate
data.
Transaction Manager - ANSWERSEnsures transactions are properly executed.
Prevents conflicts between concurrent transactions. Also restores the database to a
consistent state in the event of a failure.
Log - ANSWERSA file containing a complete record of ALL inserts, updates, and
deletes processed by the database. The records can be used to restore a database.
Catalog/Data Dictionary/Repository - ANSWERSA directory of tables, columns, indexes,
and other database objects.
Relational Database - ANSWERSStores data in tables, columns, and rows, SIMILAR to
a spreadsheet. It also supports SQL. Made up of relations.
NoSQL - ANSWERSA new generation of DBMS that is NOT based on the traditional
relational database model.
CRUD - ANSWERSAcronym for actions that can be performed by a query.
SQL Statement - ANSWERSA database command such as a query that inserts,
retrieves, updates, or deletes data. Composed of one or more clauses.
INSERT - ANSWERSInserts rows into a table.
SELECT - ANSWERSRetrieves data from a table.
