OIM 350 Exam 1 Study Guide Question
and answers already passed
2025/2026
data - correct answer ✔stored representations of objects and events that have meaning and
importance in the user's environment
structured data - correct answer ✔numbers, dates, times, texts
unstructured data - correct answer ✔images, video, documents
metadata - correct answer ✔data that describes the properties, structure, and context of data
information - correct answer ✔data that has been processed and converted into a form that is useful
to the decision maker
database - correct answer ✔collection of interrelated data items that are managed as a single unit
old database - correct answer ✔punch card reader (L) and writer (R)
new database - correct answer ✔contains one or more tables- with one or more columns and zero or
more rows
personal/desktop DB - correct answer ✔only one user at a time; user-app-DBMS-DB (Microsoft Access
or other)
work group/departmental DB - correct answer ✔shared customer DB and documents, office network
, conceptual data model - correct answer ✔captures the major entities, relationships amongst entities,
and attributes of entities required for a database
logical data model - correct answer ✔transforms the major entity/attribute/relationship requirements
into a high-level specification for a database
physical data model - correct answer ✔transforms the high-level specifications for a database into
detailed specifications for how to construct an actual database
database management system (DBMS) - correct answer ✔a software system that enables the creation
and use of databases, provided by a database vendor
database system - correct answer ✔a computer-based system that enables end-users to interact with a
database in a DBMS directly or through front-end applications
things you do with a database - correct answer ✔create, update, and delete tables, insert, update, and
delete data in an existing table, query existing tables to retrieve data
things you do with a DBMS - correct answer ✔create, update, and delete databases, store, retrieve,
and update user data and metadata, coordination and control (security), and backup/recovery
operational data - correct answer ✔data collected and used for day-to-day operational needs
operational database - correct answer ✔collects/stores operational data- online transaction processing
system (OLTP)
analytical data - correct answer ✔data collected and used for analytical tasks to support organizational
decision-making based on operational data
and answers already passed
2025/2026
data - correct answer ✔stored representations of objects and events that have meaning and
importance in the user's environment
structured data - correct answer ✔numbers, dates, times, texts
unstructured data - correct answer ✔images, video, documents
metadata - correct answer ✔data that describes the properties, structure, and context of data
information - correct answer ✔data that has been processed and converted into a form that is useful
to the decision maker
database - correct answer ✔collection of interrelated data items that are managed as a single unit
old database - correct answer ✔punch card reader (L) and writer (R)
new database - correct answer ✔contains one or more tables- with one or more columns and zero or
more rows
personal/desktop DB - correct answer ✔only one user at a time; user-app-DBMS-DB (Microsoft Access
or other)
work group/departmental DB - correct answer ✔shared customer DB and documents, office network
, conceptual data model - correct answer ✔captures the major entities, relationships amongst entities,
and attributes of entities required for a database
logical data model - correct answer ✔transforms the major entity/attribute/relationship requirements
into a high-level specification for a database
physical data model - correct answer ✔transforms the high-level specifications for a database into
detailed specifications for how to construct an actual database
database management system (DBMS) - correct answer ✔a software system that enables the creation
and use of databases, provided by a database vendor
database system - correct answer ✔a computer-based system that enables end-users to interact with a
database in a DBMS directly or through front-end applications
things you do with a database - correct answer ✔create, update, and delete tables, insert, update, and
delete data in an existing table, query existing tables to retrieve data
things you do with a DBMS - correct answer ✔create, update, and delete databases, store, retrieve,
and update user data and metadata, coordination and control (security), and backup/recovery
operational data - correct answer ✔data collected and used for day-to-day operational needs
operational database - correct answer ✔collects/stores operational data- online transaction processing
system (OLTP)
analytical data - correct answer ✔data collected and used for analytical tasks to support organizational
decision-making based on operational data
