MIS 180 SDSU Final Exam Questions With
All Correct & Verified Answers
information granularity Correct answer-the extent of detail within the information (fine and
detailed or coarse and abstract)
real-time information Correct answer-immediate, up-to-date information
real-time system Correct answer-provides real-time information in response to requests
information inconsistency Correct answer-occurs when the same data element has different values
information integrity issue Correct answer-occurs when a system produces incorrect, inconsistent,
or duplicate data
data gap analysis Correct answer-occurs when a company examines its data to determine if it can
meet business expectations, while identifying possible data gaps or where missing data might exist
data stewardship Correct answer-the management and oversight of an organization's data assets
to help provide business users with high-quality data that is easily accessible in a consistent manner
data steward Correct answer-responsible for ensuring the policies and procedures are
implemented across the organization and acts as a liaison between the MIS department and the
business
data governance Correct answer-refers to the overall management of the availability, usability,
integrity, and security of company data
master data management (MDM) Correct answer-the practice of gathering data and ensuring that
it is uniform, acurate, consistent and complete
including such entities as customers, suppliers, products, sales, employees, and other critical entities
that are commonly integrated across organizational systems
data validation Correct answer-includes the tests and evaluations used to determine compliance
with data governance policies to ensure correctness of data
database Correct answer-maintains information about various types of object (inventory), events
(transactions), people (employees), and places (warehouses)
database management system (DBMS) Correct answer-creates, reads, updates, and deletes data in
a database while controlling access and security
query-by-example (QBE) tool Correct answer-helps useers graphically design the answer to a
question against a database
structured query language (SQL) Correct answer-users write lines of code to answer questions
against a database
data element (data field) Correct answer-smallest or basic unit of information
, data models Correct answer-logical data structures that detail the relationships among data
elements using graphics or pictures
metadata Correct answer-details about data
relational database model Correct answer-stores info in the form of logicallt related two-
dimensional tables
relational database management system Correct answer-allows users to create, read, update, and
delete data in a relational database
entity Correct answer-stores info about a person, place, thing, transaction, or event
attribute Correct answer-the data elements associated with an entity
record Correct answer-a collection of related data elements
a primary key Correct answer-a field (or group of fields) that uniquely identifies a given record in a
table
foreign key Correct answer-a primary key of one table that appears as an attribute in another table
and acts to provide a logical relationship between two tables
physical view of information Correct answer-the physical storage of info on a storage device
logical view of information Correct answer-shows how individual users logically access information
to meet their own particular business needs
data latency Correct answer-the time it takes for data to be stored or retrieved
information redundancy Correct answer-the duplication of data, or the storage of the same data in
mulitple places
information integrity Correct answer-a measure of the quality of info
integrity constraint Correct answer-rules that help ensure the quality of info
relational integrity constraint Correct answer-rules that enforce basic and fundamental
information-based constraints
business rule Correct answer-defines how a company performs a certain aspect of its business and
typically results in yes/no true/false
business-critical integrity constraint Correct answer-enforces business rules vital to organization's
success and often requires more insight and knowledge than relational integrity constraints
identity management Correct answer-deals with identifying individuals in a system and controlling
their access to resources within that system by associating user rights and restrictions with the
established identity
content creator Correct answer-person responsible for creating the original website content
All Correct & Verified Answers
information granularity Correct answer-the extent of detail within the information (fine and
detailed or coarse and abstract)
real-time information Correct answer-immediate, up-to-date information
real-time system Correct answer-provides real-time information in response to requests
information inconsistency Correct answer-occurs when the same data element has different values
information integrity issue Correct answer-occurs when a system produces incorrect, inconsistent,
or duplicate data
data gap analysis Correct answer-occurs when a company examines its data to determine if it can
meet business expectations, while identifying possible data gaps or where missing data might exist
data stewardship Correct answer-the management and oversight of an organization's data assets
to help provide business users with high-quality data that is easily accessible in a consistent manner
data steward Correct answer-responsible for ensuring the policies and procedures are
implemented across the organization and acts as a liaison between the MIS department and the
business
data governance Correct answer-refers to the overall management of the availability, usability,
integrity, and security of company data
master data management (MDM) Correct answer-the practice of gathering data and ensuring that
it is uniform, acurate, consistent and complete
including such entities as customers, suppliers, products, sales, employees, and other critical entities
that are commonly integrated across organizational systems
data validation Correct answer-includes the tests and evaluations used to determine compliance
with data governance policies to ensure correctness of data
database Correct answer-maintains information about various types of object (inventory), events
(transactions), people (employees), and places (warehouses)
database management system (DBMS) Correct answer-creates, reads, updates, and deletes data in
a database while controlling access and security
query-by-example (QBE) tool Correct answer-helps useers graphically design the answer to a
question against a database
structured query language (SQL) Correct answer-users write lines of code to answer questions
against a database
data element (data field) Correct answer-smallest or basic unit of information
, data models Correct answer-logical data structures that detail the relationships among data
elements using graphics or pictures
metadata Correct answer-details about data
relational database model Correct answer-stores info in the form of logicallt related two-
dimensional tables
relational database management system Correct answer-allows users to create, read, update, and
delete data in a relational database
entity Correct answer-stores info about a person, place, thing, transaction, or event
attribute Correct answer-the data elements associated with an entity
record Correct answer-a collection of related data elements
a primary key Correct answer-a field (or group of fields) that uniquely identifies a given record in a
table
foreign key Correct answer-a primary key of one table that appears as an attribute in another table
and acts to provide a logical relationship between two tables
physical view of information Correct answer-the physical storage of info on a storage device
logical view of information Correct answer-shows how individual users logically access information
to meet their own particular business needs
data latency Correct answer-the time it takes for data to be stored or retrieved
information redundancy Correct answer-the duplication of data, or the storage of the same data in
mulitple places
information integrity Correct answer-a measure of the quality of info
integrity constraint Correct answer-rules that help ensure the quality of info
relational integrity constraint Correct answer-rules that enforce basic and fundamental
information-based constraints
business rule Correct answer-defines how a company performs a certain aspect of its business and
typically results in yes/no true/false
business-critical integrity constraint Correct answer-enforces business rules vital to organization's
success and often requires more insight and knowledge than relational integrity constraints
identity management Correct answer-deals with identifying individuals in a system and controlling
their access to resources within that system by associating user rights and restrictions with the
established identity
content creator Correct answer-person responsible for creating the original website content
