ISTM 210 Exam 3 [2026/2027] | UPDATED ACTUAL
Exam Question and Answer | Complete Review
• Structured Query Language (SQL) -✓✓ Using data visualization instead of
_______________________, makes business programming much easier to
understand.
• Can be described as computer applications that change data into significant,
meaningful information that helps organizations make better decisions. -✓✓ Business
Intelligence
• Database Management Systems (DBMS) -✓✓ A well thought-out collection of
computer files
• Filing Cabinets -✓✓ Database systems are extremely similar to _______ _______ in
that they organize information based on a set of rules.
• Tables -✓✓ Where a database holds data
• Relation -✓✓ Technical term for a table
• Records -✓✓ The rows of a table
• Fields -✓✓ The columns of a table
• Entity Relationship Modeling (ERM) -✓✓ a database-modeling method used to
construct a theoretical and conceptual representation of data to produce a schema
• Database Schema -✓✓ a "map" of data tables and their relationships to one another
• One-to-One Relationship -✓✓ Where a record of one table can only be associated with
one record from another table
• One-to-Many Relationship -✓✓ Where a single record from a table can be associated
with more than one record from another table, but a record from the second table can
only be associated with the one record from the first table
• Many-to-Many Relationship -✓✓ Where a record from one table may be associated
with more than one record from the other table and a record from the second table may
also be associated with more than one record from the first table
• Data Validation Rules -✓✓ Help avoid input errors to ensure the data's integrity
,• 1970; Edgar Codd -✓✓ The relational database model was first proposed in _______
by _______ _______.
• Structured Query Language (SQL) -✓✓ The most widely used standard computer
language for relational databases as it allows a programmer to manipulate and query
data
• SQL Functions -✓✓ Delete, Append, Update
• Fluid -✓✓ Data is _______ because it changes all the time.
• Oracle -✓✓ _______ is the world's most widely used database.
• Real Estate Owned -✓✓ REO is an acronym for...
• Alibaba Group -✓✓ Chinese e-commerce company that provides sales services via
web portals
• Cloud -✓✓ Using computer resources like a hard drive or software that exists on
another computer connected by a network, typically the Internet
• Cloud Drive -✓✓ A hard drive in the Cloud
• Cloud Service Provider -✓✓ CSP is an acronym for...
• Terms of Service -✓✓ TOS is an acronym for...
• Infrastructure as a Service (IaaS) -✓✓ Hosts supply hardware, software applications,
servers, and storage via the internet
• On-Demand -✓✓ IaaS can quickly adjust and supply more computing power because
it is considered _______-________.
• IaaS -✓✓ Windows Azure is an example of an...
• Storage as a Service (StaaS) -✓✓ Storing or renting space from a CSP
• Staas -✓✓ DropBox is an example of a...
• Software as a Service (SaaS) -✓✓ When the CSP installs and operates application
software in the Cloud that the Cloud user can use
• On-Demand Software -✓✓ Saas is also known as....
, • Saas -✓✓ Apache OpenOffice is an example of a...
• Writer -✓✓ What is the name of the OpenOffice word processor?
• Calc -✓✓ What is the name of the OpenOffice spreadsheet?
• Impress -✓✓ What is the name of the OpenOffice presentation software?
• Base -✓✓ What is the name of the OpenOffice database application?
• Draw -✓✓ What is the name of the OpenOffice graphics editor?
• It was free -✓✓ How much does OpenOffice cost?
• Platform as a Service (PaaS) -✓✓ When a Cloud provider supplies a computer
platform through the Internet
• PaaS -✓✓ Amazon Elastic Beanstalk is an example of a...
• Business Intelligence (BI) -✓✓ The set of techniques and tools for the transformation
of raw data into meaningful and useful information for business analysis purposes
• Return on Investment -✓✓ ROI is an acronym for...
• Decision Support Systems (DSS) -✓✓ Computer-based systems that support an
organization's decision-making activities
• 1950s -✓✓ What decade did businesses start DSS?
• Big Data -✓✓ Large collected datasets
• Structured Data -✓✓ Data that resides in fixed formats, is typically well labeled, and
often has traditional fields and records of common data tables
• Unstructured Data -✓✓ Disorganized data that cannot be easily read or processed by
a computer because it is not stored in rows and columns like traditional data tables
• 80% -✓✓ What percentage of all data is unstructured?
• Semi-Structured Data -✓✓ In-between Structured and Unstructured data, and can
possibly be converted into structured data, but not without a lot of work
• Four V's of Big Data -✓✓ Volume, Velocity, Variety, & Veracity
Exam Question and Answer | Complete Review
• Structured Query Language (SQL) -✓✓ Using data visualization instead of
_______________________, makes business programming much easier to
understand.
• Can be described as computer applications that change data into significant,
meaningful information that helps organizations make better decisions. -✓✓ Business
Intelligence
• Database Management Systems (DBMS) -✓✓ A well thought-out collection of
computer files
• Filing Cabinets -✓✓ Database systems are extremely similar to _______ _______ in
that they organize information based on a set of rules.
• Tables -✓✓ Where a database holds data
• Relation -✓✓ Technical term for a table
• Records -✓✓ The rows of a table
• Fields -✓✓ The columns of a table
• Entity Relationship Modeling (ERM) -✓✓ a database-modeling method used to
construct a theoretical and conceptual representation of data to produce a schema
• Database Schema -✓✓ a "map" of data tables and their relationships to one another
• One-to-One Relationship -✓✓ Where a record of one table can only be associated with
one record from another table
• One-to-Many Relationship -✓✓ Where a single record from a table can be associated
with more than one record from another table, but a record from the second table can
only be associated with the one record from the first table
• Many-to-Many Relationship -✓✓ Where a record from one table may be associated
with more than one record from the other table and a record from the second table may
also be associated with more than one record from the first table
• Data Validation Rules -✓✓ Help avoid input errors to ensure the data's integrity
,• 1970; Edgar Codd -✓✓ The relational database model was first proposed in _______
by _______ _______.
• Structured Query Language (SQL) -✓✓ The most widely used standard computer
language for relational databases as it allows a programmer to manipulate and query
data
• SQL Functions -✓✓ Delete, Append, Update
• Fluid -✓✓ Data is _______ because it changes all the time.
• Oracle -✓✓ _______ is the world's most widely used database.
• Real Estate Owned -✓✓ REO is an acronym for...
• Alibaba Group -✓✓ Chinese e-commerce company that provides sales services via
web portals
• Cloud -✓✓ Using computer resources like a hard drive or software that exists on
another computer connected by a network, typically the Internet
• Cloud Drive -✓✓ A hard drive in the Cloud
• Cloud Service Provider -✓✓ CSP is an acronym for...
• Terms of Service -✓✓ TOS is an acronym for...
• Infrastructure as a Service (IaaS) -✓✓ Hosts supply hardware, software applications,
servers, and storage via the internet
• On-Demand -✓✓ IaaS can quickly adjust and supply more computing power because
it is considered _______-________.
• IaaS -✓✓ Windows Azure is an example of an...
• Storage as a Service (StaaS) -✓✓ Storing or renting space from a CSP
• Staas -✓✓ DropBox is an example of a...
• Software as a Service (SaaS) -✓✓ When the CSP installs and operates application
software in the Cloud that the Cloud user can use
• On-Demand Software -✓✓ Saas is also known as....
, • Saas -✓✓ Apache OpenOffice is an example of a...
• Writer -✓✓ What is the name of the OpenOffice word processor?
• Calc -✓✓ What is the name of the OpenOffice spreadsheet?
• Impress -✓✓ What is the name of the OpenOffice presentation software?
• Base -✓✓ What is the name of the OpenOffice database application?
• Draw -✓✓ What is the name of the OpenOffice graphics editor?
• It was free -✓✓ How much does OpenOffice cost?
• Platform as a Service (PaaS) -✓✓ When a Cloud provider supplies a computer
platform through the Internet
• PaaS -✓✓ Amazon Elastic Beanstalk is an example of a...
• Business Intelligence (BI) -✓✓ The set of techniques and tools for the transformation
of raw data into meaningful and useful information for business analysis purposes
• Return on Investment -✓✓ ROI is an acronym for...
• Decision Support Systems (DSS) -✓✓ Computer-based systems that support an
organization's decision-making activities
• 1950s -✓✓ What decade did businesses start DSS?
• Big Data -✓✓ Large collected datasets
• Structured Data -✓✓ Data that resides in fixed formats, is typically well labeled, and
often has traditional fields and records of common data tables
• Unstructured Data -✓✓ Disorganized data that cannot be easily read or processed by
a computer because it is not stored in rows and columns like traditional data tables
• 80% -✓✓ What percentage of all data is unstructured?
• Semi-Structured Data -✓✓ In-between Structured and Unstructured data, and can
possibly be converted into structured data, but not without a lot of work
• Four V's of Big Data -✓✓ Volume, Velocity, Variety, & Veracity
