DAD 220 Module 1 Questions with Verified
Correct Answers
Data
Numeric, textual, visual, or audio information that describes real-world systems.
Analog Data
Data that is encoded as continuous variations on various physical media.
Digital Data
Data that is encoded as zeros and ones on electronic and magnetic media.
Database
A collection of data in a structured format.
Database System (Database Management System, DBMS)
Software that reads and writes data in a database.
Query
A command for a database the typically inserts new data, retrieves data, updates data, or
deletes data from a database.
Query Language
A specialized programming language designed specifically for database systems.
Database Administrator
Responsible for securing the database system against unauthorized users.
Database Designer
Determines the format of each data element and the overall database structure.
Database Programmer
Develops computer programs that utilize a database.
Database User
A consumer of data in a database.
, Transaction
A 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.
Architecture of a Database System
The internal components and the relationships between components.
Query Processor
Interprets queries, creates a plan to modify the database or retrieve data, and returns query
results to the application.
Query Optimization
Performed by the query processor to ensure the most efficient instructions are executed on the
data.
Storage Manager
Translates the query processor instructions into low-level file-system commands that modify
or retrieve data.
Indexes
Used by the storage manager to quickly locate data.
Transaction Manager
Ensures transactions are properly executed by preventing conflicts between concurrent
transactions and restoring the database to a consistent state in the event of a transaction or
system failure.
Log
A file containing a complete record of all inserts, updates, and deletes processed by the
database.
Catalog (Data Dictionary)
A directory of tables, columns, indexes, and other database objects.
Correct Answers
Data
Numeric, textual, visual, or audio information that describes real-world systems.
Analog Data
Data that is encoded as continuous variations on various physical media.
Digital Data
Data that is encoded as zeros and ones on electronic and magnetic media.
Database
A collection of data in a structured format.
Database System (Database Management System, DBMS)
Software that reads and writes data in a database.
Query
A command for a database the typically inserts new data, retrieves data, updates data, or
deletes data from a database.
Query Language
A specialized programming language designed specifically for database systems.
Database Administrator
Responsible for securing the database system against unauthorized users.
Database Designer
Determines the format of each data element and the overall database structure.
Database Programmer
Develops computer programs that utilize a database.
Database User
A consumer of data in a database.
, Transaction
A 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.
Architecture of a Database System
The internal components and the relationships between components.
Query Processor
Interprets queries, creates a plan to modify the database or retrieve data, and returns query
results to the application.
Query Optimization
Performed by the query processor to ensure the most efficient instructions are executed on the
data.
Storage Manager
Translates the query processor instructions into low-level file-system commands that modify
or retrieve data.
Indexes
Used by the storage manager to quickly locate data.
Transaction Manager
Ensures transactions are properly executed by preventing conflicts between concurrent
transactions and restoring the database to a consistent state in the event of a transaction or
system failure.
Log
A file containing a complete record of all inserts, updates, and deletes processed by the
database.
Catalog (Data Dictionary)
A directory of tables, columns, indexes, and other database objects.
