WGU C175/D426 DATA MANAGEMENT FOUNDATIONS
OA EXAM ACTUAL EXAM 2 LATEST VERSIONS 300
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (100% CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
Numeric, textual, visual, or audio information that describes real-world systems. It is
collected and processed to aid in a variety of tasks. - ANSWER: Data
Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks. - ANSWER: Analog Data
Most common today. Encoded as 0s and 1s on electronic magnetic data. - ANSWER:
Digital Data
A collection of data in structured format. In principle, can be stored on paper or even
clay tablets. - ANSWER: Database
Software that reads and writes in a database. - ANSWER: Database System (DBMS)
A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database. - ANSWER: Query
Specialized programming language designed specifically for database systems. Reads
and writes data efficiently. - ANSWER: Query Language
Software that HELPS business users interact with database systems. - ANSWER:
Database Application
What role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability. - ANSWER:
Database Administrator
What 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. - ANSWER: Database Designer
What role am I?
, Develop programs that utilize a database and write applications that combine query
languages and general purpose programming language. - ANSWER: Database
Programmer
What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information. - ANSWER: Database User
A group of queries that MUST be completed or rejected as a whole. - ANSWER:
Transaction
Describes the internal components AND the relationships between components. -
ANSWER: Architecture
Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization. - ANSWER:
Query Processor
Ensures efficient instructions are executed on the data from the Query Processor. -
ANSWER: Query Optimization
Translates the query processor instructions into low-level file-system commands that
modify OR retrieve data. Uses indexes to quickly locate data. - ANSWER: Storage
Manager
Ensures transactions are properly executed. Prevents conflicts between concurrent
transactions. Also restores the database to a consistent state in the event of a
failure. - ANSWER: Transaction Manager
A file containing a complete record of ALL inserts, updates, and deletes processed by
the database. The records can be used to restore a database. - ANSWER: Log
A directory of tables, columns, indexes, and other database objects. - ANSWER:
Catalog/Data Dictionary/Repository
Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also supports
SQL. Made up of relations. - ANSWER: Relational Database
A new generation of DBMS that is NOT based on the traditional relational database
model. - ANSWER: NoSQL
Acronym for actions that can be performed by a query. - ANSWER: CRUD
A database command such as a query that inserts, retrieves, updates, or deletes
data. Composed of one or more clauses. - ANSWER: SQL Statement
OA EXAM ACTUAL EXAM 2 LATEST VERSIONS 300
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (100% CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
Numeric, textual, visual, or audio information that describes real-world systems. It is
collected and processed to aid in a variety of tasks. - ANSWER: Data
Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks. - ANSWER: Analog Data
Most common today. Encoded as 0s and 1s on electronic magnetic data. - ANSWER:
Digital Data
A collection of data in structured format. In principle, can be stored on paper or even
clay tablets. - ANSWER: Database
Software that reads and writes in a database. - ANSWER: Database System (DBMS)
A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database. - ANSWER: Query
Specialized programming language designed specifically for database systems. Reads
and writes data efficiently. - ANSWER: Query Language
Software that HELPS business users interact with database systems. - ANSWER:
Database Application
What role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability. - ANSWER:
Database Administrator
What 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. - ANSWER: Database Designer
What role am I?
, Develop programs that utilize a database and write applications that combine query
languages and general purpose programming language. - ANSWER: Database
Programmer
What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information. - ANSWER: Database User
A group of queries that MUST be completed or rejected as a whole. - ANSWER:
Transaction
Describes the internal components AND the relationships between components. -
ANSWER: Architecture
Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization. - ANSWER:
Query Processor
Ensures efficient instructions are executed on the data from the Query Processor. -
ANSWER: Query Optimization
Translates the query processor instructions into low-level file-system commands that
modify OR retrieve data. Uses indexes to quickly locate data. - ANSWER: Storage
Manager
Ensures transactions are properly executed. Prevents conflicts between concurrent
transactions. Also restores the database to a consistent state in the event of a
failure. - ANSWER: Transaction Manager
A file containing a complete record of ALL inserts, updates, and deletes processed by
the database. The records can be used to restore a database. - ANSWER: Log
A directory of tables, columns, indexes, and other database objects. - ANSWER:
Catalog/Data Dictionary/Repository
Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also supports
SQL. Made up of relations. - ANSWER: Relational Database
A new generation of DBMS that is NOT based on the traditional relational database
model. - ANSWER: NoSQL
Acronym for actions that can be performed by a query. - ANSWER: CRUD
A database command such as a query that inserts, retrieves, updates, or deletes
data. Composed of one or more clauses. - ANSWER: SQL Statement
