MIS 180 SDSU final exam questions and
answers latest update | solved
information granularity CORRECT ANSWERS the extent of detail within the information
(fine and detailed or coarse and abstract)
real-time information CORRECT ANSWERS immediate, up-to-date information
real-time system CORRECT ANSWERS provides real-time information in response to
requests
information inconsistency CORRECT ANSWERS occurs when the same data element
has different values
information integrity issue CORRECT ANSWERS occurs when a system produces
incorrect, inconsistent, or duplicate data
data gap analysis CORRECT ANSWERS 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 ANSWERS 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 ANSWERS 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 ANSWERS refers to the overall management of the
availability, usability, integrity, and security of company data
master data management (MDM) CORRECT ANSWERS 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 ANSWERS includes the tests and evaluations used to
determine compliance with data governance policies to ensure correctness of data
database CORRECT ANSWERS maintains information about various types of object
(inventory), events (transactions), people (employees), and places (warehouses)
, database management system (DBMS) CORRECT ANSWERS creates, reads,
updates, and deletes data in a database while controlling access and security
query-by-example (QBE) tool CORRECT ANSWERS helps useers graphically design
the answer to a question against a database
structured query language (SQL) CORRECT ANSWERS users write lines of code to
answer questions against a database
data element (data field) CORRECT ANSWERS smallest or basic unit of information
data models CORRECT ANSWERS logical data structures that detail the relationships
among data elements using graphics or pictures
metadata CORRECT ANSWERS details about data
relational database model CORRECT ANSWERS stores info in the form of logicallt
related two-dimensional tables
relational database management system CORRECT ANSWERS allows users to create,
read, update, and delete data in a relational database
entity CORRECT ANSWERS stores info about a person, place, thing, transaction, or
event
attribute CORRECT ANSWERS the data elements associated with an entity
record CORRECT ANSWERS a collection of related data elements
a primary key CORRECT ANSWERS a field (or group of fields) that uniquely identifies a
given record in a table
foreign key CORRECT ANSWERS 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 ANSWERS the physical storage of info on a
storage device
logical view of information CORRECT ANSWERS shows how individual users logically
access information to meet their own particular business needs
data latency CORRECT ANSWERS the time it takes for data to be stored or retrieved
information redundancy CORRECT ANSWERS the duplication of data, or the storage of
the same data in mulitple places
answers latest update | solved
information granularity CORRECT ANSWERS the extent of detail within the information
(fine and detailed or coarse and abstract)
real-time information CORRECT ANSWERS immediate, up-to-date information
real-time system CORRECT ANSWERS provides real-time information in response to
requests
information inconsistency CORRECT ANSWERS occurs when the same data element
has different values
information integrity issue CORRECT ANSWERS occurs when a system produces
incorrect, inconsistent, or duplicate data
data gap analysis CORRECT ANSWERS 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 ANSWERS 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 ANSWERS 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 ANSWERS refers to the overall management of the
availability, usability, integrity, and security of company data
master data management (MDM) CORRECT ANSWERS 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 ANSWERS includes the tests and evaluations used to
determine compliance with data governance policies to ensure correctness of data
database CORRECT ANSWERS maintains information about various types of object
(inventory), events (transactions), people (employees), and places (warehouses)
, database management system (DBMS) CORRECT ANSWERS creates, reads,
updates, and deletes data in a database while controlling access and security
query-by-example (QBE) tool CORRECT ANSWERS helps useers graphically design
the answer to a question against a database
structured query language (SQL) CORRECT ANSWERS users write lines of code to
answer questions against a database
data element (data field) CORRECT ANSWERS smallest or basic unit of information
data models CORRECT ANSWERS logical data structures that detail the relationships
among data elements using graphics or pictures
metadata CORRECT ANSWERS details about data
relational database model CORRECT ANSWERS stores info in the form of logicallt
related two-dimensional tables
relational database management system CORRECT ANSWERS allows users to create,
read, update, and delete data in a relational database
entity CORRECT ANSWERS stores info about a person, place, thing, transaction, or
event
attribute CORRECT ANSWERS the data elements associated with an entity
record CORRECT ANSWERS a collection of related data elements
a primary key CORRECT ANSWERS a field (or group of fields) that uniquely identifies a
given record in a table
foreign key CORRECT ANSWERS 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 ANSWERS the physical storage of info on a
storage device
logical view of information CORRECT ANSWERS shows how individual users logically
access information to meet their own particular business needs
data latency CORRECT ANSWERS the time it takes for data to be stored or retrieved
information redundancy CORRECT ANSWERS the duplication of data, or the storage of
the same data in mulitple places
